Abstract
Data warehousing involves complex processes that transform source data through several stages to deliver suitable information ready to be analysed. Though many techniques for visual modelling of data warehouses from the static point of view have been devised, only few attempts have been made to model the data flows involved in a data warehousing process. Besides, each attempt was mainly aimed at a specific application, such as ETL, OLAP, what-if analysis, data mining. Data flows are typically very complex in this domain; for this reason, we argue, designers would greatly benefit from a technique for uniformly modelling data warehousing flows for all applications. In this paper, we propose an integrated visual modelling technique for data cubes and data flows. This technique is based on UML profiling; its feasibility is evaluated by means of a prototype implementation.
Supported by the Spanish projects: ESPIA (TIN2007-67078), QUASIMODO (PAC08- 0157-0668), and DEMETER (GVPRE/2008/063). Jesús Pardillo is funded by MEC under FPU grant AP2006-00332. Special thanks to the anonymous reviewers for their helpful comments.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Favre, J.: Towards a Basic Theory to Model Model Driven Engineering. In: 3rd Workshop in Software Model Engineering, WiSME (2004)
Romero, O., Abelló, A.: A Survey of Multidimensional Modeling Methodologies. International Journal of Data Warehousing & Mining 5(2), 1–23 (2009)
OMG: Unified Modeling Language (UML) Superstructure, version 2.1.2. (November 2007), http://www.omg.org/technology/documents/formal/uml.htm
Moody, D.: What Makes a Good Diagram? Improving the Cognitive Effectiveness of Diagrams in IS Development. In: Adv. in Inform. Syst. Dev.; New Methods and Pract. for the Networked Soc., pp. 481–492 (2007)
Pirolli, P.: Information Foraging Theory: Adaptive Interaction with Information. Oxford University Press, USA (2007)
Luján-Mora, S., Trujillo, J., Song, I.Y.: A UML profile for multidimensional modeling in data warehouses. Data Knowl. Eng. 59(3), 725–769 (2006)
Object Management Group: Object Constraint Language (OCL), version 2.0. (October 2003), http://www.omg.org/technology/documents/formal/ocl.htm
Ware, C.: Information Visualization: Perception for Design, 2nd edn. Morgan Kaufmann, San Francisco (2004)
Tarr, P.L., Ossher, H., Harrison, W.H., Sutton Jr., S.M.: N Degrees of Separation: Multi-Dimensional Separation of Concerns. In: Proc. ICSE, pp. 107–119 (1999)
Romero, O., Abelló, A.: On the need of a reference algebra for OLAP. In: Song, I.-Y., Eder, J., Nguyen, T.M. (eds.) DaWaK 2007. LNCS, vol. 4654, pp. 99–110. Springer, Heidelberg (2007)
Trujillo, J., Luján-Mora, S., Song, I.-Y.: Applying UML For Designing Multidimensional Databases And OLAP Applications. In: Advanced Topics in Database Research, vol. 2, pp. 13–36 (2003)
Papastefanatos, G., Vassiliadis, P., Simitsis, A., Vassiliou, Y.: Design Metrics for Data Warehouse Evolution. In: Li, Q., Spaccapietra, S., Yu, E., Olivé, A. (eds.) ER 2008. LNCS, vol. 5231, pp. 440–454. Springer, Heidelberg (2008)
Cabibbo, L., Torlone, R.: From a Procedural to a Visual Query Language for OLAP. In: Proc. SSDBM, pp. 74–83 (1998)
Green, T.R.G., Petre, M.: Usability Analysis of Visual Programming Environments: A ‘Cognitive Dimensions’ Framework. J. Vis. Lang. Comput. 7(2), 131–174 (1996)
Mazón, J.-N., Trujillo, J.: An MDA approach for the development of data warehouses. Decis. Support Syst. 45(1), 41–58 (2008)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Pardillo, J., Golfarelli, M., Rizzi, S., Trujillo, J. (2009). Visual Modelling of Data Warehousing Flows with UML Profiles. In: Pedersen, T.B., Mohania, M.K., Tjoa, A.M. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2009. Lecture Notes in Computer Science, vol 5691. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-03730-6_4
Download citation
DOI: https://doi.org/10.1007/978-3-642-03730-6_4
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-03729-0
Online ISBN: 978-3-642-03730-6
eBook Packages: Computer ScienceComputer Science (R0)