Requirements Engineering

, Volume 24, Issue 1, pp 103–117 | Cite as

A multifactor approach for elicitation of Information requirements of data warehouses

  • Deepika PrakashEmail author
  • Naveen Prakash
Original Article


Whereas requirements engineering for transactional systems aims to discover the functionality of the system-to-be, data warehouse requirements engineering aims to discover the Information contents of the data-warehouse-to-be. Though notions of goals, Decisions, business processes, business events have been used to set the context for Information discovery, the move from these to obtain the relevant Information is largely ad hoc, unguided, and does not provide traceability of Information. We propose four elicitation techniques that are inferred from manager concerns during Decision making and that provide guidance and traceability. These form a suite such that each augments the set of already discovered Information. Consequently, the possibility of missing requirements is reduced, thereby making for more effective requirements engineering.


Information Decision Decision–Information CSFI ENDSI MEANSI Outcome feedback 


  1. 1.
    Antón AI (1996) Goal-based requirements analysis. In: Proceedings of the second international conference on requirements engineering. IEEE, pp 136–144Google Scholar
  2. 2.
    Lamsweerde A (2000) Requirements engineering in the year 00: a research perspective. In: Proceedings of the 22nd international conference on Software engineering. ACM, pp 5–19Google Scholar
  3. 3.
    Sutcliffe AG, Maiden NA, Minocha S, Manuel D (1998) Supporting scenario-based requirements engineering. IEEE Trans Softw Eng 24(12):1072–1088CrossRefGoogle Scholar
  4. 4.
    Lamsweerde A, Willemet L (1998) Inferring declarative requirements specifications from operational scenarios. IEEE Trans Softw Eng 24(12):1089–1114CrossRefGoogle Scholar
  5. 5.
    CREWS Team (1998) The CREWS glossary, CREWS report 98-1.
  6. 6.
    Liu L, Yu E (2004) Designing information systems in social context: a goal and scenario modelling approach. Inf Syst 29(2):187–203CrossRefGoogle Scholar
  7. 7.
    Boehnlein M, Ulbrich vom Ende A (1999) Deriving initial data warehouse structures from the conceptual data models of the underlying operational information systems. In: Proceedings of workshop on data warehousing and OLAP. ACM, pp 15–21Google Scholar
  8. 8.
    Boehnlein M, Ulbrich vom Ende A (2000) Business process oriented development of data warehouse structures. In: Proceedings of data warehousing 2000. PhysicaVerlag HD, pp 3–21Google Scholar
  9. 9.
    Bonifati A, Cattaneo F, Ceris S, Fuggetta A, Paraboschi S (2001) Designing data marts for data warehouses. ACM Trans Softw Eng Methodol 10(4):452–483CrossRefGoogle Scholar
  10. 10.
    Prakash N, Gosain A (2003) Requirements driven data warehouse development. In: CAiSE short paper proceedings, pp 13–17Google Scholar
  11. 11.
    Prakash N, Gosain A (2008) An approach to engineering the requirements of data warehouses. Requir Eng J 13(1):49–72CrossRefGoogle Scholar
  12. 12.
    Mazón JN, Pardillo J, Trujillo J (2007) A model-driven goal-oriented requirement engineering approach for data warehouses. In: Hainaut JL et al (eds) Advances in conceptual modeling—foundations and applications. ER 2007. Lecture notes in computer science, vol 4802. Springer, Berlin, pp 255–264Google Scholar
  13. 13.
    Giorgini P, Rizzi S, Garzetti M (2008) GRAnD: a goal-oriented approach to requirement analysis in data warehouses. Decis Support Syst 45(1):4–21CrossRefGoogle Scholar
  14. 14.
    Prakash N, Bhardwaj H (2014) Functionality for business indicators in data warehouse requirements engineering. In: Parsons J, Chiu D (eds) Advances in conceptual modeling. ER 2013. Lecture notes in computer science, vol 8697. Springer, Cham, pp 39–48Google Scholar
  15. 15.
    Nasiri A, Wrembel R, Zimányi E. Model-based requirements engineering for data warehouses: from multidimensional modelling to KPI monitoring. In: International conference on conceptual modeling 2015. Springer, Berlin, pp 198–209Google Scholar
  16. 16.
    Corr L, Stagnitto J (2012) Agile data warehouse design. DecisionOne Press, LeedsGoogle Scholar
  17. 17.
    Cravero Leal A, Mazón JN, Trujillo J (2013) A business-oriented approach to data warehouse development. Ingeniería e Investigación 33(1):59–65Google Scholar
  18. 18.
    Gosain A, Bhati R (2016) Goal oriented approaches in data warehouse requirements engineering: a review. In: International conference on smart trends for information technology and computer communications. Springer, Berlin, pp 244–253Google Scholar
  19. 19.
    Bhardwaj H, Prakash N (2016) Eliciting and structuring business indicators in data warehouse requirements engineering. Expert Syst 33(4):405–413CrossRefGoogle Scholar
  20. 20.
    Giorgini P, Rizzi S, Garzetti M (2005) Goal-oriented requirement analysis for data warehouse design. In: Proceedings of the 8th ACM international workshop on data warehousing and OLAP. ACM, pp 47–56Google Scholar
  21. 21.
    Prakash D, Gupta D (2014) Eliciting data warehouse contents for policy enforcement rules. Int J Inf Syst Model Des (IJISMD) 5(2):41–69CrossRefGoogle Scholar
  22. 22.
    Prakash D, Prakash N (2015) Towards DW support for formulating policies. In: IFIP working conference on the practice of enterprise modeling. Springer, Cham, pp 374–388Google Scholar
  23. 23.
    Bullen CV, Rockart JF (1981) A primer of critical success factors, CISR No. 69 Sloan WP No. 1220-81 Center for Information Systems Research, Sloan School of Management Massachusetts Institute of TechnologyGoogle Scholar
  24. 24.
    Wetherbe JC, Davis GB (1983) Developing a long-range information architecture. In: Proceedings of AFIPS, pp 261–269Google Scholar
  25. 25.
    Sterman JD (1989) Modeling managerial behaviour: misperceptions of feedback in a dynamic decision making experiment. Manag Sci 35(3):321–339CrossRefGoogle Scholar
  26. 26.
    Inmon B (2005) Building the data warehouse, 4th edn. Wiley, New YorkGoogle Scholar
  27. 27.
    Kimball R, Ross M (2002) The data warehouse toolkit: the complete guide to dimensional modeling. Wiley, New YorkGoogle Scholar
  28. 28.
    Prakash N, Prakash D, Sharma YK (2009) Towards better fitting data warehouse systems. In: Persson A, Stirna J (eds) The practice of enterprise modeling. PoEM 2009. Lecture notes in business information processing, vol 39. Springer, Berlin, pp 130–144Google Scholar
  29. 29.
    Golfarelli M, Maio D, Rizzi S (1998) Conceptual design of data warehouses from E/R schemes. In: Proceedings of the thirty-first Hawaii international conference on system sciences, 1998, vol 7. IEEE, pp 334–343Google Scholar
  30. 30.
    Moody LD, Kortink MAR (2000) From enterprise models to dimensional models: a methodology for data warehouses and data mart design. In: Proceedings of the international workshop on design and management of data warehouses, Stockholm, Sweden, pp 5.1–5.12Google Scholar
  31. 31.
    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 (DMDW2000) Stockholm, SwedenGoogle Scholar
  32. 32.
    Boynton AC, Zmud RW (1984) An assessment of critical success factors. Sloan Manag Rev 25(4):17–27Google Scholar
  33. 33.
    Prakash N, Prakash D, Gupta D (2011) Decisions and decision requirements for data warehouse systems. In: Information systems evolution, pp 92–107Google Scholar

Copyright information

© Springer-Verlag London Ltd. 2017

Authors and Affiliations

  1. 1.School of Mathematics, Statistics and Computational ScienceCentral University of RajasthanKishangarhIndia
  2. 2.ICLCNew DelhiIndia

Personalised recommendations