Mechanism to enable evolving XML schema

• US 7,395,271 B2
• Filed: 08/25/2003
• Issued: 07/01/2008
• Est. Priority Date: 08/25/2003
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Sedlar, Eric, Chandrasekar, Sivasankaran, Murthy, Ravi, Agarwal, Nipun, Idicula, Sam
• Primary Examiner(s): Vo; Tim
• Assistant Examiner(s): Gortayo; Dangelino N
• Application Number:
  US10/648,497
• Publication Number:
  US 20050050056A1
• Time in Patent Office: 1,772 Days
• Field of Search: 707/3, 707/204, 707/1, 707/4, 707/100, 707/102, 707/103, 707/104, 707/200, 707/103.R, 707/2, 709/203
• US Class Current: 1/1
• CPC Class Codes: G06F 16/84 Mapping; Conversion
• CPC Class Codes: G06F 40/143 Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]
• CPC Class Codes: G06F 40/154 Tree transformation for tree-structured or markup documents, e.g. XSLT, XSL-FO or stylesheets
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

A method and system for evolving XML-schema-based data to conform to an evolved XML schema is disclosed. Based on an existing XML schema and an instance document that is based on the existing XML schema, an XML-schema-independent form of the instance document is generated. Based on a set of specified transformations and the XML-schema-independent form of the instance document, an evolved instance document is generated. The evolved instance document conforms to an evolved XML schema that incorporates changes to the existing XML schema. Techniques described herein are flexible enough to accommodate a wide variety of evolutions to XML schemas.

Claims

1. A method comprising:

a procedure receiving an identity of an existing XML schema;

the procedure receiving an identity of an evolved XML schema that is a version of the existing XML schema that incorporates one or more modifications;

the procedure receiving a reference to a transformation set that indicates changes that, when made to instance documents that conform to the existing XML schema, will cause the instance documents to conform to the evolved XML schema;

the procedure reading data for different existing XML-schema-dependent instance documents, wherein the existing XML-schema-dependent instance documents do not contain tags of the existing XML schema;

based on said data, the procedure generating, for each particular existing XML-schema-dependent instance document of the existing XML-schema-dependent instance documents, a corresponding XML-schema-independent instance document that contains both (a) the tags of the existing XML schema and (b) particular data from said particular existing XML-schema-dependent document, thereby generating XML-schema-independent instance documents that contain data from the existing XML-schema-independent instance documents and conform to the existing XML schema;

for each particular XML-schema-independent instance document of the XML-schema-independent instance documents, the procedure applying, to the particular XML-schema-independent instance document, one or more transformations in the transformation set, thereby producing evolved XML-schema-independent instance documents that conform to the evolved XML schema instead of the existing XML schema;

the procedure instructing the database server to execute one or more DDL statements to create evolved database structures that are based on the evolved XML schema; and

the procedure populating one or more columns of the evolved database structures with content values of column-corresponding XML elements that are contained in the evolved XML-schema-independent instance documents.

2. A tangible computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 1.

3. A method comprising:

receiving an identity of an existing XML schema;

receiving an identity of an evolved XML schema that is a version of the existing XML schema that incorporates one or more modifications;

receiving a reference to a transformation set that indicates changes that, when made to instance documents that conform to the existing XML schema, will cause the instance documents to conform to the evolved XML schema;

reading data for different existing XML-schema-dependent instance documents, wherein the existing XML-schema-dependent instance documents do not contain tags of the existing XML schema;

based on said data, generating, for each particular existing XML-schema-dependent instance document of the existing XML-schema-dependent instance documents, a corresponding XML-schema-independent instance document that contains both (a) the tags of the existing XML schema and (b) particular data from said particular existing XML-schema-dependent document, thereby generating XML-schema-independent instance documents that contain data from the existing XML-schema-independent instance documents and conform to the existing XML schema;

for each particular XML-schema-independent instance document of the XML-schema-independent instance documents, applying, to the particular XML-schema-independent instance document, one or more transformations in the transformation set, thereby producing evolved XML-schema-independent instance documents that conform to the evolved XML schema instead of the existing XML schema;

instructing the database server to execute one or more DDL statements to create evolved database structures that are based on the evolved XML schema; and

populating one or more columns of the evolved database structures with content values of column-corresponding XML elements that are contained in the evolved XML-schema-independent instance documents.

4. A tangible computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 3.