A normal form for relational databases that is based on domains and keys
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
A relational model of data for large shared data banks
Communications of the ACM
Principles of Database and Knowledge-Base Systems: Volume II: The New Technologies
Principles of Database and Knowledge-Base Systems: Volume II: The New Technologies
Foundations of Databases: The Logical Level
Foundations of Databases: The Logical Level
Entity-Relationship Modeling: Foundations of Database Technology
Entity-Relationship Modeling: Foundations of Database Technology
| Hi-index | 0.00 |
MatBase is a Knowledge and Database Management System based on the Elementary Mathematical Data Model (EMDM). Its relational import subsystem provides users with the ability to incorporate databases from IBM DB/2, Oracle, or MS SQL Server and Access RDBMS. During import, besides copying table schemes and data, corresponding EMDM scheme and entity-relationship diagram (E-RD) are generated too and a design checking is also performed, including keys, references integrity, and existence constraints, as well as optional E-RD closed loops signalization. Checking is done according to MatBase higher relational standards: for example, every table should have an autonumber primary key, at least another (semantic) key and a not-null column, all keys should be minimally one-to-one, whereas all foreign keys should reference primary keys. Whenever this is possible, design flaws are automatically corrected; when not, they are only logged into MatBase system tables. The paper focuses on the two linear translation algorithms from the relational data model (RDM) to EMDM and ERDM that are reverse conceptual engineering tools reconstructing object-oriented mathematical semantics and visual structuring respectively from relational syntax. As an example, these algorithms are applied to a RDM domain-key normal form meta-catalog database.