Database Models

Susan D. Urban,

Susan D. Urban

Arizona State University

Search for more papers by this author

Susan D. Urban,

Susan D. Urban

Arizona State University

Search for more papers by this author

First published: 15 June 2007

https://doi.org/10.1002/047134608X.W4301.pub2

Share a link

Email
Wechat
Bluesky

Abstract

A database model is a tool for describing the data that are to be stored in a database, providing an abstract, conceptual layer that protects the users and developers of database applications from the need to be concerned with low-level implementation details. Many different database models have been developed over the years, ranging from database-dependent models that are associated with specific types of database management systems to database-independent models that provide conceptual modeling front-ends for database application development. This article provides an overview of the basic concepts associated with conceptual, relational, and object-based database models. Conceptual modeling techniques are presented using the entity-relationship model and the semantic extensions of the enhanced entity-relationship model. The relational data model is presented as one of the most widely used models associated with a specific type of database management system. Techniques for mapping from conceptual models to the relational model are also presented. Throughout the article, the role of database semantics and semantic integrity constraints is emphasized. The article ends with an overview of the object-oriented data model and the object-relational data model, with a discussion of new directions for data modeling in advanced applications.

1 Fundamental Data Modeling Concepts
2 Development of Database Models
3 Conceptual Data Modeling
4 The Relational Data Model
5 Object-Based Models
6 Summary

Bibliography

