US5551025A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Relational database system for storing different types of data
Assignee: Verizon Patent and Licensing Inc
•
Filing: 1994-11-30
•
Granted: 1996-08-27
•
Expires: 2014-11-30
Abstract
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.
Inventors
- 👤 Daniel L. O'Reilly
- 👤 Matthew J. Brazier
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-08 00:26
CPC Classifications
H; H04; H04Q; H04Q3/00; H04Q3/0016; H04Q3/0062; G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/283; H04Q2213/00; H04Q2213/13522; H04Q2213/13545; H04Q2213/13547; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99944; Y10S707/99945; Y10S707/99948
Claims Analysis
Total Claims: 29
Claim 1
Independent Claim
120 words
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.
Claim 2
Dependent Claim
120 words
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.
Claim 3
Dependent Claim
58 words
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.
Claim 4
Dependent Claim
58 words
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.
Claim 5
Dependent Claim
78 words
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.
Claim 6
Dependent Claim
54 words
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.
Claim 7
Dependent Claim
68 words
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.
Claim 8
Independent Claim
135 words
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.
Claim 9
Independent Claim
135 words
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.
Claim 10
Dependent Claim
106 words
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.
Claim 11
Dependent Claim
71 words
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.
Claim 12
Dependent Claim
57 words
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.
Claim 13
Dependent Claim
35 words
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.
Claim 14
Dependent Claim
157 words
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.
Claim 15
Dependent Claim
157 words
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.
Claim 16
Dependent Claim
123 words
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.
Claim 17
Dependent Claim
70 words
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.
Claim 18
Dependent Claim
36 words
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.
Claim 19
Dependent Claim
147 words
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.
Claim 20
Dependent Claim
147 words
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.
Claim 21
Dependent Claim
71 words
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.
Claim 22
Dependent Claim
87 words
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.
Claim 23
Dependent Claim
129 words
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.
Claim 24
Dependent Claim
129 words
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.
Claim 25
Dependent Claim
62 words
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.
Claim 26
Dependent Claim
60 words
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.
Claim 27
Dependent Claim
77 words
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.
Claim 28
Dependent Claim
56 words
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.
Claim 29
Dependent Claim
67 words
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.
References Cited (Backward Citations)
US5259023A
Cited
US5276867A
Cited
US5317728A
Cited
US5274813A
Cited
US5210787A
Cited
US5313631A
Cited
US5359512A
Cited
US5351290A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1999-08-27 | 2000-02-26 | 2000-08-27 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2003-08-27 | 2004-02-26 | 2004-08-27 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2007-08-27 | 2008-02-26 | 2008-08-27 | $7700.00 | Window Closed / Lapsed |