A framework for multidimensional design of data warehouses from ontologies

Data and Knowledge Engineering

Volumn 69, Issue 11, 2010, Pages 1138-1157

  Romero, Oscar ^a   Abelló, Alberto ^a  

^a UNIVERSITAT POLITÈCNICA DE CATALUNYA   (Spain)

Author keywords

Multidimensional design; OLAP; Ontologies

Indexed keywords

ANALYSIS CAPABILITIES; CONCEPTUAL SCHEMAS; DATA SOURCE; DATA WAREHOUSING; DESIGN METHOD; DESIGN TASKS; END USERS; MULTIDIMENSIONAL DESIGN; OLAP; REQUIREMENTS ELICITATION; USER-CENTERED APPROACH; WAREHOUSE DESIGN;

ARCHITECTURAL DESIGN; DATA HANDLING; ONTOLOGY; REENGINEERING; REQUIREMENTS ENGINEERING;

DATA WAREHOUSES;

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

References (47)

1. 2 (Yet Another Multidimensional Model): an extension of UML Inf. Syst. 31 6 2006 541 567
2. R. Agrawal, A. Gupta, and S. Sarawagi Modeling multidimensional databases Proc. of the 13th Int. Conf. on Data Engineering 1997 IEEE 232 243
3. A. Artale, D. Calvanese, R. Kontchakov, V. Ryzhikov, and M. Zakharyaschev Reasoning over extended ER models Proc. of 26th Int. Conf. on Conceptual Modeling, volume 4801 of Lecture Notes in Computer Science 2007 Springer 277 292
4. F. Baader, D. Calvanese, D.L. McGuinness, D. Nardi, P.F. Patel-Schneider, The Description Logic Handbook: Theory, Implementation, and Applications 2003 Cambridge University Press
5. G. Berardi, D. Calvanese, and D. Giacomo Reasoning on UML class diagrams Artif. Intell. 168 1-2 2005 70 118
6. T. Berners-Lee, J. Hendler, and O. Lassila The semantic web Sci. Am. 284 5 2001
7. M. Böhnlein, and A.U. vom Ende Deriving initial data warehouse structures from the conceptual data models of the underlying operational information systems Proc. of 2nd Int. Workshop on Data Warehousing and OLAP 1999 ACM 15 21
8. A. Bonifati, F. Cattaneo, S. Ceri, A. Fuggetta, and S. Paraboschi Designing data marts for data warehouses ACM Trans. Softw. Eng. Method. 10 4 2001 452 483
9. A. Calì, D. Calvanese, G.D. Giacomo, and M. Lenzerini A formal framework for reasoning on UML class diagrams Proc. of 11th Int. Symposium on Foundations of Intelligent Systems, volume 2366 of LNCS 2002 Springer 503 513
10. P.P.-S.S. Chen The entity-relationship model: toward a unified view of data ACM Trans. Database Syst. 1 1 1976 9 36
11. J. Demetrovics, G. Katona, and D. Miklós Functional dependencies distorted by errors Discrete Appl. Math. 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. L. Frías, A. Queralt, and A. Olivé EU-Rent Car Rentals Specification. Technical report 2003 Departament de Llenguatges i Sistemes Inform'atics
14. D. Gaševic, D. Djuric, and V. Devedžic MDA-based automatic OWL ontology development Int. J. Software Tools Technol. Transfer 9 2 2007 103 117
15. 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
16. M. Golfarelli, D. Maio, and S. Rizzi The dimensional fact model: a conceptual model for data warehouses Int. J. Coop. Inf. Syst. 7 2-3 1998 215 247
17. M. Golfarelli, and S. Rizzi Data Warehouse Design. Modern Principles and Methodologies 2009 McGraw-Hill
18. O. Group. Unified Modeling Language (UML), Version 2.1.2. http://www.omg.org/technology/documents/formal/uml.htm.
19. J. 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
20. I. Horrocks Using an expressive description logic: fact or fiction? Proc. of 6th Conf. on Principles of Knowledge Representation and Reasoning 1998 Morgan Kaufmann 636 649
21. 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
22. M.R. Jensen, T. Holmgren, and T.B. Pedersen Discovering multidimensional structure in relational data 6th Int. Conf. on Data Warehousing and Knowledge Discovery, volume 3181 of LNCS 2004 Springer 138 148
23. 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.
24. 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
25. M. Lenzerini Data integration: a theoretical perspective Proc. of 21th ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems 2002 ACM 233 246
26. H. Mannila, and K. Räihä On the complexity of inferring functional dependencies Discrete Appl. Math. 40 2 1992 237 243
27. J.-N. Mazón, J. Lechtenbörger, and J. Trujillo A survey on summarizability issues in multidimensional modeling Data Knowl. Eng. 68 12 2009 1452 1469
28. J.-N. Mazón, J. Trujillo, and J. Lechtenbörger Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms Data Knowl. Eng. 23 3 2007 725 751
29. 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
30. A. Olivé On the role of conceptual schemas in information systems development Proc. of 9th Int. Conf. on Reliable Software Technologies (Ada-Europe 2004), volume 3063 of Lecture Notes in Computer Science 2004 Springer 16 34 (Pubitemid 38846669)
31. 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 volume 58 2002 CEUR-WS.org 23 32
32. A. Poggi, D. Lembo, D. Calvanese, G.D. Giacomo, M. Lenzerini, and R. Rosati Linking data to ontologies J. Data Semant. 10 2008 133 173
33. N. Prakash, Y. Singh, and A. Gosain Informational scenarios for data warehouse requirements elicitation 23rd International Conference on Conceptual Modeling, ER 2004, volume 3288 of Lecture Notes in Computer Science 2004 Springer 205 216
34. N. Prat, J. Akoka, and I. Comyn-Wattiau A UML-based data warehouse design method Decis. Support Syst. 42 3 2006 1449 1473
35. I. Reinhartz-Berger Towards automatization of domain modeling Data Knowl. Eng. 69 5 2010 491 515
36. 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
37. O. Romero, and A. Abelló Automating multidimensional design from ontologies Proc. of ACM 10th Int. Workshop on Data Warehousing and OLAP 2007 ACM 1 8
38. O. Romero, and A. Abelló A survey of multidimensional modeling methodologies Int. J. Data Warehouse Min. (IJDWM) 5 2 2009 1 23
39. O. Romero, and A. Abelló Automatic Validation of Requirements to Support Multidimensional Design Data & Knowledge Engineering 69 2010 917 942
40. O. Romero, D. Calvanese, A. Abelló, and M. Rodriguez-Muro Discovering functional dependencies for multidimensional design Proc. of ACM 12th Int. Conf. on Data Warehousing and OLAP 2009 ACM 1 8
41. 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
42. 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
43. D. Skoutas, and A. Simitsis Ontology-based conceptual design of ETL processes for both structured and semi-structured data IJSWIS 2007 1 24
44. 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
45. H.B.K.T., and Y. Zhao Automated elicitation of functional dependencies from source codes of database transactions Inf. Softw. Technol. 46 2 2004 109 117
46. W3C. OWL Web Ontology Language Overview. http://www.w3.org/TR/owl- features/.
47. 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