Solving summarizability problems in fact-dimension relationships for multidimensional models

DOLAP: Proceedings of the ACM International Workshop on Data Warehousing and OLAP

Volumn , Issue , 2008, Pages 57-64

  Mazón, Jose Norberto ^a   Lechtenbörger, Jens ^b   Trujillo, Juan ^a  

^a UNIVERSITY OF ALICANTE   (Spain)

^b UNIVERSITY OF MÜNSTER   (Germany)

Author keywords

Data warehouse; Multidimensional modeling; Summarizability

Indexed keywords

ABSTRACT BASIS; ANALYSIS OF DATA; COMPLIANT MODEL; CONCEPTUAL LEVELS; CONCEPTUAL MODEL; DATA ANALYSIS TOOL; DECISION MAKERS; DIMENSION HIERARCHIES; LEVELS OF DETAIL; MULTI-DIMENSIONAL MODEL; MULTIDIMENSIONAL ANALYSIS; MULTIDIMENSIONAL MODELING; NORMALIZATION PROCESS; SEMANTIC GAP; SUMMARIZABILITY;

KNOWLEDGE MANAGEMENT; QUALITY ASSURANCE;

DATA WAREHOUSES;

EID: 70349423940     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1458432.1458443     Document Type: Conference Paper

References (23)

1. Jacky Akoka, Isabelle Comyn-Wattiau, and Nicolas Prat. Dimension hierarchies design from UML generalizations and aggregations. In ER, pages 442-455, 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 Gutiérrez, and Alberto O. Mendelzon. Capturing summarizability with integrity constraints in OLAP. ACM Trans. Database Syst., 30(3):854-886, 2005.
5. R. Kimball and M. Ross. The Data Warehouse Toolkit. Wiley & Sons, 2002.
6. Jens Lechtenbörger and Gottfried Vossen. Multidimensional normal forms for data warehouse design. Inf. Syst., 28(5):415-434, 2003.
7. Wolfgang Lehner, Jens Albrecht, and Hartmut Wedekind. Normal forms for multidimensional databases. In SSDBM, pages 63-72, 1998.
8. Hans-Joachim Lenz and Arie Shoshani. Summarizability in OLAP and statistical data bases. In SSDBM, pages 132-143, 1997.
9. Sergio Luján-Mora, Juan Trujillo, and Il-Yeol Song. A UML profile for multidimensional modeling in data warehouses. Data Knowl. Eng., 59(3):725-769, 2006.
10. Elzbieta Malinowski and Esteban Zimányi. Hierarchies in a multidimensional model: From conceptual modeling to logical representation. Data Knowl. Eng., 59(2):348-377, 2006.
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 and Juan Trujillo. An MDA approach for the development of data warehouses. Decis. Support Syst., 45(1):41-58, 2008.
14. Jose-Norberto Mazón, Juan Trujillo, and Jens Lechtenbörger. Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms. Data Knowl. Eng., 63(3):725-751, 2007.
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-01
18. Torben Bach Pedersen, Christian S. Jensen, and Curtis E. Dyreson. Extending practical pre-aggregation in on-line analytical processing. In VLDB, pages 663-674, 1999.
19. Torben Bach Pedersen, Christian S. Jensen, and Curtis E. Dyreson. A foundation for capturing and querying complex multidimensional data. Inf. Syst., 26(5):383-423, 2001.
20. Maurizio Rafanelli and Arie Shoshani. STORM: A statistical object representation model. In SSDBM, pages 14-29, 1990.
21. Stefano Rizzi, Alberto Abelló, Jens Lechtenbörger, and Juan Trujillo. Research in data warehouse modeling and design: dead or alive? In DOLAP, pages 3-10, 2006.
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, and Murali Ramanathan. BioStar models of clinical and genomic data for biomedical data warehouse design. IJBRA, 1(1):63-80, 2005.