Method and system for provisioning databases in an advanced intelligent network

• US 6,009,430 A
• Filed: 12/19/1997
• Issued: 12/28/1999
• Est. Priority Date: 12/19/1997
• Status: Expired due to Term

• Current Assignee: WSOU Investments, LLC (WSOU Holdings, LLC)
• Original Assignee: Alcatel USA Sourcing L.P. (Nokia Corporation)
• Inventors: Payne, William A., Joseph, Rayappu F.
• Primary Examiner(s): Choules, Jack M.
• Assistant Examiner(s): Corrielus, Jean M
• Application Number:
  US08/993,792
• Time in Patent Office: 739 Days
• Field of Search: 379/67, 379/88.01, 379/89, 379/51, 379/50, 379/127, 379/114, 379/229, 707/204, 707/202, 707/10
• US Class Current: 1/1
• CPC Class Codes: H04Q 3/0029 Provisions for intelligent networking
• CPC Class Codes: H04Q 3/54533 Configuration data, translation, passwords, databases
• CPC Class Codes: H04Q 3/54558 Redundancy, stand-by
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A method of provisioning databases in a telecommunications system includes storing data for a telephony service in a plurality of redundant database nodes. An operation to be performed in the redundant database nodes is received and broadcast to the redundant database nodes for execution. Responses are received from the redundant database nodes. Each response includes an identification of the redundant database node transmitting the response and a result of executing the operation in the redundant database node. The results of the responses are automatically stored. In response to an event, the stored results are automatically queried to determine a status of the operation. The status of the operation is automatically reported.

Claims

1. A method of provisioning databases in a telecommunications system, comprising the steps of:

storing data for a telephony service in a plurality of redundant database nodes;

receiving an operation to be performed in the redundant database nodes;

automatically broadcasting the operation to the redundant database nodes for execution so that the redundant database nodes perform the operation simultaneously in parallel fashion;

receiving responses from the redundant database nodes, each response including an identification of the redundant database node transmitting the response and a result of executing the operation in the redundant database node;

automatically storing the results of the responses received from the redundant database nodes;

in response to an event, automatically querying the stored results to determine a status of the operation; and

automatically reporting the status of the operation.

2. The method of claim 1, wherein the event is an expiration of a response period.

3. The method of claim 2, further comprising the step of using a timer to time the response period, the event being the expiration of the timer.

4. The method of claim 1, wherein the event is receiving a response from each of the redundant database nodes.

5. The method of claim 4, further comprising the steps of:

setting a counter to represent the number of redundant database nodes;

in response to receiving a response from a redundant database node, automatically adjusting the counter to indicate receipt of the response; and

the event being the counter indicating receipt of a response from each of the redundant database nodes.

6. The method of claim 5, wherein the counter is set equal to the number of redundant database nodes, the counter is automatically decremented to indicate receipt of the response and the event is the counter being zero.

7. The method of claim 1, wherein the event is the first occurrence of an expiration of a response period or receipt of a response from each of the redundant database nodes.

8. The method of claim 1, wherein the status of the operation is successful if at least one of the results of executing the operation in a redundant database node is successful.

9. The method of claim 8, if the status of the operation is successful, further comprising the step of automatically logging the operation in a journal.

10. The method of claim 1, wherein the operation is received from an interface for the telephony service and the status of the operation is reported to the interface for the telephony service.

11. The method of claim 1, wherein the results are stored in a shared memory having a plurality of stores each associated with one of the redundant database nodes, further comprising the steps of:

resetting the stores to an initial value;

in response to receiving from a redundant database node a response having an unsuccessful result, automatically setting the store associated with the redundant database node to an unsuccessful value;

in response to receiving from a redundant database node a response having a successful result, automatically setting the store associated with the redundant database node to a successful value; and

wherein the status of the operation is determined from the values in the stores.

12. The method of claim 11, further comprising the step of setting the stores to a transmitted value in response to broadcasting the operation to the redundant database nodes.

13. The method of claim 12, wherein the initial value is -2, the transmitted value is -1, the unsuccessful value is 0 and the successful value is 1.

14. A method of provisioning databases in a telecommunications system, comprising the steps of:

storing data for a telephony service in a plurality of first redundant database nodes;

receiving a first operation to be performed in the first redundant database nodes;

automatically broadcasting the first operation to the first redundant database nodes for execution;

receiving responses from the first redundant database nodes, each response including an identification of the first redundant database node transmitting the response and a result of executing the first operation in the first redundant database node;

automatically storing the results of the responses received from the first redundant database nodes;

in response to an event, automatically querying the stored results to determine a status of the first operation;

automatically reporting the status of the first operation;

storing data for a second telephony service in a plurality of second redundant database nodes;

providing a shared memory having a plurality of first stores each associated with one of the first redundant database nodes and a plurality of second stores each associated with one of the second redundant database nodes;

wherein responses received from the first redundant database nodes are stored in the first stores and the first stores are queried to determine a status of the first operation;

receiving a second operation to be performed in the second redundant database nodes;

automatically broadcasting the second operation to the second redundant database nodes for execution;

