AN AUTOMATIC METHOD FOR THE DESIGN OF MULTIDIMENSIONAL SCHEMAS FROM OBJECT ORIENTED DATABASES

Yasser Hachaichi () and Jamel Feki ()
Additional contact information
Yasser Hachaichi: Multimedia, InfoRmation Systems and Advanced, Computing Laboratory, University of Sfax, Higher Institute of Business Administration, BP 1013, Sfax, 3018, Tunisia
Jamel Feki: Multimedia, InfoRmation Systems and Advanced, Computing Laboratory, University of Sfax, Faculty of Economics and Management, BP 1018, Sfax, 3018, Tunisia

International Journal of Information Technology & Decision Making (IJITDM), 2013, vol. 12, issue 06, 1223-1259

Abstract: A data warehouse (DW) is a large data repository system designed for decision-making purposes. Its design relies on a specific model called multidimensional. This multidimensional model supports analyses of huge volumes of data that trace the enterprise's activities over time. Several design methods were proposed to build multidimensional schemas from either the relational data model or the entity-relationship data model. Almost all proposals that treated the object-oriented data model assume the presence of the data source UML class-diagram. However, in practice, either such a diagram does not exist or is obsolete due to multiple changes/evolutions of the information system. Furthermore, these few proposals require an intense manual intervention of the designer, which requires a high expertise both in the DW domain and in the object database domain. To overcome these disadvantages, this work proposes an automatic DW schema design method starting from an object database (schema and its instances). This method applies a set of extraction rules to identify multidimensional concepts and to generate star schemas. It is defined for the standard ODMG model and, thus, can be adapted with slight changes for other object database models. In addition, its extraction rules have the merit of being independent of the domain semantics. Furthermore, they automatically generate schemas classified according to their analytical potential; this classification helps the DW designer in selecting the most relevant schemas among the generated ones. Finally, being automatic, our method is supported by a toolset that also prepares for the automatic generation of the Extract Transform and Load procedures used to load the DW.

Keywords: Multidimensional model; data warehouse; automatic design; object-oriented database (search for similar items in EconPapers)
Date: 2013
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (1)

Downloads: (external link)
http://www.worldscientific.com/doi/abs/10.1142/S0219622013500351
Access to full text is restricted to subscribers

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:wsi:ijitdm:v:12:y:2013:i:06:n:s0219622013500351

Ordering information: This journal article can be ordered from

DOI: 10.1142/S0219622013500351

Access Statistics for this article

International Journal of Information Technology & Decision Making (IJITDM) is currently edited by Yong Shi

More articles in International Journal of Information Technology & Decision Making (IJITDM) from World Scientific Publishing Co. Pte. Ltd.
Bibliographic data for series maintained by Tai Tone Lim ().