Cited By
View all- Maryanski FRoush C(1980)Definition of database transactions by the casual userProceedings of the May 19-22, 1980, national computer conference10.1145/1500518.1500563(293-300)Online publication date: 19-May-1980
A semantic approach in designing relational data bases
Pages 596 - 601
Abstract
This paper proposes a semantic approach to data base design in the relational approach. The analysis on entity types, associations and attributes presented may be applied to data base design in other approaches too. Entity types, associations, and attributes in an operational environment are recognized and their semantic properties are studied. The attributes are categorized into simple and repeating, and the associations are categorized into atomic and molecular. Based on the analysis, relation schemas are established for the data base. These relation schemas are mostly in fourth normal form. Further normalization and optimization guarantees that optimal fourth normal form relation schemas are to be obtained. In this paper, the concept of semantically irrelevant functional dependency is also proposed. If this concept is adopted, then we may have a more optimal data model, which is semantically sound, than the optimal fourth normal form data model.
References
[1]
ANSI/X3/SPARC Study Group on Data Base Management Systems, Interim Report, ACM SIGMOD FDT Vol. 7, No. 2, 1975.
[2]
Bernstein, P.A., J.R. Swenson, and D.C. Tsichritzis, "A Unified Approach to Functional Dependencies and Relations." Proc. 1975 ACM SIGMOD Int. Conf. on the Management of Data, pp. 237-245.
[3]
Chen, P.P.S., "The Entity-Relationship Model-Toward A Unified View of Data," ACM TODS Vol. 1, No. 1, March, 1976, pp. 9-36.
[4]
Codd, E.F., "Further Normalization of the Data Base Relational Model," Data Base Systems, Courant Computer Science Symphosia Series, Vol. 6, R. Rustin (ed.), Prentice-Hall, 1972, pp. 33-64.
[5]
Codd, E.F., "Relational Completeness of Data Base Sublanguages," Data Base Systems, Courant Computer Science Series, Vol. 6, R. Rustin (ed.) Prentice-Hall, 1972, pp. 65-98.
[6]
Date, C.J., An Introduction to Database Systems, 2nd ed., Addison Wesley, 1977.
[7]
Fagin, R., "Multivalued Dependencies and A New Normal Form for Relational Databases," ACM TODS vol. 2, No. 3 Sept. 1977.
[8]
Martin, J., Computer Data Base Organization, 2nd ed., Prentice-Hall, 1977.
[9]
Schmid, H.A. and J.E. Swenson, "On the Semantics of the Relational Data Model," Proc. 1975 ACM SIGMOD Int. Conf. on the Management of Data, pp. 211-223.
Index Terms
- A semantic approach in designing relational data bases
Recommendations
Ontology enrichment by discovering multi-relational association rules from ontological knowledge bases
SAC '16: Proceedings of the 31st Annual ACM Symposium on Applied ComputingIn the Semantic Web context, OWL ontologies represent the conceptualization of domains of interest while the corresponding assertional knowledge is given by the heterogeneous Web resources referring to them. Being strongly decoupled, ontologies and ...
Semantic Interoperability Between Relational Database Systems
IDEAS '07: Proceedings of the 11th International Database Engineering and Applications SymposiumRelational DataBase Systems (RDBSs) are well-known and widely used in many organizations, however, semantic conflicts between the participating RDBSs must be resolved before data can be exchanged between them. Semantic resolution between the RDBSs is ...
Comments
Information & Contributors
Information
Published In
January 1978
990 pages
Copyright © 1978 ACM.
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]
Publisher
Association for Computing Machinery
New York, NY, United States
Publication History
Published: 01 January 1978
Check for updates
Author Tags
Qualifiers
- Article
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- View Citations1Total Citations
- 339Total Downloads
- Downloads (Last 12 months)21
- Downloads (Last 6 weeks)2
Reflects downloads up to 10 Oct 2024
Other Metrics
Citations
Cited By
View all- Maryanski FRoush C(1980)Definition of database transactions by the casual userProceedings of the May 19-22, 1980, national computer conference10.1145/1500518.1500563(293-300)Online publication date: 19-May-1980
View Options
Get Access
Login options
Check if you have access through your login credentials or your institution to get full access on this article.
Sign in