Automatic validation of requirements to support multidimensional design

Data and Knowledge Engineering

Volumn 69, Issue 9, 2010, Pages 917-942

  Romero, Oscar ^a   Abelló, Alberto ^a  

^a UNIVERSITAT POLITÈCNICA DE CATALUNYA   (Spain)

Author keywords

Data warehouse; Design by examples; Multidimensional design; OLAP; Requirements

Indexed keywords

AUTOMATIC VALIDATION; CONCEPTUAL SCHEMAS; DATA SOURCE; DATA-DRIVEN; DATA-DRIVEN METHODS; END USERS; HYBRID APPROACH; HYBRID METHOD; MULTI-DIMENSIONAL MODEL; MULTIDIMENSIONAL DESIGN; NOVEL METHODS; POTENTIAL ANALYSIS; REQUIREMENT-DRIVEN; SCHEMAS; VALIDATION PROCESS;

DATA WAREHOUSES;

DESIGN;

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

References (36)

1. TPC-H Version 2.8.0, http://www.tpc.org/tpch/default.asp, last access 30-09-2008.
2. 2 (Yet Another Multidimensional Model): an extension of UML Information Systems 31 6 2006 541 567
3. R. Agrawal, A. Gupta, and S. Sarawagi Modeling multidimensional databases Proc. of the 13th Int. Conf. on Data Engineering 1997 IEEE 232 243
4. O. Romero, A. Abelló, Multidimensional Design by Examples. In Proc. of 8th Int. Conf. on Data Warehousing and Knowledge Discovery, volume 4081 of LNCS, page 85-94. Springer, 2006.
5. O. Romero, A. Abelló, Automating Multidimensional Design from Ontologies. In Proc. of ACM 10th Int. Workshop on Data Warehousing and OLAP, page 1-8. ACM, 2007.
6. O. Romero, A. Abelló, On the Need of a Reference Algebra for OLAP. In Proc. of 9th Int. Conf. on Data Warehousing and Knowledge Discovery, volume 4654 of LNCS, page 99-110. Springer, 2007.
7. O. Romero, D. Calvanese, A. Abelló, M. Rodríguez-Muro, Discovering Functional Dependencies from Ontologies. In Proc. of ACM 12th Int. Workshop on Data Warehousing and OLAP (to appear), LNCS, page 1-8. Springer, 2009.
8. O. Romero, and A. Abelló A Survey of Multidimensional Modeling Methodologies International Journal of Data Warehousing and Mining (IJDWM) 5 2 2009 1 23
9. A. Bonifati, F. Cattaneo, S. Ceri, A. Fuggetta, and S. Paraboschi Designing data marts for data warehouses ACM Transactions on Software Engineering and Methodology 10 4 2001 452 483
10. A. Corral, Y. Manolopoulos, Y. Theodoridis, and M. Vassilakopoulos Closest pair queries in spatial databases Proceedings of the 2000 ACM SIGMOD International Conference on Management of Data 2000 ACM 189 200
11. J. Demetrovics, G.O. Katona, and D. Miklós Functional dependencies distorted by errors Discrete Applied Mathematics 156 6 2008 862 869
12. D. Dori, R. Feldman, and A. Sturm Transforming an operational system model to a data warehouse model: a survey of techniques IEEE Int. Conf. on Software - Science, Technology and Engineering (SwSTE 2005) 2005 IEEE Computer Society 47 56 (Pubitemid 43803512)
13. P. Giorgini, S. Rizzi, and M. Garzetti Goal-oriented requirement analysis for data warehouse design Proc. of 8th Int. Workshop on Data Warehousing and OLAP 2005 ACM Press 47 56
14. M. Golfarelli, D. Maio, and S. Rizzi The dimensional fact model: a conceptual model for data warehouses International Journal of Cooperative Information Systems 7 2-3 1998 215 247
15. J.-L. Hainaut, M. Chandelon, C. Tonneau, and M. Joris Contribution to a theory of database reverse engineering Proc. of the 1st Working Conf. on Reverse Engineering 1993 IEEE 161 170
16. B. Hüsemann, J. Lechtenbörger, and G. Vossen Conceptual data warehouse modeling Proc. of 2nd Int. Workshop on Design and Management of Data Warehouses 2000 CEUR-WS.org 6
17. M.R. Jensen, T. Holmgren, and T.B. Pedersen Discovering multidimensional structure in relational data 6th Int. Conf. on Data Warehousing and Knowledge Discovery LNCS vol. 3181 2004 Springer 138 148
18. R. Kimball, L. Reeves, W. Thornthwaite, and M. Ross The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses 1998 John Wiley & Sons, Inc.
19. J. Lechtenbörger, and G. Vossen Multidimensional normal forms for data warehouse design Information Systems 28 5 2003 415 434
20. W. Lehner, J. Albrecht, and H. Wedekind Normal forms for multidimensional databases Proc. of 10th Int. Conf. on Statistical and Scientific Database Management 1998 IEEE 63 72
21. H. Lenz, and A. Shoshani Summarizability in OLAP and statistical data bases Proc. of 9th Int. Conf. on Scientific and Statistical Database Management 1997 IEEE 132 143
22. H. Mannila, and K.-J. Räihä On the complexity of inferring functional dependencies Discrete Applied Mathematics 40 2 1992 237 243
23. J.-N. Mazón, and J. Trujillo An mda approach for the development of data warehouses Decision Support Systems 45 1 2008 41 58
24. J.-N. Mazon, J. Trujillo, and J. Lechtenborger Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms Data & Knowledge Engineering 23 3 2007 725 751
25. Microsoft. MDX Specification. http://msdn.microsoft.com/en-us/library/ aa216767.aspx. Last access: 8/08/2008.
26. D. Moody, and M. Kortink From enterprise models to dimensional models: a methodology for data warehouse and data mart design Proc. of 2nd Int. Workshop on Design and Management of Data Warehouses 2000 CEUR-WS.org
27. Patrick O'Neil, Elizabeth O'Neil and Xuedong Chen. The Star Schema Benchmark, http://www.cs.umb.edu/~poneil/StarSchemaB.PDF, last access 30-09-2008.
28. C. Phipps, and K.C. Davis Automating data warehouse conceptual schema design and evaluation Proc. of 4th Int. Workshop on Design and Management of Data Warehouses vol. 58 2002 CEUR-WS.org 23 32
29. N. Prakash, Y. Singh, and A. Gosain Informational scenarios for data warehouse requirements elicitation 23rd International Conference on Conceptual Modeling, ER 2004 Lecture Notes in Computer Science vol. 3288 2004 Springer 205 216
30. N. Prat, J. Akoka, and I. Comyn-Wattiau A UML-based data warehouse design method Decision Support Systems 42 3 2006 1449 1473
31. S. Rizzi, A. Abelló, J. Lechtenbörger, and J. Trujillo Research in data warehouse modeling and design: dead or alive? Proc. of ACM 9th International Workshop on Data Warehousing and OLAP 2006 ACM 3 10
32. J. Schiefer, B. List, and R.M. Bruckner A holistic approach for managing requirements of data warehouse systems 8th Americas Conference on Information Systems (AMCIS 2002) 2002 77 87
33. Y. Sismanis, P. Brown, P.J. Haas, and B. Reinwald Gordian: efficient and scalable discovery of composite keys Proc. of the 32nd Int. Conf. on Very Large Data Bases (VLDB 2006) 2006 ACM 691 702
34. I.-Y. Song, R. Khare, and B. Dai SAMSTAR: a semi-automated lexical method for generating STAR schemas from an ER diagram Proc. of the 10th Int Workshop on Data Warehousing and OLAP 2007 ACM 9 16
35. H.B.K. Tan, and Y. Zhao Automated elicitation of functional dependencies from source codes of database transactions Information & Software Technology 46 2 2004 109 117
36. R. Winter, and B. Strauch A method for demand-driven information requirements analysis in DW projects Proc. of 36th Annual Hawaii Int. Conf. on System Sciences 2003 IEEE 231 239