Extending OCL for OLAP querying on conceptual multidimensional models of data warehouses

Information Sciences

Volumn 180, Issue 5, 2010, Pages 584-601

  Pardillo, Jesús ^a   Mazón, Jose Norberto ^a   Trujillo, Juan ^a  

^a UNIVERSITY OF ALICANTE   (Spain)

Author keywords

Conceptual modelling; Data warehouse; Multidimensional modelling; OLAP; Query language

Indexed keywords

CONCEPTUAL LEVELS; CONCEPTUAL MODELLING; DATA ANALYSIS; DATA WAREHOUSE STRUCTURE; DECISION MAKERS; MODEL DRIVEN ARCHITECTURES; MODEL-DRIVEN; MULTI-DIMENSIONAL MODEL; MULTIDIMENSIONAL MODELLING; OBJECT CONSTRAINT LANGUAGE; OLAP QUERIES; ON-LINE ANALYTICAL PROCESSING; OPTIMISATIONS; PRE-AGGREGATION; SAMPLE DATA; STRUCTURE DATA;

LINGUISTICS; QUERY LANGUAGES; SOFTWARE ARCHITECTURE;

DATA WAREHOUSES;

EID: 71849117048     PISSN: 00200255     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.ins.2009.11.006     Document Type: Article

References (42)

