Pluggable merge patterns for data access services

• US 7,779,047 B2
• Filed: 06/22/2007
• Issued: 08/17/2010
• Est. Priority Date: 06/22/2007
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Brodsky, Stephen Andrew, Bireley, William Robert, Smith, Brandon Jacob Wright, Blevins, Delmar Eugene, Dawra, Anshul, Gounder, Swaminathan, Salo, Timo Juhani
• Primary Examiner(s): LE, DEBBIE M
• Application Number:
  US11/767,450
• Publication Number:
  US 20080320019A1
• Time in Patent Office: 1,152 Days
• Field of Search: 707 1- 5, 707/10, 707100-101, 707/104.1, 707/103.R, 707/103.Y, 707/103.Z
• US Class Current: 707/803
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof

Abstract

Provided are techniques for storing data. Invocation of a data access service is received, wherein the invocation identifies a data structure storing one or more data elements having a data format. An update handler to be plugged into a data access framework is identified, wherein the update handler processes data elements having the data format. Under control of the update handler, data elements are accessed in the data structure; one or more statements for storing the data elements into the data store are determined; and the one or more statements are forwarded to the data access framework.

Claims

1. A computer-implemented method, comprising:

receiving, with a computer including a processor, invocation of a data access service, wherein the invocation identifies a data structure storing one or more data elements having a data format;

identifying an update handler from a plurality of update handlers to be plugged into a data access framework, wherein the identified update handler processes data elements having the data format;

invoking the data access framework with the update handler;

under control of the data access framework, invoking the update handler;

under control of the update handler,

accessing data elements in the data structure;

determining one or more statements for storing the data elements into a data store; and

forwarding the one or more statements to the data access framework; and

under control of the data access framework,

receiving the one or more statements; and

executing the one or more statements to store the data elements into the data store.

2. The method of claim 1, wherein accessing further comprises:

decomposing the data structure; and

extracting data elements from the data structure.

3. The method of claim 1, wherein the data access service, the data access framework, and the update handler comprise a same code unit.

4. The method of claim 1, wherein the data access service, the data access framework, and the update handler comprise different code units.

5. The method of claim 1, further comprising:

performing introspection of the data elements in the data structure to identify the update handler.

6. The method of claim 1, wherein identifying the one or more statements further comprises:

generating the one or more statements using column names and table names in the data structure, wherein the one or more statements are Structured Query Language (SQL) statements.

7. The method of claim 1, wherein the invocation includes an override that identifies one or more statements to be executed for a particular type of data element.

8. The method of claim 1, further comprising:

under control of the update handler, using reflection to analyze the data structure to determine what type of the one or more statements are to be generated to store the data elements into the data store.

9. The method of claim 1, further comprising:

under control of the data access service, invoking the data access framework.

10. The method of claim 1, wherein the data structure comprises a first data structure storing data elements having a first data format and further comprising:

receiving a second data structure storing data elements having a second data format; and

identifying a new update handler to be plugged into the data access framework, wherein the new update handler processes data elements having the second data format.

11. A computer program product comprising a computer-readable storage medium including at least one computer readable program, wherein the at least one computer readable program when executed on a computer causes the computer to:

receive invocation of a data access service, wherein the invocation identifies a data structure storing one or more data elements having a data format;

identify an update handler from a plurality of update handlers to be plugged into a data access framework, wherein the identified update handler processes data elements having the data format;

invoke the data access framework with the update handler;

under control of the data access framework, invoke the update handler;

under control of the update handler,

access data elements in the data structure;

determine one or more statements for storing the data elements into a data store; and

forward the one or more statements to the data access framework; and

under control of the data access framework,

receive the one or more statements; and

execute the one or more statements to store the data elements into the data store.

12. The computer program product of claim 11, wherein when accessing, the at least one computer readable program when executed on a computer causes the computer to:

decompose the data structure; and

extract data elements from the data structure.

13. The computer program product of claim 11, wherein the data access service, the data access framework, and the update handler comprise one computer readable program.

14. The computer program product of claim 11, wherein the data access service, the data access framework, and the update handler comprise different computer readable programs.

15. The computer program product of claim 11, wherein the at least one computer readable program when executed on a computer causes the computer to:

perform introspection of the data elements in the data structure to identify the update handler.

16. The computer program product of claim 11, wherein the at least one computer readable program when executed on a computer causes the computer to:

generate the one or more statements using column names and table names in the data structure, wherein the one or more statements are Structured Query Language (SQL) statements.

17. The computer program product of claim 11, wherein the invocation includes an override that identifies one or more statements to be executed for a particular type of data element.

18. The computer program product of claim 11, wherein the at least one computer readable program when executed on a computer causes the computer to:

under control of the update handler, use reflection to analyze the data structure to determine what type of the one or more statements are to be generated to store the data elements into the data store.

19. The computer program product of claim 11, wherein the at least one computer readable program when executed on a computer causes the computer to:

under control of the data access service, invoke the data access framework.

20. The computer program product of claim 11, wherein the data structure comprises a first data structure storing data elements having a first data format and wherein the at least one computer readable program when executed on a computer causes the computer to:

receive a second data structure storing data elements having a second data format; and

identify a new update handler to be plugged into the data access framework, wherein the new update handler processes data elements having the second data format.

21. A system, comprising:

hardware logic capable of performing operations, the operations comprising;

receiving invocation of a data access service, wherein the invocation identifies a data structure storing one or more data elements having a data format;

identifying an update handler from a plurality of update handlers to be plugged into a data access framework, wherein the identified update handler processes data elements having the data format;

invoking the data access framework with the update handler;

under control of the data access framework, invoking the update handler;

under control of the update handler,

accessing data elements in the data structure;

determining one or more statements for storing the data elements into a data store; and

forwarding the one or more statements to the data access framework; and

under control of the data access framework,

receiving the one or more statements; and

executing the one or more statements to store the data elements into the data store.

22. The system of claim 21, wherein the operations further comprise:

performing introspection of the data elements in the data structure to identify the update handler.

23. The system of claim 21, wherein the operations for identifying the one or more statements further comprise:

generating the one or more statements using column names and table names in the data structure, wherein the one or more statements are Structured Query Language (SQL) statements.

24. The system of claim 21, wherein the invocation includes an override that identifies one or more statements to be executed for a particular type of data element.

25. The system of claim 21, wherein the operations further comprise:

under control of the update handler, using reflection to analyze the data structure to determine what type of the one or more statements are to be generated to store the data elements into the data store.

26. The system of claim 21, wherein the operations further comprise:

under control of the data access service, invoking the data access framework.

27. The system of claim 21, wherein the data structure comprises a first data structure storing data elements having a first data format and wherein the operations further comprise:

receiving a second data structure storing data elements having a second data format; and

identifying a new update handler to be plugged into the data access framework, wherein the new update handler processes data elements having the second data format.

28. The system of claim 21, wherein the operations for accessing further comprise:

decomposing the data structure; and

extracting data elements from the data structure.