Relational database system for storing different types of data

• US 5,551,025 A
• Filed: 11/30/1994
• Issued: 08/27/1996
• Est. Priority Date: 11/30/1994
• Status: Expired due to Term

• Current Assignee: Verizon Patent and Licensing Incorporated (Verizon Communications Inc.)
• Original Assignee: MCI Communications Corporation (Verizon Communications Inc.)
• Inventors: Brazier, Matthew J., O'Reilly, Daniel L.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): PHAM, CUAN
• Application Number:
  US08/350,186
• Time in Patent Office: 636 Days
• Field of Search: 395/600, 395/575, 395/275, 395/700, 395/800, 379/88, 379/92
• US Class Current: 1/1
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: H04Q 2213/13522 traffic management
• CPC Class Codes: H04Q 2213/13545 monitoring of signaling messages, intelligent network
• CPC Class Codes: H04Q 2213/13547 subscriber, e.g. profile, database, database access
• CPC Class Codes: H04Q 3/0062 Provisions for network management
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

In a traffic view server (TVS) system in which the traffic through a telecommunications network is monitored, a database system is provided to enable high processing rate for the TVS, both for inserting the data into the system and for extracting the stored data out for reporting purposes. The database system is structured in three pieces, a first one handling statistics data from records that are collected by a traffic statistics system (MTS), a second one handling enhanced call detail records (ECDR) screened from the MTS, and a last one handling common material references. The statistics data are first stored in a fast response electronic storage medium, after they have been segregated into different basic types of statistics data. The thus segregated basic types of statistics data are then combined and forwarded for long term storage in a magnetic storage medium at a brief period of time after a predetermined time interval. On the other hand, the CDR and reference data are stored directly, but at a steady rate, to respective CDR and reference storage tables.

Claims

1. In a telecommunications network, a method of storing data, comprising the steps of:

(a) retrieving from a traffic data collection system statistics data collected by said traffic data collection system;

(b) grouping the statistics data into different types of statistics data;

(c) routing each of the different types of statistics data to its own file storage in a fast response storage means;

(d) retrieving from each said file storage in said fast response storage means at predetermined periodic time periods respective stored sets of said different types of statistics data; and

(e) storing each said stored set of respective said different types of statistics data to a slower response storage means at a predefined time period for longer term storage.

2. The method of claim 1, further comprising the steps of:

retrieving from said traffic data collection system call details data collected by said traffic data collection system; and

storing said call details data to a call detail file at said slower storage means as soon as said call details data is collected from said traffic data collection system.

3. The method of claim 1, further comprising the steps of:

retrieving reference data collected by said traffic data collection system;

grouping the reference data into respective sets of customer data required for generating reports to be provided to subscribers of said network; and

storing the respective sets of customer data into corresponding files in said slower storage means.

4. The method of claim 1, wherein said traffic data collection system collects reference data from said network, said reference data including customer phone number data, report data, delivery address data for reports, ncode mapping data, and country and state mapping data, said method further comprising the step of:

storing said reference data into respective storage files corresponding to at least said phone number data, report data, delivery address data, ncode mapping data, and country and state mapping data.

5. The method of claim 1, wherein said step (a) further comprises the step of:

utilizing a plurality of retrieve means for retrieving said statistics data;

wherein said fast response storage means is divided into a plurality of storage areas each for receiving the same type of statistics data from said plurality of retrieving means.

6. The method of claim 5, further comprising the steps of:

dividing said slower response storage means into a plurality of storage areas;

wherein said step (d) further comprises the step of;

utilizing a plurality of data moving means to move the same type of statistics data from each of said storage areas of said fast response storage means to a corresponding storage area of said slower storage means.

7. A method of storing various data from a telecommunications network, comprising the steps of:

(a) collecting at least statistics, call details and reference data from said network;

(b) storing said call details data in a first storage means;

(c) storing said reference data in said first storage means;

(d) grouping the statistics data into different types of statistics data;

(e) routing each of said different types of statistics data to a second storage means, said second storage means operating substantially faster than said first storage means;

(f) retrieving from said second storage means at predetermined periodic time periods respective stored sets of said different types of statistics data; and

(g) storing said respective stored sets of different types of statistics data to said first storage means at a predefined time period for longer term storage.

8. The method of claim 7, wherein said step (b) further comprises the step of:

storing said call details data into a call details file in said first storage means;

said method further comprising the steps of;

grouping said reference data into respective sets of customer data; and

wherein said step (c) further comprises the step of;

storing said respective sets of reference data into corresponding storage files in said first storage means, said storage files in said first storage means including at least a phone number data file, report data file, delivery address data file, ncode mapping data file, and country and state mapping data file.

9. The method of claim 7, further comprising the steps of:

partitioning said second storage means into a plurality of storage files for receiving said different types of statistics data;

routing each of said different types of statistics data to a corresponding one of said storage files in said second storage means so that the same type of statistics data is stored in the same storage file of said second storage means.

10. The method of claim 7, further comprising the steps of:

dividing said first storage means into a plurality of storage files;

