Solving summarizability problems in fact-dimension relationships for multidimensional models

Subscribe (Full Service)


	Search: The ACM Digital Library The Guide

	Feedback
Take a look at the new version of this page: [ beta version ]. Tell us what you think.

Solving summarizability problems in fact-dimension relationships for multidimensional models

Full text

Pdf (302 KB)

Source

Data Warehousing and OLAP archive
Proceeding of the ACM 11th international workshop on Data warehousing and OLAP table of contents

Napa Valley, California, USA

SESSION: Multidimensional design and ETL table of contents

Pages: 57-64

Year of Publication: 2008

ISBN:978-1-60558-250-4

Authors

Jose-Norberto Mazón	University of Alicante, Alicante, Spain
Jens Lechtenbörger	University of Münster, Münster, Germany
Juan Trujillo	University of Alicante, Alicante, Spain

Sponsors

SIGWEB: ACM Special Interest Group on Hypertext, Hypermedia, and Web
SIGIR: ACM Special Interest Group on Information Retrieval
ACM: Association for Computing Machinery

Publisher

ACM New York, NY, USA

Bibliometrics

Downloads (6 Weeks): 17, Downloads (12 Months): 148, Citation Count: 0

Additional Information:

abstract references index terms collaborative colleagues

Tools and Actions:	Request Permissions Review this Article Save this Article to a Binder Display Formats: BibTeX EndNote ACM Ref

DOI Bookmark:	Use this link to bookmark this Article: http://doi.acm.org/10.1145/1458432.1458443 What is a DOI?

ABSTRACT

Multidimensional analysis allows decision makers to efficiently and effectively use data analysis tools, which mainly depend on multidimensional (MD) structures of a data warehouse such as facts and dimension hierarchies to explore the information and aggregate it at different levels of detail in an accurate way. A conceptual model of such MD structures serves as abstract basis of the subsequent implementation according to one specific technology. However, there is a semantic gap between a conceptual model and its implementation which complicates an adequate treatment of summarizability issues, which in turn may lead to erroneous results of data analysis tools and cause the failure of the whole data warehouse project. To bridge this gap for relationships between facts and dimension, we present an approach at the conceptual level for (i) identifying problematic situations in fact-dimension relationships, (ii) defining these relationships in a conceptual MD model, and (iii) applying a normalization process to transform this conceptual MD model into a summarizability-compliant model that avoids erroneous analysis of data. Furthermore, we also describe our Eclipsebased implementation of this normalization process.

REFERENCES

