Physical modeling of data warehouses using UML component and deployment diagrams: Design and implementation issues

Journal of Database Management

Volumn 17, Issue 2, 2006, Pages 12-42

  Luján Mora, Sergio ^a   Trujillo, Juan ^a,b  

^a UNIVERSITY OF ALICANTE   (Spain)

^b DOLAP   (Spain)

Author keywords

Component; Configuration; Data warehouse; Deployment; Implementation; Physical design; UML

Indexed keywords

COMPONENTS; DATABASE SYSTEMS; DECISION MAKING; DECISION THEORY; MATHEMATICAL MODELS; PRODUCT DESIGN; SERVERS;

CONFIGURATION; DEPLOYMENT; IMPLEMENTATION; PHYSICAL DESIGN; UNIFIED MODELING LANGUAGE (UML);

DATA WAREHOUSES;

EID: 33745619549     PISSN: 10638016     EISSN: 10638016     Source Type: Journal    
DOI: 10.4018/jdm.2006040102     Document Type: Article

References (32)

1. Abelló A., Samos J., & Saltor, F. (2001). A frame-work for the classification and description of multidimensional data models. In Proceedings of the 12th International Conference on Database and Expert Systems Applications (DEXA'01) (Vol. 2113, pp. 668-677), Munich, Germany. Springer-Verlag.
2. Abelló, A., Samos, J., & Saltor, F. (2002). YAM2 (Yet another multidimensional model): An extension of UML. In Proceedings of the International Database Engineering & Applications Symposium (IDEAS'02) (pp. 172-181), Edmonton, Canada. IEEE Computer Society.
3. Ambler, S. (2002). A UML profile for data modeling. Retrieved June 2003, from http://www.agiledata.org/essays/um1Data ModelingProfile.html
4. Blaschka, M., Sapia, C., Höfling, G., & Dinter, B. (1998). Finding your way through multidimensional data models. In Proceedings of the 9th International Conference on Data base and Expert Systems Applications (DEXA'98) (Vol. 1460, pp. 198-203), Vienna, Austria. Springer-Verlag.
5. Giovinazzo, W. (2000). Object-oriented data warehouse design. Building a star schema. Upper Saddle River, NJ: Prentice-Hall.
6. Golfarelli, M., Maio, D., & Rizzi, S. (1998). The dimensional fact model: A conceptual model for data warehouses. International Journal of Cooperative Information Systems, 7(2-3), 215-247.
7. Husemann, B., Lechtenbörger, J., & Vossen, G. (2000). Conceptual data warehouse modeling. In Proceedings of the 2nd International Workshop on Design and Management of Data Warehouses (DMDW'00) (pp. 6.1-6.11), Stockholm, Sweden.
8. Jacobson, I., Booch, G., & Rumbaugh, J. (1999). The unified software development process. Reading, MA: Addison-Wesley.
9. Jarke, M., Lenzerini, M., Vassiliou, Y., & Vassiliadis, P. (2003). Fundamentals of data warehouses (2nd ed.). Berlin: Springer-Verlag.
10. Kimball, R. (2002). The data warehouse toolkit (2nd ed.). New York: John Wiley & Sons.
11. Kimball, R., Reeves, L., Ross, M., & Thornthwaite, W. (1998). The data warehouse lifecycle toolkit. New York: John Wiley & Sons.
12. Luján-Mora, S., & Trujillo, J. (2003). A comprehensive method for data warehouse design. In Proceedings of the 5th International Workshop on Design and Management of Data Warehouses (DMDW'03) (pp. 1.1-1.14), Berlin, Germany.
13. Luján-Mora, S., & Trujillo, J. (2004a). A data warehouse engineering process. In Proceedings of the 3rd Biennial International Conference on Advances in Information Systems (ADVIS'04) (Vol. 3261, pp. 14-23), Izmir, Turkey. Springer-Verlag.
14. Luján-Mora, S., & Trujillo, J. (2004b). Modeling the physical design of data warehouses from a UML specification, In Proceedings of the ACM Seventh International Workshop on Data Warehousing and OLAP (DOLAP 2004) (pp. 48-57), Washington, DC,
15. Luján-Mora, S., Trujillo, J., & Song, I. (2002a). Extending UML for multidimensional modeling. In Proceedings of the 5th International Conference on the Unified Modeling Language (UML'02) (Vol. 2460, pp. 290-304), Dresden, Germany. Springer-Verlag.
16. Luján-Mora, S., Trujillo, J., & Song, I. (2002b). Multidimensional modeling with UML package diagrams. In Proceedings of the 21st International Conference on Conceptual Modeling (ER'02) (Vol. 2503, pp. 199-213), Tampere, Finland. Springer-Verlag.
17. Luján-Mora, S., Vassiliadis, P., & Trujillo, J. (2004). Data mapping diagrams for data warehouse design with UML. In Proceedings of the 23rd International Conference on Conceptual Modeling (ER'04) (pp. 191-204), Shanghai, China.
18. Naiburg, E., & Maksimchuk, R. (2001). UML for database design. Upper Saddle River, NJ: Addison-Wesiey.
19. Nicola, M., & Rizvi, H. (2003). Storage layout and I/O performance in data warehouses. In Proceedings of the 5th International Work-shop on Design and Management of Data Warehouses (DMDW'03) (pp. 7.1-7.9), Berlin, Germany.
20. Object Management Group (OMG). (2003). Unified modeling language specification 1.5. Retrieved January 2004, from http://www.omg.org/cgi-bin/doc? fonnal/03-03-01
21. Poe, V., Klauer, P., & Brobst, S. (1998). Building a data warehouse for decision support (2nd ed.). Upper Saddle River, NJ: Prentice-Hall.
22. Rizzi, S. (2003). Open problems in data warehousing: Eight years later. In Proceedings of the 5th International Workshop on Design and Management of Data Warehouses (DMDW'03), Berlin, Germany.
23. Sapia, C. (1999). On modeling and predicting query behavior in OLAP systems. In Proceedings of the 1st International Workshop on Design and Management of Data Ware houses (DMDW'99) (pp. 1-10), Heidelberg, Germany.
24. Sapia, C., Blaschka, M., Höfling, G., & Dinter, B. (1998). Extending the E/R model for the multidimensional paradigm. In Proceedings of the 1st International Workshop on Data Warehouse and Data Mining (DWDM'98) (Vol. 1552, pp. 105-116), Singapore. SpringerVerlag.
25. Selonen, P., Koskimies, K., & Sakkinen, M. (2003). Transformation between UML diagrams. Journal of Database Management, 14(3), 37-55.
26. Silverston, L., Inmon, W., & Graziano, K. (1997). The data model resource book: A library of logical data models and data warehouse designs. New York: John Wiley & Sons.
27. Triantafillakis, A., Kanellis, P., & Martakos, D. (2004). Data warehouse interoperability for the extended enterprise. Journal of Data-base Management, 15(3), 73-84.
28. Trujillo, J., & Luján-Mora, S. (2003). A UML based approach for modeling ETL processes in data warehouses. In Proceedings of the 22nd International Conference on Conceptual Modeling (ER'03) (Vol. 2813, pp. 307-320), Chicago, Illinois, USA. Springer-Verlag.
29. Trujillo, J., Palomar, M., Gómez, J., & Song, I. (2001). Designing data warehouses with OO conceptual models. IEEE Computer, Special Issue on Data Warehouses, 34(12), 66-75.
30. Tryfona, N., Busborg, F., & Christiansen, J. (1999). starER: A conceptual model for data warehouse design. In Proceedings of the ACM 2nd International Workshop on Data Warehousing and OLAP (DOLAP'99) (pp. 3-8), Kansas City, Missouri, USA. ACM.
31. Warmer, J., & Kleppe, A. (1998). The object constraint language: Precise modeling with UML. Reading, MA: Addison-Wesley.
32. Whittle, J. (2000). Formal approaches to systems analysis using UML: An overview. Journal of Database Management, 11(4), 4-13.