ACM SIGMOD Anthology ACM SIGMOD dblp.uni-trier.de

The Structural Model for Database Design.

Gio Wiederhold, Ramez Elmasri: The Structural Model for Database Design. ER 1979: 237-258
@inproceedings{DBLP:conf/er/WiederholdE79,
  author    = {Gio Wiederhold and
               Ramez Elmasri},
  editor    = {Peter P. Chen},
  title     = {The Structural Model for Database Design},
  booktitle = {Entity-Relationship Approach to Systems Analysis and Design.
                Proc. 1st International Conference on the Entity-Relationship
               Approach},
  publisher = {North-Holland},
  year      = {1979},
  isbn      = {0-444-85487-8},
  pages     = {237-258},
  ee        = {db/conf/er/WiederholdE79.html},
  crossref  = {DBLP:conf/er/79},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX

Abstract

The structural database model is summarized and its use for database design is demonstrated. The model is an extension of the relational model, but also captures relationship information so that the relations can be connected to each other. Entities and relationship between entities are represented using five types of relations and three types of connections. Constraints implied by the relationship between types of relations are specified by the connections. The rules for the maintenance of the structural integrity of the model under insertion and deletion of tuples are given and used to aid in database implementation. This model can be used to represent the structural features of several database model types and of databases implemented according to their rules. We propose that the structural model can be used to represent data relationships within the conceptual schema of the ANSI-SPARC DBMS model. We then present our view of the database design and implementation process.

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 2 Issue 1, ER 1979-1998" and ... DVD Version: Load ACM SIGMOD Anthology DVD 1" and ... BibTeX

References

[1]
Jean-Raymond Abrial: Data Semantics. IFIP Working Conference Data Base Management 1974: 1-60 BibTeX
[2]
Morton M. Astrahan, Mike W. Blasgen, Donald D. Chamberlin, Kapali P. Eswaran, Jim Gray, Patricia P. Griffiths, W. Frank King III, Raymond A. Lorie, Paul R. McJones, James W. Mehl, Gianfranco R. Putzolu, Irving L. Traiger, Bradford W. Wade, Vera Watson: System R: Relational Approach to Database Management. ACM Trans. Database Syst. 1(2): 97-137(1976) BibTeX
[3]
Shi-Kuo Chang, Wu-Haung Cheng: Database Skeleton and Its Application to Logical Database Synthesis. IEEE Trans. Software Eng. 4(1): 18-30(1978) BibTeX
[4]
Peter P. Chen: The Entity-Relationship Model - Toward a Unified View of Data. ACM Trans. Database Syst. 1(1): 9-36(1976) BibTeX
[5]
E. F. Codd: A Relational Model of Data for Large Shared Data Banks. Commun. ACM 13(6): 377-387(1970) BibTeX
[6]
E. F. Codd: Further Normalization of the Data Base Relational Model. IBM Research Report, San Jose, California RJ909: (1971) BibTeX
[7]
...
[8]
E. F. Codd: Recent Investigations in Relational Data Base Systems. IFIP Congress 1974: 1017-1021 BibTeX
[9]
...
[10]
Ramez Elmasri, Gio Wiederhold: Data Model Integration Using the Structural Model. SIGMOD Conference 1979: 191-202 BibTeX
[11]
...
[12]
...
[13]
James P. Fry, Edgar H. Sibley: Evolution of Data-Base Management Systems. ACM Comput. Surv. 8(1): 7-42(1976) BibTeX
[14]
Michael Hammer, Dennis McLeod: The Semantic Data Model: A Modelling Mechanism for Data Base Applications. SIGMOD Conference 1978: 26-36 BibTeX
[15]
Gerald Held, Michael Stonebraker, Eugene Wong: INGRES: A Relational Data Base System. AFIPS National Computer Conference 1975: 409-416 BibTeX
[16]
William Kent: New Criteria for the Conceptual Model. VLDB 1976: 1-12 BibTeX
[17]
Glenn K. Manacher: On the Feasibility of Implementing a Large Relational Data Base with Optimal Performance on a Mini-Computer. VLDB 1975: 175-201 BibTeX
[18]
Shamkant B. Navathe, Mario Schkolnick: View Representation in Logical Database Design. SIGMOD Conference 1978: 144-156 BibTeX
[19]
Daniel Sagalowicz: IDA: An Intelligent Data Access Program. VLDB 1977: 293-302 BibTeX
[20]
John Miles Smith, Diane C. P. Smith: Database Abstractions: Aggregation and Generalization. ACM Trans. Database Syst. 2(2): 105-133(1977) BibTeX
[21]
...
[22]
...
[23]
Dennis Tsichritzis, Frederick H. Lochovsky: Hierarchical Data-Base Management: A Survey. ACM Comput. Surv. 8(1): 105-123(1976) BibTeX
[24]
...
[25]
...
[26]
...
[27]
Gio Wiederhold: Database Design. McGraw-Hill Book Company 1977
BibTeX

Referenced by

  1. Catherine Hamon, Arthur M. Keller: Two-Level Caching of Composite Object Views of Relational Databases. ICDE 1995: 428-437
  2. Gio Wiederhold: Modelling and System Maintenance. OOER 1995: 1-20
  3. Renée J. Miller, Yannis E. Ioannidis, Raghu Ramakrishnan: The Use of Information Capacity in Schema Integration and Translation. VLDB 1993: 120-133
  4. Jeffrey R. Horowitz, Alfonso F. Cardenas: Decomposing Heterogeneous Inter-Entity Relationship Updates. IEEE Trans. Knowl. Data Eng. 4(4): 360-370(1992)
  5. Thierry Barsalou, Dipayan Gangopadhyay: M(DM): An Open Framework for Interoperation of Multimodel Multidatabase Systems. ICDE 1992: 218-227
  6. Thierry Barsalou, Arthur M. Keller, Niki Siambela, Gio Wiederhold: Updating Relational Databases through Object-Based Views. SIGMOD Conference 1991: 248-257
  7. Kyu-Young Whang, Brad T. Vander Zanden, Howard M. Taylor: A Linear-Time Probabilistic Counting Algorithm for Database Applications. ACM Trans. Database Syst. 15(2): 208-229(1990)
  8. Jeffrey D. Ullman: Principles of Database and Knowledge-Base Systems, Volume II. Computer Science Press 1989, ISBN 0-7167-8162-X
    Contents
  9. Jim Diederich, Jack Milton: New Methods and Fast Algorithms for Database Normalization. ACM Trans. Database Syst. 13(3): 339-365(1988)
  10. Xiaolei Qian, Richard J. Waldinger: A Transaction Logic for Database Specification. SIGMOD Conference 1988: 243-250
  11. Serge Abiteboul, Richard Hull: IFO: A Formal Semantic Database Model. ACM Trans. Database Syst. 12(4): 525-565(1987)
  12. Richard Hull, Roger King: Semantic Database Modeling: Survey, Applications, and Research Issues. ACM Comput. Surv. 19(3): 201-260(1987)
  13. Gio Wiederhold, Xiaolei Qian: Modeling Asynchrony in Distributed Databases. ICDE 1987: 246-250
  14. Jim Diederich, Jack Milton: ODDESSY: An Object-Oriented Database Design System. ICDE 1987: 235-244
  15. Joachim Biskup, Bernhard Convent: A Formal View Integration Method. SIGMOD Conference 1986: 398-407
  16. Xiaolei Qian, Gio Wiederhold: Data Definition Facilities of Critias. ER 1985: 46-55
  17. S. Jerrold Kaplan: Designing a Portable Natural Language Database Query System. ACM Trans. Database Syst. 9(1): 1-19(1984)
  18. Shamkant B. Navathe, T. Sashidhar, Ramez Elmasri: Relationship Merging in Schema Integration. VLDB 1984: 78-90
  19. Ramez Elmasri, Shamkant B. Navathe: Object Integration in Logical Database Design. ICDE 1984: 426-433
  20. James Davidson: A Natural Language Interface for Performing Database Updates. ICDE 1984: 69-76
  21. Edward Sciore: Inclusion Dependencies and the Universal Instance. PODS 1983: 48-57
  22. Robert W. Marti: Integrating Database and Program Description Using an ER-Data Dictionary. ER 1983: 377-392
  23. Maurizio Lenzerini, Gaetano Santucci: Cardinality Constraints in the Entity-Relationship Model. ER 1983: 529-549
  24. Marco A. Casanova, Ronald Fagin, Christos H. Papadimitriou: Inclusion Dependencies and Their Interaction with Functional Dependencies. PODS 1982: 171-176
  25. Marco A. Casanova: A Theory of Data Dependencies over Relational Expressions. PODS 1982: 189-198
  26. Michael Hammer, Dennis McLeod: Database Description with SDM: A Semantic Database Model. ACM Trans. Database Syst. 6(3): 351-386(1981)
  27. Kyu-Young Whang, Gio Wiederhold, Daniel Sagalowicz: Separability - An Approach to Physical Data Base Design. VLDB 1981: 320-332
  28. Ramez Elmasri, Gio Wiederhold: GORDAS: A Formal High-Level Query Language for the Entity-Relationship Model. ER 1981: 49-72
  29. Peter P. Chen: Recent Literature on the Entity-Relationship Approach. ER 1979: 3-12
BibTeX
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
ER 1979 Proceedings: Copyright © by Int. Conf. on ERA, ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sat May 16 23:09:29 2009