Data Modeling

Research on ontology and conceptual data modeling builds on the premise that the world could be represented in terms of concepts (also known as “things”), their properties and their (things') relationships. A persistent effort in the representation is how to distinguish things from their properties, as well as how to denote relationships that relate two things together. Following the tradition of deriving guidelines from ontology studies, this paper proposes a need to make a clear distinction between relationships among things and relationships among things' properties. The central thrust of this paper is in proposing an ontologically guided principle: For the same relationship, working with the relationship among things will lead to better user performance than working with the relationship among things' properties. This principle, called Relationship without Pointers principle, is robustly validated by re-analyzing a set of experiment data on user data modeling performance with three database models. This principle may be applicable to other contexts that study relationships.