APPARATUS, SYSTEM, AND METHOD FOR XML BASED DISCONNECTED DATA ACCESS FOR MULTIVALUED/HIERARCHICAL DATABASES

• US 20090063654A1
• Filed: 08/28/2007
• Published: 03/05/2009
• Est. Priority Date: 08/28/2007
• Status: Abandoned Application

• Current Assignee: Rocket Software Incorporated
• Original Assignee: International Business Machines Corporation
• Inventors: Mao, Jianfeng
• Application Number:
  US11/846,473
• Publication Number:
  US 20090063654A1
• Time in Patent Office: Days
• US Class Current: 709/217
• CPC Class Codes: G06F 16/84 Mapping; Conversion

Abstract

An apparatus, system, and method are disclosed for providing a client with disconnected data access to a non-relational database. A command module requests non-relational XML data from a non-relational database using an XML mapping in response to a non-relational data request. A fill module receives the non-relational XML data from the non-relational database and populates one or more data access sets with the non-relational XML data. A communications module transmits the one or more data access sets to an integration broker in communication with the integration adapter.

Claims

1. An integration adapter for providing a client with disconnected data access to a non-relational database, the integration adapter comprising:

an Extensible Markup Language (XML) mapping;

a command module configured to request non-relational XML data from a non-relational database using the XML mapping, the command module configured to request the non-relational XML data in response to a non-relational data request;

a fill module configured to receive the non-relational XML data from the non-relational database and to populate one or more data access sets with the non-relational XML data; and

a communications module configured to transmit the one or more data access sets to an integration broker in communication with the integration adapter.

2. The integration adapter of claim 1, further comprising an edit module configured to receive one or more changes to the non-relational XML data from at least one of the one or more data access sets.

3. The integration adapter of claim 2, further comprising an update module configured to send the one or more changes in the non-relational XML data to the non-relational database using the XML mapping.

4. The integration adapter of claim 1, wherein the XML mapping is configured to map a data source schema of the non-relational database to an XML schema.

5. The integration adapter of claim 4, wherein the non-relational database is configured to store non-relational data in a format substantially similar to an XML format.

6. The integration adapter of claim 5, wherein the non-relational database comprises at least one of a hierarchical database and a multivalued database.

7. The integration adapter of claim 4, wherein the XML mapping comprises one of a non-relational database default mapping and a user-defined custom mapping.

8. The integration adapter of claim 4, wherein the XML mapping is stored in one of the non-relational database, a data file accessible by the non-relational database, and the one or more data access sets.

9. The integration adapter of claim 1, wherein the command module is further configured to request the non-relational XML data from the non-relational database in a single network transaction and wherein the update module is further configured to send the one or more changes to the non-relational database in a single network transaction.

10. The integration adapter of claim 3, further comprising a conflict module configured to prompt a user with one or more data update options in response to one or more conflicting changes to data in the non-relational database.

11. The integration adapter of claim 1, wherein the one or more data access sets each comprise one of an ADO.NET DataSet and a Service Data Objects Data Graph.

12. The integration adapter of claim 2, wherein the one or more changes are made by a user.

13. The integration adapter of claim 2, wherein the at least one of the one or more data access sets is configured to send the one or more changes to the edit module in response to one of a user input and a request from the edit module.

14. The integration adapter of claim 1, wherein the command module is further configured to request the non-relational XML data in response to user input.

15. The integration adapter of claim 2, wherein the one or more data access sets are further configured to store a change history comprising the non-relational XML data and the one or more changes to the non-relational XML data.

16. The integration adapter of claim 4, further comprising an XML mapping definition tool configured to assist a user in defining the XML mapping.

17. A system to provide a client with disconnected data access to a non-relational database, the system comprising:

an integration broker configured to facilitate communication between a client and a non-relational database adapter;

a client in communication with the integration broker, the client comprising a disconnected access module configured to store one or more data access sets and to make changes to data in the data access sets in response to user input;

a non-relational database adapter in communication with the integration broker and a non-relational database, the non-relational database adapter comprising,

an XML mapping configured to map a data source schema of the non-relational database to an XML schema;

a command module configured to request non-relational XML data from the non-relational database using the XML mapping, the command module configured to request the non-relational XML data in response to a client non-relational data request from the integration broker;

a fill module configured to receive the non-relational XML data from the non-relational database and to populate one or more data access sets with the non-relational XML data; and

a communications module configured to transmit the one or more data access sets to the client through the integration broker.

18. The system of claim 17, wherein the non-relational database adapter further comprises an edit module configured to receive one or more client changes in the non-relational XML data from at least one of the one or more data access sets through the integration broker.

19. The system of claim 18, wherein the non-relational database adapter further comprises an update module configured to send the one or more client changes in the non-relational XML data to the non-relational database using the XML mapping.

20. A computer program product comprising a computer readable medium having computer usable program code executable to perform operations for providing a client with disconnected data access to a non-relational database, the operations of the computer program product comprising:

receiving a non-relational data request;

requesting non-relational XML data from a non-relational database using an XML mapping in response to the non-relational data request;

receiving the non-relational XML data from the non-relational database;

populating one or more data access sets with the non-relational XML data; and

transmitting the one or more data access sets to an integration broker.

21. The computer program product of claim 20, wherein further comprising receiving one or more changes in the non-relational XML data from at least one of the one or more data access sets and sending the one or more changes in the non-relational XML data to the non-relational database using the XML mapping.

22. An integration adapter for providing a client with disconnected data access to a multivalued/hierarchical database, the integration adapter comprising:

an XML mapping configured to map a data source schema of a multivalued/hierarchical database to an XML schema;

a command module configured to request XML data from the multivalued/hierarchical database using the XML mapping, the command module configured to request the XML data in response to a data request from a client;

a fill module configured to receive the XML data from the multivalued/hierarchical database and to populate one or more data access sets with the XML data;

a communications module configured to transmit the one or more data access sets to an integration broker in communication with the integration adapter;

an edit module configured to receive one or more changes to the XML data from at least one of the one or more data access sets; and

an update module configured to send the one or more changes to the XML data to the multivalued/hierarchical database using the XML mapping.

23. The integration adapter of claim 22, wherein the one or more data access sets each comprise one of an ADO.NET DataSet and a Service Data Objects Data Graph.

24. A method for deploying computing infrastructure, comprising integrating computer-readable code into a computing system, wherein the code in combination with the computing system is capable of performing the following:

receiving a data request from a client;

requesting XML data from a multivalued/hierarchical database using an XML mapping in response to the data request;

receiving the XML data from the multivalued/hierarchical database;

populating one or more data access sets with the XML data; and

transmitting the one or more data access sets to an integration broker.

25. The method of claim 24, wherein the code in combination with the computing system is further capable of receiving one or more changes in the XML data from at least one of the one or more data access sets and sending the one or more changes in the XML data to the multivalued/hierarchical database using the XML mapping.