System and method for maintenance and deferred propagation of schema changes to the affected objects in an object oriented database

• US 5,794,030 A
• Filed: 12/04/1995
• Issued: 08/11/1998
• Est. Priority Date: 12/04/1995
• Status: Expired due to Term

• Current Assignee: Objectivity, Inc.
• Original Assignee: Objectivity, Inc.
• Inventors: Morsi, Magdi, Rucker, James
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Coby, Frantz
• Application Number:
  US08/567,119
• Time in Patent Office: 981 Days
• Field of Search: 395/614, 395/612, 395/613, 395/615, 395/129, 395/700, 395/650, 395/611, 395/616
• US Class Current: 1/1
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

A method and system for use with object oriented databases provides schema evolution with deferred propagation of schema changes. The method and system provide a schema that persistently maintains class objects by storing an initial class definition, and shape objects associated with particular class objects and storing subsequent class definitions. The shape objects associated with a particular class object form a shape chain, the last shape object in the shape chain being the current shape object, and maintaining the current class definition. Client objects representing actual instances of data in the database, are instantiated from whichever client object or shape object is current at the time of instantiation, so the all newly created client objects always have the current class definition. Existing client objects, which are those that were created prior to one or more subsequent modifications of the class definition and instantiations of the shape objects in the shape chain of the class, are updated to the current class definition only when they are accessed in the database, thereby providing deferred propagation. Updating such client objects includes copying data members for which there was no change in the definition of the member, and performing type conversion on those data members for which there was a change in the definition of the member.

Claims

1. A schema, embodied in a computer readable medium and defining at least one class of objects in a database, the schema comprising:

at least one class object providing a first definition of a class;

for at least one class object, a shape chain comprising at least one shape object associated with the class object in an ordered series, each shape object providing a subsequent definition of the class object at a selected time, and at least one shape object in the shape chain being a current shape object for the class; and

for at least one class object, at least one client object instantiated from the class object or from the shape object that was the current shape object at the time the client object was instantiated.

2. The schema of the claim 1, further comprising:

a base class object representing a base class, the base class object associated with a first shape chain including first shape objects; and

at least one derived class represented by a class object derived from the base class object and associated with a second shape chain including second shape objects, each second shape object referencing a first shape object that was the current first shape object at a time when the second shape object was instantiated, and the first shape object referencing the second shape object.

3. The schema of claim 1, further comprising:

an embedding class object representing an embedding class, the embedding class object associated with a first shape chain including first shape objects, and having at least one member object defining a member of the embedding class, the member object referencing a second class object being an embedded class object; and

the embedded class object associated with a second shape chain including second shape objects, each second shape object referencing a first shape object that was the current first shape object at a time when the second shape object was instantiated, the first shape object referencing the second shape object.

4. The schema of claim 1, wherein the ordered series of shape objects in a shape chain comprises a doubly linked list of shape objects terminating with a current shape object.

5. The schema of claim 1, further comprising:

for at least one class object, at least one member object defining a member of the class, the class object having references to the member objects, and each member object having a reference to the class object; and

wherein for each shape object in the shape chain of the class object, the shape object references to the member objects of the class, and maintains for selected member objects a flag indicating whether the member defined by the member object is deleted from the class.

6. The schema of claim 5, wherein each member object has a numerical member identifier unique within the class definition, and the class object and each shape object in the shape chain maintain the highest member identifier, such that for a new member added to the class definition, a new member object is instantiated and attached to the current shape object, the new member object having a member identifier incremented from the highest member identifier.

7. The schema of claim 1, wherein each class object has a reference to the current shape object in its shape chain.

8. The schema of claim 1, wherein each class object has a name corresponding to a name of the class, and a globally unique class identifier.

9. The schema of claim 8, included in an object oriented database system comprising a translation object that accepts a name of a class object and returns a reference to the current shape object in the shape chain of the class object.

10. The schema of claim 8, included in an object oriented database system comprising a translation object that accepts a class identifier of a class object and returns a reference to the current shape object in the shape chain of the class object.

