Data Warehouse Requirements Engineering

As the first to focus on the issue of Data Warehouse Requirements Engineering, this book introduces a model-driven requirements process used to identify requirements granules and incrementally develop data warehouse fragments. In addition, it presents an approach to the pair-wise integration of requirements granules for consolidating multiple data warehouse fragments. The process is systematic and does away with the fuzziness associated with existing techniques. Thus, consolidation is treated as a requirements engineering issue.

The notion of a decision occupies a central position in the decision-based approach. On one hand, information relevant to a decision must be elicited from stakeholders; modeled; and transformed into multi-dimensional form. On the other, decisions themselves are to be obtained from decision applications. For the former, the authors introduce a suite of information elicitation techniques specific to data warehousing. This information is subsequently converted into multi-dimensional form. For the latter, not only are decisions obtained from decision applications for managing operational businesses, but also from applications for formulating business policies and for defining rules for enforcing policies, respectively.

In this context, the book presents a broad range of models, tools and techniques. For readers from academia, the book identifies the scientific/technological problems it addresses and provides cogent arguments for the proposed solutions; for readers from industry, it presents an approach for ensuring that the product meets its requirements while ensuring low lead times in delivery.

• Decision
• Systems Development Life Cycle
• Data Warehousing
• Information Elicitation and Modeling
• Data Mart/Warehouse integration
• Multi-factor Elicitation
• Formulating Policy and Policy Enforcement Rules

• ICLC Ltd., New Delhi, India

  Naveen Prakash

• Central University of Rajasthan, Kishangarh, India

  Deepika Prakash

Naveen Prakash obtained his doctoral degree from the Indian Institute of Technology Delhi (IIT Delhi) in 1980. He subsequently worked at the Bhabha Atomic Research Centre, Mumbai and at the National Center for Software Development and Computing Techniques, Tata Institute of Fundamental Research (NCSDCT, TIFR) before joining the R&D group of CMC Ltd where he worked for over 10 years doing industrial R&D. In 1989, he moved to academics. He worked at the Department of Computer Science and Engineering, Indian Institute of Technology Kanpur (IIT Kanpur), and at the Delhi Institute of Technology (DIT) (now Netaji Subhas Institute of Technology (NSIT)), Delhi. During this period he provided consultancy services to Asian Development Bank and African Development Bank projects in Sri Lanka and Tanzania, respectively, as well as to the Indira Gandhi National Centre for the Arts (IGNCA) as a United Nations Development Programme (UNDP) consultant. He served as a scientific advisor to the British Council Division, New Delhi and took up the directorship of various educational institutes in India. Post-retirement, he worked on a World Bank project in Malawi.

Professor Prakash has lectured extensively in various universities abroad. He is on the editorial board of the Requirements Engineering Journal, and of the International Journal of Information System Modeling and Design (IJISMD). He has published over 70 research papers and authored two books.

Prof. Prakash continues to be an active researcher. Besides Business Intelligence and Data Warehousing, his interests include the Internet-of-things and NoSQL database. He also lectures at the Indira Gandhi Delhi Technical University for Women (IGDTUW), Delhi.

Deepika Prakash obtained her Ph.D. from Delhi Technological University, Delhi in the area of Data Warehouse Requirements Engineering. Currently, she is an Assistant Professor at the Department of Big Data Analytics, Central University of Rajasthan, Rajasthan.

Dr. Prakash has five years of teaching experience, as well as two years of experience in industrial R&D, building data marts for purchase, sales and inventory and in data mart integration. Her responsibilities spanned the complete life cycle, from requirements engineering through conceptual modeling to extract-transform-load (ETL) activities.

As a researcher, she has authored a number of papers in international forums and has delivered invited lectures at a number of Institutes throughout India. Her current research interests include Business Intelligence, Health Analytics, and the Internet-of-Things.

Policies and ethics