Apparatus, system, and method for XML based disconnected data access for multivalued/hierarchical databases

• US 8,386,500 B2
• Filed: 08/28/2007
• Issued: 02/26/2013
• Est. Priority Date: 08/28/2007
• Status: Active Grant

• Current Assignee: Rocket Software Incorporated
• Original Assignee: Rocket Software Incorporated
• Inventors: Mao, Jianfeng
• Primary Examiner(s): Ng, Amy
• Application Number:
  US11/846,502
• Publication Number:
  US 20090064037A1
• Time in Patent Office: 2,009 Days
• Field of Search: 707/756, 707/760, 707/999.1, 707/999.101, 707/999.102, 707/999.103, 707/999.104, 707/999.105, 707/999.106, 707/999.107
• US Class Current: 707/756
• 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:

providing an Extensible Markup Language (XML) schema for a non-relational data request;

performing the non-relational data request for non-relational XML data from a non-relational database having a data source schema different than the XML schema, using an XML mapping from the data source schema to the XML schema in processing the non-relational data request;

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

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

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 configured to facilitate communication with one or more clients to read and write the non-relational XML data stored in the data access sets.

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 the data source schema of the non-relational database to the 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 Extensible Markup Language (XML) schema different than the data source schema to form an XML mapping;

providing the XML schema for a non-relational data request;

performing the non-relational data request for non-relational XML data from the non-relational database using the XML mapping from the data source schema to the XML schema in processing the non-relational data request;

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

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

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;

reconnecting to the non-relational database prior to updating data in the non-relational database; and

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

18. The method 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:

providing an Extensible Markup Language (XML) schema for a data request from a client through an integration broker;

performing the data request for XML data from a multivalued/hierarchical database having a data source schema different than the XML schema, using an XML mapping in processing the data request, the XML mapping configured to map the data source schema of the multivalued/hierarchical database to the XML schema;

receiving the XML data from the multivalued/hierarchical database;

disconnecting from the multivalued/hierarchical database after receiving the XML data;

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

transmitting the one or more data access sets to the integration broker configured to facilitate communication with one or more clients to read and write the XML data stored in the data access sets.

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.