From user requirements to conceptual design in data warehouse design a survey

Data Warehousing Design and Advanced Engineering Applications: Methods for Complex Construction

Volumn , Issue , 2009, Pages 1-16

  Golfarelli, Matteo ^a  

^a UNIVERSITY OF BOLOGNA   (Italy)

Author keywords

[No Author keywords available]

Indexed keywords

EID: 80054892147     PISSN: None     EISSN: None     Source Type: Book    
DOI: 10.4018/978-1-60566-756-0.ch001     Document Type: Chapter

References (45)

1. 2: A multidimensional conceptual model extending UML. Information Systems, 31(6), 541-567. doi:10.1016/j.is.2004.12.002
2. Agrawal, R., Gupta, A., & Sarawagi, S. (1997). Modeling multidimensional databases. In Proceedings of the International Conference on Data Engineering, Birmingham U.K. (pp. 232-243).
3. Basili, V. R., Caldiera, G., & Rombaci, H. D. (1994). The goal question metric approach. In Encyclopedia of software engineering (pp. 528-532). New York: John Wiley & Sons, Inc.
4. Boehnlein, M., & Ulbrich vom Ende, A. (2000). Business process oriented development of data warehouse structures. In Proceedings of Data Warehousing 2000. Heidelberg, Germany: Physica Verlag.
5. Bonifati, A., Cattaneo, F., Ceri, S., Fuggetta, A., & Paraboschi, S. (2001). Designing data marts for data warehouses. ACM Transactions on Software Engineering and Methodology, 10(4), 452-483. doi:10.1145/384189.384190
6. Bresciani, P., Giorgini, P., Giunchiglia, F., Mylopoulos, J., & Perini, A. (2004). Tropos: An agent-oriented software development methodology. Journal of Autonomous Agents and Multi--Agent Systems, 8(3), 203-236. doi:10.1023/B:AGNT.0000018806.20944.ef
7. Cabibbo, L., & Torlone, R. (1998). A logical approach to multidimensional databases. In Proceedings of the International Conference on Extending Database Technology, Valencia, Spain (pp. 183-197).
8. Chung, L., Nixon, B. A., Yu, E., & Mylopoulos, J. (1999). Non-functional requirements in software. Berlin, Germany: Springer.
9. Cohen, P., & Levesque, H. (1990). Intention is choice with commitment. Artificial Intelligence, 42(2-3), 213-261. doi:10.1016/0004-3702(90)90055-5
10. Cysneiros, L. M., & Sampaio do Prado Leite, J. C. (2004). Nonfunctional requirements: From elicitation to conceptual models. IEEE Transactions on Software Engineering, 30(5), 328-350. doi:10.1109/TSE.2004.10
11. Demarest, M. (1997). The politics of data warehousing. Retrieved August 2008, from http://www.noumenal.com/marc/dwpoly.html
12. Fernández-Medina, E.,Trujillo, J.,Villarroel, R., & Piattini, M. (2006). Access control and audit model for the multidimensional modeling of data warehouses. Decision Support Systems, 42(3), 1270-1289. doi:10.1016/j.dss.2005.10.008
13. Franconi, E., & Kamble, A. (2004). A data warehouse conceptual data model. In Proceedings of the International Conference on Statistical and Scientific Database Management, Santorini Island, Greece (pp. 435-436).
14. Giorgini, P., Rizzi, S., & Garzetti, M. (2008). GRAnD: A goal-oriented approach to requirement analysis in data warehouses. Decision Support Systems, 45(1), 4-21. doi:10.1016/j.dss.2006.12.001
15. nd ed.). Hershey, PA: IGI Global.
16. 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. doi:10.1142/S0218843098000118
17. th International Conference on Data Engineering (ICDE 2001), Heidelberg, Germany (pp. 7-9).
18. Golfarelli, M., & Rizzi, S. (2009). A survey on temporal data warehousing. [IJDWM]. International Journal of Data Warehousing and Mining, 5(1), 1-17.
19. Guo, Y., Tang, S., Tong, Y., & Yang, D. (2006). Triple-driven data modeling methodology in data warehousing: A case study. In Proceedings of the ACM International Workshop on Data Warehousing and OLAP (pp. 59-66).
20. Hüsemann, B., Lechtenbörger, J., & Vossen, G. (2000). Conceptual data warehouse design. In Proceedings of the International Workshop on Design and Management of Data Warehouses. Stockholm, Sweden (pp. 3-9).
21. Jensen, M., Holmgren, T., & Pedersen, T. (2004). Discovering multidimensional structure in relational data. In Proceedings of the International Conference on Data Warehousing and Knowledge Discovery, Zaragoza, Spain (pp. 138-148).
22. Kimbal, R., Reeves, L., Ross, M., & Thornthwaite, W. (1998). The data warehouse lifecycle toolkit. New York: John Wiley and Sons, Inc
23. Lechtenboerger, J., & Vossen, G. (2003). Multidimensional normal forms for data warehouse design. Information Systems, 28(5), 415-434. doi:10.1016/S0306-4379(02)00024-8
24. List, B., Bruckner, R., Machaczek, K., & Schiefer, J. (2002). A comparison of data warehouse development methodologies: Case study of the process warehouse. In Proceedings of the International Conference on Database and Expert Systems Applications (pp. 203-215).
25. Luján-Mora, S.,Trujillo, J., & Song, I. Y. (2006). A UML profile for multidimensional modeling in data warehouses. Data & Knowledge Engineering, 59(3), 725-769. doi:10.1016/j.datak.2005.11.004
26. Mazon, J. N., & Trujillo, J. (2008). An MDA approach for the development of data warehouses. Decision Support Systems, 45(1), 41-58. doi:10.1016/j.dss.2006.12.003
27. Mazon, J. N., Trujillo, J., & Lechtenboerger, J. (2007). Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms. Data & Knowledge Engineering, 63, 725-751. doi:10.1016/j.datak.2007.04.004
28. Mylopoulos, J., Chung, L., & Nixon, B. (1992). Representing and using non-functional requirements: A process-oriented approach. IEEE Transactions on Software Engineering, 18(6), 483-497. doi:10.1109/32.142871
29. Paim, F. R. S., & Castro, J. (2002). Enhancing data warehouse design with the NFR framework. In Proceedings of the Workshop em Engenharia de Requisitos, Valencia, Spain (pp. 40-57).
30. th IEEE International Conference on Requirements Engineering, Monterey Bay, CA, USA (pp. 75-84).
31. Pedersen, T. B., & Jensen, C. (1999). Multidimensional data modeling for complex data. In Proceedings of the International Conference on Data Engineering, Sydney, Australia (pp. 336-345).
32. Peralta, V., Illarze, A., & Ruggia, R. (2003). On the applicability of rules to automate data warehouse logical design. In Proceedings of the Decision Systems Engineering Workshop, Klagenfurt, Austria (pp. 317-328).
33. Sapia, C., Blaschka, M., Hofling, G., & Dinter, B. (1999). Extending the E/R model for the multidimensional paradigm (. LNCS, 1552, 105-116.
34. Sen, A., & Sinha, A. P. (2005). A comparison of data warehousing methodologies. Communications of the ACM, 48(3), 79-84. doi:10.1145/1047671.1047673
35. Soler, E., Stefanov, V., Mazon, J. N., Trujillo, J., Fernandez-Medina, E., & Piattini, M. (2008). Towards comprehensive requirement analysis for data warehouses: Considering security requirements. In Proceedings of the Third International Conference on Availability, Reliability and Security - ARES 2008, Barcelona, Spain (pp. 4-7).
36. Trujillo, J., Luján-Mora, S., & Medina, E. (2002). The gold model case tool: An environment for designing OLAP applications. In Proceedings of the International Conference on Enterprise Information Systems, Ciutad Real, Spain (pp. 699-707).
37. Tryfona, N., Busborg, F., & Borch Christiansen, J. G. (1999). starER: A conceptual model for data warehouse design. In Proceedings of the ACM International Workshop on Data Warehousing and OLAP, Kansas City, USA (pp. 3-8).
38. Tsois, A., Karayannidis, N., & Sellis, T. (2001). MAC: Conceptual data modeling for OLAP. In Proceedings of the International Workshop on Design and Management of Data Warehouses. Interlaken, Switzerland (pp. 5.1-5.11).
39. Vassiliadis, P., Bouzeghoub, M., & Quix, C. (1999). Towards quality-oriented data warehouse usage and evolution. In Proceedings of the International Conference on Advanced Information Systems Engineering, Heidelberg, Germany (pp. 149-163).
40. Winter, R., & Strauch, B. (2003). A method for demand-driven information requirements analysis in data warehousing. In Proceedings of the Hawaii International Conference on System Sciences, Hawaii (pp. 1359-1365).
41. Yu, E. (1993). Modeling organizations for information systems requirements engineering. In Proceedings of the First IEEE International Symposium on Requirements Engineering, San Jose, USA (pp. 34-41).
42. Yu, E. (1995). Modelling strategic relationships for process reengineering. Unpublished doctoral dissertation, Department of Computer Science, University of Toronto.
43. rd IEEE International Symposium on Requirements Engineering, Annapolis, USA.
44. Yu, E., & Mylopoulos, J. (1994). Understanding 'why' in software process modeling, analysis and design. In Proceedings of the Sixteenth International Conference on Software Engineering, Sorrento, Italy.
45. Yu, E., & Mylopoulos, J. (1996). Using goals, rules, and methods to support reasoning in business process reengineering. International Journal of Intelligent Systems in Accounting Finance & Management, 5(1), 1-13. doi:10.1002/(SICI)1099-1174(199603)5:1<1::AID-ISAF99>3.0.CO;2-C