Method and system for provisioning telecommunications services in an advanced intelligent network

• US 6,138,110 A
• Filed: 12/30/1997
• Issued: 10/24/2000
• Est. Priority Date: 12/30/1997
• Status: Expired due to Fees

• Current Assignee: Alcatel USA Sourcing L.P. (Nokia Corporation)
• Original Assignee: Alcatel USA Sourcing L.P. (Nokia Corporation)
• Inventors: Doone, Heather M., Jahn, Alfredo
• Primary Examiner(s): Alam, Hosain T.
• Assistant Examiner(s): Shah, Sanjiv
• Application Number:
  US09/001,331
• Time in Patent Office: 1,029 Days
• Field of Search: 707/1, 707/2, 707/10, 707/100, 707/102, 707/104
• US Class Current: 1/1
• CPC Class Codes: H04Q 3/0054 Service creation techniques
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

A method of provisioning services in a telecommunications network includes providing a client site having a client interface. Database sites connected to the client site in the telecommunications network are determined. The database sites each have a server interface and at least one database storing data for a telecommunications service. A communication session between the client interface and the server interfaces of the database sites is established. At the client interface, a database operation is received to be performed in at least one database of the database sites. The database operation is transmitted from the client interface to at least one server interface for execution in a database.

Claims

1. A method of provisioning services in a telecommunications network, comprising:

providing a client site in a telecommunications network, the client site having a client interface;

determining database sites connected to the client site in the telecommunications network, the database sites each having a server interface and at least one database storing data for a telecommunications service;

establishing a communication session between the client interface and the server interfaces of the database sites;

receiving at the client interface a database operation to be performed in at least one database of the database sites;

transmitting the database operation from the client interface to at least one server interface for execution in a database;

initially selecting each of the database sites connected to the client site for transmission of the database operations;

in response to an operator request, deselecting a database site; and

transmitting the database operation from the client interface to the server interface of each selected database site.

2. The method of claim 1, further comprising:

reselecting the database site in response to a second operator request.

3. A method of provisioning services in a telecommunications network, comprising:

providing a client site in a telecommunications network, the client site having a client interface;

determining database sites connected to the client site in the telecommunications network, the database sites each having a server interface and at least one database storing data for a telecommunications service;

establishing a communication session between the client interface and the server interfaces of the database sites;

receiving at the client interface a database operation to be performed in at least one database of the database sites;

transmitting the database operation from the client interface to at least one server interface for execution in a database;

initially selecting each of the database sites connected to the client site for transmission of the database operations;

in response to a failure of a database site, deselecting the database site; and

transmitting the database operation from the client interface to the server interface of each selected database site.

4. A method of provisioning services in a telecommunications network, comprising:

providing a client site in a telecommunications network, the client site having a client interface;

determining database sites connected to the client site in the telecommunications network, the database sites each having a server interface and at least one database storing data for a telecommunications service;

establishing a communication session between the client interface and the server interfaces of the database sites;

receiving at the client interface a database operation to be performed in at least one database of the database sites;

transmitting the database operation from the client interface to at least one server interface for execution in a database;

generating a first list including each of the database sites connected to the client site;

generating a second list including a status for each database site of the first list;

transmitting the database operation from the client interface to the server interfaces of only the database sites having a first value of the status.

5. The method of claim 4, wherein the second list is operable to be accessed by an operator to change the status of a database site.

6. A method of provisioning services in a telecommunications network, comprising:

providing a client site in a telecommunications network, the client site having a client interface;

determining database sites connected to the client site in the telecommunications network, the database sites each having a server interface and at least one database storing data for a telecommunications service;

establishing a communication session between the client interface and the server interfaces of the database sites;

receiving at the client interface a database operation to be performed in at least one database of the database sites;

transmitting the database operation from the client interface to at least one server interface for execution in a database;

if the database operation modifies data for a telecommunications service, the server interface passing the database operation to a database manager operable to modify databases storing data for the telecommunications service; and

if the database operation is a query, the server interface passing the database operation to an SQL server operable to query the database independently of the database manager.

7. A method of provisioning services in a telecommunications network, comprising:

providing a client site in a telecommunications network, the client site having a client interface;

