Data preparation for traffic track usage measurement
US6385301B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Nov 10, 1998 |
| Grant date | May 7, 2002 |
| Priority date | — |
| Expiry date | Nov 10, 2018 |
Classification
- Technology area (CPC H)Electricity
- CPC primaryH04M2207/12
- WIPO fieldTelecommunications
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.