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

• US 20090064037A1
• Filed: 08/28/2007
• Published: 03/05/2009
• Est. Priority Date: 08/28/2007
• Status: Active Grant

• Current Assignee: Rocket Software Incorporated
• Original Assignee: International Business Machines Corporation
• Inventors: Mao, Jianfeng
• Granted Patent: US 8,386,500 B2
• Time in Patent Office: Days
• US Class Current: 715/810
• CPC Class Codes: G06F 16/86 Mapping to a database

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. A method for providing a client with disconnected data access to a non-relational database, the method comprising:

receiving a non-relational data request;

requesting non-relational Extensible Markup Language (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.

2. The method of claim 1, further comprising receiving one or more changes to the non-relational XML data from at least one of the one or more data access sets.

3. The method of claim 2, further comprising sending the one or more changes in the non-relational XML data to the non-relational database using the XML mapping.

4. The method of claim 1, further comprising mapping a data source schema of the non-relational database to an XML schema to form the XML mapping.

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

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

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

8. The method of claim 1, 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 method of claim 1, wherein the requesting of non-relational XML data from the non-relational database is performed in a single network transaction and wherein the sending of the one or more changes to the non-relational database is performed in a single network transaction.

10. The method of claim 3, further comprising detecting one or more conflicting changes to data in the non-relational database and prompting a user with one or more data update options.

11. The method 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 method of claim 2, wherein the one or more changes are made by a user.

13. The method 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 user input and a request from the edit module.

14. The method of claim 1, wherein the requesting of the non-relational XML data is performed in response to user input.

15. The method 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 method of claim 1, further comprising assisting a user to define the XML mapping.

17. A method for providing a client with disconnected data access to a non-relational database, the method comprising:

mapping a data source schema of a non-relational database to an XML schema to form an XML mapping;

receiving a non-relational data request;

requesting non-relational XML data from the non-relational database using the XML mapping;

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

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

editing the non-relational XML data in the data access sets in response to input from a user;

storing one or more changes to the non-relational XML data in the data access sets; and

updating data in the non-relational database based on the one or more changes using the XML mapping.

18. The system of claim 17, further comprising detecting one or more conflicting changes to data in the non-relational database, prompting the user with one or more data update options, receiving a chosen update option from the user, and executing the chosen update option.

19. A method for providing a client with disconnected data access to a multivalued/hierarchical database, the method comprising:

receiving a data request from a client through an integration broker;

requesting XML data from a multivalued/hierarchical database using an XML mapping in response to the data request, the XML mapping configured to map a data source schema of the multivalued/hierarchical database to an XML schema;

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 the integration broker.

20. The method of claim 19, further comprising receiving one or more changes to 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.