Method and apparatus for automating the management of a database

• US 6,047,046 A
• Filed: 03/05/1999
• Issued: 04/04/2000
• Est. Priority Date: 03/05/1997
• Status: Expired due to Term

• Current Assignee: Bellsouth Intellectual Property Corporation (AT&T, Inc.)
• Original Assignee: Bellsouth Intellectual Property Corporation (AT&T, Inc.)
• Inventors: Smets, Raymond J., Kraus, Evan
• Primary Examiner(s): Tsang, Fan S.
• Application Number:
  US09/263,475
• Time in Patent Office: 396 Days
• Field of Search: 379/88.19, 379/88.21, 379/88.22, 379/88.23, 379/88.25, 379/88.27, 707/1, 707/104, 707/2, 707/200, 707/203, 707/100, 707/3, 707/4, 707/530, 707/540
• US Class Current: 379/88.25
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: H04M 1/2746 Sorting, e.g. according to history or frequency of use
• CPC Class Codes: H04M 1/57 Arrangements for indicating or recording the number of the calling subscriber at the called subscriber's set at the operator set in a manual exchange H04M5/20
• CPC Class Codes: H04M 3/42229 Personal communication services, i.e. services related to one subscriber independent of his terminal and/or location diverting calls from one subscriber to another subscriber, i.e. two different subscriptions H04M3/54; selecting arrangements in intelligent networks H04Q3/005
• CPC Class Codes: H04M 3/46 Arrangements for calling a number of substations in a predetermined sequence until an answer is obtained
• CPC Class Codes: H04M 3/487 Arrangements for providing information services, e.g. recorded voice services or time announcements
• CPC Class Codes: H04Q 2213/13091 CLI, identification of calling line
• CPC Class Codes: H04Q 2213/13093 Personal computer, PC
• CPC Class Codes: H04Q 2213/13097 Numbering, addressing
• CPC Class Codes: H04Q 2213/13098 Mobile subscriber
• CPC Class Codes: H04Q 2213/13103 Memory
• CPC Class Codes: H04Q 2213/13109 Initializing, personal profile
• CPC Class Codes: H04Q 2213/13213 Counting, timing circuits
• CPC Class Codes: H04Q 2213/13345 Intelligent networks, SCP
• CPC Class Codes: H04Q 2213/13349 Network management
• CPC Class Codes: H04Q 2213/13377 Recorded announcement
• 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
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A method and apparatus to automate the process of updating and maintaining a dynamically changing database by assigning status states to each entry within the database and operating on those entries in accordance with the status states. More specifically, when a new entry for the database is received (13) it is classified as a short-term entry (11). If the new entry is accessed (14) prior to the expiration of the short-term status (15), then the classification of the entry is changed to long-term (12). Otherwise, if the short-term status expires (15), the entry is functionally removed from the database (10). Long term entries (12) are maintained within the database for an assigned period of time which attempts to emulate the useful life of the entry. Upon expiration of a long-term status (16), the entry is functionally removed from the database (10).

Claims

1. In a program module having access to a database of entries, each of said entries comprising a first reference date and a second reference date, and said program module having access to a timing device which provides a present date, a method for updating said database, comprising the steps of:

a. examining a first reference date and a second reference date for a first entry in said database;

b. removing said first entry from said database if said second reference date is not initialized and said first reference date is earlier than said present date;

c. removing said first entry from said database if said second reference date is earlier than said present date; and

d. examining a next first reference date and a next second reference for a next entry in said database and repeating steps b-c for said next entry.

2. The program module of claim 1, responsive to receiving a new entry for said database, further comprising the steps of:

equating a new first reference date to said present date plus a predetermined number of time units;

setting a new second reference date to a non-initialized value; and

storing said new entry, said new first reference date and said new second reference date in said database.

3. The program module of claim 2, wherein said predetermined number of time units ranges from 1 to 14 days and said equating step further comprises setting said new first reference date for said specific entry to the value of said present date plus said predetermined number of time units.

4. The program module of claim 1, responsive to receiving an update command, said update command being associated with a specific entry in said database, further comprising the steps of:

searching said database for said specific entry; and

if a second reference date for said specific entry is not initialized and a first reference date for said specific entry is later than said present date, equating said second reference date for said specific entry to said present date plus a predetermined number of time units.

5. The program module of claim 4, wherein said predetermined number of time units ranges from 30 to 180 days and said equating step further comprises setting said second reference date for said specific entry to said present date plus the said predetermined number of time units.