Method and apparatus for accessing a database through a network

• US 6,601,065 B1
• Filed: 12/21/2000
• Issued: 07/29/2003
• Est. Priority Date: 12/21/2000
• Status: Expired due to Term

• Current Assignee: Cisco Technology, Inc. (Cisco Systems, Inc.)
• Original Assignee: Cisco Technology, Inc. (Cisco Systems, Inc.)
• Inventors: Luther, Clay W., Treece, Alan W., Sanders, Jeffery A., Forsythe, William C., Nelson, Mark R.
• Primary Examiner(s): Metjahic, Safet
• Assistant Examiner(s): Alaubaidi, Haythim J.
• Application Number:
  US09/746,272
• Time in Patent Office: 950 Days
• Field of Search: 707/1-4, 379/218, 379/218.01
• US Class Current: 707/781
• CPC Class Codes: G06F 16/2452 Query translation
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: H04L 12/66 Arrangements for connecting between networks having differing types of switching systems, e.g. gateways
• CPC Class Codes: H04L 61/4505 using standardised directories; using standardised directory access protocols
• CPC Class Codes: H04L 61/4523 using lightweight directory access protocol [LDAP]
• CPC Class Codes: H04L 61/4557 Directories for hybrid networks, e.g. including telephone numbers
• CPC Class Codes: H04L 67/565 Conversion or adaptation of application format or content adding application control or application functional data H04L67/561
• CPC Class Codes: H04L 69/08 Protocols for interworking; Protocol conversion
• CPC Class Codes: H04L 9/40 Network security protocols
• CPC Class Codes: Y10S 707/922 Communications
• CPC Class Codes: Y10S 707/959 Network
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A system (10) includes a client (14, 21) which can communicate through a network (12) and a database layer (29) with any of several databases (31-33). The client communicates with the database layer using a public network communication protocol, in a manner independent of respective protocols specific to each of the databases. The database layer handles communication with each database according to the respective protocol of that database.

Claims

1. A method, comprising the steps of:

providing a network through which can be transmitted message units that contain information in a digital form;

transmitting from a client through said network a message which is in the form of at least one message unit and which contains a request directed to a repository, said request being in a first format conforming to a public network communication protocol;

receiving said request from said network;

thereafter converting said request from said first format to a second format compatible with a protocol of said repository;

using said request in said second format to access said repository and obtain from said repository a response to said request, said response being in said second format;

converting said response from said second format to said first format; and

transmitting through said network to said client a further message which is in the form of at least one message unit and which contains said response in said second format;

including the step of providing said repository within a group of repositories which handle requests according to respective different protocols;

wherein said request from said client includes an identification of a selected one of said repositories; and

wherein said step of converting said request includes the steps of selecting as said second format the protocol of said selected repository, and then effecting the conversion of said request from said first format to said second format.

2. A method according to claim 1, including the step of selecting as said client a telephone which is capable of effecting telephony functions by transmitting message units through said network.

3. A method according to claim 1, including the step of selecting as said public network communication protocol the extensible Markup Language (XML).

4. A method according to claim 1, including the step of selecting as said protocol of said selected repository one of the Structured Query Language (SQL) protocol and the Lightweight Directory Access Protocol (LDAP).

5. A method according to claim 1, including the step of providing control information for said client within said response, said client being responsive to said control information for operating in a manner which is a function of said control information.

6. A method according to claim 1, wherein said request includes authentication information, and including, after said step of receiving said request through said network and prior to said step of transmitting said response through said network, the step of evaluating said authentication information to determine whether access to said selected repository is authorized.

7. A method according to claim 1, wherein said request asks for information stored in said selected repository.

8. A method according to claim 1, wherein said request includes information to be stored to said selected repository.

9. A method according to claim 8, including the steps of:

storing in said selected repository the information received in said request; and

thereafter transmitting through said network to each of a plurality of further clients a message which is in the form of at least one message unit and which contains a notification that information in said selected repository has been changed.

10. A method, comprising the steps of:

providing a network through which can be transmitted message units that contain information in a digital form;

transmitting from a client through said network a message which is in the form of at least one message unit and which contains a request directed to a repository, said request being in a first format conforming to a public network communication protocol;

receiving said request from said network;

thereafter converting said request from said first format to a second format compatible with a protocol of said repository;

using said request in said second format to access said repository and obtain from said repository a response to said request, said response being in said second format;

converting said response from said second format to said first format;

transmitting through said network to said client a further message which is in the form of at least one message unit and which contains said response in said second format;

maintaining first and second information storage sections which each store the same information;

determining whether each of said information storage sections is currently operational; and

selecting one of said information storage sections which is currently operational to serve as said repository.

11. An apparatus, comprising:

a network through which can be transmitted message units that contain information in a digital form;

a client coupled to said network;

a repository; and

a section operatively disposed between said repository and said network;

wherein said client is operable to transmit through said network to said section a message which is in the form of at least one message unit and which contains a request directed to said repository, said request being in a first format conforming to a public network communication protocol;

wherein said section is operable to;

convert said request from said first format to a second format compatible with a protocol of said repository;

use said request in said second format to access said repository and obtain from said repository a response to said request, said response being in said second format;

convert said response from said second format to said first format; and

transmit through said network to said client a further message which is in the form of at least one message unit and which contains said response in said second format;

wherein said repository is one a group of repositories which each handle requests according to a respect different protocol;

wherein said request from said client includes an identification of a selected one of said repositories; and

wherein said section is operable to effect said conversion of said request by selecting as said second format the protocol of said selected repository, and to thereafter effect the conversion of said request from said first format to said second format.

12. An apparatus according to claim 11, wherein said client includes a telephone capable of effecting telephony functions by transmitting message units through said network.

13. An apparatus according to claim 11, wherein said public network communication protocol is the extensible Markup Language (XML).

14. An apparatus according to claim 11, wherein said protocol of said selected repository is one of the Structured Query Language (SQL) protocol and the Lightweight Directory Access Protocol (LDAP).

15. An apparatus according to claim 11, wherein said section is operable to provide control information for said client within said response, and wherein said client operates in a manner which is a function of said control information.

16. An apparatus according to claim 11, wherein said request includes authentication information, and wherein said section is operable, prior to receiving said request through said network and prior to transmitting said response through said network, to evaluate said authentication information to determine whether access to said selected repository is authorized.

17. An apparatus according to claim 11, wherein said request asks for information stored in said selected repository.

18. An apparatus according to claim 11, wherein said request includes information to be stored in said selected repository.

19. An apparatus according to claim 18, wherein said section is operable to store in said selected repository the information received in said request, and to thereafter transmit through said network to each of a plurality of further clients a message which is in the form of at least one message unit and which contains a notification that information in said selected repository has been changed.

20. An apparatus, comprising:

a network through which can be transmitted message units that contain information in a digital form;

a client coupled to said network;

a repository; and

a section operatively disposed between said repository and said network;

wherein said client is operable to transmit through said network to said section a message which is in the form of at least one message unit and which contains a request directed to said repository, said request being in a first format conforming to a public network communication protocol; and

wherein said section disposed between said repository and said network is operable to;

convert said request from said first format to a second format compatible with a protocol of said repository;

use said request in said second format to access said repository and obtain from said repository a response to said request, said response being in said second format;

convert said response from said second format to said first format; and

transmit through said network to said client a further message which is in the form of at least one message unit and which contains said response in said second format;

including first and second information storage sections which each store the same information, and wherein said section disposed between said repository and said network is operable to;

determine whether each of said information storage sections is currently operational; and

select one of said information storage sections which is currently operational to serve as said repository.