A Survey of Multidimensional Modeling Methodologies

International Journal of Data Warehousing and Mining (IJDWM)

Volumn 5, Issue 2, 2009, Pages 1-23

  Romero, Oscar ^a   Abelló, Alberto ^a  

^a UNIVERSITAT POLITÈCNICA DE CATALUNYA   (Spain)

Author keywords

Data Warehouse; Multidimensional Database Design; OLAP; Survey

Indexed keywords

EID: 85001655082     PISSN: 15483924     EISSN: 15483932     Source Type: Journal    
DOI: 10.4018/jdwm.2009040101     Document Type: Article

References (26)

1. Berners-Lee, T., Hendler, J., & Lassila, O. (2001). The Semantic Web. Scientific American.
2. Böhnlein, M., & Ulbrich-vom Ende, A. (1999). Deriving Initial Data Warehouse Structures from the Conceptual Data Models of the Underlying Operational Information Systems. In I. Song, T. J. Teorey (Eds.), Proceedings of 2nd International Workshop on Data Warehousing and OLAP; pp, 15–21. Kansas City, USA: ACM Press.
3. Bonifati, A., Cattaneo, F., Ceri, S., Fuggetta, A., & Paraboschi, S. (2001). Designing Data Marts for Data Warehouses. ACM Transactions Software Engineering and Methodology, 10(4):452–483.
4. Cabibbo L., & Torlone, R. (1998). A Logical Approach to Multidimensional Databases. In H. Schek, F. Saltor, I. Ramos, G. Alonso (Eds.), Proceedings of 6th International Conference on Extending Database Technology; Vol. 1377, Lecture Notes of Computer Science (pp, 183–197). Valencia, Spain: Springer.
5. Codd, E. F., Codd, S.B., & Salley, C.T. (1993). Providing OLAP (On Line Analytical Processing) to Users-Analysts: an IT Mandate. E. F. Codd and Associates.
6. Giorgini, P., Rizzi, S., Garzetti, M. (2005). Goal-oriented Requirement Analysis for Data Warehouse Design. In I. Song, J. Trujillo (Eds.), Proceedings of 8th International Workshop on Data Warehousing and OLAP; pp, 47–56. Bremen, Germany: ACM Press.
7. Golfarelli, M., Maio, D., & Rizzi, S. (1998a). The Dimensional Fact Model: A Conceptual Model for Data Warehouses. International Journal of Cooperative Information Systems, 7(2–3):215–247.
8. Golfarelli, M., Rizzi, S. (1998b). Methodological Framework for Data Warehouse Design. In In I. Song, T. J. Teorey (Eds.), Proceedings of 1st ACM International Workshop on Data Warehousing and OLAP; pp, 3–9. Bethesda, USA: ACM Press.
9. Google (Google, 2008). Google Scholar. Retrieved August, 8, 2008, from http://scholar.google.com/.
10. Hüsemann, B., Lechtenbörger, J., & Vossen, G. (2000). Conceptual Data Warehouse Modeling. In M. A. Jeusfeld, H. Shu, M. Staudt, G. Vossen (Eds.), Proceedings of 2nd International Workshop on Design and Management of Data Warehouses; pp 6. Stockholm, Sweden: CEUR-WS.org.
11. Jensen, M. R., Holmgren, T., & Pedersen, T. B. (2004). Discovering Multidimensional Structure in Relational Data. In Y. Kambayashi, M. K. Mohania, W. Wöβ (Eds.), Proceedings of 6th International Conference on Data Warehousing and Knowledge Discovery; Vol. 3181, Lecture Notes of Computer Science (pp 138–148). Zaragoza, Spain: Springer.
12. Kimball, R. (1996). The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. John Wiley & Sons, Inc.
13. Kimball, R., Reeves, L., Thornthwaite, W., & Ross, M. (1998). The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses. John Wiley & Sons, Inc.
14. Lehner, W., Albrecht, J., & Wedekind, H. (1998). Normal Forms for Multidimensional Databases. In M. Rafanelli, M. Jarke (Eds.), Proceedings of 10th International Conference on Statistical and Scientific Database Management; pp 63–72, Capri, Italy: IEEE.
15. List, B., Bruckner, R. M., Machaczek, K., & Schiefer, J. (2002). A Comparison of Data Warehouse Development Methodologies Case Study of the Process Warehouse. In A. Hameurlain, R. Cicchetti, R. Traunmüller (Eds.) Proceedings of 13th International Conference on Database and Expert Systems Applications; Vol. 2453, Lecture Notes in Computer Science (pp 203–215). Aix-en-Provence, France: Springer.
16. Mazón, J. N., Trujillo, J., & Lechtenborger, J. (2007). Reconciling Requirement-Driven Data Warehouses with Data Sources Via Multidimensional Normal Forms. Data & Knowledge Engineering, 23(3):725–751.
17. Microsoft (Microsoft, 2008). MDX Specification. Retrieved August, 8, 2008, from http://msdn.microsoft.com/en-us/library/aa216767.aspx.
18. Moody, D. L., & Kortink, M. A. (2000). From Enterprise Models to Dimensional Models: A Methodology for Data Warehouse and Data Mart Design. In M. A. Jeusfeld, H. Shu, M. Staudt, G. Vossen (Eds.), Proceedings of 2nd International Workshop on Design and Management of Data Warehouses; pp 6. Stockholm, Sweden: CEUR-WS.org.
19. Phipps, C., & Davis, K. C. (2002). Automating Data Warehouse Conceptual Schema Design and Evaluation. In L. V. S. Lakshmanan (Ed.), Proceedings of 4th International Workshop on Design and Management of Data Warehouses; pp 23–32, Toronto, Canada: CEUR-WS.org.
20. Prat, N., Akoka, J., & Comyn-Wattiau, I. (2006). A UML-based Data Warehouse Design Method. Decision Support Systems, 42(3):1449–1473.
21. Romero, O., & Abelló, A. (2006). Multidimensional Design by Examples. In A. M. Tjoa, J. Trujillo (Eds.), Proceedings of 8th International Conference on Data Warehousing and Knowledge Discovery; Vol. Lecture Notes of Computer Science (pp 85–94). Krakow, Poland: Springer.
22. Romero, O., & Abelló, A. (2007). Automating Multidimensional Design from Ontologies. In I. Song, T. B. Pedersen (Eds.), Proceedings of ACM 10th International Workshop on Data Warehousing and OLAP; pp 1–8, Lisbon, Portugal: ACM Press.
23. Romero, O., & Abelló, A. (in press). MDBE: Automatic Multidimensional Modeling. In Proceedings of 27rd Int. Conf. on Conceptual Modeling.
24. Song, I., Khare, R., & Dai, B. (2007). SAMSTAR: A Semi-Automated Lexical Method for Generating STAR Schemas from an ER Diagram In I. Song, T. B. Pedersen (Eds.), Proceedings of ACM 10th International Workshop on Data Warehousing and OLAP; pp 9–16, Lisbon, Portugal: ACM Press.
25. Vrdoljak, B., Banek, M., & Rizzi, S. (2003). Designing Web Warehouses from XML Schemas. In In Y. Kambayashi, M. K. Mohania, W. Wöβ (Eds.), Proceedings of 5th International Conference on Data Warehousing and Knowledge Discovery; Vol. 2737, Lecture Notes of Computer Science (pp 89–98). Prague, Czech Republic: Springer.
26. Winter, R., & Strauch, B. (2003). A Method for Demand-Driven Information Requirements Analysis in DW Projects. In Proceedings of 36th Annual Hawaii International Conference on System Sciences; pp 231–239. Hawaii, USA: IEEE.