determining database sites connected to the client site in the telecommunications network, the database sites each having at least one database storing data for a telecommunications service and an active and a standby site manager with a server interface;

for each database site, determining the active site manager;

establishing a communication session between the client interface and the server interfaces of the active site managers of the database sites;

receiving at the client interface a database operation to be performed in at least one database of the database sites;

transmitting the database operation from the client interface to at least one server interface of an active site manager for execution in a database;

generating a first list including each of the database sites connected to the client site;

generating a second list including a status for each database site of the first list;

associating each active site manager with its database site; and

transmitting the database operation from the client interface to the server interfaces of only the database sites having a first value of the status.

8. A method of provisioning services in a telecommunications network, comprising:

providing a client site in a telecommunications network, the client site having a client interface;

determining database sites connected to the client site in the telecommunications network, the database sites each having at least one database storing data for a telecommunications service and an active and a standby site manager with a server interface;

for each database site, determining the active site manager;

establishing a communication session between the client interface and the server interfaces of the active site managers of the database sites;

receiving at the client interface a database operation to be performed in at least one database of the database sites;

transmitting the database operation from the client interface to at least one server interface of an active site manager for execution in a database, wherein the communication session with a server interface is established via a dedicated socket at the server interface;

generating a second list including a status for each database site of the first list;

associating each active site manager with its database site;

generating an array of active site managers indexed by database site;

generating an array of socket handles indexed by active site manager;

using the second list to determine database sites having a first value of the status;

using the array of active site managers to determine active site managers for the database sites having the first value of the status;

using the array of socket handles to determine socket handles for the active site managers of the database sites having the first value of the status; and

transmitting the database operation from the client interface to the server interfaces using only the socket handles for the active site managers of the database sites having the first value of the status.

9. A method of provisioning services in a telecommunications network, comprising:

providing a client site in a telecommunications network, the client site having a client interface;

determining database sites connected to the client site in the telecommunications network, the database sites each having at least one database storing data for a telecommunications service and an active and a standby site manager with a server interface;

for each database site, determining the active site manager;

establishing a communication session between the client interface and the server interfaces of the active site managers of the database sites;

receiving at the client interface a database operation to be performed in at least one database of the database sites;

transmitting the database operation from the client interface to at least one server interface of an active site manager for execution in a database;

wherein the step of determining database sites connected to the client site in the telecommunications network includes;

broadcasting a request from the client site over the telecommunications network for each database site to respond with an identification of the database site; and

receiving the identification of the database sites connected to the client site in the telecommunications network.

10. The method of claim 9, wherein the request is broadcast and the identifications are received via a Corba interface in the client site.

11. The method of claim 9, wherein the step of determining an active site manager for each database site connected to the client site in the telecommunications network includes:

transmitting a second request from the client site over the telecommunications network to each database site to respond with an identification of the active site manager; and

receiving the identification of the active site managers from the database sites.

12. A method of provisioning services in a telecommunications network, comprising:

providing a client site in a telecommunications network, the client site having a client interface;

determining database sites connected to the client site in the telecommunications network, the database sites each having at least one database storing data for a telecommunications service and an active and a standby site manager with a server interface;

for each database site, determining the active site manager;

establishing a communication session between the client interface and the server interfaces of the active site managers of the database sites;

receiving at the client interface a database operation to be performed in at least one database of the database sites;

transmitting the database operation from the client interface to at least one server interface of an active site manager for execution in a database;

in response to a failure of the active site manager in one of the database sites, the standby site manager becoming a new active site manager in the database site;

determining the new active site manager;

establishing a communication session between the client interface and the server interface of the new active site manager of the database site.

13. An advanced intelligent network, comprising:

a service management system having a client interface;

a plurality of service control points connected to the service management system via a network, the service control points each having a server interface and at least one database storing data for a telecommunications service;

the client interface operable to identify the service control points and to establish a communication session between the client interface and the server interfaces of the service control points; and

in response to receiving a database operation to be performed in at least one database of the service control points, the client interface operable to transmit the database operation from the client interface to at least one server interface for execution in a database;

a list including a status for each service control point, the client interface operable to transmit the database operation from the client interface to the server interfaces of only the service control points having a first value of the status in the list.