Method and apparatus for automating the management of a database

• US 5,898,760 A
• Filed: 03/05/1997
• Issued: 04/27/1999
• Est. Priority Date: 03/05/1997
• Status: Expired due to Fees

• Current Assignee: Bellsouth Intellectual Property Corporation (AT&T, Inc.)
• Original Assignee: BellSouth Corporation (AT&T, Inc.)
• Inventors: Smets, Raymond J., Kraus, Evan
• Primary Examiner(s): Tsang, Fan S.
• Application Number:
  US08/811,895
• Time in Patent Office: 783 Days
• Field of Search: 379/88.19, 379/88.21, 379/88.22, 379/88.23, 379/88.24, 379/88.25, 379/88.27, 379/142, 707/530, 707/540
• US Class Current: 379/88.21
• 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. A computer-readable medium on which is stored a computer program for managing a caller-name announcement database, and a data file containing said caller-name announcement database, said caller-name announcement database comprising a plurality of entries indexed by a plurality of originating directory numbers, each of said entries including an announcement message, a use-by date and a keep-until date, said computer program having access to a timer and said computer program comprising instructions which, when executed by a computer, perform the steps of:

a. detecting a first call for a party, the first call having an originating directory number and being detected on a first date;

b. receiving an announcement message during the first call, the announcement message being associated with the originating directory number;

c. equating a use-by date to said first date plus a first predetermined number of time units;

d. storing said announcement message and said use-by date in said database indexed by said originating directory number;

e. detecting a second call for said party, said second call having said originating directory number and being detected on a second date;

f. if said second date is not later than said use-by date, equating a keep-until date to said second date plus a second predetermined number of time units;

g. if said second date is later than said first use-by date, receiving a new announcement message and equating said use-by data to said second date;

h. detecting a next call for said party, the next call having said originating directory number and being detected on a next date;

i. if said next date is later than said keep-until date, receiving a new announcement message, equating said use-by date to said next date and disabling said keep-until date.

2. The computer-readable medium of claim 1, wherein said receiving an announcement step further comprises the steps of:

prompting an originating party of said first call to recite audibly said announcement message; and

recording said announcement message.

3. The computer-readable medium of claim 1, wherein said database further comprises a plurality of candidate announcement messages and said receiving an announcement step further comprises the steps of:

prompting said originating party of s aid first call to enter a code; and

selecting a candidate announcement message in accordance with said code.

4. The computer-readable medium of claim 1, wherein said database further comprises a list of candidate announcement messages, each of said candidate announcement messages being associated with a particular originating directory number, and being operative to obtain a message announcement by retrieving a candidate announcement message from said list based on said originating directory number of said first call.

5. The computer-readable medium of claim 1, wherein said first predetermined number of time units ranges from 1 to 14 days.

6. The computer-readable medium of claim 1, wherein said second predetermined number of time units ranges from 30 to 180 days.

7. The computer-readable medium of claim 1, wherein said second predetermined number of time units is greater than said first predetermined number of time units.

8. In an integrated computer telephony system providing a caller-name announcement system including a caller-name announcement database, said database comprising a plurality of entries, each said entry including a caller-name announcement paired with an update indicator, a method for automatically updating said entries in said database, comprising the steps of:

receiving a call for a subscriber;

obtaining an identification key associated with said call;

determining an update in said database status pertaining to a database entry associated with said identification key; and

updating said database entry in accordance with said update status.

9. The method of claim 8, wherein said determining an update status step further comprises:

searching said database on said identification key for said database entry;

if said entry is not found, identifying said update status as requiring a caller-name announcement input for said identification key;

if said entry is found, examining an update indicator for said entry, said update indicator for said entry comprising a first reference date and a second reference date; and

if said second reference date is not initialized and said call is received prior to said first reference date, identifying said update status as requiring said second reference date to be initialized,

if said second reference date is not initialized and said call is received after said first reference date, identifying said update status as requiring a caller-name announcement input for said identification key,

if said second reference date is initialized and said call is received prior to said second reference date, identifying said update status as being current, and

if said second reference date is initialized and said call is received after said second reference date, identifying said update status as requiring a caller-name announcement input for said identification key.

10. The method of claim 8, wherein said update status indicates said database require s a caller-name announcement input for said identification key and said update indicator comprises a first reference date and a second reference date, and wherein said updating step further comprises:

receiving a caller-name announcement message for said identification key;

equating a first reference date for said identification key to a value representing a predetermined number of time units from the date of receiving said call;

setting a second reference date for said identification key to a non-initialized state; and

storing said caller-name announcement message and said update indicator in said database for said identification key.

11. The method of claim 10, wherein said predetermined number of time units ranges from 1 to 14 days.

12. The method of claim 8, wherein said update status indicates a requirement for said second reference date to be initialized, and said updating step further comprises equating said second reference date to a value representing a predetermined number of time units from the date of receiving said call.

13. The method of claim 12, wherein said predetermined number of time units ranges from 30 to 180 days.

14. The method of claim 10, wherein said receiving a caller-name announcement message step further comprises:

