Requirements Engineering For Data Warehouse

Authors

  • Preeti Goel Assistant Professor, Trinity Institute of Professional Studies, Dwarka, New Delhi
  • Renu Yadav Assistant Professor, Trinity Institute of Professional Studies, Dwarka, New Delhi

Keywords:

Engineering, Data Warehouse, Requirement Analysis, Requirement gathering techniques, ETL Process (Data Staging Process)

Abstract

Our research paper will focus on the effectiveness of a  requirement engineering process on organizational data  warehouses used by the business analysts and managers  for an effective decision making during critical situations.  The global slowdown due to economic recession of 2008- 09 also affected the business climate within India and the  growth rate of the Information Technology Sector. But,  India being a developing economy managed to survive the  economic recession to an extent. This paper focuses on  the important role played by organizational data warehouse systems used for making important decisions  during hard times that help in averting the impact of  recession to a large extent. Recession presented businesses with a dilemma: whether  to cut costs to conserve resources, or to invest in new  products and processes to exploit competitor weakness.  Here comes the need of correct data on which strategic  decisions can be made. Thus the need of an effective  requirement engineering phase is there. The policies laid  down by Indian Govt. caused a total change in the way in  which India does business. There are challenges facing  managers together with hope for more initiative and  creativity, leading to success for industry and for the whole  nation. Building of efficient Data Warehouse and its maintenance  is a costly and time consuming process. To overcome this  problem, we should use such a technique that helps in  exploring and clarifying each requirement in detail which  can be considered while constructing the Data Warehouse  at an early phase. The importance of an effective  requirement engineering phase lies in the fact that if  requirements are properly identified in the beginning, then  the data warehouse would be built on an almost correct  data. Correctly gathered and represented data would help  the business managers to take an apt decision in the face  of uncertainty to optimize the resources available at their  disposal.

References

A Model-Driven Goal-Oriented Requirement Engineering Approach for Data Warehouses, Dept. of Software and Computing Systems, University of Alicante, Spain

Google Images

http://tynerblain.com/blog/2006/01/14/top-five requirements-gathering-tips, blog of Tyner Blain. [4] http://ieeexplore.ieee.org/xpl/freeabs_all.jsp? arnumber=1510056, Nassis, V.; Rajugan, R.;Dillon, T.S.; Rahayu, W.; Dept. of CS-CE, La Trobe Univ., Melbourne, Vic., Australia

IS 460 Notes on Requirements Gathering by Professor Yong Tan, Faculty, and Washington?

I nmon, W.: Building the Data Warehouse. Wiley & Sons, Chichester (2002)

K.K Aggarwal, Yogesh Singh, “Software Engineering”, By New Age International (P) Ltd., Publishers, 2008. [8] Kochar B; Khurana N; Agarwal A, “Improvement to Requirement Engineering (JAD process) for Data Warehouses”, INDIACom, National Conference 2008.

Paulraj Ponniah, “Data warehousing fundamentals”, By John Wiley &Sons, Inc., 2006.

“Requirements Gathering Techniques”, Oregon.gov (www.oregon.gov/dhs/admin/pmo/data/executing_te mplates/tools_and_techniques/requirements_gather ing_techniques.doc)

Research Paper # 93344, Data Warehousing [12] Verick S,Islam I, “The Great Recession of 2008-2009: Causes, Consequences and Policy Responses.” Discussion Paper No. 4934 May 2010.

Published

2012-12-23

How to Cite

Requirements Engineering For Data Warehouse . (2012). Trinity Journal of Management, IT & Media (TJMITM), 3(1), 33–37. Retrieved from https://acspublisher.com/journals/index.php/tjmitm/article/view/1335