Requirements Engineering for A Data Warehouse : A Study of Managerial & Technical Aspects

Authors

  • Anil Kumar  Dravidian University, Andhra Pradesh, India
  • Anil K. Saini   Department of Information Technology, GGSIPU, New Delhi, India

Keywords:

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

Abstract

This research paper focuses on how to prepare an effective data warehouse with the use of Requirements Engineering. Earlier operating systems used for storage of information, facilitated us in making only day-to-day decisions, because they provided us with only the current data, which cannot consider appropriate enough to involve significant conclusions. Thusly, it evoked the need of using Data Warehouse for storing all the information. Construction of efficient Data Warehouse and its maintenance involves extraction, cleaning and filtering of information etc. It is a costly and time-consuming procedure, because this has made in advance of the necessities to be met. To surmount this problem, such a technique should use, which will help in exploring and clarifying each requirement in particular having a meaningful consideration while constructing the Data Warehouse at an early phase. For this we have combined the technique 'Requirement Analysis' of 'Requirement Engineering' with the Requirement gathering techniques of Data Warehouse i.e. 'Interview' and 'Survey Method'.

References

  1. "DKMS Briefs No. Six: Data Warehouses, Data Marts, and Data Warehousing" by Joseph M. Firestone, 24 May 2002.
  2. Paulraj Ponniah, "Data warehousing fundamentals", By John Wiley &Sons, Inc., 2006.
  3. Chaudhuri, S., & Dayal, U. (1997). An overview of data warehousing and OLAP technology. ACM Sigmod record, 26 (1), 65-74.
  4. Mohamed Frendi and Camille Salinesi,"Requirements Engineering for Data Warehousing", France, 2003.
  5. The Data Administrator Newsletter-TDAN.com, Robert S. Seiner Publisher
  6. Schiefer J., List B., Bruckner, R.,"A holistic approach for managing requirements of data warehouse systems". In Proceeding of Americas Conference on Information Systems, 2002.
  7. A Model-Driven Goal-Oriented Requirement Engineering Approach for Data Warehouses, Dept. of Software and Computing Systems, University of Alicante, Spain 
  8. Salinesi, C., & Gam, I. (2006, June). A requirement-driven approach to designing data warehouses. In Requirements Engineering Foundations for Software Quality (REFSQ'06) (p. 1).
  9. Salinesi, C., & Gam, I. (2006, June). A requirement-driven approach to designing data warehouses. In Requirements Engineering: Foundations for Software Quality (REFSQ'06) (p. 1).
  10. Winter, R., & Strauch, B. (2004, March). Information requirements engineering for data warehouse systems. In Proceedings of the 2004 ACM symposium on Applied computing (pp. 1359-1365). ACM.
  11. Mercier-Laurent, E., Owoc, M. L., & Boulanger, D. (Eds.). (2016).
  12. Inmon, W.: Building the Data Warehouse. Wiley & Sons, Chichester (2002) [11] Gam, I., Salinesi, C.: A requirement-driven approach to designing data warehouses. In: REFSQ (2006)
  13. Ines Gam, Camille Salinesi,"A Requirement-Driven Approach for Designing Data Warehouses, France, 2006.
  14. Giorgini, P.; Rizzi, S.; Gazette, M. A. Siena,"Grand: A Goal-Oriented Approach to Requirement Analysis in Data Warehouses", 2008.
  15. "Software Requirements Engineering: Practices and Techniques", Ronald Kirk Kandt, JPL, California Institute of Technology, November 7, 2003.
  16. "Improvement to Requirement Engineering (JAD process) for Data Warehouses", arjesh Kochar; Nidhi Khurana; Akash Agarwal, INDIACom, National Conference 2008.
  17. Gill, P., Stewart, K., Treasure, E., & Chadwick, B. (2008). Methods of data collection in qualitative research: interviews and focus groups. British dental journal, 204 (6), 291.
  18. Paetsch, F., Eberlein, A., & Maurer, F. (2003, June). Requirements engineering and agile software development. In Enabling Technologies: Infrastructure for Collaborative Enterprises, 2003. WET ICE 2003. Proceedings. Twelfth IEEE International Workshops on (pp. 308-313). IEEE.
  19. Inmon, W. H. (2005). Building the data warehouse. John Wiley & sons.

IInternational Journal of Scientific Research in Computer Science, Engineering and Information Technology

Downloads

Published

2017-12-31

Issue

Volume 2, Issue 6, November-December-2017

Section

Research Articles

License

Copyright (c) IJSRCSEIT

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

How to Cite

[1]
Anil Kumar, Anil K. Saini , " Requirements Engineering for A Data Warehouse : A Study of Managerial & Technical Aspects , IInternational Journal of Scientific Research in Computer Science, Engineering and Information Technology(IJSRCSEIT), ISSN : 2456-3307, Volume 2, Issue 6, pp.1153-1157, November-December-2017.