The relational model with relation-valued attributes
Information Systems
Semantic database modeling: survey, applications, and research issues
ACM Computing Surveys (CSUR)
The structure of the relational database model
The structure of the relational database model
Identifying Extended Entity-Relationship Object Structures in Relational Schemas
IEEE Transactions on Software Engineering
Conceptual database design: an Entity-relationship approach
Conceptual database design: an Entity-relationship approach
World Wide Web Journal - Special issue on XML: principles, tools, and techniques
Spatio-temporal conceptual models: data structures + space + time
Proceedings of the 7th ACM international symposium on Advances in geographic information systems
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
Data on the Web: from relations to semistructured data and XML
Data on the Web: from relations to semistructured data and XML
Entity-Relationship Modeling: Foundations of Database Technology
Entity-Relationship Modeling: Foundations of Database Technology
Justification for Inclusion Dependency Normal Form
IEEE Transactions on Knowledge and Data Engineering
Bioinformatics Adventures in Database Research
ICDT '03 Proceedings of the 9th International Conference on Database Theory
Complex Objects Modeling: An Entity-Relationship-Approach
Papers from the Workshop ``Theory and Applications of Nested Relations and Complex Objects' on Nested Relations and Complex Objects
Fundamentals of Database Systems, Fourth Edition
Fundamentals of Database Systems, Fourth Edition
English sentence structures and EER modeling
APCCM '07 Proceedings of the fourth Asia-Pacific conference on Comceptual modelling - Volume 67
Geometrically Enhanced Conceptual Modelling
ER '09 Proceedings of the 28th International Conference on Conceptual Modeling
Intelligent author identification
ER'10 Proceedings of the 2010 international conference on Advances in conceptual modeling: applications and challenges
On better understanding OCL collections or an OCL ordered set is not an OCL set
MODELS'09 Proceedings of the 2009 international conference on Models in Software Engineering
Strengthening SAT-based validation of UML/OCL models by representing collections as relations
ECMFA'12 Proceedings of the 8th European conference on Modelling Foundations and Applications
| Hi-index | 0.00 |
Collections play an important part in everyday life. Therefore, conceptual data models should support collection types to make data modeling as natural as possible for its users. Based on the fundamental properties of endorsing order and multiplicity of its elements we introduce the collection types of rankings, lists, sets and bags into the framework of Entity-Relationship modeling. This provides users with easy-to-use constructors that naturally model different kinds of collections. Moreover, we propose a transformation of extended ER schemata into relational database schemata. The transformation is intuitive and invertable introducing surrogate attributes that preserve the semantics of the collection. Furthermore, it is a proper extension to previous transformations, and results in a relational database schema that is in Inclusion Dependency Normal Form. In addition, we introduce a uniqueness constraint that identifies collections uniquely and guarantees referential integrity at the same time.