Abstract
Data Warehouse (DWH) systems represent a single source of information for analyzing the status, the development and the results of an organization.
Today’s DWH systems provide many different services to different kinds of users. People involved in designing and managing DWH systems need to see the big picture of how the DWH is being used, to have an overview of the current situation, and to be able to visualize future scenarios. Currently, there is a lack of such general models in Data Warehousing.
We introduce the UML Profile for Modeling DWH Usage for modeling the different kinds of DWH usage on a conceptual level. It uses features of UML intended for the purpose of creating abstract, general models. The profile distinguishes four perspectives of usage, and allows to model details of the users. The UML Profile is applied to examples illustrating some of the application scenarios.
This research has been funded by the Austrian Federal Ministry for Education, Science, and Culture, and the European Social Fund (ESF) under grant 31.963/46-VII/9/2002.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Inmon, W.H., Hackathorn, R.D.: Using the data warehouse. Wiley-QED Publishing, Somerset, NJ, USA (1994)
Kimball, R., Reeves, L., Ross, M., Thornthwaite, W.: The Data Warehouse Lifecycle Toolkit. John Wiley & Sons, Inc., England (1998)
Object Management Group, Inc.: UML 2.0 Superstructure (2005), http://www.omg.org/cgi-bin/apps/doc?formal/05-07-04.pdf
Object Management Group, Inc.: Model Driven Architecture (MDA) (2004), http://www.omg.org/cgi-bin/doc?formal/03-06-01
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)
Vassiliadis, P., Sellis, T.K.: A Survey of Logical Models for OLAP Databases. SIGMOD Record 28(4), 64–69 (1999)
Abelló, A., Samos, J., Saltor, F.: YAM 2 (Yet Another Multidimensional Model): An Extension of UML. In: IDEAS 2002, pp. 172–181. IEEE Computer Society Press, Los Alamitos (2002)
Nguyen, T.B., Tjoa, A.M., Wagner, R.: An Object Oriented Multidimensional Data Model for OLAP. In: Lu, H., Zhou, A. (eds.) WAIM 2000. LNCS, vol. 1846, pp. 69–82. Springer, Heidelberg (2000)
Demarest, M.: The politics of data warehousing (1997), http://www.noumenal.com/marc/dwpoly.html
Ferández-Medina, E., Trujillo, J., Villarroel, R., Piattini, M.: Developing secure data warehouses with a uml extension. Inf. Syst. 32(6), 826–856 (2007)
Priebe, T., Pernul, G.: A pragmatic approach to conceptual modeling of olap security. In: Kunii, H.S., Jajodia, S., Sølvberg, A. (eds.) ER 2001. LNCS, vol. 2224, pp. 311–324. Springer, Heidelberg (2001)
Kirkgöze, R., Katic, N., Stolba, M., Tjoa, A.M.: A security concept for olap. In: DEXA 1997, Washington, DC, USA, p. 619. IEEE Computer Society, Los Alamitos (1997)
Wang, L., Jajodia, S., Wijesekera, D.: Securing olap data cubes against privacy breaches. In: IEEE Symposium on Security and Privacy, p. 161. IEEE Computer Society Press, Los Alamitos (2004)
Bruckner, R., List, B., Schiefer, J.: Developing requirements for data warehouse systems with use cases. In: Proceedings AMCIS 2001, pp. 329–335 (2001)
Mazón, J.N., Pardillo, J., Trujillo, J.C.: A model-driven goal-oriented requirement engineering approach for data warehouses. In: RIGiM Workshop, ER 2007 (2007)
Giorgini, P., Rizzi, S., Garzetti, M.: Goal-oriented requirement analysis for data warehouse design. In: Proceedings DOLAP 2005, pp. 47–56. ACM Press, New York (2005)
Mazón, J.N., Trujillo, J.C., Lechtenbörger, J.: Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms. Data Knowl. Eng. (2007) (doi:10.1016/j.datak.2007.04.004)
Mazón, J.N., Trujillo, J.C.: An mda approach for the development of data warehouses. Decision Support Systems (2006) (doi:10.1016/j.dss.2006.12.003)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2007 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Stefanov, V., List, B. (2007). A UML Profile for Modeling Data Warehouse Usage. In: Hainaut, JL., et al. Advances in Conceptual Modeling – Foundations and Applications. ER 2007. Lecture Notes in Computer Science, vol 4802. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-76292-8_16
Download citation
DOI: https://doi.org/10.1007/978-3-540-76292-8_16
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-76291-1
Online ISBN: 978-3-540-76292-8
eBook Packages: Computer ScienceComputer Science (R0)