Relational database system for storing different types of data
First Claim
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.
3 Assignments
0 Petitions
Accused Products
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.
-
Citations
24 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. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
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. - View Dependent Claims (8, 9, 10, 11)
-
-
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. - View Dependent Claims (13, 14, 15)
-
-
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. - View Dependent Claims (17, 18)
-
-
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. - View Dependent Claims (20, 21, 22, 23, 24)
-
Specification