Data Model for Extensible Support of Explicit Relationships in Design Databases.

Joan Peckham, Bonnie MacKellar, Michael Doherty: Data Model for Extensible Support of Explicit Relationships in Design Databases. VLDB J. 4(2): 157-191(1995)
  author    = {Joan Peckham and
               Bonnie MacKellar and
               Michael Doherty},
  title     = {Data Model for Extensible Support of Explicit Relationships in
               Design Databases},
  journal   = {VLDB J.},
  volume    = {4},
  number    = {2},
  year      = {1995},
  pages     = {157-191},
  ee        = {db/journals/vldb/PeckhamMD95.html},
  bibsource = {DBLP,}


We describe the conceptual model of SORAC, a data modeling system developed at the University of Rhode Island. SORAC supports both semantic objects and relationships, and provides a tool for modeling databases needed for complex design domains. SORAC's set of built-in semantic relationships permits the schema designer to specify enforcement rules that maintain constraints on the object and relationship types. SORAC then automatically generates C++ code to maintain the specified enforcement rules, producing a schema that is compatible with Ontos. This facilitates the task of the schema designer, who no longer has to ensure that all methods on object classes correctly maintain necessary constraints. In addition, explicit specification of enforcement rules permits automated analysis of enforcement propagations. We compare the interpretations of relationships within the semantic and object-oriented models as an introduction to the mixed model that SORAC supports. Next, the set of built-in SORAC relationship types is presented in terms of the enforcement rules permitted on each relationship type. We then use the modeling requirements of an architectural design support system, called ArchObjects, to demonstrate the capabilities of SORAC. The implementation of current SORAC prototype is also briefly discussed.

Copyright © 1995 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.

Key Words

Database constraints, semantic and object-oriented data modeling, relationship semantics, computer-aided architectural design.

Online Paper

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 4 Issue 1, Books, VLDB-j, TODS, ..." and ... DVD Version: Load ACM SIGMOD Anthology DVD 2" and ... BibTeX


