Abstract
Most of the requirements engineering (RE) approaches for data warehouse (DW) do not distinguish the early and late RE phase unlike recent RE approaches for transactional systems. They captured information requirement instead of decision requirement which is the main focus of this article. In this paper we present a novel RE approach for DW consisting of three phases namely; (i) early RE (ii) late RE, and (iii) conceptual design. The early RE phase captures ‘whys’ that underlies decision requirements and the late RE phase captures ‘what’ the DW system should do. The conceptual design evolves through the early and late requirements. All the models produced (early requirements model, late requirements model and multi dimensional conceptual model) are interlinked, thus, support traceability among each other. Finally, the proposed approach has been demonstrated by a case study of a typical Indian public sector bank and supported by a CASE tool.
This is a preview of subscription content, log in via an institution to check access.
Similar content being viewed by others
References
Boehnlein M, vom Ende U (2000) A business process oriented development of data warehouse structures. In: Proceedings of data warehousing, Physica Verlag, Heidelberg
Bonifati A, Cattaneo F, Ceri S, Fuggetta A, Paraboschi S (2001) Designing data marts for data warehouses. ACM Trans Softw Eng Methodol 10(4):452–483
Bresciani P, Giorgini P, Mylopoulos J, Perini A (2004) TROPOS: an agent oriented software development methodology. Auton Agent Multi-Agent Syst 8:203–236
Bulos D, (1999) Designing OLAP with ADAPT. Technical Reports, Atos Origin
Cabibbo L, Torlone R (1998) A logical approach to multidimensional databases. In: Proceedings of 6th international conference on extending database technology, LNCS, vol 1377. Springer, Heidelberg, pp 183–197
Donzelli P, Moulding M (2000) Developments in application domain modelling for the verification and validation of synthetic environments: a formal requirements engineering framework. In: Proceedings of the spring 99 simulation interoperability workshop, LNCS, Springer, Orlando.
Frendi M, Salinesi C (2003) Requirements engineering for data warehousing. In: Proceedings of REFSQ Workshop
Giorgini P, Rizzi S, Garzetti M (2007) GRAnD: a goal-oriented approach to requirement analysis in data warehouses. Decis Support Syst 45:4–21
Golfarelli M, Rizzi S (1999) Designing the data warehouse: key steps and crucial issues. J Comput Sci Inf Manag 2(3):88–100
Golfarelli M, Rizzi S, Saltarelli E (2002) WAND: a case tool for workload-based design of a data mart. In: Proceedings of SEBD, Italy, pp 422–426
Golfarelli M (2008) The DFM: a conceptual model for data warehouse. In: Wang John (ed) Encyclopedia of data warehousing and mining, 2nd edn. IGI Global, Hershey
Husemann B, Lechtenborger J, Vossen G (2000) Conceptual data warehouse design. In: Proceedings of the international workshop on design and management
Inmon WH (1996) Building the data warehouse. Wiley, New York
Jeusfield M, Quix C, Jarke M (1998) Design and analysis of quality information for data warehouses. In: Proceedings of 17th international conference on conceptual modeling
Kimball R, Ross M (2002) The data warehouse toolkit, 2nd edn. Wiley, Hoboken
Lehner W, Albrecht J, Wedekind H (1998) Normal forms for multidimensional databases. In: Proceedings of 8th international conference on statistical and scientific database management, IEEE Computer Society, Washington
Lujan-Mora S, Trujillo J, Song IY (2002) The gold model case tool: an environment for designing OLAP applications. In: Proceedings of ICEIS, pp 699–707
Mazon JN, Trujillo J, Serrano M, Piattini M (2005) Designing data warehouses: from business requirements analysis to multidimensional modeling. In: Proceedings of REBNITA’05, Paris
Mazon JN, Trujillo J (2006) An MDA approach for the development of data warehouses. Decis support Syst. doi:10.1016/j.dss.2006.12.003
Mazon JN, Pardillo J, Trujillo J (2007). A model-driven goal-oriented requirements engineering approach for data warehouses. In: Proceedings of ER workshop, LNCS, vol 4802. Springer, Heidelberg, pp 255–264
Paim FR, Castro JB (2003) DWARF: an approach for requirements definition and management of data warehouse systems. In: Proceeding of the 11th IEEE international requirements engineering conference, pp 1090–1099
Prakash N, Gosain A (2003) Requirements driven data warehouse development. In: Proceedings of CAiSE 03 short paper, pp 13–17
Prakash N, Gosain A (2008) An approach to engineering the requirements of data warehouses. Requirements Eng J 13(1):49
Prakash N, Prakash D, Gupta D (2010) Decision and decision requirements for data warehouse systems. In: Proceedings of CAiSE’ forum, lecture notes in business information processing, vol 72. Springer, Heidelberg, pp 92–107
Salinesi C, Gam I (2009) How specific requirements engineering be in the context of decisional information systems. In: Proceedings of third international conference on research challenges in information science, IEEE, New York city
Shiefer J, List B, Bruckne RM (2002) A holistic approach for managing requirements of data warehouse systems. In: Proceedings of 8th Americas conference on information systems, pp 77–87
Tryfona N, Busborg F and Christiansen J (1999) Star ER: a conceptual model for data warehouse design. In: Proceedings of 2nd international workshop on data warehousing and OLAP, ACM, New York city, pp 3–8
Vassiliadis P (2000) Gulliver in the land of data warehousing: practical experiences and observations of a researcher. In: Proceedings of 2nd international workshop on deign and management of data warehouses, pp 12.1–12.16
Winter R, Strauch B (2003) A method for demand–driven information requirements analysis in data warehousing projects. In: Proceedings of the 36th Hawaii international conference on system sciences
Winter R, Strauch B (2004) Information requirements engineering for data warehouse systems. In: Proceedings of ACM symposium on applied computing, Nicosia
Yu E (1995) Modeling strategic relationships for process reengineering. Ph.D. thesis, Department of Computer Science, University of Toronto, Toronto
Yu E (1997) Towards modeling and reasoning support for early-phase requirements engineering. In: Proceedings of IEEE international symposium on requirements engineering, pp 226–235
Yu E, Mylopoulos J (1994) Understanding why in requirements engineering-with an example. In: Proceedings of workshop on system requirements: analysis, management and exploitation, Germany, pp 4–7 Oct.
Author information
Authors and Affiliations
Corresponding author
Rights and permissions
About this article
Cite this article
Kumar, M., Gosain, A. & Singh, Y. A novel requirements engineering approach for designing data warehouses. Int J Syst Assur Eng Manag 7 (Suppl 1), 205–221 (2016). https://doi.org/10.1007/s13198-015-0363-5
Received:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s13198-015-0363-5