Making and using abstract XML representations of data dictionary metadata

• US 8,275,810 B2
• Filed: 07/05/2005
• Issued: 09/25/2012
• Est. Priority Date: 07/05/2005
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Barton, Lee B.
• Primary Examiner(s): Vital, Pierre
• Assistant Examiner(s): Rostami, Mohammad S
• Application Number:
  US11/174,909
• Publication Number:
  US 20070011192A1
• Time in Patent Office: 2,639 Days
• Field of Search: 707/1, 707/2, 707/3, 707/4, 707/5, 707/6, 707/7, 707/8, 707/9, 707/10, 707/100, 707/101, 707/102, 707/103, 707/104, 707/200, 707/201, 707/202, 709/226, 709/231, 709/223
• US Class Current: 707/803
• CPC Class Codes: G06F 16/288 Entity relationship models
• CPC Class Codes: G06F 16/83 Querying

Abstract

An XML representation of the metadata for objects in a database system. The XML representation is called SXML. The SXML representations of two objects that belong to the same class of objects may be compared to produce a difference representation that shows the differences between the objects. Database commands that will create or alter objects may be produced from the difference representation, as well as an XML representation of the database commands. In addition to being comparable, SXML representations have the characteristics that a given property of the metadata is expressed in only one way in the representation, that SXML does not describe properties that belong only to particular instances of the object described by the metadata, that SXML describes only properties that the user can specify when creating an object, and that SXML is easy for humans to read, understand, and write.

Claims

1. A representation of database system metadata that defines an object in a database system, the object belonging to a class thereof that is defined in the database system metadata and the database system metadata defining the object such that the database system is able to query the object, the database system metadata having been fetched by an execution of a query on the database system, the representation of the database system metadata being automatically produced by the database system from the fetched database system metadata prior to any transformation to a data definition language, the representation of the database system metadata being included in a storage device accessible to a processor, and the representation of the database system metadata being characterized in that:

the representation of the database system metadata for an object in the database system belonging to a particular class of classes comprises a simplified XML (SXML) representation, wherein

the simplified XML (SXML) representation comprises an aggregate metadata of the object, in which the aggregate metadata is less than metadata for all properties of the object, and the simplified XML (SXML) representation does not include metadata, which is specific to an instance of the object that is used to produce the simplified XML(SXML) representation, or metadata, which is associated with a property of the object that cannot be specified by a user during creation of the object, and

the simplified XML (SXML) representation is automatically comparable by the processor with another simplified XML (SXML) representation of the database system metadata for another object belonging to the particular class from a different database system to determine one or more differences between the database system metadata for objects in database systems.

2. The computer implemented method of clam 1, in which the representation of the database system metadata set forth in claim 1 further characterized in that:

the simplified XML representation includes properties specified by the database system metadata for the object which the user may specify when creating the object but does not include the database system metadata specifying one or more internal representations of one or more instances of the object in the database system that produces the simplified XML (SXML) representation.

3. The computer implemented method of clam 1, in which the representation of the database system metadata set forth in claim 1, wherein the database system comprises a relational database system that responds to SQL and the simplified XML (SXML) representation is further characterized in that:

the simplified XML (SXML) representation of the database system metadata employs constructs from BNF Syntax for SQL and SQL names for objects in the database system metadata but does not contain binary-encoded values or implementation-specific tags, whereby the simplified XML (SXML) representation of the database system metadata is easily read by human beings.

4. The computer implemented method of clam 1, in which the representation of the database system metadata set forth in claim 1, wherein

the processor reads the representation of the database system metadata to produce database system metadata for other objects that are like the object.

5. The computer implemented method of clam 1, in which the representation of the database system metadata set forth in claim 1, wherein

the database system that produced the representation of the database system metadata comprises a relational database system that respond to SQL, and

the processor automatically produces creation DDL for the object from the representation of the database system metadata.

6. The computer implemented method of clam 1, in which the representation of the database system metadata set forth in claim 1, wherein

the database system that produced the representation of the database system metadata comprises a relational database system that responds to SQL, and

the processor compares the representation of the database system metadata produced by the database system for a first object of the objects with another representation of the database system metadata for a second object of the objects produced by a different database system and produces ALTER DDL which, when applied to the second object by the different database system, makes the second object like the first object.

7. The computer implemented method of clam 1, in which the representation of the database system metadata set forth in claim 1, wherein

the processor reads the representation of the database system metadata for the object in the database system belonging to the particular class and reads the representation of the database system metadata for the another object in the different database system, the object and the another object belonging to the particular class, to produce a representation of the database system metadata that shows one or more differences between metadata of the object and metadata of the another object.

8. The computer implemented method of clam 1, in which the representation of the database system metadata set forth in claim 7, wherein

the representation of the database system metadata is made according to XML standard.

9. The computer implemented method of clam 1, in which the representation of the database system metadata set forth in claim 1 wherein:

the simplified XML (SXML) representation of the database system metadata is made according to SXML standard.

10. A data storage device having stored thereupon a sequence of instructions which, when executed by at least one processor, causes the at least one processor to perform a process, the process comprising:

using the at least one processor to perform an execution of a query that causes the database system metadata to be fetched and used to generate the representation of database system metadata, in which

