Implementation of backward compatible XML schema evolution in a relational database system

• US 7,870,163 B2
• Filed: 09/28/2006
• Issued: 01/11/2011
• Est. Priority Date: 09/28/2006
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Sedlar, Eric, Baby, Thomas, Agrawal, Abhyudaya, Idicula, Sam, Murthy, Ravi, Agarwal, Nipun
• Primary Examiner(s): Wong; Don
• Assistant Examiner(s): Nguyen; Kim T
• Application Number:
  US11/540,341
• Publication Number:
  US 20080082560A1
• Time in Patent Office: 1,566 Days
• Field of Search: 707/802, 707/803
• US Class Current: 707/802
• CPC Class Codes: G06F 40/143 Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]

Abstract

In-place XML schema evolution occurs by evaluating an existing XML schema in a database system to see if it is compatible with a new XML schema. To determine if the old schema is compatible with the new schema, a lock-step traversal is performed on the two schemas. Each instruction in the old schema is compared to instructions in the new schema. Detected differences between the two schemas are evaluated to determine if existing XML documents are still compatible with the new schema. If they are, then an in-place schema evolution operation can take place. The in-place schema operation basically, involves appending the updated object information to the underlying object type and preserving the order of elements in a document by storing element mapping information on disk.

Claims

1. A computer-implemented method for modifying an existing XML schema in a database without modifying existing data that conforms to the existing XML schema in the database, the method comprising:

storing data from a set of XML documents in base database structures in a database according to an XML schema, wherein the XML schema defines an XML structure for said set of XML documents;

after storing the data from the set of XML documents in the base database structures, receiving a request to make one or more changes to the schema;

determining that the schema, if modified by the one or more changes, would be compatible with the stored data; and

wherein the step of determining that the schema, if modified by the one or more changes, would be compatible with the stored data comprises one or more of;

(a) determining that the one or more changes comprise an addition of a new element to the schema, and determining that the data stored in the base database structures in the database would be compatible with the schema as modified to add the new element;

(b) determining that the one or more changes comprise a removal of an element from the schema, and determining that the data stored in the base database structures in the database would be compatible with the schema as modified to remove the element;

or

(c) determining that the one or more changes affect the ordering of elements within the schema, and determining that the data stored in the base database structures in the database would be compatible with the schema as modified to affect the ordering of elements within the schema; and

in response to determining that the schema, if modified by the one or more changes, would be compatible with the stored data, modifying the base database structures in the database to reflect the changes to the schema without modifying the data from the set of XML documents that is stored in the base database structures;

wherein the method is performed by one or more computing devices.

2. The method of claim 1, wherein a database structure of said base database structures includes a positional descriptor column.

3. The method of claim 2, wherein the positional descriptor column stores a set of kidnum values in an ordered list, wherein each kidnum in the set of kidnum values is uniquely mapped to an attribute in a set of attributes.

4. The method of claim 1, wherein modifying the base database structures in the database to reflect the changes to the schema comprises updating the element ordering in the base database structures in the database, and wherein the updated element ordering is added to the schema as an annotation.

5. The method of claim 3, wherein each kidnum in the set of kidnum values is mapped to a propnum.

6. The method of claim 1, wherein receiving the request to make one or more changes to the schema includes receiving a request to add a new element to the schema, and wherein the step of determining that the schema, if modified by the one or more changes, would be compatible with the stored data comprises (a) determining that the one or more changes comprise an addition of the new element to the schema, and determining that the data stored in the base database structures in the database would be compatible with the schema as modified to add the new element.

7. The method of claim 6, further comprising determining a kidnum value for the new element.

8. The method of claim 7, wherein the kidnum value for the new element comprises a value greater than the highest kidnum value associated with a kidnum value for each attribute in a set of attributes.

9. The method of claim 7, wherein the kidnum value for the new element comprises a value greater than the highest kidnum value associated with a kidnum value for each attribute in a set of attributes associated with a complex type hierarchy.

10. The method of claim 1, wherein determining that the data stored in the base database structures in the database would be compatible with the schema, if modified by the one or more changes, includes identifying whether the modification to the schema executes in constant time.

