Customizable metadata merging framework

• US 7,469,262 B2
• Filed: 12/29/2003
• Issued: 12/23/2008
• Est. Priority Date: 12/29/2003
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Baskaran, Rajagopal, Singson, Jaime E.
• Primary Examiner(s): Vy; Hung T
• Application Number:
  US10/749,037
• Publication Number:
  US 20050149583A1
• Time in Patent Office: 1,821 Days
• Field of Search: 707/103.R, 707/103.Y, 707/103.Z, 707/204, 707/203, 707/101
• US Class Current: 1/1
• CPC Class Codes: G06F 16/219 Managing data history or versioning querying versioned data G06F16/2474; querying temporal data G06F16/2477
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99954 Version management

Abstract

One embodiment of the present invention provides a system that facilitates merging different versions of a database object. During operation, the system receives metadata associated with a first version of a database object and a second version of the database object. The system then compares metadata associated with the first version with metadata associated with the second version to create a difference report. Next, the system uses the different report to create an action plan that specifies how to merge the metadata associated with the first and second versions of the metadata object.

Claims

1. A computer implemented method to facilitate merging different versions of a database object, comprising:

receiving metadata associated with a first version of the database object and a second version of the database object, wherein the metadata provides a data structure that describes the database objects and is distinct from the database objects themselves;

comparing metadata associated with the first version of the database object with metadata associated with the second version of the database object to create a difference report;

creating an action plan from the difference report that specifies how to merge metadata associated with the first version of the database object with metadata associated with the second version of the database object, wherein creating the action plan from the difference report involves allowing a user to select which actions to take in merging metadata in order to produce merged metadata with desired properties and attributes; and

using the action plan to facilitate merging the metadata associated with the first version of the database object with the metadata associated with the second version of the object; and

wherein the first version of the database object and the second version of the database object include other objects that have been captured using Unified Modeling Language (UML) and stored in the database during design time.

2. The method of claim 1, wherein metadata associated with the first version and the second version of the database object are represented in Unified Modeling Language.

3. The method of claim 1, wherein comparing metadata associated with the first version and second version of the database object involves customizing which associations to compare.

4. The method of claim 1, wherein comparing metadata associated with the first version and second version of the database object involves customizing how to compare the first metadata and the second metadata.

5. The method of claim 1, wherein creating the action plan involves examining the difference report to determine what actions to take in bringing metadata associated with the first version and second versions of the database object into agreement.

6. The method of claim 1, wherein metadata associated with first and second versions of the metadata object can define database objects, wherein database objects include tables, columns, dimensions, cube, views, materialized views, and external tables.

7. The method of claim 1, wherein the action plan can specify a number of actions including creating, updating, and deleting database objects, and their properties.

8. A computer-readable storage medium storing instructions that when executed by a computer cause the computer to perform a method to facilitate merging different versions of a database object, the method comprising:

receiving metadata associated with a first version of the database object and a second version of the database object, wherein the metadata provides a data structure that describes the database objects and is distinct from the database objects themselves;

comparing metadata associated with the first version of the database object with metadata associated with the second version of the database object to create a difference report;

creating an action plan from the difference report that specifies how to merge metadata associated with the first version of the database object with metadata associated with the second version of the database object, wherein creating the action plan from the difference report involves allowing a user to select which actions to take in merging metadata in order to produce merged metadata with desired properties and attributes; and

using the action plan to facilitate merging the metadata associated with the first version of the database object with the metadata associated with the second version of the object; and

wherein the first version of the database object and the second version of the database object include other objects that have been captured using UML and stored in the database during design time.

9. The computer-readable storage medium of claim 8, wherein metadata associated with the first version and the second version of the database object are represented in Unified Modeling Language.

10. The computer-readable storage medium of claim 8, wherein comparing metadata associated with the first version and second version of the database object involves customizing which associations to compare.

11. The computer-readable storage medium of claim 8, wherein comparing metadata associated with the first version and second version of the database object involves customizing how to compare the first metadata and the second metadata.

12. The computer-readable storage medium of claim 8, wherein creating the action plan involves examining the difference report to determine what actions to take in bringing metadata associated with the first version and second versions of the database object into agreement.

13. The computer-readable storage medium of claim 8, wherein metadata associated with first and second versions of the metadata object can define database objects, wherein database objects include tables, columns, views, dimensions, and cubes.

14. The computer-readable storage medium of claim 8, wherein the action plan can specify a number of actions including creating, updating, and deleting database objects and their properties.

15. An apparatus to facilitate merging different versions of a database object, comprising:

a processor;

a memory;

a receiving mechanism configured to receive metadata associated with a first version of the database object and a second version of the database object, wherein the metadata provides a data structure that describes the database objects and is distinct from the database objects themselves;

a comparing mechanism configured to compare metadata associated with the first version of the database object with metadata associated with the second version of the database object to create a difference report;

a creating mechanism configured to create an action plan from the difference report that specifies how to merge metadata associated with the first version of the database object with metadata associated with the second version of the database object, wherein creating the action plan from the difference report involves allowing a user to select which actions to take in merging metadata in order to produce merged metadata with desired properties and attributes; and

a merging mechanism configured to use the action plan to facilitate merging the metadata associated with the first version of the database object with the metadata associated with the second version of the object; and

wherein the first version of the database object and the second version of the database object include other objects that have been captured using UML and stored in the database during design time.

16. The apparatus of claim 15, wherein metadata associated with the first version and the second version of the database object are represented in Unified Modeling Language.

17. The apparatus of claim 15, wherein comparing metadata associated with the first version and second version of the database object involves customizing which associations to compare.

18. The apparatus of claim 15, wherein comparing metadata associated with the first version and second version of the database object involves customizing how to compare the first metadata and the second metadata.

19. The apparatus of claim 15, wherein creating the action plan involves examining the difference report to determine what actions to take in bringing metadata associated with the first version and second versions of the database object into agreement.

20. The apparatus of claim 15, wherein metadata associated with first and second versions of the metadata object can define tables, columns, properties of tables, and properties of columns.

21. The apparatus of claim 15, wherein the action plan can specify a number of actions including creating, updating, and deleting tables, columns, or properties.