Database abstractions: aggregation
Communications of the ACM
Modeling relationships in object-relational databases
Data & Knowledge Engineering
Foundation for Future Database Systems: The Third Manifesto
Foundation for Future Database Systems: The Third Manifesto
Preserving Aggregation in an Object-Relational DBMS
ADVIS '02 Proceedings of the Second International Conference on Advances in Information Systems
Formalization of the Whole-Part Relationship in the Unified Modeling Language
IEEE Transactions on Software Engineering
Enriched Relationship Processing in Object-Relational Database Management Systems
CODAS '01 Proceedings of the Third International Symposium on Cooperative Database Systems for Advanced Applications
Implementation of Object-Oriented Association Relationships in Relational Databases
IDEAS '98 Proceedings of the 1998 International Symposium on Database Engineering & Applications
An Introduction to Database Systems
An Introduction to Database Systems
Re-engineering relational databases: the way forward
Proceedings of the 2011 International Conference on Intelligent Semantic Web-Services and Applications
| Hi-index | 0.00 |
Widely accepted view is that the relational data model is not powerful enough for preserving semantics of the aggregation and composition relationships (whole-part relationships in general) in a relational database. Data model that is specified in SQL:2003 standard and used by the Object-Relational Database Management Systems (ORDBMSs) is believed to have better qualities in this regard. The Third Manifesto provides thorough revision of the relational data model and can be considered to be the manifest about ORDBMSs. We present designs for implementing whole-part relationships in a database that is maintained by the system which takes all the principles of the Third Manifesto into account. We show that ORDBMSs that use SQL language don't have all necessary means for implementing these designs and therefore still need improvement. We also show that some of the problems are caused by the shortcomings of the SQL standard.