prompting an originating party of said call to recite audibly said caller-name announcement message; and

recording said caller-name announcement message.

15. The method of claim 10, wherein said database further comprises a plurality of candidate caller-name announcement messages and said receiving a caller-name announcement message step further comprises:

prompting an originating party of said call to enter a code to identify a candidate caller-name announcement message; and

retrieving said candidate caller-name announcement message from said database in accordance with said code.

16. The method of claim 10, wherein said database further comprises a list of candidate caller-name announcement messages, each of said candidate caller-name announcement messages being associated with a particular originating directory number and said list being updated by a separate process, and wherein said receiving a caller-name announcement message step further comprises retrieving a candidate caller-name announcement message from said list based on said originating directory number of said call.

17. In a program module operating within a telecommunications system and having access to a database of entries, each said entry comprising a search key, an announcement message, 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 automatically updating said database, comprising the steps of:

receiving a call;

identifying a search key associated with said call;

searching said database on said search key to obtain an entry;

if said entry is not found in the database, performing an update process for said entry;

if said second reference date of said entry is not initialized and said first reference date of said entry is later than said present date, initializing said second reference date for said entry;

if said second reference date of said entry is not initialized and said first reference of said entry is earlier than said present date, performing an update process for said entry; and

if said second reference date of said entry is initialized and is earlier than said present date, performing an update process for said entry.

18. The program module of claim 17, wherein said step of initializing said second reference date further comprises the step of equating said second reference date to said present date plus a predetermined number of time units.

19. The program module of claim 17, wherein a predetermined number of time units ranges from 30 to 180 days and said initializing step further comprises the step of equating said second reference date to a date value representing said predetermined number of time units from said present date.

20. The program module of claim 17, wherein said step of performing an update process for said entry comprises the steps of:

receiving an announcement message for said entry;

setting said second reference date of said entry to a non-initialized value;

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

storing said announcement message, said first reference date, said second reference date and said search key in said database as said entry.

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

22. The program module of claim 20, wherein said announcement message comprises a caller-name identifying an originating party associated with said call, and wherein said receiving a caller-name announcement message step further comprises the steps of:

prompting said originating party of said call to audibly recite said caller-name; and

recording said caller-name.

23. A computer system for automatically updating a caller-name announcement database, comprising:

a processing unit;

a memory storage device operative to store said caller-name announcement database;

an interface device coupled to said processing unit for receiving calls; and

a timer being operative to provide a present date;

said processing unit being operative to;

detect a call from an originating directory number on said interface device;

search said caller-name announcement database in said memory storage device to obtain an entry for said originating directory number;

if said entry is a short-term entry, convert said entry to a long-term entry;

update said caller-name announcement database if said caller-name announcement database does not contain said entry; and

update said caller-name announcement database if said entry has expired.

24. The computer system of claim 23, wherein said entry comprises an announcement message, a first reference date and a second reference date, said entry is expired if said entry is a short-term entry and said first reference date for said entry plus a first predetermined number of time units is earlier than said present date and wherein said processing unit updates said caller-name announcement database by updating said entry.

25. The computer system of claim 24, wherein said processing unit updates said entry by:

obtaining an announcement message for said entry;

setting said second reference date to a non-initialized value;

equating said first reference date to said present date; and

storing said announcement message, said first reference date and said second reference date in said caller-name announcement database as said entry.

26. The computer system of claim 23, wherein said entry comprises an announcement message, a first reference date and a second reference date, said entry is expired, if said entry is a long-term entry and said second reference date plus a second predetermined number of time units is earlier than said present date said processing unit updates said caller-name announcement database by updating said entry.

27. The computer system of claim 26, wherein said processing unit updates said entry by:

obtaining an announcement message for said entry;

setting said second reference date to a non-initialized value;

equating said first reference date to said present date indicated by said timer; and

storing said announcement message, said first reference date and said second reference date in said caller-name announcement database as said entry.

28. The computer system of claim 23, wherein said entry comprises an announcement message, a first reference date and a second reference date, and said entry is a short-term entry with said first reference date being less than a first predetermined number of time units earlier than said present date and said second reference date not containing a valid date, and said processing unit converts said entry by equating said second reference date for said entry to said present date.

29. The computer system of claim 28, wherein said first predetermined number of time units can range from 1 to 14 days.

30. The computer system of claim 23, wherein said entry comprises an announcement message, a first reference date and a second reference date, and said entry is a long-term entry with said second reference date containing a valid date which is less than a second predetermined number of time units earlier than said present date.

31. The computer system of claim 30, wherein said second predetermined number of time units can range from 30 to 180 days.

32. The computer system of claim 23, wherein said entry comprises an announcement message, a first reference date and a second reference date, said entry is expired if said entry is a short-term entry and said first reference date plus a first predetermined number of time units is earlier than said present date, said entry is expired if said entry is a long-term entry and second reference date plus a second predetermined number of time units is earlier than said present date, and said second predetermined number of time units is substantially greater than said first predetermined number of time units.