Query processing client-server database system

• US 7,912,853 B2
• Filed: 05/07/2007
• Issued: 03/22/2011
• Est. Priority Date: 05/07/2007
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Agrawal, Sheshnarayan
• Primary Examiner(s): Jalil; Neveen Abel
• Assistant Examiner(s): Syed; Farhan M
• Application Number:
  US11/745,275
• Publication Number:
  US 20080281782A1
• Time in Patent Office: 1,415 Days
• Field of Search: None
• US Class Current: 707/771
• 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, said 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, wherein said client intercepts the query before passing it to said server;

transmitting said inputted query from said client to said server, wherein a query parsing processing is skipped at said client, when specified by said application that outputs the query, wherein query response time is improved due to partial query processing, wherein said application may switch between specifying skipping and non-skipping with arbitrary timing, wherein a source code for said application includes a command for switching between skipping and not skipping said query parsing processing 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 client performs processing to determine query type and a number of parameters of said query before transmitting said query to said server.

7. The method of claim 1, wherein when said query parsing processing is skipped at said client, when specified by said application, the inputted query is transmitted from said client to said server without said client performing any parsing on said query.

3. 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, wherein the client and application reside within a single computer module, wherein said client intercepts the query before passing it to said server and transmits said query to said server via said network, wherein a query parsing processing skipped at said client, when specified by said application that outputs the query, wherein query response time is improved due to partial query processing, wherein said application may switch between specifying skipping and non-skipping with arbitrary timing, wherein a source code for said application includes a command for switching between skipping and not skipping said query parsing processing at said client; and

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

4. The system of claim 3, 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.

8. The system of claim 3, wherein when said query parsing processing is skipped at said client, when specified by said application, the inputted query is transmitted from said client to said server without said client performing any parsing on said query.

5. A computer program product including a computer readable storage 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, wherein said client intercepts the query before passing it to said server; and

computer program code for transmitting said inputted query to said server, wherein a query parsing processing is skipped at said client, when specified by said application that outputs the query, wherein query response time is improved due to partial query processing, wherein said application may switch between specifying skipping and non-skipping with arbitrary timing, wherein the computer program code further includes switching between skipping and not skipping said query parsing processing at said client.

6. The computer program product of claim 5, 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.