The DOI matches its Crossref record; 20 of the 20 references it cites were found in a registry or an index.
A logical design methodology for relational databases using the extended entity-relationship model
Open accessAbstract
A database design methodology is defined for the design of large relational databases. First, the data requirements are conceptualized using an extended entity-relationship model, with the extensions being additional semantics such as ternary relationships, optional relationships, and the generalization abstraction. The extended entity-relationship model is then decomposed according to a set of basic entity-relationship constructs, and these are transformed into candidate relations. A set of basic transformations has been developed for the three types of relations: entity relations, extended entity relations, and relationship relations. Candidate relations are further analyzed and modified to attain the highest degree of normalization desired. The methodology produces database designs that are not only accurate representations of reality, but flexible enough to accommodate future processing requirements. It also reduces the number of data dependencies that must be analyzed, using the extended ER model conceptualization, and maintains data integrity through normalization. This approach can be implemented manually or in a simple software package as long as a "good" solution is acceptable and absolute optimality is not required.
Overview
The claims and statistics of this paper haven’t been checked yet.
Run the check — free, no account needed. It reads the open-access text and checks the sources it cites.
Integrity signals
Registry
Cites
Statistics
Verification
Claims the paper makes
The claims and statistics of this paper haven’t been checked yet.
Run the check — free, no account needed. It reads the open-access text and checks the sources it cites.
Self-check
Percentages, sums and reported differences re-computed from the paper’s own numbers.
The self-check needs the paper’s full text.
Citations
Cites
The Entity Relationship Model — Toward a Unified View of Data
Chen, P. P.-S. (2002) · Software Pioneers · doi:10.1007/978-3-642-59412-0_18 · Cited by 5,751
A relational model of data for large shared data banks
Codd, E. F. (1970) · Communications of the ACM · doi:10.1145/362384.362685 · Cited by 5,547
A relational model of data for large shared data banks
Codd, E. F. (1983) · Communications of the ACM · doi:10.1145/357980.358007 · Cited by 4,796
The entity-relationship model—toward a unified view of data
Chen, P. P.-S. (1976) · ACM Transactions on Database Systems · doi:10.1145/320434.320440 · Cited by 4,708
Introduction to Database Systems
(2006) · Foundations of Database Design · doi:10.1201/9781420003345.ch1 · Cited by 3,521
Proceedings of the 27th International Conference on Very Large Data Bases
Apers, P. M. G., Atzeni, P., Ceri, S., Paraboschi, S., Ramamohanarao, K., & Snodgrass, R. T. (2001) · Cited by 845
Multivalued dependencies and a new normal form for relational databases
Fagin, R. (1977) · ACM Transactions on Database Systems · doi:10.1145/320557.320571 · Cited by 712
Proceedings of the 33rd international conference on Very large data bases
Klas, W., & Neuhold, E. J. (2007) · Very Large Data Bases · Cited by 509
Synthesizing third normal form relations from functional dependencies
Bernstein, P. A. (1976) · ACM Transactions on Database Systems · doi:10.1145/320493.320489 · Cited by 448
The category concept: An extension to the entity-relationship model
Elmasri, R., Weeldreyer, J., & Hevner, A. (1985) · Data & Knowledge Engineering · doi:10.1016/0169-023x(85)90027-8 · Cited by 265
Recent Investigations in Relational Data Base Systems.
Codd, E. F. (1974) · IFIP Congress · Cited by 257
Formal semantics for time in databases
Clifford, J., & Warren, D. S. (1983) · ACM Transactions on Database Systems · doi:10.1145/319983.319986 · Cited by 225
Beeri, C., Bernstein, P. A., & Goodman, N. (1989) · Readings in Artificial Intelligence and Databases · doi:10.1016/b978-0-934613-53-8.50035-2 · Cited by 215
Integrating User Views in Database Design
Navathe, Elmasri, & Larson (1986) · Computer · doi:10.1109/mc.1986.1663033 · Cited by 210
Strategic data-planning methodologies
Martin, J. (1982) · OpenGrey (Institut de l'Information Scientifique et Technique) · Cited by 197
Entity Relationship Approach to Information Modeling and Analysis
Chen, P. P.-S. (1981) · Cited by 129
On the design of relational database schemata
Zaniolo, C., & Meklanoff, M. A. (1981) · ACM Transactions on Database Systems · doi:10.1145/319540.319542 · Cited by 68
Date, C. J. (1984) · Medical Entomology and Zoology · Cited by 67
Hierarchical schemata for relational databases
Lien, Y. E. (1981) · ACM Transactions on Database Systems · doi:10.1145/319540.319546 · Cited by 46
Database design: composing fully normalized tables from a rigorous dependency diagram
Smith, H. C. (1985) · Communications of the ACM · doi:10.1145/4021.4024 · Cited by 38
Cited by
Federated database systems for managing distributed, heterogeneous, and autonomous databases
Sheth, A. P., & Larson, J. A. (1990) · ACM Computing Surveys · doi:10.1145/96602.96604 · Cited by 2,476
Query evaluation techniques for large databases
Graefe, G. (1993) · ACM Computing Surveys · doi:10.1145/152610.152611 · Cited by 1,262
Semantic database modeling: survey, applications, and research issues
Hull, R., & King, R. (1987) · ACM Computing Surveys · doi:10.1145/45072.45073 · Cited by 1,146
Research Commentary: Information Systems and Conceptual Modeling—A Research Agenda
Wand, Y., & Weber, R. (2002) · Information Systems Research · doi:10.1287/isre.13.4.363.69 · Cited by 755
On the ontological expressiveness of information systems analysis and design grammars
Wand, Y., & Weber, R. (1993) · Information Systems Journal · doi:10.1111/j.1365-2575.1993.tb00127.x · Cited by 688
Metadata
- Authors
- Teorey, T. J., Yang, D., & Fry, J. P.
- Venue
- ACM Computing Surveys
- Published
- 1986-06
- Volume
- 18
- Issue
- 2
- Pages
- 197-222
- ISSN
- 0360-0300 (ISSN-L)
- 1557-7341
- OpenAlex
- W2113827629
- Cited by
- 752
- References
- 20
- FWCI
- 18.66
- Type
- journal article
- Language
- en
- Open access
- bronze
About these checks
Registry, retraction, Cites and statistics results are computed, not judged, with one exception: a printed reference that no index lists is read once by a model before it counts as a citation error. Claims are extracted by a model and kept only when their quote appears verbatim in the text; each cited source is then checked, with a model’s help, for whether it says what the claim relies on. Those verdicts can be wrong — read the claim’s quote and the cited source before relying on one.
Statistics and arithmetic are recomputed, not judged.
Confidence bands are shown only for fields calibrated on our annotated test set. None is calibrated yet, so no band is shown.
What counts as a claim ›How we measure confidence ›How we check this ›
Are you an author, or do you see a problem with this page? Request a review
Data sources
Bibliographic data: Semantic Scholar, OpenAlex, Crossref.
Contains information from the Semantic Scholar Academic Graph Datasets, made available under the ODC Attribution License (ODC-BY 1.0).
Semantic Scholar’s data is described in: Kinney, R., et al. (2023). The Semantic Scholar Open Data Platform. arXiv:2301.10140.