the data storage device includes the representation of the database system metadata set forth in claim 1.

27. The computer implemented method of clam 1, in which the simplified XML (SXML) representation or the another simplified XML (SXML) representation set forth in claim 1 further characterized in that:

a given property specified by the database system metadata for the object belonging to the particular class is expressed in only one way in the simplified XML (SXML) representation or the another simplified XML (SXML) representation of the database system metadata.

11. An apparatus employed in a database system that includes a processor and a storage device accessible to the processor for comparing database system metadata for a set of at least two objects belonging to the same class of objects, the database system metadata defining an object in a database system, the object belonging to a class thereof that is defined in the database system metadata and the database system metadata defining the object such that the database system is able to query the object, the database system metadata being included in the storage device, and the apparatus comprising:

at least one processor of the database system to perform an execution of a query that causes the database system metadata to be fetched and used to generate a simplified XML (SXML) representation of the database system metadata for an object of a class, in which

the simplified XML (SXML) representation comprises an aggregate metadata of the object, and

the aggregate metadata is less than metadata of all properties of the object and does not include some metadata, which is specific to an instance of the object, or metadata, which is associated with a property of the object, that cannot be specified by a user during creation of the object; and

a metadata comparator coupled to the at least one processor to compare the simplified XML (SXML) representation to another simplified XML (SXML) representation, which is generated by another database system for another object of the class, in which the another simplified XML (SXML) representation represents one or more differences between metadata for the object and metadata for the another object.

12. The apparatus set forth in claim 11, wherein

the simplified XML (SXML) representation includes properties specified by the database system metadata for one or more objects which a user specifies when creating the one or more objects but do not include database system metadata specifying one or more internal representations of objects in the one or more objects'"'"' respective database systems.

13. The apparatus set forth in claim 11 further comprising:

a generator which is executed by the processor to receive the simplified XML representation and to produce a description therefrom of how the object is to be modified to become similar to the another object.

14. The apparatus set forth in claim 13 wherein

the database system comprises a relational database system, and

the description comprises one or more ALTER DDL statements for altering the object so that the object becomes similar to the another object.

15. The apparatus set forth in claim 13 wherein

the database system comprises a relational database system, and

the description comprises an XML representation of one or more ALTER DDL statements for altering the object so that the one object becomes similar to the another object.

16. The apparatus set forth in claim 13, wherein

the simplified XML (SXML) representation of the database system metadata and the another simplified XML (SXML) representation are made according to XML standard.

17. The apparatus set forth in claim 11, wherein

the simplified XML (SXML) representation of the database system metadata and the another simplified XML (SXML) representation are made according to SXML standard.

18. A data storage device characterized in that:

the data storage device includes code which, when executed in the database system, implements the metadata comparator set forth in claim 11.

19. A method for comparing database system metadata for a set of at least two objects belonging to a class of objects, the database system metadata defining an object in a database system, the object belonging to the class that is defined in the database system metadata and the database system metadata defining the object such that the database system is allowed to query the object, the method comprising:

using at least one processor of the database system to perform a process, the process comprising;

performing an execution of a query to fetch the database system metadata for an object of a set of objects of a class;

generating a simplified XML (SXML) representation of the database system metadata for the object of the set of objects by using the database system metadata that is fetched, in which

the simplified XML (SXML) representation comprises an aggregate metadata of the object,

the aggregate metadata is less than metadata of all properties of the object and does not include some metadata, which is specific to an instance of the object, or metadata, which is associated with a property of the object, that cannot be specified by a user during creation of the object, and

the simplified XML (SXML) representation is characterized by being capable of being compared with another simplified XML (SXML) representation generated by another database system for another object of the class to which the object belongs, the another simplified XML (SXML) representation representing one or more differences between metadata for the object and metadata for the another object.

20. The method set forth in claim 19, wherein

the simplified XML (SXML) representation includes one or more properties specified by the database system metadata for one or more objects which the user specifies when creating the one or more objects but do not include database system metadata specifying one or more internal representations of the one or more objects in the one or more objects'"'"' respective database systems.

21. The method set forth in claim 19, further comprising:

accessing the another simplified XML (SXML) representation; and

producing a description from the another simplified XML (SXML) representation of how the object is to be modified to become similar to the another object.

22. The method set forth in claim 21, wherein

the database system comprises a relational database system, in which

the description comprises one or more ALTER DDL statements for altering the object so that the object becomes similar to the another object.

23. The method set forth in claim 21, wherein

the database system comprises a relational database system, and

the description comprises an XML representation of one or more ALTER DDL statements for altering the object so that the object becomes similar to the another object.

24. The method set forth in claim 21, wherein

the simplified XML (SXML) representation and the another simplified XML (SXML) representation are made according to XML standard.

25. The method set forth in claim 19, wherein

the simplified XML (SXML) representation and the another simplified XML (SXML) representation are made according to SXML standard.

26. A data storage device characterized in that:

the device includes code which, when executed in a database system, implements the method of claim 19.

28. The method set forth in claim 19, in which the simplified XML (SXML) representation for the object is compared with the another simplified XML (SXML) representation for the another object to produce a different representation.