Skip to main content
SpringerLink
Log in

A multifactor approach for elicitation of Information requirements of data warehouses

  • Original Article
  • Published:
Requirements Engineering Aims and scope Submit manuscript

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4

Similar content being viewed by others

References

  1. Antón AI (1996) Goal-based requirements analysis. In: Proceedings of the second international conference on requirements engineering. IEEE, pp 136–144

  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–19

  3. Sutcliffe AG, Maiden NA, Minocha S, Manuel D (1998) Supporting scenario-based requirements engineering. IEEE Trans Softw Eng 24(12):1072–1088

    Article  Google Scholar 

  4. Lamsweerde A, Willemet L (1998) Inferring declarative requirements specifications from operational scenarios. IEEE Trans Softw Eng 24(12):1089–1114

    Article  Google Scholar 

  5. CREWS Team (1998) The CREWS glossary, CREWS report 98-1. http://SUNSITE.informatik.rwth-aachen.de/CREWS/reports.htm

  6. Liu L, Yu E (2004) Designing information systems in social context: a goal and scenario modelling approach. Inf Syst 29(2):187–203

    Article  Google Scholar 

  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–21

  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–21

  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–483

    Article  Google Scholar 

  10. Prakash N, Gosain A (2003) Requirements driven data warehouse development. In: CAiSE short paper proceedings, pp 13–17

  11. Prakash N, Gosain A (2008) An approach to engineering the requirements of data warehouses. Requir Eng J 13(1):49–72

    Article  Google Scholar 

  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–264

  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–21

    Article  Google Scholar 

  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–48

  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–209

  16. Corr L, Stagnitto J (2012) Agile data warehouse design. DecisionOne Press, Leeds

    Google Scholar 

  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–65

    Google Scholar 

  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–253

  19. Bhardwaj H, Prakash N (2016) Eliciting and structuring business indicators in data warehouse requirements engineering. Expert Syst 33(4):405–413

    Article  Google Scholar 

  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–56

  21. Prakash D, Gupta D (2014) Eliciting data warehouse contents for policy enforcement rules. Int J Inf Syst Model Des (IJISMD) 5(2):41–69

    Article  Google Scholar 

  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–388

  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 Technology

  24. Wetherbe JC, Davis GB (1983) Developing a long-range information architecture. In: Proceedings of AFIPS, pp 261–269

  25. Sterman JD (1989) Modeling managerial behaviour: misperceptions of feedback in a dynamic decision making experiment. Manag Sci 35(3):321–339

    Article  Google Scholar 

  26. Inmon B (2005) Building the data warehouse, 4th edn. Wiley, New York

    Google Scholar 

  27. Kimball R, Ross M (2002) The data warehouse toolkit: the complete guide to dimensional modeling. Wiley, New York

    Google Scholar 

  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–144

  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–343

  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.12

  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, Sweden

  32. Boynton AC, Zmud RW (1984) An assessment of critical success factors. Sloan Manag Rev 25(4):17–27

    Google Scholar 

  33. Prakash N, Prakash D, Gupta D (2011) Decisions and decision requirements for data warehouse systems. In: Information systems evolution, pp 92–107

Download references

Author information

Authors and Affiliations

  1. School of Mathematics, Statistics and Computational Science, Central University of Rajasthan, Kishangarh, India

    Deepika Prakash

  2. ICLC, 21/8 S. Bhagat Singh Marg, New Delhi, 110001, India

    Naveen Prakash

Authors
  1. Deepika Prakash
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Naveen Prakash
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Deepika Prakash.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Prakash, D., Prakash, N. A multifactor approach for elicitation of Information requirements of data warehouses. Requirements Eng 24, 103–117 (2019). https://doi.org/10.1007/s00766-017-0283-9

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s00766-017-0283-9

Keywords

Search

Navigation