Atlantis Press Paper Details: An Object-Relational Data Warehouse Modelig for Complex Data

This paper proposed an object relational data warehouse modeling for complex data. This model can be viewed as an extension of relational star schema that incorporates the features of object-oriented data model. In this model, non-additive complex data such as video, audio, graphics and text can be shown in fact table of the star schema structure as the targets for analysis. In the fact table, an Object ID represents a complex object and each type of object is correspond to a specific processing/analyzing model, which can handle the complicated functions while necessary analysis are required. Many-to-many relationships between the fact table and some dimensions can be modeled as degenerated dimensions via complex objects and simple aggregation of whole-part relationships are modeled as in traditional relational tables. Generalization-specialization relationships are modeled with object oriented concepts to take the advantages of the characteristics in the inheritance of super-class to sub-class relationships. The data warehouse model is a general concept of preparing data for various analysis. The necessary data marts can be generated from this model according to user requirements.

		back to author index

title:		An Object-Relational Data Warehouse Modelig for Complex Data
publication:		JCIS-2006 Proceedings
part of series:		Advances in Intelligent Systems Research
ISBN:		978-90-78677-01-7
ISSN:		1951-6851
DOI:		doi:10.2991/jcis.2006.253 (how to use a DOI)
author(s):		Wen-Yang Lin, Chin-Ang Wu, Chuan-Chun Wu
corresponding author:		Chuan-Chun Wu
publication date:		October 2006
keywords:		data warehouse, object-reltiaonl, star schema, complex data
abstract:		This paper proposed an object relational data warehouse modeling for complex data. This model can be viewed as an extension of relational star schema that incorporates the features of object-oriented data model. In this model, non-additive complex data such as video, audio, graphics and text can be shown in fact table of the star schema structure as the targets for analysis. In the fact table, an Object ID represents a complex object and each type of object is correspond to a specific processing/analyzing model, which can handle the complicated functions while necessary analysis are required. Many-to-many relationships between the fact table and some dimensions can be modeled as degenerated dimensions via complex objects and simple aggregation of whole-part relationships are modeled as in traditional relational tables. Generalization-specialization relationships are modeled with object oriented concepts to take the advantages of the characteristics in the inheritance of super-class to sub-class relationships. The data warehouse model is a general concept of preparing data for various analysis. The necessary data marts can be generated from this model according to user requirements.
copyright:		© Atlantis Press. This article is distributed under the terms of the Creative Commons Attribution License, which permits non-commercial use, distribution and reproduction in any medium, provided the original work is properly cited.
full text:		JCIS06-CSI-97.pdf (185 K)