Method and apparatus for generating query and response statements at runtime from generic requests

• US 7,225,202 B2
• Filed: 03/18/2004
• Issued: 05/29/2007
• Est. Priority Date: 03/18/2004
• Status: Active Grant

• Current Assignee: Kyndryl Incorporated
• Original Assignee: International Business Machines Corporation
• Inventors: Morgan, Fabian F., Phillips, Brent Russel, Focazio, Robyn Lee
• Primary Examiner(s): Kindred; Alford W.
• Application Number:
  US10/803,658
• Publication Number:
  US 20050210004A1
• Time in Patent Office: 1,167 Days
• Field of Search: 707/1, 707/100, 715/513
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2452 Query translation
• CPC Class Codes: G06F 16/86 Mapping to a database
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A method, apparatus, and computer instructions of generating SQL statements at run time from generic and abstract XML request and response messages is provided. A set of generic and abstract XML schemas are provided for a client to send request XML messages for performing actions on information of objects in a data store. An adaptor processes the request XML messages and generates the SQL statements to submit to the data store. Upon receiving results, the adaptor sends response XML messages that adhere to the generic and abstract XML schemas to the client, which then obtains values of results from response XML message.

Claims

1. A method in a data processing system for generating a query statement at run time to submit and retrieve information of an object in a data store, the method comprising:

receiving a request from a client to perform an action on the object in the data store;

responsive to receiving the request, sending an extensible markup language request message to an adaptor for processing, wherein the extensible markup language request message adheres to a set of generic schemas including a plurality of row sets, wherein a row set includes a plurality of rows and wherein a row of the plurality of rows includes a plurality of columns, wherein a column includes a name and a value;

receiving an extensible markup language response message from the adaptor, wherein the extensible markup language response message adheres to the set of generic schemas; and

responsive to receiving the extensible markup language response message, returning resulting values obtained from the response message to the client.

2. The method of claim 1, wherein the action includes one of adding, deleting, getting, listing, updating, and validating the object in the data store.

3. The method of claim 1, wherein the request is formatted independently from a structure of the data store.

4. The method of claim 1, wherein a row of the plurality of rows represents a record of the object in the data store.

5. The method of claim 4, wherein the row includes a row set that represents a nested object.

6. The method of claim 1, wherein the name represents a name of the object.

7. The method of claim 6, wherein the value represents a value in the data store for the name of the object.

8. The method of claim 1, wherein the request message includes a plurality of parameters, filters, and sorts.

9. The method of claim 1, wherein the adaptor processes the request message by generating a query statement from the request message and executing the generated query statement on the data store.

10. The method of claim 1, wherein the request message, the response message, and the set of generic schemas are formatted using an extensible markup language.

11. A computer program product in a computer readable medium for performing actions on a data store, the computer program product comprising:

first instructions for receiving a request in a first format for an action on an object in the data store;

second instructions, responsive to processing the request, for generating an extensible markup language request message formatted according to a set of generic schemas including a plurality of row sets, wherein a row set includes a plurality of rows and wherein a row of the plurality of rows includes a plurality of columns, wherein a column includes a name and a value;

third instructions for sending the request message to an adapter for processing and for receiving an extensible markup language response message formatted according to the set of generic schemas from the adapter; and

fourth instructions that format result values of the response message in the first format.

12. The computer program product of claim 11, wherein a row of the plurality of rows represents a record of the object in the data store.

13. The method of claim 12, wherein the row includes a row set that represents a nested object.

14. The computer program product of claim 11, wherein the fourth instructions send the result values to a client that issued the request.

15. A data processing system for processing requests for actions on objects in a data store, comprising:

a memory that contains a set of generic schemas as a singleton in-memory object, wherein the set of generic schemas includes a plurality of row sets, wherein a row set includes a plurality of rows, and wherein a row of the plurality of rows includes a plurality of columns, wherein a column includes a name and a value, and an adapter as a set of instructions; and

a processing unit, responsive to execution of the set of instructions, for reading a request for an action on an object in the data store and generating an extensible markup language request message responsive to processing of the request, wherein the adapter receives the request message and executes a query on the data store responsive to processing the request message, and the adapter provides an extensible markup language response message responsive to receiving a result value from the data store.

16. The data processing system of claim 15, further comprising:

a network adapter that receives the request from a client, wherein the extensible markup language response message is sent to the client by the network adapter.

17. The data processing system of claim 16, wherein the request is formatted independently of the data store.