ObjectDB.pptVIP

Object Database Systems Gulay UnelApril 1, 2008 Motivation Support more complex kinds of data Two paths: Object-Oriented Database Systems Object-Relational Database Systems Object-Oriented DBS Good for apps where complex objects play a central role Influenced by object-oriented PLs An attempt to add DBMS functionality to a PL environment Object Data Model Object Query Language are developed Object Relational DBS Extend relational database systems with the functionality necessary to support a broader class of applications Bridge between relational and object-oriented paradigms RDBMS vendors are adding ORDBMS functionality Advantages Disadvantages ODBMS: Navigational interfaces: implemented efficientlyby pointersoptimized for specific search routes or viewpoints RDBMS: Declarative interfaces: better for general purpose queries How ODB works? (from Wikipedia) Motivating Example Dinky Entertainment Company Assets: collection of cartoon characters Especially: Herbert the Worm Also licensing Herbert’s image, voice, video DB: products films New Data Types User-defined data types: Herbert’s image, voice, video footage Object identity important to store references instead of copies of objects Inheritance In RDBMS: BLOBs Binary Large Object Further processing by the user application program Not efficient as we have to retrieve all BLOBs in a collection Manipulating the New Data Cereal Company: Clog wants to lease an image of Herbert in front of a sunriseSELECT F.Frameno, thumbnail(F.image), C.lease_priceFROM Frames F, Categories CWHERE F.category = C.cid AND is_sunrise(F.image) AND is_herbert(F.image)Frames(Frameno: integer, image: jpeg_image, category: integer)Categories(cid: integer, name: text, lease_price:float, comments: text) Methods written in an imperative language like Java registered with a DBS: can be used in the same way as built-in methods such as =, +, -, , Additional Features User Defined Methods: User defined types are mani