11. The schema of claim 8, included in an object oriented database management system comprising:

a schema manager that receives a DDL input file including at least one class definition modifying an existing class in the database, and creates a new shape object in the shape chain of the class object defining the class, the new shape object becoming the current shape object in the shape chain, the schema manager;

associating with the new shape object, new member objects representing new members of the class; and

indicating, for selected member objects associated with the new shape object and representing existing members of the class, that the member has been deleted from the class according to the class definition.

12. The schema manager of claim 11, further determining for each input member definition in a class definition in the input file, whether the input member definition is different from an existing member definition provided by an existing member object in the current shape object of the class, and responsive to a difference, determining whether the input member definition is consistent with the existing member definition.

13. The schema of claim 12, wherein:

each member object has a numerical member identifier unique within the class definition; and

the schema manager, responsive to a consistent definition between an input member definition and an existing member definition provided by an existing member object, copies the member identifier of the existing member object to a new member object providing the input member definition.

14. The schema of claim 1 included in an object oriented database management system comprising:

an object manager accepting a request for a client object and determining whether the client object references the current shape object of the class from which the client object is instantiated, and responsive to the client object not referencing the current shape object, updating the definition of the client object to class definition provided by the current shape object.

15. A method of evolving a schema of a class in a database, the method comprising the steps of:

maintaining for the class a class object providing a first definition of the class;

maintaining in association with the class object a shape chain including at least one shape object in an ordered series, each shape object providing a subsequent definition of the class, the shape chain including a current shape object;

receiving an input data definition language file containing a modified definition of the class;

creating a new shape object for the class according to the modified definition of the class; and

,

appending the new shape object to the shape chain for the class, making the new shape object the current shape object.

16. The method of claim 15, further comprising:

instantiating a new client object of the class from the current shape object.

17. The method of claim 15, further comprising:

deferring updating of an existing client object instantiated from either the class object or any of the shape objects in the shape chain of the class object, excluding the current shape object, until the client object is accessed.

18. The method of claim 17, wherein deferring updating of an existing client object further comprises:

receiving a request for the client object; and

determining whether the client object was instantiated from the current shape object of the class;

and where the client object is not instantiated from the current shape object;

retrieving an instance object of the current shape object;

updating the members of the instance object with the existing corresponding members of the client object according to a type of the members; and

deleting the client object, the instance object becoming the client object.

19. The method of claim 18, wherein updating the members further comprises:

where the type of a member of the instance object is the same as the type of a corresponding member of the client object, copying the data of the member of the client object to the corresponding member of the instance object; and

where the type of a member of the instance object is not the same as the type of a corresponding member of the client object, converting the data of the member of the client object to the type of corresponding member of the instance object.

20. The method of claim 19, where converting the data of the member of the client object comprises creating a conversion object that converts from the type of the member of the client object to the type of the member of the instance object.

21. A schema for an object oriented database, embodied in a computer readable medium and capable of maintaining a time sequenced plurality of class definitions for each of a plurality of classes, the schema comprising:

for each class, a class object representing the class, and maintaining a first definition of the class;

for each class, a time sequenced plurality of shape objects, each shape object maintaining a subsequent definition of the class, the plurality of shape objects including a current shape object maintaining a current definition of the class, at least one of the plurality of shape objects associated with the class object of the class, wherein each class object maintains a reference to the current shape object of the class, and each shape object maintains a reference to a previous shape object and a reference to a next shape object in the time sequenced plurality of shape objects; and

each class object maintains a reference to at least one member object defining a member of the class, each member object having a member identifier unique within the class having the member, the class object maintaining the highest member identifier of its member objects, and each member object of the class having a reference to a shape object associated with the class object for the class.

22. The schema of claim 21, wherein:

each shape object of a class has a globally unique shape identifier;

each shape object maintains references to any parent shape object and to any child shape object; and

each shape object maintains references to any shape objects of member objects that are defined by embedded classes, and to any shape objects of classes that embed the class associated with the shape object as a member.