receiving responses from the second redundant database nodes, each response including an identification of the second redundant database node transmitting the response and a result of executing the second operation in the second redundant database node;

automatically storing the results of the responses received from the second redundant database nodes in the second stores;

in response to a second event, automatically querying the second stores to determine a status of the second operation; and

automatically reporting the status of the second operation.

15. The method of claim 14, wherein the event is the first occurrence of an expiration of a first response period or receipt of a response from each of the first redundant database nodes and the second event is the first occurrence of an expiration of a second response period or receipt of a response from each of the second redundant database nodes.

16. The method of claim 14, further comprising the steps of:

in response to receiving the first operation, resetting the first stores to an initial value;

in response to broadcasting the first operation to the first redundant database nodes, setting the first stores to a transmitted value;

in response to receiving from a first redundant database node a response having an unsuccessful result, automatically setting the first store associated with the first redundant database node to an unsuccessful value;

in response to receiving from a first redundant database node a response having a successful result, automatically setting the first store associated with the first redundant database node to a successful value;

wherein the status of the first operation is determined from the values in the first stores;

in response to receiving the second operation, resetting the second stores to the initial value;

in response to broadcasting second the operation to the second redundant database nodes, setting the second stores to the transmitted value;

in response to receiving from a second redundant database node a response having an unsuccessful result, automatically setting the second store associated with the second redundant database node to the unsuccessful value;

in response to receiving from a second redundant database node a response having a successful result, automatically setting the second store associated with the second redundant database node to the successful value; and

wherein the status of the second operation is determined from the values in the second stores.

17. A method of provisioning databases in a telecommunications system, comprising the steps of:

storing data for a telephony service in a plurality of redundant database nodes each having a plurality of redundant processing modules;

receiving an operation to be performed in the redundant database nodes;

selecting a set of provisioning modules comprising a related provisioning module from each redundant database node;

automatically broadcasting the operation to the provisioning modules for execution in the redundant database nodes so that the redundant database nodes perform the operation simultaneously in parallel fashion;

receiving responses from the provisioning modules, each response including an identification of the provisioning module transmitting the response, the redundant database node of the provisioning module, and a result of executing the operation in the redundant database node;

automatically storing the results of the responses received from the provisioning modules;

in response to an event, automatically querying the stored results to determine a status of the operation; and

automatically reporting the status of the operation.

18. A method of provisioning databases in a telecommunications system, comprising the steps of:

storing data for a telephony service in a plurality of redundant database nodes each having a plurality of redundant processing modules;

receiving a first operation to be performed in the redundant database nodes;

selecting a set of first provisioning modules comprising a related provisioning module from each redundant database node;

automatically broadcasting the first operation to the first provisioning modules for execution in the redundant database nodes;

receiving responses from the first provisioning modules, each response including an identification of the first provisioning module transmitting the response, the redundant database node of the first provisioning module, and a result of executing the first operation in the redundant database node;

automatically storing the results of the responses received from the first provisioning modules;

in response to an event, automatically querying the stored results to determine a status of the first operation;

automatically reporting the status of the first operation;

receiving a second operation to be performed in the redundant database nodes;

selecting a set of second provisioning modules comprising a related provisioning module from each redundant database node;

providing a shared memory having a plurality of first stores each associated with one of the first provisioning modules and a plurality of second stores each associated with one of the second provisioning modules;

wherein results of the responses received from the first provisioning modules are stored in the first stores and the first stores are queried to determine a status of the first operation;

automatically broadcasting the second operation to the second provisioning modules for execution in the redundant database nodes;

receiving responses from the second provisioning modules, each response including an identification of the second provisioning module transmitting the response, the redundant database node of the second provisioning module, and a result of executing the second operation in the redundant database node;

automatically storing the results of the responses received from the second provisioning modules in the second stores;

in response to a second event, automatically querying the second stores to determine a status of the second operation; and

automatically reporting the status of the second operation.

19. A database provisioning system, comprising:

a plurality of redundant database nodes each comprising a provisioning module and a database storing data for a telephony service;

a manager module operable to automatically broadcast an operation to the redundant database nodes for execution by the provisioning modules on the databases, the redundant database nodes operable to perform the operation simultaneously in parallel fashion in response to the automatic broadcast;

a reply module operable to receive responses from the redundant database nodes, the responses each including a result of executing the operation in the redundant database node;

the reply module operable to automatically store in a shared memory the results of the responses received from the redundant database nodes;

in response to an event, the manager module operable to automatically access the shared memory to determine a status of the operation based on the stored results; and

the manager module operable to automatically report the status of the operation.

20. The database provisioning system of claim 19, further comprising:

the shared memory comprising a plurality of stores each associated with one of the redundant database nodes;

the manager module operable to reset the stores to an initial value in response to receiving the operation;

the manager module operable to set the stores to a transmit value in response to broadcasting the operation to the redundant database nodes;

the reply module operable to set a store associated with a redundant database node to an unsuccessful value in response to receiving from the redundant database node a response having an unsuccessful result;

the reply module operable to set a store associated with a redundant database node to a successful value in response to receiving from the redundant database node a response having a successful result; and

wherein the status of the operation is determined from the values in the stores.