21. The method of claim 1, wherein the step of determining that the schema, if modified by the one or more changes, would be compatible with the stored data comprises (b) determining that the one or more changes comprise a removal of an element from the schema, and determining that the data stored in the base database structures in the database would be compatible with the schema as modified to remove the element.

22. The method of claim 1, wherein the step of determining that the schema, if modified by the one or more changes, would be compatible with the stored data comprises (c) determining that the one or more changes affect the ordering of elements within the schema, and determining that the data stored in the base database structures in the database would be compatible with the schema as modified to affect the ordering of elements within the schema.

11. A non-transitory computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to modify an existing XML schema in a database without modifying existing data that conforms to the existing XML schema in the database by performing the steps of:

storing data from a set of XML documents in base database structures in a database according to an XML schema, wherein the XML schema defines an XML structure for said set of XML documents;

after storing the data from the set of XML documents in the base database structures, receiving a request to make one or more changes to the schema;

determining that the schema, if modified by the one or more changes, would be compatible with the stored data; and

wherein the step of determining that the schema, if modified by the one or more changes, would be compatible with the stored data comprises one or more of;

(a) determining that the one or more changes comprise an addition of a new element to the schema, and determining that the data stored in the base database structures in the database would be compatible with the schema as modified to add the new element;

(b) determining that the one or more changes comprise a removal of an element from the schema, and determining whether the data stored in the base database structures in the database would be compatible with the schema as modified to remove the element;

or

(c) determining that the one or more changes affect the ordering of elements within the schema, and determining whether the data stored in the base database structures in the database would be compatible with the schema as modified to affect the ordering of elements within the schema; and

in response to determining that the schema, if modified by the one or more changes, would be compatible with the stored data, modifying the base database structures in the database to reflect the changes to the schema without modifying the data from the set of XML documents that is stored in the base database structures.

12. The computer-readable storage medium of claim 11, wherein a database structure of said base database structures includes a positional descriptor column.

13. The computer-readable storage medium of claim 12, wherein the positional descriptor column stores a set of kidnum values in an ordered list, wherein each kidnum in the set of kidnum values is uniquely mapped to an attribute in a set of attributes.

14. The computer-readable storage medium of claim 11, wherein the step of modifying the base database structures in the database to reflect the changes to the schema comprises updating the element ordering in the base database structures in the database, and wherein the updated element ordering is added to the schema as an annotation.

15. The computer-readable storage medium of claim 13, wherein each kidnum in the set of kidnum values is mapped to a propnum.

16. The computer-readable storage medium of claim 11, wherein receiving the request to make one or more changes to the schema includes receiving a request to add a new element to the schema, and wherein the step of determining that the schema, if modified by the one or more changes, would be compatible with the stored data comprises (a) determining that the one or more changes comprise an addition of the new element to the schema, and determining that the data stored in the base database structures in the database would be compatible with the schema as modified to add the new element.

17. The computer-readable storage medium of claim 16, wherein the one or more sequences of instructions, when executed by the one or more processors, further cause the one or more processors to perform determining a kidnum value for the new element.

18. The computer-readable storage medium of claim 17, wherein the kidnum value for the new element comprises a value greater than the highest kidnum value associated with a kidnum value for each attribute in a set of attributes.

19. The computer-readable storage medium of claim 17, wherein the kidnum value for the new element comprises a value greater than the highest kidnum value associated with a kidnum value for each attribute in a set of attributes associated with a complex type hierarchy.

20. The computer-readable storage medium of claim 11, wherein determining that the data stored in the base database structures in the database would be compatible with the schema, if modified by the one or more changes, includes identifying whether the modification to the schema executes in constant time.

23. The computer-readable storage medium of claim 11, wherein the step of determining that the schema, if modified by the one or more changes, would be compatible with the stored data comprises (b) determining that the one or more changes comprise a removal of an element from the schema, and determining that the data stored in the base database structures in the database would be compatible with the schema as modified to remove the element.

24. The computer-readable storage medium of claim 11, wherein the step of determining that the schema, if modified by the one or more changes, would be compatible with the stored data comprises (c) determining that the one or more changes affect the ordering of elements within the schema, and determining that the data stored in the base database structures in the database would be compatible with the schema as modified to affect the ordering of elements within the schema.