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.
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
- Catherine Hamon, Arthur M. Keller:
Two-Level Caching of Composite Object Views of Relational Databases.
ICDE 1995: 428-437
- Gio Wiederhold:
Modelling and System Maintenance.
OOER 1995: 1-20
- Renée J. Miller, Yannis E. Ioannidis, Raghu Ramakrishnan:
The Use of Information Capacity in Schema Integration and Translation.
VLDB 1993: 120-133
- Jeffrey R. Horowitz, Alfonso F. Cardenas:
Decomposing Heterogeneous Inter-Entity Relationship Updates.
IEEE Trans. Knowl. Data Eng. 4(4): 360-370(1992)
- Thierry Barsalou, Dipayan Gangopadhyay:
M(DM): An Open Framework for Interoperation of Multimodel Multidatabase Systems.
ICDE 1992: 218-227
- Thierry Barsalou, Arthur M. Keller, Niki Siambela, Gio Wiederhold:
Updating Relational Databases through Object-Based Views.
SIGMOD Conference 1991: 248-257
- 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)
- Jeffrey D. Ullman:
Principles of Database and Knowledge-Base Systems, Volume II.
Computer Science Press 1989, ISBN 0-7167-8162-X
Contents - Jim Diederich, Jack Milton:
New Methods and Fast Algorithms for Database Normalization.
ACM Trans. Database Syst. 13(3): 339-365(1988)
- Xiaolei Qian, Richard J. Waldinger:
A Transaction Logic for Database Specification.
SIGMOD Conference 1988: 243-250
- Serge Abiteboul, Richard Hull:
IFO: A Formal Semantic Database Model.
ACM Trans. Database Syst. 12(4): 525-565(1987)
- Richard Hull, Roger King:
Semantic Database Modeling: Survey, Applications, and Research Issues.
ACM Comput. Surv. 19(3): 201-260(1987)
- Gio Wiederhold, Xiaolei Qian:
Modeling Asynchrony in Distributed Databases.
ICDE 1987: 246-250
- Jim Diederich, Jack Milton:
ODDESSY: An Object-Oriented Database Design System.
ICDE 1987: 235-244
- Joachim Biskup, Bernhard Convent:
A Formal View Integration Method.
SIGMOD Conference 1986: 398-407
- Xiaolei Qian, Gio Wiederhold:
Data Definition Facilities of Critias.
ER 1985: 46-55
- S. Jerrold Kaplan:
Designing a Portable Natural Language Database Query System.
ACM Trans. Database Syst. 9(1): 1-19(1984)
- Shamkant B. Navathe, T. Sashidhar, Ramez Elmasri:
Relationship Merging in Schema Integration.
VLDB 1984: 78-90
- Ramez Elmasri, Shamkant B. Navathe:
Object Integration in Logical Database Design.
ICDE 1984: 426-433
- James Davidson:
A Natural Language Interface for Performing Database Updates.
ICDE 1984: 69-76
- Edward Sciore:
Inclusion Dependencies and the Universal Instance.
PODS 1983: 48-57
- Robert W. Marti:
Integrating Database and Program Description Using an ER-Data Dictionary.
ER 1983: 377-392
- Maurizio Lenzerini, Gaetano Santucci:
Cardinality Constraints in the Entity-Relationship Model.
ER 1983: 529-549
- Marco A. Casanova, Ronald Fagin, Christos H. Papadimitriou:
Inclusion Dependencies and Their Interaction with Functional Dependencies.
PODS 1982: 171-176
- Marco A. Casanova:
A Theory of Data Dependencies over Relational Expressions.
PODS 1982: 189-198
- Michael Hammer, Dennis McLeod:
Database Description with SDM: A Semantic Database Model.
ACM Trans. Database Syst. 6(3): 351-386(1981)
- Kyu-Young Whang, Gio Wiederhold, Daniel Sagalowicz:
Separability - An Approach to Physical Data Base Design.
VLDB 1981: 320-332
- Ramez Elmasri, Gio Wiederhold:
GORDAS: A Formal High-Level Query Language for the Entity-Relationship Model.
ER 1981: 49-72
- 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