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
Specifying and Enforcing Association Semantics via ORN in the Presence of Association Cycles
IEEE Transactions on Knowledge and Data Engineering
Object Related Plus: A Practical Tool for Developing Enhanced Object Databases
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Synergistic Database Design with an Extended Entity-Relationship Model
Proceedings of the Eight International Conference on Enity-Relationship Approach to Database Design and Querying
Advanced SQL 1999: Understanding Object-Relational, and Other Advanced Features
Advanced SQL 1999: Understanding Object-Relational, and Other Advanced Features
Guest Editors' Introduction: Model-Driven Development
IEEE Software
A new UML-compatible object relationship notation (ORN)
ACM-SE 38 Proceedings of the 38th annual on Southeast regional conference
Specifying and Enforcing Association Semantics via ORN in the Presence of Association Cycles
IEEE Transactions on Knowledge and Data Engineering
Hi-index | 0.00 |
Diagrams widely used to model databases capture important semantics about the associations between objects. Additional association semantics can be captured when these diagrams are extended with Object Relationship Notation (ORN). Yet, the association semantics so easily expressed in database models are difficult to translate into SQL. This problem has existed for many years and was first addressed by this author in a paper written almost ten years ago. Since then, modeling diagrams, SQL, and ORN have evolved, but the problem remains. To solve it, we show here how enhanced association semantics modeled in a now standardardized diagram, the UML class diagram, can be easily mapped into the most recent standardized version of SQL, provided both are extended with the updated version of ORN.