DOI QR코드

DOI QR Code

Stakeholders Driven Requirements Engineering Approach for Data Warehouse Development

  • Kumar, Manoj (Department of Computer Science & Engineering, Ambedkar Institute of Technology) ;
  • Gosain, Anjana (University School of Information Technology, Guru Gobind Singh Indraprastha University) ;
  • Singh, Yogesh (University School of Information Technology, Guru Gobind Singh Indraprastha University)
  • Received : 2010.04.22
  • Accepted : 2010.06.25
  • Published : 2010.09.30

Abstract

Most of the data warehouse (DW) requirements engineering approaches have not distinguished the early requirements engineering phase from the late requirements engineering phase. There are very few approaches seen in the literature that explicitly model the early & late requirements for a DW. In this paper, we propose an AGDI (Agent-Goal-Decision-Information) model to support the early and late requirements for the development of DWs. Here, the notion of agent refers to the stakeholders of the organization and the dependency among agents refers to the dependencies among stakeholders for fulfilling their organizational goals. The proposed AGDI model also supports three interrelated modeling activities namely, organization modeling, decision modeling and information modeling. Here, early requirements are modeled by performing organization modeling and decision modeling activities, whereas late requirements are modeled by performing information modeling activities. The proposed approach has been illustrated to capture the early and late requirements for the development of a university data warehouse exemplifying our model's ability of supporting its decisional goals by providing decisional information.

Keywords

References

  1. Wong, S.T., Hoo, K.S. Jr., Knowlton, R.C., Laxer, K.D., Cao, X., Hawkins, R.A., Dillon, W.P., Arenson, R.L., Design and applications of a multimodality image data warehouse framework, J. American Medical Information Association, 9, 239-254, 2002 https://doi.org/10.1197/jamia.M0988
  2. Miller, L.L., Honavar, V., Barta, T., Warehousing Structured and Unstructured Data for Data Mining, http://www.asis.org/annal-97/whouse.htm
  3. Inmon, W.H., Building the data warehouse, Wiley, New York, 1996.
  4. Ballard, C., Herreman, D., Schau, D., Bell, R.,Kim,E., Valencic, A., Data modeling techniques for data warehousing, redbooks.ibm.com
  5. Jarke, M., Jeusfeld, A., Quix, C., Vassiliadis P., Architecture and quality in data warehouses, proceedings of 10th CAiSE Conference, Springer, Heidelberg, 93-113, 1998.
  6. Yu, E.S.K., Modeling Strategic Relationships for Process Reengineering, Ph.D. thesis, Dept. of Computer Science, University of Toronto, Toronto, 1995.
  7. Yu, E.S.K., Towards Modeling and Reasoning Support for Early-Phase Requirements Engineering, proceedings of IEEE International Symposium on Requirements Engineering, 226-235, 1997.
  8. Yu, E., Mylopoulos, J., Understanding Why in Requirements Engineering with an Example, proceedings of Workshop on System Requirements: Analysis, Management, and Exploitation, 1994.
  9. Bresciani P., Giorgini P., Mylopoulous J., Perini A., TROPOS: An Agent-Oriented Software Development Methodology, J. Autonomous Agents and Multi-Agent Systems, 8, 203-236, 2004. https://doi.org/10.1023/B:AGNT.0000018806.20944.ef
  10. Yu, E.S.K., Why Agent Oriented Requirements Engineering, proceedings of Third Workshop on Requirements Engineering, Barcelona, Catalonia, June 1997.
  11. Rao, A. S., George, M. P., Modeling rational agents within a BDI architecture, proceedings of Knowledge Representation and Reasoning Conference, 1991.
  12. Giorgini, P., Rizzi, S., Garzetti, M., GRAnD: A goal-oriented approach to requirement analysis in data warehouses, Elsevier Science Direct, Decision Support Systems, 45, 4-21, 2008. https://doi.org/10.1016/j.dss.2006.12.001
  13. Prakash, N., Gosain, A., An approach to engineering the requirements of data warehouses, Springer-Veralag, Requirements Eng. Journal, 2007.
  14. Prakash, N., Gosain, A., Requirements driven data warehouse development, proceedings of CAiSE Short Paper, 13-17, 2003.
  15. Golfarelli, M., Rizzi, S., Designing the data warehouse: key steps and crucial issues, J. Computer Science Information Management, 2(3), 1999
  16. Husemann, B., Lechtenborger, J., Vossen, G., Conceptual data warehouse design, proceedings of the international workshop on design and management of data warehouses, Stockholm, Sweden, June 5-6, 2000.
  17. Boehnlein, M., Ulbrich vom Ende A., Deriving initial data warehouse structures from the conceptual data models of the underlying operational information systems, Proceedings of workshop on data warehousing and OLAP, Kansas City, MO, USA, 1991.
  18. Kimball, R., Reeves, L., Ross, M., Thornthwate, W., The data warehouse lifecycle toolkit. Wiley, New York, 1998.
  19. Frendi, M., Salinesi, C., Requirements engineering for data warehousing, proceedings of REFSQ Workshop, 2003.
  20. Winter, R., Strauch, B., Information requirements engineering for data warehouse systems, proceedings of ACM symposium on applied computing, Nicosia, Cyprus, 2003.
  21. Bonifati, A., Cattaneo, F., Ceri, S., Fuggetta, A., Paraboschi, S., Designing data marts for data warehouses. ACM Trans Software Eng Methodology, 10(4), 452-483, 2001. https://doi.org/10.1145/384189.384190
  22. Shiefer, J., List, B., Bruckner, R.M., A holistic approach for managing requirements of data warehouse systems, proceedings of 8th Americas Conference on information systems, 2002.
  23. Anton, A. I., Goal based requirements analysis, proceedings of the IEEE International Conference on Requirements Engineering, Colarado Springs, USA, 1996.
  24. Bubenko, J. A., Information Modeling in the Context of System De-velopment, proceedings of IFIP, 395-411, 1980.
  25. Hewitt, C., Viewing Control Structures as Patterns of Passing Messages, J. Artificial Intelligence, 8(3), 323-364, 1977. https://doi.org/10.1016/0004-3702(77)90033-9
  26. Hyacinth, S.N., Software Agents: An Overview, J. Knowledge Engineering Review, 11(3), 205-244, 1996. https://doi.org/10.1017/S026988890000789X
  27. Van, L.A., Goal-oriented requirements engineering: a guided tour. Invited paper for RE'01, proceedings of 5th IEEE international symposium on requirements engineering, Toronto, August, 249-263, 2001.
  28. Sutcliffe, A., Maiden, N., Bridging the requirements gap: policies, goals and domains, proceedings of IEEE seventh international workshop on software specification and design, 1993.
  29. Rolland, C., Grosz, G., Kla, R., A proposal for a scenario classification framework, Requirement Engineering Journal, 1998.
  30. Mylopoulos, J., Chung, L., Nixon, B., Representing and using nonfunctional requirements: a processoriented approach, IEEE Trans Software Eng, 18(6), 483-497,1992. https://doi.org/10.1109/32.142871
  31. Dardenne, A., Van Lamsweerde, A., Fickas, S., Goal-Directed Requirements Acquisition, Science of Computer Programming, 20, 3-50, 1993. https://doi.org/10.1016/0167-6423(93)90021-G

Cited by

  1. Eliciting and structuring business indicators in data warehouse requirements engineering vol.33, pp.4, 2016, https://doi.org/10.1111/exsy.12165