QUERY PROCESSING CLIENT-SERVER DATABASE SYSTEM

• US 20080281782A1
• Filed: 05/07/2007
• Published: 11/13/2008
• Est. Priority Date: 05/07/2007
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: AGRAWAL, Sheshnarayan
• Granted Patent: US 7,912,853 B2
• Time in Patent Office: Days
• US Class Current: 707/3
• CPC Class Codes: G06F 16/24534 Query rewriting; Transformation

Abstract

There is disclosed a method for processing a query in a client-server database system comprising a server for managing content in a database and at least one client connected to the server via a network. The method comprises inputting a query from an application; and transmitting the inputted query to the server, skipping a query parsing processing at the client. The server parses the query transmitted from the client computer module and executes the query by manipulating the data in the database according to the query.

Claims

1. A method for processing a query in a client-server database system, the database system having a server for managing content in a database and at least one client connected to said server via a network, said method comprising:

inputting a query to said client from an application;

transmitting the inputted query from said client to said server, wherein a query parsing processing is skipped at said client;

parsing, at said server, said query received from said client; and

executing said query at said server by manipulating data in said database according to said query.

2. The method of claim 1, wherein said transmitting skips the query parsing processing if specified by said application.

3. The method of claim 2, wherein a source code for said application includes a command for switching between skipping and not skipping said query parsing processing at said client.

4. The method of claim 1, wherein said client performs processing to determine query type and a number of parameters of said query before transmitting said query to said server.

5. A client-server database system for executing queries, said system comprising:

a server for managing content in a database; and

at least one client connected to said server via a network,

wherein said client receives a query from an application, and transmits said query to said server via said network, wherein a query parsing processing skipped at said client, and

said server parses said query transmitted from the client and executes said query by manipulating said content in said database in accordance with the query provided.

6. The system of claim 5, wherein said client skips said query parsing processing if specified by said application.

7. The system of claim 6, wherein a source code for said application includes a command for switching between skipping and not skipping said query parsing processing at said client.

8. The system of claim 5, wherein said client performs processing to determine query type and a number of parameters of said inputted query before transmitting said inputted query to said server.

9. A computer program product including a computer readable medium having a computer program recorded therein for processing a query in a client of a client-server database system having a server for managing content in a database and parsing a query transmitted from a client and executing said query by manipulating said data in said database according to said query and at least one client connected to said server via a network, said computer program comprising:

computer program code for inputting a query from an application; and

computer program code for transmitting said inputted query to said server, wherein a query parsing processing is skipped at said client.

10. The computer program product of claim 9, wherein said application specifies to skip said query parsing processing at said client.

11. The computer program product of claim 10, wherein said computer program further including:

computer program code for said application for switching between skipping and not skipping said query parsing processing at said client.

12. The computer program product of claim 9, said computer program further comprising:

computer program code for performing processing to determine query type and a number of parameters of said inputted query before transmitting said inputted query to said server.