wherein said step (g) further comprises the step of;

storing the same type of statistics data from said respective sets of different types of statistics data to the same storage file in said first storage means.

11. The method of claim 7, further comprising the step of:

utilizing said stored call details data, said reference data and said statistics data to generate reports for customers who subscribe to a special call service.

12. A database system for storing data of special service calls in a telecommunications network, comprising:

means for collecting at least call details data, reference data and statistics data from the calls in said network;

first storage means for storing said call details data and reference data of the calls in said network;

means for separating said statistics data into a plurality of different types of statistics data; and

second storage means having a plurality of storage files each for storing one type of said statistics data so that said plurality of different types of statistics data are each stored in a corresponding one of said plurality of storage files in said second storage means, said second storage means operating substantially faster than said first storage means for receiving said statistics data;

wherein at a predefined time for each given time period, said second storage means downloads said different types of statistics data to said first storage means.

13. The system of claim 12, wherein said first storage means further comprises:

a call details file into which said call details are stored; and

at least one phone number data file, report data file, delivery address data file, ncode mapping data file, and country and state mapping data file;

wherein said retrieved reference data includes different types of data including at least phone number data, report data, delivery address data, ncode mapping data, and country and state mapping data; and

wherein said retrieved data is sorted into the different types of data each being stored in a corresponding one of said phone number data file, report data file, delivery address data file, ncode mapping data file, and country and state mapping data file.

14. The system of claim 12, wherein said basic types of data includes at least summary data, termination data, number plan area (NPA) data, telephone number prefix (NXX) data, and country data;

and

wherein said second storage means includes at least a summary data file, a termination data file, a NPA data file, a NXX data file, and a country data file each for storing corresponding said basic types of data.

15. The system of claim 12, further comprising the step of:

means utilizing said stored call details data, said reference data and said statistics data to generate reports for customers who subscribe to said special service calls.

16. In a telecommunications network, a system for storing data, comprising:

means for retrieving from a traffic statistics system at least call statistics collected by said traffic statistics data system;

means for grouping said statistics data into different types of statistics data;

a first memory means having a plurality storage files;

means for routing each of said different types of statistics data to its own storage file in said first memory means to form respective sets of different types of statistics data;

means for retrieving from each of said storage files in said first memory means at predetermined periodic time periods respective stored sets of said different types of statistics data; and

a second memory means for storing each said stored set of respective types of statistics data at a predefined time period for longer term storage, said second memory means operating slower than said first memory means.

17. The system of claim 16, wherein said retrieving means further retrieves from said traffic data collection system call details data collected by said traffic data collection system, said system further comprising:

a second memory means having a call details data file for storing said call details data, said second memory means storing said call details data as soon as said call details data is collected from said traffic data collection system.

18. The system of claim 16, wherein said retrieving means further retrieves from said traffic data collection system different types of reference data collected by said traffic data collection system, said reference data including at least phone number data, report data, delivery address data, ncode data, and country/state data;

wherein said second memory means comprises at least one phone number data file, one report data file, one delivery address file, one ncode data file and one country/state data file each for storing the corresponding type of reference data.

19. In a telecommunication network, a method of storing data, comprising the steps of:

(a) retrieving from a traffic data collection system records containing statistics data collected by said traffic data collection system;

(b) removing said statistics data from said records and grouping said statistics data into different types of statistics data;

(c) routing each of said different types of statistics data to its own file storage in a fast response storage means;

(d) retrieving from each said file storage in said fast response storage means at predetermined periodic time periods respective stored sets of said different types of statistics data; and

(e) storing each said stored set of respective different types of statistics data to a slower response storage means at a predefined time period for longer term storage.

20. The method of claim 19, further comprising the steps of:

extracting from said records retrieved from said traffic data collection system call details data collected by said traffic data collection system; and

storing said call details data to a call detail file at said slower storage means as soon as said call details data is collected from said traffic data collection system.

21. The method of claim 19, further comprising the steps of:

retrieving from said records reference data collected by said traffic data collection system;

grouping the reference data into respective sets of customer data required for generating reports to be provided to subscribers of said network;

storing the respective sets of customer data into corresponding files in said slower storage means.

22. The method of claim 19, wherein said records from said traffic collection system include reference data, said reference data including customer phone number data, report data, delivery address data for reports, ncode mapping data, and country and state mapping data, said method further comprising the step of:

storing said reference data into respective storage files corresponding to at least said phone number data, report data, delivery address data, ncode mapping data, and country and state mapping data.

23. The method of claim 19, wherein said step (a) further comprises the step of:

utilizing a plurality of retrieve means for separating said statistics data from said records;

wherein said fast response storage means is divided into a plurality of storage areas each for receiving the same type of data from said plurality of retrieving means.

24. The method of claim 23, further comprising the steps of:

dividing said slower response storage means into a plurality of storage areas;

wherein said step (d) further comprises the step of;

utilizing a plurality of data moving means to move the same type of data from each of said storage areas of said fast response storage means to a corresponding storage area of said slower storage means.