A Meta-Analysis Comparing Relational and Semantic Models

A Meta-Analysis Comparing Relational and Semantic Models

Keng Siau (Missouri University of Science and Technology, USA), Fiona F.H. Nah (University of Nebraska – Lincoln, USA) and Qing Cao (Texas Tech University, USA)
Copyright: © 2011 |Pages: 16
DOI: 10.4018/jdm.2011100103
OnDemand PDF Download:
No Current Special Offers


Data modeling is the sine quo non of systems development and one of the most widely researched topics in the database literature. In the past three decades, semantic data modeling has emerged as an alternative to traditional relational modeling. The majority of the research in data modeling suggests that the use of semantic data models leads to better performance; however, the findings are not conclusive and are sometimes inconsistent. The discrepancies that exist in the data modeling literature and the relatively low statistical power in the studies make meta-analysis a viable choice in analyzing and integrating the findings of these studies.
Article Preview

1. Introduction

Databases are used in every sector of the industry including business, health care, education, government, and libraries (Liao & Palvia, 2000; Firat et al., 2009; Aiken et al., 2011; Siau & Rossi, 2011). As databases continue to become ever more critical components of both large and small systems, the success of development projects will become increasingly dependent on the accuracy of the data models (Ramakrishnan & Gehrke, 2002; Siau et al., 2010). We have witnessed enormous growth in the number and importance of database applications in the last three decades. Aiken et al. (2011) stressed that the amount of data available these days and the value from information that organizations must derive from these data have made data modeling and database management a critical and vital issue for the competitiveness and survival of organizations. Data modeling techniques have continued to evolve since the first database management system was introduced in the 1960s (Watson, 2005). Subsequently, hierarchical and network database models were introduced in the 1970s. The relational data model and semantic data models, such as entity-relationship model (ER) and extended entity-relationship model (EER), have been widely used in practice since the early 1980s (Hoffer et al., 2010) and the trend continues even today.

Object oriented modeling became popular in the late 1990s and early 2000s. Studies on object oriented approaches (e.g., Siau & Cao, 2001; Siau & Loo, 2006; Taha & Elmasri, 2009; Gemino & Parker, 2009; VanderMeer & Dutta, 2009; Evermann & Wand, 2009; Siau & Tian, 2009; Shank et al., 2010; Siau, 2010; Tan et al., 2011) started to appear in academic publications in the 2000s. Despite the emergence of object oriented modeling techniques, relational and ER/EER models and their query languages continue to be important and widely studied (e.g., Sengupta & Ramesh, 2009; Niu et al., 2009; Sakr, 2009; Ayanso et al., 2009; Huh et al., 2010; An et al., 2010; Bera et al., 2010; Shlezinger et al., 2010). Further, relational database management systems are widely used and relational data model is still the dominant model in industry.

In the relational data model, a relation is a subset of the Cartesian product of an ordered list of domains (Codd, 1970). The power of the relational data model lies in its rigorous mathematical foundations and simple user-level paradigm. Semantic models use the concepts of entities or objects and relationships among them. Semantic models provide flexible structuring capabilities and allow data constraints to be specified explicitly. Object-oriented data models, dynamic data models, and active data models are the new trends in data modeling (Embley, 1998). Despite much research interest in semantic and object oriented data modeling, the relational database is still the predominant database used in the industry (Coronel et al., 2009), while ER modeling remains highly popular as a tool for conceptual data modeling (Post, 2004).

Complete Article List

Search this Journal:
Open Access Articles
Volume 33: 4 Issues (2022): 2 Released, 2 Forthcoming
Volume 32: 4 Issues (2021)
Volume 31: 4 Issues (2020)
Volume 30: 4 Issues (2019)
Volume 29: 4 Issues (2018)
Volume 28: 4 Issues (2017)
Volume 27: 4 Issues (2016)
Volume 26: 4 Issues (2015)
Volume 25: 4 Issues (2014)
Volume 24: 4 Issues (2013)
Volume 23: 4 Issues (2012)
Volume 22: 4 Issues (2011)
Volume 21: 4 Issues (2010)
Volume 20: 4 Issues (2009)
Volume 19: 4 Issues (2008)
Volume 18: 4 Issues (2007)
Volume 17: 4 Issues (2006)
Volume 16: 4 Issues (2005)
Volume 15: 4 Issues (2004)
Volume 14: 4 Issues (2003)
Volume 13: 4 Issues (2002)
Volume 12: 4 Issues (2001)
Volume 11: 4 Issues (2000)
Volume 10: 4 Issues (1999)
Volume 9: 4 Issues (1998)
Volume 8: 4 Issues (1997)
Volume 7: 4 Issues (1996)
Volume 6: 4 Issues (1995)
Volume 5: 4 Issues (1994)
Volume 4: 4 Issues (1993)
Volume 3: 4 Issues (1992)
Volume 2: 4 Issues (1991)
Volume 1: 2 Issues (1990)
View Complete Journal Contents Listing