System and method for processing database queries

• US 8,145,658 B2
• Filed: 04/23/2008
• Issued: 03/27/2012
• Est. Priority Date: 09/27/2001
• Status: Expired due to Fees

• Current Assignee: Open Invention Network LLC
• Original Assignee: Kevin V. Nguyen, Monica Rose Cleghorn
• Inventors: Cleghorn, Monica Rose, Nguyen, Kevin V.
• Primary Examiner(s): Wu, Yicun
• Application Number:
  US12/150,057
• Publication Number:
  US 20090083242A1
• Time in Patent Office: 1,434 Days
• Field of Search: 707/763, 707/769, 707/770, 379/115, 379/90.01, 379/119
• US Class Current: 707/763
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions
• CPC Class Codes: H04L 63/0428 wherein the data content is protected, e.g. by encrypting or encapsulating the payload
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

The present invention provides a system and method for processing a database query between one or more clients and one or more databases. The database query, which is formatted using a first protocol, is received from one of the clients. One of the databases is selected to process the database query and the database query is translated from the first protocol to a second protocol. The translated database query is then sent to the selected database for processing. A response to the database query, which is formatted using the second protocol, is received from the selected database and the response is translated from the second protocol to the first protocol. The present invention determines which of the clients sent the database query and sends the translated response to the client that sent the database query. This method can be implemented as a computer program embodied on a computer readable medium.

Claims

1. A method of processing a database query between one or more clients and one or more databases, the method comprising the steps of:

receiving the database query from one of the clients, the database query formatted using a first protocol;

setting a query timer to monitor the elapsed time from when the database query was received;

selecting one of the databases to process the database query;

translating the database query from the first protocol to a second protocol;

sending the translated database query to the selected database for processing;

receiving a response to the database query from the selected database, the response formatted using the second protocol;

translating the response from the second protocol to the first protocol;

determining which of the clients sent the database query;

sending the translated response to the client that sent the database query;

monitoring via the query timer, whether the translated response to the database query has been received during the elapsed time since the database query was received and waiting for the response via the query timer if the query timer has not expired; and

turning off the query timer responsive to the translated response being received.

2. The method as recited in claim 1, further comprising the step of validating the client.

3. The method as recited in claim 1, further comprising the step of sending a time out response to the client that sent the database query whenever the translated response has not been received within a specified time period.

4. The method as recited in claim 1, further comprising the step of logging the database query.

5. The method as recited in claim 1, further comprising the step of storing an address identifier for the client that sent the database query.

6. The method as recited in claim 1, further comprising the step of storing a query identifier for the database query.

7. The method as recited in claim 1, wherein the steps of sending the translated database query to the selected database for processing and receiving a response to the database query from the selected database, the response formatted using the second protocol comprise the steps of:

encrypting the translated database query;

sending the encrypted database query to the selected database for processing;

receiving an encrypted response to the encrypted database query from the selected database, the response formatted using the second protocol; and

decrypting the encrypted response into a response.

8. The method as recited in claim 1, wherein the first protocol is an Internet protocol.

9. The method as recited in claim 1, wherein the second protocol is a signaling protocol.

10. The method as recited in claim 9, wherein the signaling protocol is a Signaling'"'"' System 7 protocol.

11. The method as recited in claim 1, wherein the database query is part of a call validation process.

12. The method as recited in claim 1, wherein the database query is part of a call billing process.

13. The method as recited in claim 1, wherein the database query is part of a bank card validation process.

14. The method as recited in claim 1, wherein the database query is part of a bank card settlement process.

15. The method as recited in claim 1, wherein the selected database is a line information database.

16. A system for processing a database query between one or more clients and one or more databases, the system comprising:

a computer communicably coupled to the one or more clients;

one or more network servers communicably coupled to the computer and the one or more databases;

a server/router module resident on the computer, the server/router module;

receives the database query from one of the clients, the database query formatted using a first protocol;

sets a query timer to monitor the elapsed time from when the database query was received;

selects one of the network servers and one of the databases to process the database query;

sends the database query to the selected network server;

determines which of the clients sent the database query, and sends a translated response to the client that sent the database query; and

a network interface module resident on each of the network servers, the network interface module;

translates the database query from the first protocol to a second protocol;

sends the translated database query to the selected database for processing;

receives a response to the database query from the selected database, the response formatted using the second protocol;

translates the response from the second protocol to the first protocol; and

sends the translated response to the computer;

monitors via the query time whether the translated response to the database query has been received during the elapsed time since the database query was received and waiting for the response via the query timer if the query timer has not expired; and

turning off the query timer responsive to the translated response being received.

17. The system as recited in claim 16, wherein the server/router module validates the client.

18. The system as recited in claim 16, wherein the server/router module sends a time out response to the client that sent the database query whenever the translated response has not been received within a specified time period.

19. The system as recited in claim 16, wherein the network interface module logs the database query.

20. The system as recited in claim 16, wherein the server/router module stores at least one of:

an address identifier for the client that sent the database query; and

a query identifier for the database query.

21. The system as recited in claim 16, wherein the network interface module sends the translated database query to the selected database for processing and receives the response to the database query from the selected database, the response formatted using the second protocol by encrypting the translated database query, sending the encrypted database query to the selected database for processing, receiving an encrypted response to the encrypted database query from the selected database, the response formatted using the second protocol, and decrypting the encrypted response into the response.

22. The system as recited in claim 16, wherein the computer and the server/router module comprise:

a first computer communicably coupled to the one or more clients;

a second computer communicably to the one or more network servers;

a server module resident on the first computer, the server module receiving the database query from one of the clients, the database query formatted using a first protocol, sending the database query to the second computer, and sending a translated response to the client that sent the database query; and

a router module resident on the second computer, the router module selecting one of the network servers and one of the databases to process the database query, sending the database query to the selected network server, determining which of the clients sent the database query, and sending the translated response to the first computer.

23. The system as recited in claim 16, wherein the first protocol is an Internet protocol.

24. The system as recited in claim 16, wherein the second protocol is a signaling protocol.

25. The system as recited in claim 24, wherein the signaling protocol is a Signaling System 7 protocol.

26. The system as recited in claim 16, wherein at least one of the network servers is at least one of:

a service control point;

a legacy server; and

a bank server.

27. The system as recited in claim 16, wherein the database query is at least one of:

part of a call validation process;

part of a call billing process;

part of a bank card validation process; and

part of a bank card settlement process.

28. The system as recited in claim 16, wherein the selected database is a line information database.

29. A method of processing a database query, the method comprising:

receiving the database query based on a first protocol, the database query related to information about a telephone number, the database query sent using the telephone number;

setting a query timer to monitor the elapsed time from when the database query was received;

translating the database query from the first protocol to a second protocol;

processing the translated database query by a line information database;

receiving a response formatted using the second protocol, the response used to process a call related to the telephone number;

translating the response from the second protocol to the first protocol;

sending the translated response to the client that sent the database query;

monitoring via the query timer whether the translated response to the database query has been received during the elapsed time since the database query was received and waiting for the response via the query timer if the query timer has not expired; and

turning off query timer when the translated response has been received.