A Graphical Schema Representation for Object-Oriented Databases

The graphical representation of database schemata has been a useful tool for the designers and users of database systems. Such a tool is no longer viewed simply as a convenience, but as a necessity. In this paper, we present a graphical schema representation for object-oriented databases (OODBs) which incorporates a wide variety of symbols including those for classes, attributes, methods, user-defined relationships, constraint relationships, and generic (system-defined) relationships—enough to support a diverse group of object-oriented data models. We have also defined several levels of abridgement or display, one of which allows the user to display only the class hierarchy. The OOdini system that creates and manipulates such graphical schemata is discussed. This system, besides offering constraint-based editing of the aforesaid schema representation, provides for conversion into an abstract OODB schema language. A feature is also provided for converting this abstract textual language into the syntax of the Vodak Modeling Language, thus making OOdini an effective OODB graphical interface.

[1]  Narain H. Gehani,et al.  ODE (Object Database and Environment): the language and the data model , 1989, SIGMOD '89.

[2]  Michael Stonebraker,et al.  The design of POSTGRES , 1986, SIGMOD '86.

[3]  Roger B. Dannenberg,et al.  Garnet: comprehensive support for graphical, highly interactive user interfaces , 1990, Computer.

[4]  James Gettys,et al.  The X window system , 1990 .

[5]  James Geller,et al.  Graphical Deep Knowledge for Intelligent Machine Drafting , 1987, IJCAI.

[6]  Peter P. Chen.  The entity-relationship model: toward a unified view of data , 1975, VLDB '75.

[7]  David W. Shipman.  The functional data model and the data language DAPLEX , 1979, SIGMOD '79.

[8]  C. J. Date.  An Introduction to Database Systems , 1975 .

[9]  Ramez Elmasri,et al.  Fundamentals of Database Systems , 1989 .

[10]  Michael Schrefl,et al.  Dynamic Derivation of Personalized Views , 1988, VLDB.

[11]  Kevin Wilkinson,et al.  Overview of the Iris DBMS , 1989, Research Foundations in Object-Oriented and Semantic Database Systems.

[12]  Michael Schrefl,et al.  Object class definition by generalization using upward inheritance , 1988, Proceedings. Fourth International Conference on Data Engineering.

[13]  Trevor P. Hopkins,et al.  OSF/motif programmer's guide , 1991 .

[14]  Daniel Bryce,et al.  SNAP: A graphics-based schema manager , 1986, 1986 IEEE Second International Conference on Data Engineering.

[15]  Peter Wegner,et al.  The Object-Oriented Classification Paradigm , 1987, Research Directions in Object-Oriented Programming.

[16]  John F. Sowa,et al.  Conceptual Structures: Information Processing in Mind and Machine , 1983 .

[17]  Michael Stonebraker,et al.  Third-generation database system manifesto , 1990, SGMD.

[18]  Jacob Stein,et al.  The GemStone object database management system , 1991, CACM.

[19]  William E. Lorensen,et al.  Object-Oriented Modeling and Design , 1991, TOOLS.

[20]  Michael Schrefl,et al.  A Knowledge-Based Approach to Overcome Structural Differences in Object Oriented Database Integration , 1988, DS-3.

[21]  W. Shipman David,et al.  The functional data model and the data language DAPLEX , 1988 .

[22]  Douglas A. Young.  X window systems - programming and applications with Xt , 1989 .

[23]  Marc Gyssens,et al.  A graph-oriented object model for database end-user interfaces , 1990, SIGMOD '90.

[24]  Michael Stonebraker,et al.  Readings in Database Systems , 1988 .

[25]  Renzo Orsini,et al.  An Overview of Sidereus: A Graphical Database Schema Editor for Galileo , 1988, EDBT.

[26]  Joan Peckham,et al.  Representing Design Objects in SORAC , 1992 .

[27]  Trevor P. Hopkins.  OSF/motif style guide , 1991 .

[28]  Serge Abiteboul,et al.  IFO: A Formal Semantic Database Model , 1987, ACM Trans. Database Syst..

[29]  R. G. G. Cattell,et al.  Entity-Relationship Database User Interfaces , 1987, ER.

[30]  Renzo Orsini,et al.  GALILEO: a strongly-typed, interactive conceptual language , 1985, TODS.

[31]  Erich J. Neuhold,et al.  Structural schema integration in heterogeneous multi-database systems using the Dual Model , 1991, [1991] Proceedings. First International Workshop on Interoperability in Multidatabase Systems.

[32]  James Geller.  Propositional Representation for Graphical Knowledge , 1991, Int. J. Man Mach. Stud..

[33]  Won Kim,et al.  Object-Oriented Concepts, Databases, and Applications , 1989 .

[34]  Joobin Choobineh,et al.  The Object-Oriented Entity-Relationship Model (OOERM) , 1991, J. Manag. Inf. Syst..

[35]  R. G. G. Cattell,et al.  Entity-Relationship Database User Interface , 1988, IEEE Data Eng. Bull..

[36]  W. Horak,et al.  An object-oriented Office Document Architecture model for processing and interchange of documents , 1984 .

[37]  Bertrand Meyer,et al.  Lessons from the design of the Eiffel libraries , 1990, CACM.

[38]  Won Kim,et al.  A Model of Queries for Object-Oriented Databases , 1989, VLDB.

[39]  Jeffrey D. Ullman,et al.  Principles of Database Systems , 1980 .

[40]  Narain H. Gehani,et al.  OdeView: the graphical interface to Ode , 1990, SIGMOD '90.

[41]  Michael Schrefl,et al.  Object/behavior diagrams , 1991, [1991] Proceedings. Seventh International Conference on Data Engineering.

[42]  Jeff Conklin,et al.  Hypertext: An Introduction and Survey , 1987, Computer.

[43]  O. Deux,et al.  The Story of O2 , 1990, IEEE Trans. Knowl. Data Eng..