WO2003055185B1 - Database driven methods and systems for real time call tracing - Google Patents

Database driven methods and systems for real time call tracing

Info

Publication number
WO2003055185B1
WO2003055185B1 PCT/US2002/040952 US0240952W WO03055185B1 WO 2003055185 B1 WO2003055185 B1 WO 2003055185B1 US 0240952 W US0240952 W US 0240952W WO 03055185 B1 WO03055185 B1 WO 03055185B1
Authority
WO
WIPO (PCT)
Prior art keywords
message
database
real time
signaling
messages
Prior art date
Application number
PCT/US2002/040952
Other languages
French (fr)
Other versions
WO2003055185A1 (en
Inventor
Steven Michael Freedman
Patrick Joseph Galizia
Richard James Spangler
Joseph Yu-Lung Wan
Original Assignee
Tekelec Us
Steven Michael Freedman
Patrick Joseph Galizia
Richard James Spangler
Joseph Yu-Lung Wan
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Tekelec Us, Steven Michael Freedman, Patrick Joseph Galizia, Richard James Spangler, Joseph Yu-Lung Wan filed Critical Tekelec Us
Priority to AU2002366843A priority Critical patent/AU2002366843A1/en
Priority to EP02805651.3A priority patent/EP1466465B1/en
Publication of WO2003055185A1 publication Critical patent/WO2003055185A1/en
Publication of WO2003055185B1 publication Critical patent/WO2003055185B1/en

Links

Classifications

    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M3/00—Automatic or semi-automatic exchanges
    • H04M3/22—Arrangements for supervision, monitoring or testing
    • H04M3/2281—Call monitoring, e.g. for law enforcement purposes; Call tracing; Detection or prevention of malicious calls
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04Q—SELECTING
    • H04Q3/00—Selecting arrangements
    • H04Q3/0016—Arrangements providing connection between exchanges
    • H04Q3/0025—Provisions for signalling
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04Q—SELECTING
    • H04Q3/00—Selecting arrangements
    • H04Q3/0016—Arrangements providing connection between exchanges
    • H04Q3/0062—Provisions for network management
    • H04Q3/0087—Network testing or monitoring arrangements
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04M—TELEPHONIC COMMUNICATION
    • H04M7/00—Arrangements for interconnection between switching centres
    • H04M7/06—Arrangements for interconnection between switching centres using auxiliary connections for control or supervision, e.g. where the auxiliary connection is a signalling system number 7 link

Abstract

Database-driven methods and systems for database driven real time call tracing are disclosed. Signaling messages are copied from signaling link interface modules. The copied messages are sent to a database (202). A server (114) located remotely from the database (202) sends a query to the database (202) for a real time call trace. The database (202) is searched for messages that match the search criteria. If no messages are located in the historical data stored in the database, data entering the database (202) is analyzed in real time.

Claims

AMENDED CLAIMS[received by the International Bureau on 31 My 2003 (31.07.03); original claims 1-15 and 22-24 replaced by amended claims 1-15 and 22-24; remaining claims unchanged (7 pages)]What is claimed is:
1. A method for real time call tracing, the method comprising:
(a) copying signaling messages from signaling links at a signal transfer point (STP) and storing the signaling messages in a database located on a computing platform connected to the STP;
(b) sending, from a location remote from the STP, to the computing platform, a filter condition for locating a message in a real time call trace, the filter condition including a signaling message parameter used by the STP to route the signaling message;
(c) searching, in the database, historical data copied from the signaling link for a message matching the filter condition; (d) in response to failing to locate the message in the historical data, polling the database in real time for the message matching the filter condition; (e) in response to locating the message in steps (c) or (d), forwarding the message to the remote location; (f) at the remote location, determining a filter condition for locating the next message in the real time call trace; (g) repeating steps (a)-(f) for the next message; and (h) repeating steps (a)-(g) until the last message associated with the real time call trace reaches the remote location, wherein performing steps (a)-(h) includes performing steps (a)-(h) in real time as messages are received at the computing platform.
2. The method of claim 1 wherein the computing platform is separate from signaling link probe hardware.
3. The method of claim 1 wherein step (c) includes searching historical data in a database including messages copied by a message copy function located in the signal transfer point.
4. The method of claim 1 wherein step (c) includes searching historical data in a relational database, the relational database including a plurality of tables, each table corresponding to a signaling link, each table including a plurality of message blocks, each message block including blocks of copied signaling messages indexed according to a timestamp of a first message in each block and offsets from the timestamp.
5. The method of claim 1 wherein the computing platform comprises a general purpose computing platform.
6. The method of claim 5 wherein a first portion of the database is stored in random access memory on the general purpose computing platform and a second portion of the database is stored in disk storage on the general purpose computing platform, and wherein step (c) includes searching random access memory for the message and in response to failing to locate the message in random access memory, searching disk storage for the message, and in response to locating the message in disk storage, moving a block of memory including the message to random access memory.
7. The method of claim 1 wherein searching historical data includes searching data in the database beginning at a database record corresponding to a previously received message in the call trace.
8. The method of claim 1 wherein sending the filter conditions includes sending database location information instructing the computing platform of a database location to begin searching for the signaling messages in the real time call trace.
9. The method of claim 8 wherein sending database location information includes, in response to receiving a first message in the real time call trace, sending a database location to the computing platform corresponding to a memory location following the location of the first message. 21
10. The method of claim 1 wherein sending filter conditions includes sending timestamp information indicating timestamps associated with the signaling messages in the real time call trace.
11. The method of claim 10, wherein sending timestamp information includes detecting a timestamp of a first message received in the real time call trace and instructing the computing platform to begin searching the database for messages having a timestamp greater than the timestamp of the first message.
12. The method of claim 1 comprising in response to detecting a first message having a first timestamp in the real time call trace, sending filter criteria to a plurality of computing platforms connected to the signal transfer point instructing the signal transfer point to locate additional messages associated with the real time call trace.
13. The method of claim 12 wherein instructing the plurality of computing platforms to search for additional messages includes instructing the computing platforms to search for messages having a timestamp earlier than the timestamp of the first message,
14. The method of claim 13 comprising determining the message having the earliest timestamp and using that message as the first message in the real time call trace.
15. A system for real time call tracing, the system comprising:
(a) a computing platform operatively associated with a signal transfer point or signaling gateway for receiving signaling messages copied from signaling links connected to the signal transfer point or signaling gateway;
(b) a real time database located on the computing platform for storing the copied messages;
(c) a protocol analysis module located on the computing platform for polling the database for messages based on filter criteria, the filter criteria including a parameter used by the STP to route the signaling messages, wherein the protocol analysis module is adapted to search historical data in the database 22
and to search messages received in the database in real time; and (d) a network monitoring server located remotely from the computing platform for requesting real time call trace information by sending queries including filter criteria to the protocol analysis module, wherein the network monitoring server is adapted to send a first query including first filter criteria to capture the first message in a real time call trace and in response to capturing the first message, the network monitoring server is adapted to send a second query to the protocol analysis module, the second query including filter criteria for locating a second message in the real time call trace, wherein the first and second queries are sent in real time as the signaling messages are received by the computing platform.
16. The system of claim 15 wherein the computing platform comprises a general purpose computing platform.
17. The system of claim 16 wherein the computing platform includes random access memory and disk memory, and wherein the real time database includes a first portion stored in the random access memory and a second portion stored in the disk memory.
18. The system of claim 17 wherein the protocol analysis module is adapted to poll the portion of the real time database stored in the random access memory, and in response to failing to locate messages in the random access memory, the protocol analysis module is adapted to poll the disk memory.
19. The system of claim 15 wherein the real time database includes a plurality of tables, each table corresponding to a signaling link and including a plurality of message blocks, each message block storing a plurality of signaling messages copied from one of the signaling links.
20. The system of claim 19 wherein each message block is indexed by a timestamp of a first message in each block and subsequent 23
messages in each block are indexed by offsets from the timestamp of the first message in each block,
21. The system of claim 15 wherein the protocol analysis module is adapted to search the historical data for real time call trace information, and, in response to failing to locate the information in the historical data, to poll the database for the real time call trace information.
22. The system of claim 15 wherein the network monitoring server is adapted to communicate to the computing platform the location in the database to begin searching for the second signaling message based on the location of the first signaling message.
23. A computer program product comprising computer executable instructions embodied in a computer-readable medium for performing steps comprising: (a) receiving signaling messages copied from signaling links at a signal transfer point (STP) and storing the signaling messages in a database located on a computing platform connected to the signal transfer point;
(b) receiving filter criteria for performing a real time call trace based on signaling messages stored in the database, the filter criteria including a parameter used by the STP to route the signaling messages;
(c) querying historical data in the database based on the filter criteria; (d) in response to failing to locate a message matching the filter criteria, querying the database in real time for messages matching the filter criteria; (e) in response to locating a message matching the filter criteria, sending parameters from the message to a server; and (f) receiving new filter criteria formulated by the server based on the message parameters and repeating steps (a)-(f) for the next message in the real time call trace, wherein performing 24
steps (a)-(f) includes performing steps (a)-(f) in real time as the copied signaling messages are received by the computing platform,
24. The computer program product of claim 23 wherein storing signaling messages copied from telecommunications signaling links in a relational database includes storing signaling messages received from a probeless network monitoring system associated with the signal transfer point.
25. The computer program product of claim 23 wherein storing signaling messages copied from telecommunications signaling links includes storing signaling messages copied by link probes from telecommunications signaling links in a relational database separate from the link probes.
26. The computer program product of claim 23 wherein storing signaling messages copied from telecommunications signaling links in a relational database includes storing signaling messages in a database including a plurality of tables, each table corresponding to a signaling link and including a plurality of message blocks, each message block being indexed by a timestamp of a first signaling message stored in each message block and subsequent messages in each message block being indexed by an offset from the timestamp of the first message.
27. The computer program product of claim 23 wherein receiving filter criteria for performing a real time call trace includes receiving message parameters associated with the call trace.
28. The computer program product of claim 23 wherein querying historical data in the database includes querying data from a last received signaling message associated with a call trace until the end of the database.
29. The computer program product of claim 23 wherein querying the historical data includes searching a first portion of the database stored in random access memory and, in response to failing to locate a 25
message matching the filter criteria in the random access memory, searching a portion of the database stored in disk memory.
30. The computer program product of claim 29 comprising in response to locating a message matching the filter criteria in disk memory, moving a portion of the database stored in disk memory containing the matching message to random access memory.
PCT/US2002/040952 2001-12-20 2002-12-19 Database driven methods and systems for real time call tracing WO2003055185A1 (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
AU2002366843A AU2002366843A1 (en) 2001-12-20 2002-12-19 Database driven methods and systems for real time call tracing
EP02805651.3A EP1466465B1 (en) 2001-12-20 2002-12-19 Database driven methods and systems for real time call tracing

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US34257301P 2001-12-20 2001-12-20
US60/342,573 2001-12-20

Publications (2)

Publication Number Publication Date
WO2003055185A1 WO2003055185A1 (en) 2003-07-03
WO2003055185B1 true WO2003055185B1 (en) 2003-10-23

Family

ID=23342406

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2002/040952 WO2003055185A1 (en) 2001-12-20 2002-12-19 Database driven methods and systems for real time call tracing

Country Status (4)

Country Link
US (1) US6765990B2 (en)
EP (1) EP1466465B1 (en)
AU (1) AU2002366843A1 (en)
WO (1) WO2003055185A1 (en)

Families Citing this family (24)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7050549B2 (en) * 2000-12-12 2006-05-23 Inrange Technologies Corporation Real time call trace capable of use with multiple elements
WO2002095580A1 (en) * 2001-05-23 2002-11-28 Tekelec Methods and systems for automatically configuring network monitoring system
US7535993B2 (en) * 2003-04-21 2009-05-19 Alcatel-Lucent Usa Inc. Call control component employment of one or more criteria for internet protocol call selection for eavesdrop component monitoring
US7383298B2 (en) * 2003-08-27 2008-06-03 Tekelec Methods and systems for dynamic, distributed link table consistency management
US7496900B2 (en) * 2004-02-12 2009-02-24 International Business Machines Corporation Method for automatic detection of build regressions
US7506330B2 (en) * 2004-02-12 2009-03-17 International Business Machines Corporation Method and apparatus for identifying differences in runs of a computer program due to code changes
US8266595B2 (en) * 2004-02-12 2012-09-11 International Business Machines Corporation Removal of asynchronous events in complex application performance analysis
US7682985B2 (en) * 2004-03-17 2010-03-23 Lam Research Corporation Dual doped polysilicon and silicon germanium etch
FR2863737A1 (en) * 2004-04-15 2005-06-17 France Telecom Relational database forming process for use over e.g. Internet, involves analyzing stored communication paths in order to determine relation data characterizing relation between user terminals in paths
US7283619B2 (en) * 2004-06-15 2007-10-16 Cisco Technology, Inc. System and method for end-to-end communications tracing
US7003080B1 (en) 2004-09-23 2006-02-21 Verizon Services Corp. Methods and apparatus for reducing data capture and storage requirements for call and transaction related message monitoring and fraud detection
WO2006133095A2 (en) * 2005-06-03 2006-12-14 Tekelec Methods, systems, and computer program products for generic call tracing
WO2007014157A2 (en) * 2005-07-21 2007-02-01 Tekelec Methods, systems, and computer program products associating communications detail records with a mobile reference and using the mobile reference to retrieve the communications detail records
KR100753640B1 (en) * 2005-08-05 2007-08-29 주식회사 유프레스토 System for testifying mobile communication network and method thereof
US20070127647A1 (en) * 2005-10-25 2007-06-07 Tekelec Methods, systems, and computer program products for collecting messages associated with providing prepaid communications services in a communications network
KR100658223B1 (en) * 2005-12-01 2006-12-15 한국전자통신연구원 Apparatus and method for high accuracy clock synchronization in rtls system
US9071483B1 (en) * 2006-10-11 2015-06-30 Sprint Communications Company L.P. Presenting VOP call trace data
US8606222B2 (en) * 2006-12-28 2013-12-10 Tekelec Global, Inc. Methods, systems, and computer program products for performing prepaid account balance screening
CN101420747B (en) * 2008-11-12 2011-04-06 华为技术有限公司 Synchronization method, base station, network server and communication system
DE102009032229B4 (en) * 2009-07-08 2012-06-14 Abb Technology Ag Method and device for logging process variables of a digital field device
CN102231130B (en) * 2010-01-11 2015-06-17 国际商业机器公司 Method and device for analyzing computer system performances
US8649272B2 (en) 2010-05-17 2014-02-11 Tekelec Global, Inc. Methods, systems and computer readable media for mobile-communication-device-initiated network monitoring services
US8391833B2 (en) 2010-08-08 2013-03-05 Tekelec, Inc. Systems, methods, and computer readable media for diameter routing with number portability correction
CN103493522B (en) 2011-03-03 2016-12-07 泰科来股份有限公司 For enriching the method for Diameter signaling message, system and computer-readable medium

Family Cites Families (24)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4464543A (en) * 1982-12-01 1984-08-07 Gte Business Communication Systems Inc. Network control center call trace
US4959849A (en) 1989-07-31 1990-09-25 At&T Bell Laboratories End-to-end network surveillance
US5008929A (en) 1990-01-18 1991-04-16 U.S. Intelco Networks, Inc. Billing system for telephone signaling network
US5475732A (en) * 1993-02-16 1995-12-12 C & P Of Virginia Common channeling signaling network maintenance and testing
US5438570A (en) 1993-12-29 1995-08-01 Tekno Industries, Inc. Service observing equipment for signalling System Seven telephone network
US5757895A (en) * 1995-11-09 1998-05-26 Unisys Corporation Extracting and processing data derived from a common channel signalling network
US5592530A (en) * 1995-01-25 1997-01-07 Inet, Inc. Telephone switch dual monitors
US6515968B1 (en) 1995-03-17 2003-02-04 Worldcom, Inc. Integrated interface for real time web based viewing of telecommunications network call traffic
US5638431A (en) * 1995-05-01 1997-06-10 Mci Corporation Calling card validation system and method therefor
JP3763907B2 (en) * 1995-12-12 2006-04-05 エイ・ティ・アンド・ティ・コーポレーション Method for monitoring signaling messages in a communication network
US5809121A (en) * 1995-12-29 1998-09-15 Mci Communications Corporation System and method for generating a network call identifier
US5999616A (en) 1998-04-17 1999-12-07 Ameritech Services, Inc. Method and system for call tracing
US6393113B1 (en) 1997-06-20 2002-05-21 Tekno Industries, Inc. Means for and methods of detecting fraud, lack of credit, and the like from the SS# 7 system network
US6137876A (en) 1997-12-04 2000-10-24 Ericsson Inc Network call trace
DE69823002T2 (en) 1998-02-13 2005-03-31 Agilent Technologies, Inc. (n.d.Ges.d.Staates Delaware), Palo Alto Method for monitoring multiple transactions
US6498843B1 (en) 1998-04-22 2002-12-24 General Dynamics Government Systems Corporation Method and system for intercepting and monitoring signals in a network
EP0957644A1 (en) 1998-05-13 1999-11-17 BRITISH TELECOMMUNICATIONS public limited company A billing system
US6381306B1 (en) 1998-06-08 2002-04-30 Inet Technologies, Inc. System and method for monitoring service quality in a communications network
US6639981B1 (en) 1999-04-05 2003-10-28 Tekelec Methods and systems for routing signaling messages associated with ported subscribers in a communications network
US6400813B1 (en) 1999-10-25 2002-06-04 Inrange Technologies, Inc. Mediation system for a telephone network
US6483907B1 (en) 1999-11-09 2002-11-19 Ericsson Inc. System and method for providing call information in real time
US6456845B1 (en) 1999-12-15 2002-09-24 Tekelec Methods and systems for observing, analyzing and correlating multi-protocol signaling message traffic in a mobile telecommunications network
US7050549B2 (en) 2000-12-12 2006-05-23 Inrange Technologies Corporation Real time call trace capable of use with multiple elements
US20020072358A1 (en) 2000-12-13 2002-06-13 Telefonaktiebolaget Lm Ericsson Methods and apparatus for real-time performance monitoring in a wireless communication network

Also Published As

Publication number Publication date
WO2003055185A1 (en) 2003-07-03
US6765990B2 (en) 2004-07-20
EP1466465A4 (en) 2006-10-25
US20030142803A1 (en) 2003-07-31
EP1466465B1 (en) 2018-01-24
EP1466465A1 (en) 2004-10-13
AU2002366843A1 (en) 2003-07-09

Similar Documents

Publication Publication Date Title
WO2003055185B1 (en) Database driven methods and systems for real time call tracing
CN105183860B (en) Method of data synchronization and system
CN102968831B (en) A kind of electronic patrol method, terminal and system
CN105306585B (en) A kind of method of data synchronization of multiple data centers
CN109785595A (en) A kind of vehicle abnormality track real-time identification method based on machine learning
CN110377577B (en) Data synchronization method, device, system and computer readable storage medium
ZA200509949B (en) Method and device for configuring data in communication device
CN108228322B (en) Distributed link tracking and analyzing method, server and global scheduler
CN103178998A (en) Test and control data transmission method and device
US20030225830A1 (en) Performance measuring system for storage network
CN111542083A (en) Method for collecting and analyzing through industrial wireless network air interface
CN114201540A (en) Industrial multi-source data acquisition and storage system
CN110505307B (en) Method and system for exchanging traffic flow data between networks
CN100413257C (en) Network element warning data obtaining method
CN116186082A (en) Data summarizing method based on distribution, first server and electronic equipment
CN112989255B (en) Identification analysis system
CN111090648B (en) Relational database data synchronization conflict resolution method
CN109143878B (en) Remote signaling message and SOE message processing method for multi-channel acquisition channel
CN109766462B (en) Image file reading method, device and system in power transmission line monitoring system
JP2010282360A (en) Retrieval system and retrieval method
CN117453730B (en) Data query method, device, equipment and storage medium
CN114637786B (en) Off-line calculation method for vehicle working hours and storage medium
CN111259208B (en) Information query device and system
CN109450660B (en) Method and device for storing signaling log text into database
CN116873004A (en) Non-line side urban rail train control data analysis and management system

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A1

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NO NZ OM PH PL PT RO RU SD SE SG SK SL TJ TM TN TR TT TZ UA UG US UZ VC VN YU ZA ZM ZW

AL Designated countries for regional patents

Kind code of ref document: A1

Designated state(s): GH GM KE LS MW MZ SD SL SZ TZ UG ZM ZW AM AZ BY KG KZ MD RU TJ TM AT BE BG CH CY CZ DE DK EE ES FI FR GB GR IE IT LU MC NL PT SE SI SK TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
B Later publication of amended claims

Free format text: 20030731

WWE Wipo information: entry into national phase

Ref document number: 2002805651

Country of ref document: EP

WWP Wipo information: published in national office

Ref document number: 2002805651

Country of ref document: EP

NENP Non-entry into the national phase

Ref country code: JP

WWW Wipo information: withdrawn in national office

Country of ref document: JP