Method for pre-processing mapping information for efficient decomposition of XML documents

• US 7,529,758 B2
• Filed: 02/10/2006
• Issued: 05/05/2009
• Est. Priority Date: 02/10/2006
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Pradhan, Mayank, Nguyen, Dung Kim
• Primary Examiner(s): MIZRAHI, DIANE D
• Application Number:
  US11/351,467
• Publication Number:
  US 20070198543A1
• Time in Patent Office: 1,180 Days
• Field of Search: 707/1, 707/6, 707/10, 707/110, 707/100, 707/101, 707/102, 707/103.R, 707/103.X, 707/103.Y, 707/103.Z, 707/104.1, 715/239
• US Class Current: 1/1
• CPC Class Codes: G06F 16/86 Mapping to a database
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

Methods for pre-processing mapping information for efficient decomposition of an XML document for storage in a database are provided. The method includes receiving a mapping document that describes how all of (or a portion of) an XML document is to be decomposed, transforming the mapping document into a data structure for decomposing an XML document, and making the data persistent for use with a subsequent decomposition operation that decomposes an XML document.

Claims

1. A computer implemented method, the method implemented on a processor and a memory programmed for decomposing an XML document for storage in a relational database, the method comprising:

receiving a mapping document, the mapping document describing components of the XML document that are to be decomposed, the mapping document being in the form of a set of related XML schema documents augmented with at least one annotation that describes a mapping of the components to specified relational tables and columns in the relational database;

transforming the mapping document into a first data structure and at least one second data structure for decomposing the XML document, the transforming comprising;

i) parsing the set of related XML schema documents to produce the first data structure, the first data structure representing a data model associated with the set of related XML schema documents, wherein the first data structure comprises;

a) at least one node that represents schema components comprising model groups, particles, and element and attribute declarations, and

b) at least one edge that connect the at least one node according to relationships defined in the set of related XML schema documents; and

ii) parsing the at least one annotation to obtain mapping information that maps the components to the specified relational tables and columns in the database; and

iii) creating the at least one second data structure, each of the at least one second data structures being created for a corresponding mapped relational table in the relational database based on the mapping information; and

making the first and second data structures persistent for use with a subsequent decomposition operation that decomposes the XML document, wherein making the data structure persistent includes storing the first and second data structures in the database,

wherein storing the first and second data structures comprises assigning and storing a unique identifier to the first and second data structures, the unique identifier used in later retrieving the first and second data structures from the database for a subsequent decomposition of a second XML document in response to receiving the unique identifier, such that the retrieved first and second data structures can be used and need not be transformed from a second mapping document for the second XML document.

2. The method of claim 1, further wherein storing the first and second data structures comprises storing the first and second data structures as metadata in the database.

3. The method of claim 1, wherein the components of the XML documents include XML elements and attributes.