Representing extended entity-relationship structures in relational databases: a modular approach
ACM Transactions on Database Systems (TODS)
On the design and maintenance of optimized relational representations of entity-relationship schemas
Data & Knowledge Engineering
A survey of database design transformations based on the Entity-Relationship model
Data & Knowledge Engineering
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
Entity-Relationship Modeling: Foundations of Database Technology
Entity-Relationship Modeling: Foundations of Database Technology
Relative information capacity of simple relational database schemata
PODS '84 Proceedings of the 3rd ACM SIGACT-SIGMOD symposium on Principles of database systems
Correct Schema Transformations
EDBT '96 Proceedings of the 5th International Conference on Extending Database Technology: Advances in Database Technology
The Use of Information Capacity in Schema Integration and Translation
VLDB '93 Proceedings of the 19th International Conference on Very Large Data Bases
Model-independent schema translation
The VLDB Journal — The International Journal on Very Large Data Bases
A pragmatic method for the integration of higher-order entity-relationship schemata
ER'00 Proceedings of the 19th international conference on Conceptual modeling
| Hi-index | 0.00 |
We analyze inter-model transformations of database schemas from a conceptual point of view. A central question for us is not just whether the information capacity of the transformed schema is sufficient, but rather its suitability for a given task. For this, we require criteria beyond the resulting degree of normalisation which we subsume under the term "conceptual justification". To illustrate our point, we take a closer look at a class of conceptual requirements that frequently cause practitioners to manually denormalise the logical schema: layered schemas, where the natural layering of the data clashes with the dominant access patterns and negatively impacts performance. We show how such requirements can directly influence the transformation process and give rise to conceptually justified logical schemas. We include an example which is based on the translation from the higher-order entity-relationship model to the relational model.