Data Clustering for Effective Mapping of Object Models to Relational Models

Data Clustering for Effective Mapping of Object Models to Relational Models

Narasimha Bolloju, Kranti Toraskar
Copyright: © 1997 |Pages: 9
DOI: 10.4018/jdm.1997100102
OnDemand:
(Individual Articles)
Available
$37.50
Current Special Offers
No Current Special Offers
TOTAL SAVINGS: $37.50

Abstract

Today the object-oriented model is increasingly used during the analysis and design stages of information systems development, while relational database management systems (RDBMS) are still the most popular implementation tools. Consequently, in practice it is becoming increasingly common to map the object model to an appropriate relational model. This mapping often results in excessively fragmented tables, and denormalization is a commonly used approach for improving the system performance in such cases. However, denormalization affects the flexibility, integrity and data accessibility of implementation, while reducing correspondence between the implementation and the original object model. Based on a particular type of physical data organization, called data clustering, this paper presents an approach to avoid or minimize the need for denormalization. We first examine the use of denormalization and discuss the associated problems in the context of mapping object models to relational models. Next, we present the concept of data clustering and its effect on the performance and storage requirements. Finally, we describe and illustrate how data clustering can be employed to avoid denormalization and to achieve a greater degree of correspondence between an object model and its relational implementation. We also discuss the various trade-offs involved in the use of data clustering.

Complete Article List

Search this Journal:
Reset
Volume 35: 1 Issue (2024)
Volume 34: 3 Issues (2023)
Volume 33: 5 Issues (2022): 4 Released, 1 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