Database management system with a multiple-level cache arrangement
First Claim
1. A method for storing data in a multiple-level cache arrangement, comprising the steps of:
- initially storing all data in a secondary cache;
receiving requests for data;
moving requested data from said secondary cache to a primary cache, wherein when subsequent requests for data are received, the primary cache is searched before the secondary cache; and
periodically synchronizing and merging data in said primary cache back into said secondary cache to refresh said primary cache and remove stale information.
2 Assignments
0 Petitions
Accused Products
Abstract
A data management system for storing data in a multiple-level cache arrangement of a database comprises a multi-tier cache memory for initially storing all data in summary form in a secondary cache which may be the database; a processor for receiving requests for data and for moving requested data from the secondary cache to a primary cache, wherein, when subsequent requests for data are received, the primary cache is searched before the secondary cache; and for periodically synchronizing and merging all data in the primary cache back into said secondary cache to refresh said primary cache and remove stale information. The system is particularly useful for managing a telecommunications system call detail summary database in which telephone call details are collected as AMA records after the calls terminate and the AMA records are forwarded to a call detail database for storage in summary form and analysis by an external system, for example, for fraud analysis or billing purposes.
116 Citations
19 Claims
-
1. A method for storing data in a multiple-level cache arrangement, comprising the steps of:
-
initially storing all data in a secondary cache;
receiving requests for data;
moving requested data from said secondary cache to a primary cache, wherein when subsequent requests for data are received, the primary cache is searched before the secondary cache; and
periodically synchronizing and merging data in said primary cache back into said secondary cache to refresh said primary cache and remove stale information. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A data management system for storing data in a multiple-level cache arrangement, comprising:
-
means for initially storing all data in a secondary cache;
means for receiving requests for data;
means for moving requested data from said secondary cache to a primary cache, wherein when subsequent requests for data are received the primary cache is searched before the secondary cache; and
means for periodically synchronizing and merging all data in said primary cache back into said secondary cache to refresh said primary cache and remove stale information. - View Dependent Claims (9, 10, 11, 12, 13, 14, 16, 17, 18, 19)
-
-
15. In a method for storing call detail data in summary form in a multiple-level cache arrangement comprising a primary and a secondary cache, a synchronization process comprising the steps of:
-
initially storing call detail data in summary form in the secondary cache;
for each telephone number in the primary cache, looking in the secondary cache for data;
if found, replacing data in the secondary cache with data from the primary cache and, if not found, allocating new space in the secondary cache and copying the data from the primary cache into the new space in the secondary cache;
clearing out data for the telephone number from the primary cache; and
repeating the looking step, one of the replacing and the space allocation and copying steps, and the data clearing step at a predetermined time.
-
Specification