An introduction to database systems: vol. I (4th ed.)
An introduction to database systems: vol. I (4th ed.)
A formal approach to the definition and the design of conceptual schemata for databased systems
ACM Transactions on Database Systems (TODS)
The entity-relationship model—toward a unified view of data
ACM Transactions on Database Systems (TODS) - Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MA
Synthesizing third normal form relations from functional dependencies
ACM Transactions on Database Systems (TODS)
Multivalued dependencies and a new normal form for relational databases
ACM Transactions on Database Systems (TODS)
On the Equivalence of Database Models
Journal of the ACM (JACM)
Application Development without Programmers
Application Development without Programmers
Data Models
Design of relational views over network schemas
SIGMOD '79 Proceedings of the 1979 ACM SIGMOD international conference on Management of data
Comprehensive Approach to the Design of Relational Database Schemes
VLDB '84 Proceedings of the 10th International Conference on Very Large Data Bases
Equivalence and Mapping of Database Schemes
VLDB '84 Proceedings of the 10th International Conference on Very Large Data Bases
Semantics of Network Data Manipulation Languages: An Object-Oriented Approach
VLDB '82 Proceedings of the 8th International Conference on Very Large Data Bases
Heterogeneity in the Distributed Database Management System SIRIUS-DELTA
VLDB '82 Proceedings of the 8th International Conference on Very Large Data Bases
Using the Entity-Relationship Model for Implementing Multi-Model Database Systems
ER '81 Proceedings of the Second International Conference on the Entity-Relationship Approach to Information Modeling and Analysis
Converting A Relational Database Model into an Entity-Relationship Model
Proceedings of the Sixth International Conference on Entity-Relationship Approach
Abstracting Relational and Hierarchical Data with a Semantic Data Model
Proceedings of the Sixth International Conference on Entity-Relationship Approach
| Hi-index | 0.00 |
Traditionally, application databases have been developed for efficiency of computer operations. The logical structure of the data is buried in the database schemas, application programs, and users' and programmers' minds. To manage information as a corporate resource the logical data structures must be made explicit. In this way organizational databases can be conceptually integrated. The magnitude and complexity of corporate databases makes a manual approach to this task infeasible. We propose a computer aided approach. The approach is based on extracting implicit functional dependencies from existing database schemas and forming an Entity-Relationship representation. Where the semantics of the schema are unclear, rules are applied and additional input sought from the Data Administrator. Because of its widespread use in production systems, we focus on CODASYL Network DBMSs in this paper. The approach also has applications in databases from one DBMS to another.