[Albano et al. 1991]
Antonio Albano, Giorgio Ghelli, Renzo Orsini: A Relationship Mechanism for a Strongly Typed Object-Oriented Database Programming Language. VLDB 1991: 565-575 BibTeX
[Andrews & Sinkel 1991]
[Barsalou et al. 1991]
Thierry Barsalou, Arthur M. Keller, Niki Siambela, Gio Wiederhold: Updating Relational Databases through Object-Based Views. SIGMOD Conference 1991: 248-257 BibTeX
[Batory & Kim 1985]
Don S. Batory, Won Kim: Modeling Concepts for VLSI CAD Objects. ACM Trans. Database Syst. 10(3): 322-346(1985) BibTeX
[Bouzeghoub & Metais 1991]
Mokrane Bouzeghoub, Elisabeth Métais: Semantic Modeling of Object Oriented Databases. VLDB 1991: 3-14 BibTeX
[Ceri & Widom 1990]
Stefano Ceri, Jennifer Widom: Deriving Production Rules for Constraint Maintainance. VLDB 1990: 566-577 BibTeX
[Chen 1976]
Peter P. Chen: The Entity-Relationship Model - Toward a Unified View of Data. ACM Trans. Database Syst. 1(1): 9-36(1976) BibTeX
[Diaz & Gray 1991]
Oscar Díaz, Peter M. D. Gray: Semantic-rich User-defined Relationship as a Main Constructor in Object Oriented Database. DS-4 1990: 207-224 BibTeX
[Dogac etal. 1986]
Asuman Dogac, Esen A. Ozkarahan, Peter P. Chen: An Integrity System for a Relational Database Architecture. ER 1989: 287-301 BibTeX
[Doherty et al. 1993]
Michael Doherty, Joan Peckham, Victor Fay Wolfe: Implementing Relationships and Constraints in an Object-Oriented Database Using a Monitor Construct. Rules in Database Systems 1993: 347-363 BibTeX
[Dong 1992]
[Dube & MacKellar 1992]
[Eastman et al. 1991]
[Foo & Takefuji 1990]
Simon Y. Foo, Yoshiyasu Takefuji: Databases and Cell-Selection Algorithms for VLSI Cell Libraries. IEEE Computer 23(2): 18-30(1990) BibTeX
[Gehani & Jagadish 1991]
Narain H. Gehani, H. V. Jagadish: Ode as an Active Database: Constraints and Triggers. VLDB 1991: 327-336 BibTeX
[Geller 1991]
[Halper et al. 1992]
Michael Halper, James Geller, Yehoshua Perl: "Part" Relations for Object-Oriented Databases. ER 1992: 406-422 BibTeX
[Hammer & McLEod 1981]
Michael Hammer, Dennis McLeod: Database Description with SDM: A Semantic Database Model. ACM Trans. Database Syst. 6(3): 351-386(1981) BibTeX
[Hudson & King 1988]
Scott E. Hudson, Roger King: The Cactis Project: Database Support for Software Environment. IEEE Trans. Software Eng. 14(6): 709-719(1988) BibTeX
[Hull & King 1987]
Richard Hull, Roger King: Semantic Database Modeling: Survey, Applications, and Research Issues. ACM Comput. Surv. 19(3): 201-260(1987) BibTeX
[Kim et al. 1989]
Won Kim, Elisa Bertino, Jorge F. Garza: Composite Objects Revisted. SIGMOD Conference 1989: 337-347 BibTeX
[Kim 1990]
[Kim & Lochovsky 1989]
Won Kim, Frederick H. Lochovsky (Eds.): Object-Oriented Concepts, Databases, and Applications. ACM Press and Addison-Wesley 1989, ISBN 0-201-14410-7
Contents BibTeX
[Laffra & van den Bos 1991]
[MacKellar & Ozel 1991]
[MacKellar 1992]
[MacKellar & Peckham 1992]
[Morgenstern 1984]
Matthew Morgenstern: Constraint Equations: Declarative Expression of Constraints With Automatic Enforcement. VLDB 1984: 291-300 BibTeX
[Nguyen & Rieu 1991]
[ONTOS Developer's Guide 1991]
[Peckham & Maryanski 1988]
Joan Peckham, Fred J. Maryanski: Semantic Data Models. ACM Comput. Surv. 20(3): 153-189(1988) BibTeX
[Peckham et al. 1989]
[Peckham et al. 1995]
Joan Peckham, Fred J. Maryanski, Steven A. Demurjian: Towards the Correctness and Consistency of Update Semantics in Semantic Database Schema. IEEE Trans. Knowl. Data Eng. 8(3): 503-507(1996) BibTeX
[Prichard et al. 1994]
Janet J. Prichard, Lisa Cingiser DiPippo, Joan Peckham, Victor Fay Wolfe: RTSORAC: A Real-Time Object-Oriented Database Model. DEXA 1994: 601-610 BibTeX
[Quian 1994]
[Roberts 1993]
[Rumbaugh 1987]
James E. Rumbaugh: Relations as Semantic Constructs in an Object-Oriented Language. OOPSLA 1987: 466-481 BibTeX
[Sathi et al. 1985]
[Stefik & Bobrow 1986]
[Urban 1989]
[Urban & Delcambre 1990]
Susan Darling Urban, Lois M. L. Delcambre: Constraint Analysis: A Design Process for Specifying Operations on Objects. IEEE Trans. Knowl. Data Eng. 2(4): 391-400(1990) BibTeX
[Urban et al. 1992]
Susan Darling Urban, Anton P. Karadimce, Ravi B. Nannapaneni: The Implementation and Evaluation of Integrity Maintenance Rules in an Object-Oriented Database. ICDE 1992: 565-572 BibTeX
[Vora 1992]
[Widom & Finkelstein 1990]
Jennifer Widom, Sheldon J. Finkelstein: Set-Oriented Production Rules in Relational Database Systems. SIGMOD Conference 1990: 259-270 BibTeX
[Zdonik 1990]
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
VLDB Journal: 1992-1995 Copyright © by VLDB Endowment / 1996-... Copyright © by Springer Verlag,
ACM SIGMOD Anthology: Copyright © by ACM (, Corrections:
DBLP: Copyright © by Michael Ley (, last change: Sun May 17 00:31:23 2009