Data Warehouse Requirements Engineering (eBook)

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.

Preface 6
Contents 9
About the Authors 12
1 Requirements Engineering for Transactional Systems 14
1.1 Transactional System Development Life Cycle 15
1.2 Transactional Requirements Engineering 18
1.3 Requirements Engineering (RE) as a Process 19
1.4 Informal Approaches to Requirements Elicitation 21
1.5 Model-Driven Techniques 24
1.5.1 Goal Orientation 24
1.5.2 Agent-Oriented Requirements Engineering 26
1.5.3 Scenario Orientation 27
1.5.4 Goal–Scenario Coupling 28
1.6 Conclusion 28
References 29
2 Requirements Engineering for Data Warehousing 31
2.1 Data Warehouse Background 31
2.2 Data Warehouse Development Experience 34
2.3 Data Warehouse Systems Development Life Cycle, DWSDLC 36
2.4 Methods for Data Warehouse Development 40
2.4.1 Monolithic Versus Bus Architecture 40
2.4.2 Data Warehouse Agile Methods 42
2.5 Data Mart Consolidation 46
2.6 Strategic Alignment 50
2.7 Data Warehouse Requirements Engineering 52
2.7.1 Goal-Oriented DWRE Techniques 55
2.7.2 Goal-Motivated Techniques 58
2.7.3 Miscellaneous Approaches 59
2.7.4 Obtaining Information 59
2.8 Conclusion 60
References 61
3 Issues in Data Warehouse Requirements Engineering 63
3.1 The Central Notion of a Decision 63
3.1.1 The Decision Process 64
3.1.2 Decision-Oriented Data Warehousing 66
3.2 Obtaining Information Requirements 72
3.2.1 Critical Success Factors 72
3.2.2 Ends Achievement 73
3.2.3 Means Efficiency 74
3.2.4 Feedback Analysis 74
3.2.5 Summary 74
3.3 Requirements Consolidation 75
3.4 Conclusion 80
References 81
4 Discovering Decisions 82
4.1 Deciding Enterprise Policies 83
4.1.1 Representing Policies 85
4.1.2 Policies to Choice Sets 86
4.2 Deciding Policy Enforcement Rules 90
4.2.1 Representing Enforcement Rules 91
4.2.2 Developing Choice Sets 93
4.3 Defining Operational Decisions 100
4.3.1 Structure of an Action 100
4.4 Computer-Aided Support for Obtaining Decisions 103
4.4.1 Architecture 103
4.4.2 User Interface 105
4.5 Conclusion 109
References 110
5 Information Elicitation 111
5.1 Obtaining Multidimensional Structure 111
5.2 Decisional Information Elicitation 113
5.3 The Decision Requirement Model 116
5.3.1 The Notion of a Decision 116
5.3.2 Metamodel of Decisions 117
5.3.3 Information 119
5.4 Eliciting Information 121
5.4.1 CSFI Elicitation 121
5.4.2 ENDSI Elicitation 122
5.4.3 MEANSI Elicitation 123
5.4.4 Feedback Information Elicitation 124
5.5 The Global Elicitation Process 124
5.6 Eliciting Information for Policy Decision-Making 126
5.6.1 CSFI Elicitation 126
5.6.2 Ends Information Elicitation 128
5.7 Eliciting Information for PER Formulation 128
5.8 Information Elicitation for Operational Systems 130
5.8.1 Elicitation for Selecting PER 130
5.8.2 Information Elicitation for Actions 131
5.9 The Late Information Substage 135
5.9.1 ER Schema for Policy Formulation 135
5.9.2 ER Schema for PER Formulation and Operations 136
5.9.3 Guidelines for Constructing ER Schema 136
5.10 Computer-Based Support for Information Elicitation 137
5.10.1 User Interfaces 137
5.10.2 The Early Information Base 141
5.11 Conclusion 142
References 143
6 The Development Process 144
6.1 Agile Data Warehouse Development 144
6.2 Decision Application Model (DAM) for Agility 146
6.3 A Hierarchical View 148
6.4 Granularity of Requirements 150
6.4.1 Selecting the Right Granularity 153
6.5 Showing Agility Using an Example 157
6.6 Comparison of DAM and Epic–Theme–Story Approach 159
6.7 Data Warehouse Consolidation 160
6.8 Approaches to Consolidation 164
6.9 Consolidating Requirements Granules 165
6.9.1 An Example Showing Consolidation 169
6.10 Tool Support 174
6.11 Conclusion 176
References 177
7 Conclusion 178