Patent US4344291A successfully refreshed from Google Patents.
Patent US21237A successfully refreshed from Google Patents.
Patent US5873099A successfully refreshed from Google Patents.
US5873099A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for maintaining redundant databases
Assignee: Global Crossing Telecommunications Inc
•
Filing: 1995-04-13
•
Granted: 1999-02-16
•
Expires: 2015-04-13
Abstract
Abstract A system and method for processing telephone calls and providing enhanced services is presented. The call processing system includes a network control processor for controlling the processing and routing of the calls and for providing enhanced features, and a matrix switch for routing calls from an originating location to a terminating location. Operator consoles can be included to provide operator assistance to the caller. The network control processor comprises a central message processor that receives call data, determines the type of call, determines the processing required, and determines whether operator assistance is required. A call route distributor allocates an operator console to the call if required. A billing server is used to track billing information for the call while it is in progress. A database server is provided for database look-ups and storage. The call processing system also includes a validation system, a billing system, a distribution system, and a fraud detection and prevention system. The validation system is used to validate call information to determine whether the call can be placed. The billing system determines rates for calls and calculates the cost of completed calls. The distribution system distributes changes that are made to a master database to the appropriate slave database. The fraud detection and prevention system monitors originating and in-process calls to detect and possibly prevent possible fraudulent uses of phone services and systems. A client interface is provided to facilitate communications among applications and DEF records are used to define specific call processing actions.
Inventors
- 👤 Steven J. Hogan
- 👤 Kristi T. Feltz
- 👤 Douglas R. Murdock
- 👤 Todd A. Goodman
- 👤 David J. Vercande
- 👤 Michael R. Tangeman
- 👤 Eric M. Busch
- 👤 Raghavan Kripakaran
- 👤 Madhigubba G. Jayasimha
- 👤 Keith E. Smith
- 👤 Mark A. Austin
- 👤 Dana Bruce Berry
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-28 16:19
CPC Classifications
H; H04; H04M; H04M15/00; H04M15/44; H04M15/47; H04M15/68; H04M3/00; H04M3/42; H04Q; H04Q3/00; H04Q3/0016; H04Q3/0062; H04M2215/00; H04M2215/01; H04M2215/0104; H04M2215/0148; H04M2215/0196; Y; Y10; Y10S; Y10S707/00; Y10S707/99951; Y10S707/99952; Y10S707/99953; Y10S707/99955
Claims Analysis
Total Claims: 45
Claim 1
Independent Claim
145 words
A system for updating one or more redundant databases to reflect a change made to a first database, comprising: distribution means for receiving the change made to the first database and for determining which of said one or more redundant databases is to be updated to reflect the change; first storage means comprising a location for storing the change made to the first database; second storage means comprising an entry for storing an indication of each determined database and for storing an indication of said location where said change is stored in said first storage means; and dealer means for updating said indicated database, said dealer means including means for reading said entry from said second storage means, means for retrieveing said change from said first storage means, and means for updating said indicated redundant database using the change retrieved from said first storage means.
Claim 2
Independent Claim
145 words
A system for updating one or more redundant databases to reflect a change made to a first database, comprising: distribution means for receiving the change made to the first database and for determining which of said one or more redundant databases is to be updated to reflect the change; first storage means comprising a location for storing the change made to the first database; second storage means comprising an entry for storing an indication of each determined database and for storing an indication of said location where said change is stored in said first storage means; and dealer means for updating said indicated database, said dealer means including means for reading said entry from said second storage means, means for retrieveing said change from said first storage means, and means for updating said indicated redundant database using the change retrieved from said first storage means.
Claim 3
Dependent Claim
24 words
The system of claim 1, wherein said means for reading said entry comprises means for reading an oldest entry from said second storage means.
Claim 4
Dependent Claim
30 words
The system of claim 2, wherein said dealer means further comprises means for deleting said oldest entry from said second storage means after said indicated redundant database has been updated.
Claim 5
Dependent Claim
25 words
The system of claim 1, further comprising configuration table means for storing information regarding whether one or more of the plurality of redundant databases exists.
Claim 6
Dependent Claim
28 words
The system of claim 1, wherein said distribution means further comprising means for sending an event indication message to said dealer means indicating that the change was received.
Claim 7
Dependent Claim
44 words
The system of claim 1 further comprising: third storage means within the database for storing the change made to the first database; and means for sending a message to said distribution means indicating that the change has been stored in said third storage means.
Claim 8
Dependent Claim
26 words
The system of claim 6, further comprising means for deleting the change from said third storage means after the change is stored in first storage means.
Claim 9
Dependent Claim
27 words
The system of claim 1, further comprising means for sending the change to a second table, wherein said second table stores changes made to the first database.
Claim 10
Dependent Claim
29 words
The system of claim 8, further comprising means for sending a trigger message to said distribution means to indicate that the change has been stored in said second table.
Claim 11
Dependent Claim
140 words
In a computer system having a first database that is updated by an application and a plurality of redundant databases, a system for updating one or more of the redundant databases to reflect a change made to said first database, comprising: means for receiving an event indicating that the change has been made to said first database; means for determining which one or more of the redundant databases is to be updated to reflect the change made to said first database; table means for storing the change to be made to said determined one or more of the redundant databases; means for retrieving the change from said table means and updating said one or more determined redundant databases to reflect the change; and wherein the system performs the database updates without requiring involvement by the application updating the first database.
Claim 12
Dependent Claim
140 words
In a computer system having a first database that is updated by an application and a plurality of redundant databases, a system for updating one or more of the redundant databases to reflect a change made to said first database, comprising: means for receiving an event indicating that the change has been made to said first database; means for determining which one or more of the redundant databases is to be updated to reflect the change made to said first database; table means for storing the change to be made to said determined one or more of the redundant databases; means for retrieving the change from said table means and updating said one or more determined redundant databases to reflect the change; and wherein the system performs the database updates without requiring involvement by the application updating the first database.
Claim 13
Dependent Claim
36 words
The system of claim 10, further comprising storage means for storing information as to whether said one or more of the at least one redundant database by said means for determining exists in the computer system.
Claim 14
Dependent Claim
68 words
The system of claim 10, wherein said table means comprises: a first table for storing a message in a location, wherein said message indicates the change to said first database; and a second table for storing an entry for each redundant database to be updated as determined by said means for determining, wherein each entry indicates said location in said first table of said message indicating the change.
Claim 15
Dependent Claim
83 words
The system of claim 12, wherein said means for retrieving and updating comprises: means for reading an oldest entry from said second table, said entry indicating a redundant database to be updated and indicating said location in said first table of the change for said indicated redundant database, means for reading said location pointed to by said second table to retrieve the change from said first table, and means for updating said indicated redundant database using the change retrieved from said first table.
Claim 16
Dependent Claim
32 words
The system of claim 13, wherein said means for updating and deleting further comprises means for deleting said oldest entry from said second table after said indicated redundant database has been updated.
Claim 17
Dependent Claim
240 words
In a computer system having a first database that is updated by an application and at least one redundant database, a method of updating one or more of the at least one redundant database to reflect a change made to said first database, comprising the steps of: (a) receiving from the first database an event indicating that the change has been made to the first database; (b) storing a message in a location in a first table, wherein said message indicates the change to said first database; (c) determining which one or more of the at least one redundant database is to be updated to reflect the change made to the first database; (d) updating a second table to include an entry for each redundant database to be updated as determined in said determination step (c), wherein each entry indicates said location in said first table of said message indicating the change; and (e) updating each said redundant database to be updated as determined in step (c), step (e) comprising the steps of i. reading an oldest entry from said second table, said entry indicating a redundant database to be updated and indicating said location in said first table of the change for said indicated redundant database, ii. reading said location pointed to by said second table to retrieve the change from said first table, and iii. updating said indicated redundant database using the change retrieved from said first table.
Claim 18
Dependent Claim
240 words
In a computer system having a first database that is updated by an application and at least one redundant database, a method of updating one or more of the at least one redundant database to reflect a change made to said first database, comprising the steps of: (a) receiving from the first database an event indicating that the change has been made to the first database; (b) storing a message in a location in a first table, wherein said message indicates the change to said first database; (c) determining which one or more of the at least one redundant database is to be updated to reflect the change made to the first database; (d) updating a second table to include an entry for each redundant database to be updated as determined in said determination step (c), wherein each entry indicates said location in said first table of said message indicating the change; and (e) updating each said redundant database to be updated as determined in step (c), step (e) comprising the steps of i. reading an oldest entry from said second table, said entry indicating a redundant database to be updated and indicating said location in said first table of the change for said indicated redundant database, ii. reading said location pointed to by said second table to retrieve the change from said first table, and iii. updating said indicated redundant database using the change retrieved from said first table.
Claim 19
Dependent Claim
58 words
The method according to claim 15, wherein said steps (a)-(e) are performed by a distribution system and further comprising the steps, before said step (a), of: storing in a delta table the change made to the first database; and sending a first message to the distribution system indicating that the change has been stored in said delta table.
Claim 20
Dependent Claim
27 words
The method according to claim 16, further comprising the step of deleting the change from said delta table after said message is stored in said first table.
Claim 21
Dependent Claim
39 words
The method according to claim 15, further comprising the step of checking a configuration table to determine whether said one or more of the at least one redundant database determined in said step (c) exists in the computer system.
Claim 22
Dependent Claim
40 words
The method according to claim 15, wherein said step (e) is performed by a dealer, the method further comprising the step of sending an event indication message to said dealer indicating that said event was received in said step (a).
Claim 23
Dependent Claim
31 words
The method according to claim 15, wherein said step (e) further comprises the step of deleting said oldest entry from said second table after said indicated redundant database has been updated.
Claim 24
Dependent Claim
19 words
The method according to claim 20, wherein said step (e) is repeated for each entry in said second table.
Claim 25
Dependent Claim
164 words
In a computer system having a first database that is updated by an application and a redundant database, a method of updating the redundant database to reflect a change made to said first database, comprising the steps of: (a) receiving from the first database an event indicating that the change has been made to the first database; (b) storing a message in a location in a first table, wherein said message indicates the change to said first database; (c) updating a second table to indicate said location in said first table of said message indicating the change; and (d) updating the redundant database, comprising the steps of i. reading an oldest entry from said second table, said entry indicating said location in said first table of the change for the redundant database, ii. reading said location pointed to by said second table to retrieve the change from said first table, and iii. updating the redundant database using the change retrieved from said first table.
Claim 26
Dependent Claim
164 words
In a computer system having a first database that is updated by an application and a redundant database, a method of updating the redundant database to reflect a change made to said first database, comprising the steps of: (a) receiving from the first database an event indicating that the change has been made to the first database; (b) storing a message in a location in a first table, wherein said message indicates the change to said first database; (c) updating a second table to indicate said location in said first table of said message indicating the change; and (d) updating the redundant database, comprising the steps of i. reading an oldest entry from said second table, said entry indicating said location in said first table of the change for the redundant database, ii. reading said location pointed to by said second table to retrieve the change from said first table, and iii. updating the redundant database using the change retrieved from said first table.
Claim 27
Dependent Claim
57 words
The method according to claim 22, wherein said steps (a)-(d) are performed by a distribution system and further comprising the steps, before said step (a), of: storing in a delta table the change made to the first database; and sending said message to the distribution system indicating that the change has been stored in said delta table.
Claim 28
Dependent Claim
27 words
The method according to claim 23, further comprising the step of deleting the change from said delta table after said message is stored in said first table.
Claim 29
Dependent Claim
40 words
The method according to claim 22, wherein said step (d) is performed by a dealer, the method further comprising the step of sending an event indication message to said dealer indicating that said event was received in said step (a).
Claim 30
Dependent Claim
138 words
In a computer system having a first database that is updated by an application and a plurality of redundant databases, a method of updating one or more of the redundant databases to reflect a change made to said first database, comprising the steps of: (a) receiving an event indicating that the change has been made to said first database; (b) determining which one or more of the redundant databases is to be updated to reflect the change made to said first database; (c) updating a table to reflect the change to be made to said one or more determined redundant databases; and (d) retrieving the change from said table and updating said one or more determined redundant databases to reflect the change; wherein said steps (a)-(d) are performed without requiring involvement by the application updating the first database.
Claim 31
Dependent Claim
138 words
In a computer system having a first database that is updated by an application and a plurality of redundant databases, a method of updating one or more of the redundant databases to reflect a change made to said first database, comprising the steps of: (a) receiving an event indicating that the change has been made to said first database; (b) determining which one or more of the redundant databases is to be updated to reflect the change made to said first database; (c) updating a table to reflect the change to be made to said one or more determined redundant databases; and (d) retrieving the change from said table and updating said one or more determined redundant databases to reflect the change; wherein said steps (a)-(d) are performed without requiring involvement by the application updating the first database.
Claim 32
Dependent Claim
39 words
The method according to claim 26, further comprising the step of checking a configuration table to determine whether said one or more of the at least one redundant database determined in said step (b) exists in the computer system.
Claim 33
Dependent Claim
84 words
The method according to claim 26, wherein said table comprises a first and a second table and said step (c) comprises the steps of: i. storing a message in a location in said first table, wherein said message indicates the change to said first database; and ii. updating said second table to include an entry for each redundant database to be updated as determined in said step (b), wherein each entry indicates said location in said first table of said message indicating the change.
Claim 34
Dependent Claim
81 words
The method according to claim 28, wherein said step (d) comprises the steps of: i. reading an oldest entry from said second table, said entry indicating a redundant database to be updated and indicating said location in said first table of the change for said indicated redundant database, ii. reading said location pointed to by said second table to retrieve the change from said first table, and iii. updating said indicated redundant database using the change retrieved from said first table.
Claim 35
Dependent Claim
31 words
The method according to claim 29, wherein said step (d) further comprises the step of deleting said oldest entry from said second table after said indicated redundant database has been updated.
Claim 36
Dependent Claim
19 words
The method according to claim 29, wherein said step (d) is repeated for each entry in said second table.
Claim 37
Dependent Claim
177 words
In a computer system having a first database that is updated by an application and at least one redundant database, a method of updating one or more of the at least one redundant database to reflect a change made to said first database, comprising the steps of: (a) receiving from the application the change to be made to the first database; (b) updating the first database to reflect the change; (c) sending an event to a first table, said event indicating that the change has been made to the first database; (d) sending a first trigger to a distribution server, the trigger indicating that said event has been sent to said first table; (e) said distribution server retrieving said event from said first table in response to said first trigger; and (f) said distribution server updating one or more of the at least one redundant database to reflect the change made to the first database as determined by said retrieved event; wherein said steps (c)-(f) are performed without requiring involvement by the application updating the first database.
Claim 38
Dependent Claim
177 words
In a computer system having a first database that is updated by an application and at least one redundant database, a method of updating one or more of the at least one redundant database to reflect a change made to said first database, comprising the steps of: (a) receiving from the application the change to be made to the first database; (b) updating the first database to reflect the change; (c) sending an event to a first table, said event indicating that the change has been made to the first database; (d) sending a first trigger to a distribution server, the trigger indicating that said event has been sent to said first table; (e) said distribution server retrieving said event from said first table in response to said first trigger; and (f) said distribution server updating one or more of the at least one redundant database to reflect the change made to the first database as determined by said retrieved event; wherein said steps (c)-(f) are performed without requiring involvement by the application updating the first database.
Claim 39
Dependent Claim
36 words
The method according to claim 32, further comprising the step of determining which one or more of the at least one redundant database is to be updated to reflect a change made to said first database.
Claim 40
Dependent Claim
35 words
The method according to claim 33, further comprising the step of checking a configuration table to determine whether said one or more of the at least one redundant database determined exists in the computer system.
Claim 41
Dependent Claim
234 words
In a computer system having a first database that is updated by an application and a plurality of redundant databases, a method of updating one or more of the redundant databases to reflect a change made to said first database, comprising the steps of: (a) receiving from the application the change to be made to the first database; (b) updating a first table in the first database to reflect the change; (c) sending an event to a second table, said event indicating that the change has been made to said first table; (d) sending a first trigger to a distribution server, the trigger indicating that said event has been sent to said second table; (e) said distribution server retrieving said event from said second table in response to said first trigger; (f) said distribution server determining which one or more of the at least one redundant database is to be updated to reflect the change made to said first database; (g) said distribution server updating distribution tables to reflect the change to be made to said determined one or more of the redundant databases; (h) said distribution server sending a second trigger to a dealer indicating that one or more of the redundant databases is to be updated; and (i) said dealer retrieving the change from said distribution tables and updating said determined one or more of the redundant databases to reflect the change.
Claim 42
Dependent Claim
234 words
In a computer system having a first database that is updated by an application and a plurality of redundant databases, a method of updating one or more of the redundant databases to reflect a change made to said first database, comprising the steps of: (a) receiving from the application the change to be made to the first database; (b) updating a first table in the first database to reflect the change; (c) sending an event to a second table, said event indicating that the change has been made to said first table; (d) sending a first trigger to a distribution server, the trigger indicating that said event has been sent to said second table; (e) said distribution server retrieving said event from said second table in response to said first trigger; (f) said distribution server determining which one or more of the at least one redundant database is to be updated to reflect the change made to said first database; (g) said distribution server updating distribution tables to reflect the change to be made to said determined one or more of the redundant databases; (h) said distribution server sending a second trigger to a dealer indicating that one or more of the redundant databases is to be updated; and (i) said dealer retrieving the change from said distribution tables and updating said determined one or more of the redundant databases to reflect the change.
Claim 43
Dependent Claim
27 words
The method according to claim 35, further comprising the step of deleting the change from said second table after said message is stored in said first table.
Claim 44
Dependent Claim
39 words
The method according to claim 35, further comprising the step of checking a configuration table to determine whether said one or more of the at least one redundant database determined in said step (f) exists in the computer system.
Claim 45
Dependent Claim
32 words
The method according to claim 35, further comprising the step of deleting said oldest entry from said second table after said indicated one or more of the redundant databases has been updated.
References Cited (Backward Citations)
US3568156A
Cited
US4232199A
Cited
US4432057A
Cited
US4577061A
Cited
US4625081A
Cited
US4611096A
Cited
US4685127A
Cited
US4791640A
Cited
US4706275A
Cited
US4782519A
Cited
US4882475A
Cited
US4809170A
Cited
US4757267A
Cited
US4757267B1
Cited
US4853843A
Cited
US5068891A
Cited
US4893330A
Cited
US5379418A
Cited
US5195086A
Cited
WO1991016779A1
Cited
US5555290A
Cited
US5222120A
Cited
US5136636A
Cited
US5311572A
Cited
US5440727A
Cited
US5341414A
Cited
US5615364A
Cited
US5404508A
Cited
US5506897A
Cited
US5506897C1
Cited
US5638430A
Cited
US5546449A
Cited
US5649089A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-02-15 | 2002-08-17 | 2003-02-16 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-02-15 | 2006-08-17 | 2007-02-16 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-02-15 | 2010-08-17 | 2011-02-16 | $7700.00 | Window Closed / Lapsed |