Object-OrientedDatabaseLanguages.pptVIP

Object-Oriented Database Languages Object Description Language Object Query Language Object-Oriented DBMS’s Standards group: ODMG = Object Data Management Group. ODL = Object Description Language, like CREATE TABLE part of SQL. OQL = Object Query Language, tries to imitate SQL in an OO framework. Framework --- 1 ODMG imagines OO-DBMS vendors implementing an OO language like C++ with extensions (OQL) that allow the programmer to transfer data between the database and “host language” seamlessly. Framework --- 2 ODL is used to define persistent classes, those whose objects may be stored permanently in the database. ODL classes look like Entity sets with binary relationships, plus methods. ODL class definitions are part of the extended, OO host language. ODL Overview A class declaration includes: A name for the class. Optional key declaration(s). Extent declaration = name for the set of currently existing objects of the class. Element declarations. An element is either an attribute, a relationship, or a method. Class Definitions class name { list of element declarations, separated by semicolons } Attribute and Relationship Declarations Attributes are (usually) elements with a type that does not involve classes. attribute type name; Relationships connect an object to one or more other objects of one class. relationship type name inverse relationship; Inverse Relationships Suppose class C has a relationship R to class D. Then class D must have some relationship S to class C. R and S must be true inverses. If object d is related to object c by R, then c must be related to d by S. Example: Attributes and Relationships class Bar { attribute string name; attribute string addr; relationship SetBeer serves inverse Beer::servedAt; } class Beer { attribute string name; attribute string manf; relationship SetBar servedAt inverse Bar::serves; } Types of Relationships The type of a relationship is either A class, like Bar. If so, an object with this re