1. A. Abelló, J. Samos, F. Saltor, Implementing operations to navigate semantic star schemas, in: International Workshop on Data Warehousing and OLAP (DOLAP), 2003, pp. 56-62.
2. 2: a multidimensional conceptual model extending UML. Inf. Syst. 31 6 (2006) 541-567
3. F. Abreu, Using OCL to Formalize Object Oriented Metrics Definitions, INESC, Software Engineering Group ES007/2001, Version 0.9, May 2001.
4. J. Bézivin, Model driven engineering: an emerging technical space, in: Generative and Transformational Techniques in Software Engineering (GTTSE), 2006, pp. 36-64.
5. M. Blaschka, C. Sapia, G. Höfling, B. Dinter, Finding your way through multidimensional data models, in: International Conference on Database and Expert Systems Applications (DEXA) Workshop, 1998, pp. 198-203.
6. L. Cabibbo, R. Torlone, From a procedural to a visual query language for OLAP, in: International Conference on Scientific and Statistical Database Management (SSDBM), 1998, pp. 74-83.
7. Cabot J., and Teniente E. Incremental integrity checking of UML/OCL conceptual schemas. J. Syst. Software 82 9 (2009) 1459-1478
8. B. Demuth, H. Hußmann, Using UML/OCL constraints for relational database design, in: International Conference on UML, 1999, pp. 598-613.
9. D. Embley, D. Barry, S. Woodfield, Object-Oriented Systems Analysis, A Model-Driven Approach, Youdon Press Computing Series, 1992.
10. Evermann J., and Wand Y. Ontology based object-oriented domain modelling: fundamental concepts. Requir. Eng. 10 2 (2005) 146-160
11. Evermann J., and Wand Y. Ontology based object-oriented domain modeling: representing behavior. J. Database Manag. 20 1 (2009) 48-77
12. E. Fernández-Medina, M. Piattini, Extending OCL for secure database development, in: International Conference on UML, 2004, pp. 380-394.
13. Fuentes-Fernández L., and Vallecillo-Moreno A. An introduction to UML profiles. Eur. J. Inform. Prof. 5 2 (2004) 5-13
14. Gray J., Chaudhuri S., Bosworth A., Layman A., Reichart D., Venkatrao M., Pellow F., and Pirahesh H. Data cube: a relational aggregation operator generalizing group-by, cross-tab, and sub-totals. Data Min. Kowl. Disc. 1 1 (1997) 29-53
15. J. Horner, I.-Y. Song, P.P. Chen, An analysis of additivity in OLAP systems, in: International Workshop on Data Warehousing and OLAP (DOLAP), 2004, pp. 83-91.
16. Huang S.-M., Chou T.-H., and Seng J.-L. Data warehouse enhancement: a semantic cube model approach. Inform. Sci. 177 11 (2007) 2238-2254
17. Hung M.-C., Huang M.-L., Yang D.-L., and Hsueh N.-L. Efficient approaches for materialized views selection in a data warehouse. Inform. Sci. 177 6 (2007) 1333-1348
18. B. Hüsemann, J. Lechtenbörger, G. Vossen, Conceptual data warehouse modeling, in: International Workshop on Design and Management of Data Warehouses (DMDW), 2000, p. 6.
19. F. Jouault, I. Kurtev, On the architectural alignment of ATL and QVT, in: ACM Symposium on Applied Computing (SAC), 2006, pp. 1188-1195.
20. Kao K.-F., and Liao I.-E. An index selection method without repeated optimizer estimations. Inform. Sci. 179 13 (2009) 2263-2272
21. Kimball R., and Ross M. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (2002), Wiley
22. Liu Y.-C., Hsu P.-Y., Sheen G.-J., Ku S., and Chang K.-W. Simultaneous determination of view selection and update policy with stochastic query and response time constraints. Inform. Sci. 178 18 (2008) 3491-3509
23. 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
24. 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
25. L. Mandel, M.V. Cengarle, On the expressive power of OCL, in: World Congress on Formal Methods (FM), 1999, pp. 854-874.
26. A.S. Maniatis, P. Vassiliadis, S. Skiadopoulos, Y. Vassiliou, Advanced visualization for OLAP, in: International Workshop on Data Warehousing and OLAP (DOLAP), 2003, pp. 9-16.
27. J.-N. Mazón, J. Pardillo, J. Trujillo, A model-driven goal-oriented requirement engineering approach for data warehouses, in: International Conference on Conceptual Modelling (ER) Workshops, 2007, pp. 255-264.
28. Mazón J.-N., and Trujillo J. An MDA approach for the development of data warehouses. Decis. Support Syst. 45 1 (2008) 41-58
29. 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
30. Mazón J.-N., Lechtenbörger J., and Trujillo J. A survey on summarizability issues in multidimensional modeling. Data Knowl. Eng. 68 12 (2009) 1452-1469
31. Object Management Group, Specifications: Model Driven Architecture (MDA) v.1.0.1, Object Constraint Language (OCL) v2.0, Unified Modelling Language (UML) v.2.2b1, October 2009. .
32. J. Pardillo, J.-N. Mazón, J. Trujillo, Bridging the semantic gap in OLAP models: platform-independent queries, in: International Workshop on Data Warehousing and OLAP (DOLAP), 2008, pp. 89-96.
33. J. Pardillo, J.-N. Mazón, J. Trujillo, Model-driven metadata for OLAP cubes from the conceptual modelling of data warehouses, in: International Conference on Data Warehousing and Knowledge Discovery (DaWaK), 2008, pp. 13-22.
34. J. Pardillo, J. Trujillo, Integrated model-driven development of goal-oriented data warehouses and data marts, in: International Conference on Conceptual Modelling (ER), 2008, pp. 426-439.
35. T.B. Pedersen, C.S. Jensen, C.E. Dyreson, Extending practical pre-aggregation in on-line analytical processing, in: International Conference on Very Large Data Bases (VLDB), 1999, pp. 663-674.
36. Prat N., Akoka J., and Comyn-Wattiau I. A UML-based data warehouse design method. Decis. Support Syst. 42 3 (2006) 1449-1473
37. F. Ravat, O. Teste, R. Tournier, G. Zurfluh. Graphical querying of multidimensional databases, in: East-European Conference on Advances in Databases and Information Systems (ADBIS), 2007, pp. 298-313.
38. S. Rizzi, A. Abelló, J. Lechtenbörger, J. Trujillo, Research in data warehouse modeling and design: dead or alive? in: International Workshop on Data Warehousing and OLAP (DOLAP), 2006, pp. 3-10.
39. O. Romero, A. Abelló, On the need of a reference algebra for OLAP, in: International Conference on Data Warehousing and Knowledge Discovery (DaWaK), 2007, pp. 99-110.
40. B. Shneiderman, The eyes have it: a task by data type taxonomy for information visualizations, in: IEEE Symposium on Visual Languages (VL), 1996, pp. 336-343.
41. Trujillo J., Palomar M., Gómez J., and Song I.-Y. Designing Data Warehouses with OO Conceptual Models. IEEE Comput. 34 12 (2001) 66-75
42. Zubcoff J., Pardillo J., and Trujillo J. A UML profile for the conceptual modelling of data-mining with time-series in data warehouses. Inf. Software Technol. 51 6 (2009) 977-992