METU Object-Oriented DBMS.

Asuman Dogac, Ismailcem Budak Arpinar, Cem Evrendilek, Cetin Ozkan, Ilker Altintas, Ilker Durusoy, Mehmet Altinel, Tansel Okay, Yuksel Saygin: METU Object-Oriented DBMS. SIGMOD Conference 1994: 513
  author    = {Asuman Dogac and
               Ismailcem Budak Arpinar and
               Cem Evrendilek and
               Cetin Ozkan and
               Ilker Altintas and
               Ilker Durusoy and
               Mehmet Altinel and
               Tansel Okay and
               Yuksel Saygin},
  editor    = {Richard T. Snodgrass and
               Marianne Winslett},
  title     = {METU Object-Oriented DBMS},
  booktitle = {Proceedings of the 1994 ACM SIGMOD International Conference on
               Management of Data, Minneapolis, Minnesota, May 24-27, 1994},
  publisher = {ACM Press},
  year      = {1994},
  pages     = {513},
  ee        = {, db/conf/sigmod/sigmod94-513.html},
  crossref  = {DBLP:conf/sigmod/94},
  bibsource = {DBLP,}


MOOD (METU Object-Oriented DBMS) is developed on the Exodus Storage Manager (ESM) [ESM 92], and supports a SQL-like object-oriented query language (MOODSQL) [Ozk 93,Dog 94] and a graphical user interface, called MoodView [Arp 93], developed using Motif. The system is coded in C++ on Sun Sparc 2 workstations and has a type system derived from C++, eliminating the impedance mismatch between MOOD and C++. ESM provides the MOOD the following kernel functions:

Additionally, the MOOD kernel provides the following functions : Catalog management, and optimization and interpretation of SQL statements. During this interpretation, functions (which have been previously compiled with C++) within SQL statements, are dynamically linked and executed. The advantage of this approach is to eliminate the interpretation overhead and increase the overall efficiency of the system.

Each object is given a unique Object Identifier (OID) at object creation time by the ESM which is the disk start address of the object returned by the ESM. The object encapsulation properties are supported through the public and private declarations of C++. Objects are grouped in the abstraction level of a class, in other words, classes have extensions. Class inheritance mechanism of the MOOD is multiple inheritance. The name resolution is handled as in standard C++. Aggregate definitions are handled in the MOOD system by introducing type constructors (Set, List, Ref and Tuple). Aggregate classes can be constructed by recursive use of these type constructors.

The query optimizer of the MOOD is generated by using the Volcano Query Optimizer Generator. The Volcano Query Optimizer Generator [McK 93] provides for very fast and easy development of a query optimizer. The MOOD Optimizer uses database statistics obtained from the MOOD catalog in computing the selectivities and the costs for each optimization step.

The set of MOOD Algebra operators is given in [Dog 94]. A graphical user interface, namely MoodView is implemented. MoodView provides the database programmer with tools and functionalities for every phase of OODBMS application development. Current version of MoodView allows a database user to design, browse, and modify database schema interactively. Furthermore, a database administration tool, a full screen text-editor, a SQL based query manager, and a graphical indexing tool for the spatial data, i.e., R Trees are also implemented.

Copyright © 1994 by the ACM, Inc., used by permission. Permission to make digital or hard copies is granted provided that copies are not made or distributed for profit or direct commercial advantage, and that copies show this notice on the first page or initial screen of a display along with the full citation.

ACM SIGMOD Anthology

Online Version (ACM WWW Account required): Full Text in PDF Format

CDROM Version: Load the CDROM "Volume 1 Issue 1, SIGMOD '93-'97" and ...

DVD Version: Load ACM SIGMOD Anthology DVD 1" and ... BibTeX

Printed Edition

Richard T. Snodgrass, Marianne Winslett (Eds.): Proceedings of the 1994 ACM SIGMOD International Conference on Management of Data, Minneapolis, Minnesota, May 24-27, 1994. ACM Press 1994 BibTeX , SIGMOD Record 23(2), June 1994

Online Edition: ACM Digital Library

[Index Terms]
[Full Text in PDF Format, 90 KB]


[Arp 93]
Ismailcem Budak Arpinar, Asuman Dogac, Cem Evrendilek: MoodView: An Advanced Graphical User Interface for OODBMSs. SIGMOD Record 22(4): 11-18(1993) BibTeX
[Dog 94]
[ESM 92]
[McK 93]
William J. McKenna: Efficient Search in Extensible Query Optimization: The Volcano Optimizer Generator. Ph.D. thesis, University of Colorado-Boulder 1993
[Ozk 93]

Referenced by

  1. Fatma Ozcan, Sena Nural, Pinar Koksal, Cem Evrendilek, Asuman Dogac: Dynamic Query Optimization in Multidatabases. IEEE Data Eng. Bull. 20(3): 38-45(1997)
  2. Asuman Dogac, Ugur Halici, Ebru Kilic, Gökhan Özhan, Fatma Ozcan, Sena Nural, Cevdet Dengi, Sema Mancuhan, Ismailcem Budak Arpinar, Pinar Koksal, Cem Evrendilek: METU Interoperable Database System. SIGMOD Conference 1996: 552
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
ACM SIGMOD Anthology: Copyright © by ACM (, Corrections:
DBLP: Copyright © by Michael Ley (, last change: Sat May 16 23:40:23 2009