Note: OCR errors may be found in this Reference List extracted from the full text article. ACM has opted to expose the complete List rather than only correct and linked references.

	1	Jacky Akoka , Isabelle Comyn-Wattiau , Nicolas Prat, Dimension Hierarchies Design from UML Generalizations and Aggregations, Proceedings of the 20th International Conference on Conceptual Modeling: Conceptual Modeling, p.442-455, November 27-30, 2001
	2	Samira Si-Said Cherfi and Nicolas Prat. Multidimensional schemas quality: Assessing and balancing analyzability and simplicity. In ER (Workshops), pages 140--151, 2003.
	3	John Horner and Il-Yeol Song. A taxonomy of inaccurate summaries and their management in OLAP systems. In ER, pages 433--448, 2005.
	4	Carlos A. Hurtado , Claudio Gutierrez , Alberto O. Mendelzon, Capturing summarizability with integrity constraints in OLAP, ACM Transactions on Database Systems (TODS), v.30 n.3, p.854-886, September 2005 [doi>10.1145/1093382.1093388]
	5	R. Kimball and M. Ross. The Data Warehouse Toolkit. Wiley & Sons, 2002.
	6	Jens Lechtenbörger , Gottfried Vossen, Multidimensional normal forms for data warehouse design, Information Systems, v.28 n.5, p.415-434, July 2003 [doi>10.1016/S0306-4379(02)00024-8]
	7	Wolfgang Lehner , Jens Albrecht , Hartmut Wedekind, Normal Forms for Multidimensional Databases, Proceedings of the 10th International Conference on Scientific and Statistical Database Management, p.63-72, July 01-03, 1998 [doi>10.1109/SSDM.1998.688112]
	8	Hans-Joachim Lenz , Arie Shoshani, Summarizability in OLAP and Statistical Data Bases, Proceedings of the Ninth International Conference on Scientific and Statistical Database Management, p.132-143, August 11-13, 1997 [doi>10.1109/SSDM.1997.621175]
	9	Sergio Luján-Mora , Juan Trujillo , Il-Yeol Song, A UML profile for multidimensional modeling in data warehouses, Data & Knowledge Engineering, v.59 n.3, p.725-769, December 2006 [doi>10.1016/j.datak.2005.11.004]
	10	E. Malinowski , E. Zimányi, Hierarchies in a multidimensional model: from conceptual modeling to logical representation, Data & Knowledge Engineering, v.59 n.2, p.348-377, November 2006 [doi>10.1016/j.datak.2005.08.003]
	11	Svetlana Mansmann, Thomas Neumuth, and Marc H. Scholl. Multidimensional data modeling for business process analysis. In ER, pages 23--38, 2007.
	12	Svetlana Mansmann and Marc H. Scholl. Extending visual OLAP for handling irregular dimensional hierarchies. In DaWaK, pages 95--105, 2006.
	13	Jose-Norberto Mazón , Juan Trujillo, An MDA approach for the development of data warehouses, Decision Support Systems, v.45 n.1, p.41-58, April, 2008 [doi>10.1016/j.dss.2006.12.003]
	14	Jose-Norberto Mazón , Juan Trujillo , Jens Lechtenbörger, Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms, Data & Knowledge Engineering, v.63 n.3, p.725-751, December, 2007 [doi>10.1016/j.datak.2007.04.004]
	15	OMG. Unified Modeling Language Specification 2.0. http://www.omg.org/cgi-bin/doc?formal/05-07-04.
	16	OMG. MDA Guide 1.0.1. http://www.omg.org/cgi-bin/doc?omg/03-06-01
	17	OMG. MOF 2.0 Query/View/Transformation. http://www.omg.org/cgi-bin/doc?ptc/2005-11-0.
	18	Torben Bach Pedersen , Christian S. Jensen , Curtis E. Dyreson, Extending Practical Pre-Aggregation in On-Line Analytical Processing, Proceedings of the 25th International Conference on Very Large Data Bases, p.663-674, September 07-10, 1999
	19	Torben Bach Pedersen , Christian S. Jensen , Curtis E. Dyreson, A foundation for capturing and querying complex multidimensional data, Information Systems, v.26 n.5, p.383-423, July 2001 [doi>10.1016/S0306-4379(01)00023-0]
	20	Maurizio Rafanelli , Arie Shoshani, STORM: A Statistical Object Representation Model, Proceedings of the 5th International Conference SSDBM on Statistical and Scientific Database Management, p.14-29, April 03-05, 1990
	21	Stefano Rizzi , Alberto Abelló , Jens Lechtenbörger , Juan Trujillo, Research in data warehouse modeling and design: dead or alive?, Proceedings of the 9th ACM international workshop on Data warehousing and OLAP, November 10-10, 2006, Arlington, Virginia, USA [doi>10.1145/1183512.1183515]
	22	Il-Yeol Song, William Rowen, Carl Medsker, and Edward F. Ewen. An analysis of many-to-many relationships between fact and dimension tables in dimensional modeling. In DMDW, page 6, 2001.
	23	Liangjiang Wang , Aidong Zhang , Murali Ramanathan, BioStar models of clinical and genomic data for biomedical data warehouse design, International Journal of Bioinformatics Research and Applications, v.1 n.1, p.63-80, April 2005 [doi>10.1504/IJBRA.2005.006903]