Data preparation for traffic track usage measurement
First Claim
1. A method of preparing network call management data for traffic analysis, comprising:
- accessing detailed data records for calls processed through a telecommunication network in a table of a database;
translating at least one item of information in each record to corresponding descriptive information, using reference data regarding the telecommunication network;
for any calls processed by the telecommunication network extending over two or more predetermined time intervals, binning usage data from the records for those calls in accord with actual usage within each of the intervals; and
based on results of the translating and binning, formatting enhanced data for use in an on-line analytical processing program.
4 Assignments
0 Petitions
Accused Products
Abstract
A monitoring system captures and processes messages from SS7 links, to compile call detail records (CDRs) for all interoffice call attempts. The CDRs are uploaded into a relational database. Automatic Message Accounting (AMA) records also are accumulated and uploaded to another relational database. A data preparation operation enhances the records for further processing. This data preparation operation involves translating information in the records into more useful forms, using external reference data regarding the monitored network. For example, the data preparation translates SS7 point codes or NPA-NXX codes in the records to textual names of originating and terminating offices. The data preparation also spreads the usage information from the records to properly allocate usage time to predefined intervals. Another function of the data preparation stage is to form one or more predefined tables from the processed records, for example a table of modified records and one or more specialized summary tables. The data, so prepared, is uploaded to an on-line analytical processing application.
-
Citations
22 Claims
-
1. A method of preparing network call management data for traffic analysis, comprising:
-
accessing detailed data records for calls processed through a telecommunication network in a table of a database;
translating at least one item of information in each record to corresponding descriptive information, using reference data regarding the telecommunication network;
for any calls processed by the telecommunication network extending over two or more predetermined time intervals, binning usage data from the records for those calls in accord with actual usage within each of the intervals; and
based on results of the translating and binning, formatting enhanced data for use in an on-line analytical processing program. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
the telecommunication network includes a plurality of switching offices and a signaling network carrying call processing signaling messages between the switching offices; and
the translating comprises mapping signaling network addresses of the switching offices into descriptive identifiers of the switching offices.
-
-
3. A method according to claim 1, wherein:
-
the detailed records for calls include numbers of at least one party to each of the calls; and
the translating comprises mapping at least portions of the numbers into descriptive identifiers of offices of the telecommunication network.
-
-
4. A method according to claim 1, wherein the step of formatting comprises creating enhanced detailed records containing the enriched data and indicating the binning results.
-
5. A method according to claim 4, wherein the formatting step further comprises loading the enhanced detailed records into a pre-defined table for input to the on-line analytical processing program.
-
6. A method according to claim 5, wherein the formatting step further comprises creating at least one summary table from processing of the translated information and the binning results.
-
7. A method according to claim 6, further comprising loading the pre-defined table and the at least one summary table into the on-line analytical processing program.
-
8. A method according to claim 7, wherein the on-line analytical processing program comprises a multi-dimensional database.
-
9. A method according to claim 1, further comprising loading the formatted enhanced data into the on-line analytical processing program.
-
10. A method according to claim 1, wherein the step of formatting comprises creating at least one summary table from processing of the translated information and the binning results.
-
11. A system for tracking traffic through a telecommunication network in response to data records for calls processed by the telecommunication network, the system comprising:
-
a relational database receiving and storing the records from the telecommunication network;
a data preparation system for processing records from the relational database; and
an on-line analytical processing system, the data preparation system comprising executable code for causing a computer system to perform the following steps;
a) accessing the records in the relational database;
b) translating at least one item of information in each record to corresponding descriptive information, using reference data regarding the telecommunication network;
c) for any calls processed by the telecommunication network extending over two or more predetermined time intervals, binning usage data from the records for those calls in accord with actual usage within each of the intervals; and
d) based on results of the translating and binning, formatting enhanced call data and supplying the enhanced call data to the on-line analytical processing program. - View Dependent Claims (12, 13, 14, 15)
-
-
16. A program for preparing data records of calls processed by a telecommunication network for on-line analytical processing in accord with a selected one of a plurality of predefined types of traffic studies, comprising:
-
a first routine for accessing each record of a call and reference data regarding the telecommunication network, and translating at least one item of information in each record of a call to corresponding descriptive information from the accessed reference data in a manner corresponding to the one type of study;
a second routine for spreading records for any calls processed by the telecommunication network extending over two or more predetermined time intervals, the spreading of the records serving to allocate usage data from the records for those calls in accord with actual usage within each of the intervals; and
a third routine for allocating data from the translation routine and the binning routine to a predefined table for use in subsequent on-line analytical processing. - View Dependent Claims (17, 18, 19, 20, 21, 22)
-
Specification