A survey on summarizability issues in multidimensional modeling

Data and Knowledge Engineering

Volumn 68, Issue 12, 2009, Pages 1452-1469

  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 analysis; Data warehouse; Multidimensional modeling; Summarizability

Indexed keywords

DATA ANALYSIS; DATA ANALYSIS TOOL; HIGH LEVEL OF ABSTRACTION; LOGICAL REPRESENTATIONS; MULTI-DIMENSIONAL MODEL; MULTI-DIMENSIONAL MODELING; MULTI-DIMENSIONAL STRUCTURE; REAL WORLD SITUATIONS; SEMANTIC GAP;

DATA WAREHOUSES; DIELECTRIC WAVEGUIDES; SURVEYS; TERMINOLOGY;

DATA HANDLING;

EID: 71749112553     PISSN: 0169023X     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.datak.2009.07.010     Document Type: Article

References (37)

1. 2: a multidimensional conceptual model extending UML. Inf. Syst. 31 6 (2006) 541-567
2. J. Akoka, I. Comyn-Wattiau, N. Prat, Dimension hierarchies design from UML generalizations and aggregations, in: ER, 2001.
3. Bodart F., Patel A., Sim M., and Weber R. Should optional properties be used in conceptual modelling? A theory and three empirical tests. Inf. Syst. Res. 12 4 (2001) 384-405
4. Burdick D., Deshpande P.M., Jayram T.S., Ramakrishnan R., and Vaithyanathan S. OLAP over uncertain and imprecise data. VLDB J. 16 1 (2007) 123-144
5. Golfarelli M., Maio D., and Rizzi S. The dimensional fact model: a conceptual model for data warehouses. Int. J. Cooper. Inf. Syst. 7 2-3 (1998) 215-247
6. T. Haselmann, J. Lechtenbörger, G. Vossen, Datawarehouse detective: schema design made easy, in: BTW, 2007.
7. J. Horner, I.-Y. Song, A taxonomy of inaccurate summaries and their management in OLAP systems, in: ER, 2005.
8. Hurtado C.A., Gutiérrez C., and Mendelzon A.O. Capturing summarizability with integrity constraints in OLAP. ACM Trans. Database Syst. 30 3 (2005) 854-886
9. B. Hüsemann, J. Lechtenbörger, G. Vossen, Conceptual data warehouse modeling, in: DMDW, 2000.
10. H.V. Jagadish, L.V.S. Lakshmanan, D. Srivastava, What can hierarchies do for data warehouses? in: VLDB, 1999.
11. Jarke M., Lenzerini M., Vassiliou Y., and Vassiliadis P. Fundamentals of Data Warehouses (2003), Springer
12. Jensen C.S., Kligys A., Pedersen T.B., and Timko I. Multidimensional data modeling for location-based services. VLDB J. 13 1 (2004) 1-21
13. Kimball R., and Ross M. The Data Warehouse Toolkit (2002), Wiley & Sons
14. Lammari N., Comyn-Wattiau I., and Akoka J. Extracting generalization hierarchies from relational databases: a reverse engineering approach. Data Knowl. Eng. 63 2 (2007) 568-589
15. J. Lechtenbörger, Data warehouse schema design, in: BTW, 2003.
16. Lechtenbörger J., and Vossen G. Multidimensional normal forms for data warehouse design. Inf. Syst. 28 5 (2003) 415-434
17. W. Lehner, J. Albrecht, H. Wedekind, Normal forms for multidimensional databases, in: SSDBM, 1998.
18. H.-J. Lenz, A. Shoshani, Summarizability in OLAP and statistical data bases, in: SSDBM, 1997.
19. Luján-Mora S., Trujillo J., and Song I.-Y. A UML profile for multidimensional modeling in data warehouses. Data Knowl. Eng. 59 3 (2006) 725-769
20. E. Malinowski, E. Zimányi, OLAP hierarchies: a conceptual perspective, in: CAiSE, 2004.
21. Malinowski E., and Zimányi E. Hierarchies in a multidimensional model: from conceptual modeling to logical representation. Data Knowl. Eng. 59 2 (2006) 348-377
22. S. Mansmann, M.H. Scholl, Extending visual OLAP for handling irregular dimensional hierarchies, in: DaWaK, 2006.
23. Mansmann S., and Scholl M.H. Empowering the OLAP technology to support complex dimension hierarchies. Int. J. Data Warehouse Min. 3 4 (2007) 31-50
24. J.-N. Mazón, J. Lechtenbörger, J. Trujillo, Solving summarizability problems in fact-dimension relationships for multidimensional models, in: DOLAP, 2008.
25. Mazón J.-N., and Trujillo J. An MDA approach for the development of data warehouses. Decis. Support Syst. 45 1 (2008) 41-58
26. Mazón J.-N., Trujillo J., and Lechtenbörger J. Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms. Data Knowl. Eng. 63 3 (2007) 725-751
27. D.L. Moody, M.A.R. Kortink, From enterprise models to dimensional models: a methodology for data warehouse and data mart design, in: DMDW, 2000.
28. T. Niemi, J. Nummenmaa, P. Thanisch, Logical multidimensional database design for ragged and unbalanced aggregation, in: DMDW, 2001.
29. Niemi T., Nummenmaa J., and Thanisch P. Normalising OLAP cubes for controlling sparsity. Data Knowl. Eng. 46 3 (2003) 317-343
30. T.B. Pedersen, C.S. Jensen, C.E. Dyreson, Extending practical pre-aggregation in on-line analytical processing, in: VLDB, 1999.
31. Pedersen T.B., Jensen C.S., and Dyreson C.E. A foundation for capturing and querying complex multidimensional data. Inf. Syst. 26 5 (2001) 383-423
32. Pérez J.M., Llavori R.B., Aramburu M.J., and Pedersen T.B. Integrating data warehouses with web data: a survey. IEEE Trans. Knowl. Data Eng. 20 7 (2008) 940-955
33. Prat N., Akoka J., and Comyn-Wattiau I. A UML-based data warehouse design method. Decis. Support Syst. 42 3 (2006) 1449-1473
34. M. Rafanelli, A. Shoshani, STORM: a statistical object representation model, in: SSDBM, 1990.
35. S. Rizzi, A. Abelló, J. Lechtenbörger, J. Trujillo, Research in data warehouse modeling and design: dead or alive? in: DOLAP, 2006.
36. Romero O., and Abelló A. A survey of multidimensional modeling methodologies. IJDWM 5 2 (2009) 1-23
37. I.-Y. Song, W. Rowen, C. Medsker, E.F. Ewen, An analysis of many-to-many relationships between fact and dimension tables in dimensional modeling, in: DMDW, 2001.