1 R., Elmasri; S. B., Navathe Fundamentals of Database Systems, 5th ed.; Benjamin Cummings: Redwood City, 2006.
Web of Science® Google Scholar
2 P., Chen The Entity-Relationship Model: Toward a Unified View of Data. ACM Trans. Database Syst. 1976, 1 (1).
10.1145/320434.320440
Web of Science® Google Scholar
3 E. F., Codd A Relational Model for Large Shared Data Banks. Commun. ACM 1970, 13 (6).
10.1145/362384.362685
Web of Science® Google Scholar
4 J., Melton; A. R., Simon SQL:1999: Understanding Relational Language Components; Morgan Kaufmann: San Francisco, CA, 2001.
Google Scholar
5 D., Tsichritzis; A., Klug The ANSI/X3/SPARC DBMS Framework; AFIPS Press: Arlington, VA, 1978.
10.1016/0306-4379(78)90001-7
Google Scholar
6 C., Bachmann; S., Williams A General Purpose Programming System for Random Access Memories; Proc. of the Fall Joint Computer Conference; 1964.
Google Scholar
7 Data Description Language Journal of Development; Canadian Government Publishing Centre: Ottawa, Ontario, Canada, 1978.
Google Scholar
8 W., McGee The Information System Management System IMS/VS, Part I: General Structure and Operation. IBM Syst. J. 1977, 16 (2).
10.1147/sj.162.0084
Google Scholar
9 D., Chamberlin, et al., A History and Evaluation of System R. Commun. ACM 1981, 24 (10).
10.1145/358769.358784
Web of Science® Google Scholar
10 M., Stonebraker The Ingres Papers; Addison-Wesley: Reading, MA, 1986.
Google Scholar
11 J. M., Smith; D. C., Smith Database Abstractions: Aggregation and Generalization. ACM Trans. Database Syst. 1977, 2 (2), pp 105–133.
10.1145/320544.320546
Google Scholar
12 M., Hammer; D., McLeod Database Description with SDM: A Semantic Data Model. ACM Trans. Database Syst. 1980, 6 (3).
Web of Science® Google Scholar
13 S., Abiteboul; R., Hull IFO: A Formal Semantic Database Model. ACM Trans. Database Syst. 1987, 12 (4), pp 525–565.
10.1145/32204.32205
Web of Science® Google Scholar
14 S., Su A Semantic Association Model for Corporate and Scientific-Statistical Databases. Inform. Sci. 1983, 29.
10.1016/0020-0255(83)90015-4
Web of Science® Google Scholar
15 M. L., Brodie; D., Ridjanovic On the Design and Specification of Database Transactions. In On Conceptual Modeling; Springer-Verlag: New York, 1984.
10.1007/978-1-4612-5196-5
Google Scholar
16 J. R., Abrial Data semantics. In Data Base Management; North Holland: Amsterdam, 1974; pp 1–59.
Google Scholar
17 R., Hull; R., King Semantic Database Modelling: Survey, Applications, and Research Issues. ACM Comput. Surv. 1987, 19 (2), pp 201–260.
10.1145/45072.45073
Web of Science® Google Scholar
18 J., Peckham; F., Maryanski Semantic Data Models. ACM Comput. Surv. 1988, 20 (3).
10.1145/62061.62062
Web of Science® Google Scholar
19 P., Scheuermann; G., Schiffner; H., Weber Abstraction Capabilities and Invariant Properties Modeling with the Entity-Relationship Approach; Proc. of the Entity-Relationship Conference; 1979.
Google Scholar
20 C., Dos Santos; E., Neuhold; A., Furtado A Data Type Approach to the Entity-Relationship Model; Proc. of the Entity-Relationship Conference; 1979.
Google Scholar
21 T., Teorey; D., Yang; J., Fry A Logical Design Methodology for Relational Databases using the Extended Entity-Relationship Model. ACM Comput. Surv. 1986, 18 (2).
10.1145/7474.7475
Web of Science® Google Scholar
22 M., Gogolla; U., Hohenstein Towards a Semantic View of an Extended Entity-Relationship Model. Trans. Database Syst. 1991, 16 (3).
10.1145/111197.111200
Web of Science® Google Scholar
23 R., Elmasri; J., Weeldreyer; A., Hevner The Category Concept: An Extension to the Entity-Relationship Model. Int. J. Data Knowl. Eng. 1985, 1 (1).
Google Scholar
24 H., Sibley; L., Kerschberg Data Architecture and Data Model Considerations; Proc. of the National Computer Conference. 785–96, 1977.
Google Scholar
25 D., Shipman The Functional Data Model and the Data Language DAPLEX. ACM Trans. Database Syst. 1981, 6 (1), pp 140–173.
10.1145/319540.319561
Web of Science® Google Scholar
26 L., Fegaras; D., Maier Towards an Effective Calculus for Object Query Languages; ACM SIGMOD Conference; 1995, 47–58.
Google Scholar
27 T., Leung, et al. The Aqua Data Model and Algebra; Proc. of the Fourth International Workshop on Database Programming Languages, 157–175, 1993.
Google Scholar
28 R., Cattell, et al. The Object Database Standard: ODMG 3.0; Morgan Kaufmann: San Francisco, CA, 2000.
Google Scholar
29 M., Stonebraker, et al. Third-Generation Database System Manifesto. ACM SIGMOD Record 1990, 19 (3).
Google Scholar
30 M., Atkinson, et al. The Object-Oriented Database System Manifesto; First International Conference on Deductive and Object-Oriented Databases; Elsevier: New York, 1989.
Google Scholar
31 M., Stonebraker; L., Rowe The Design of Postgres; Proc. of the ACM SIGMOD Conference; 1986.
Google Scholar
32 M., Stonebraker; D., Moore Object Relational DBMSs: The Next Great Wave; Morgan Kaufmann: San Francisco, CA, 1995.
Web of Science® Google Scholar
33 J., Rumbaugh; I., Jacobson; G., Booch The Unified Modeling Language Reference Manual; Addison-Wesley: Reading, MA, 1999.
Google Scholar
34 Object Management Group, Home Web Site, 2007 http://www.omg.org.
Google Scholar
35 S., Dietrich; S., Urban An Advanced Course in Database Systems: Beyond Relational Databases; Prentice Hall, Englewood Cliffs, NJ, 2005.
Google Scholar
36 B., Stroudstrup The C++ Programming Language, Second Edition; Addison-Wesley: Reading, MA, 1992.
Google Scholar
37 R. G. G., Cattell Object Data Management: Object-Oriented and Extended Relational Systems; Addison-Wesley: Menlo Park, CA, 1994.
Google Scholar
38 Extensible Markup Language (XML), 2007 http://www.w3.org/XML.
Google Scholar
39 XMLSchema, 2007 http://www/w3/org/XML/Schema.
Google Scholar
40 Resource Description Framework (RDF), 2007 http://www/w3/org/RDF.
Google Scholar
41 RDF Schema, 2007 http://www.w3.org/TR/rdf-schema.
Google Scholar
42 OWL Web Ontology Language, 2007 http://www.w3.org/TR/owl-features.
Google Scholar

Wiley Encyclopedia of Electrical and Electronics Engineering

Browse other articles of this reference work:

Database Models

Abstract

Bibliography

References

Information

About Wiley Online Library

Help & Support

Opportunities

Connect with Wiley

Database Models

Abstract

Bibliography

References

Related

Information