Chapter 32 Flashcards
What are 2 implementation strategies in DWH
- Top down
- Bottom up
When we use top down implementation strategies in DWH
When technologies are well defined
When we use bottom up implementation strategies in DWH
When requirements are not clear
What are development methodologies in DWH
- Waterfall model
- Spiral model
- RAD (Rapid application development)
- User driven methodology
- Data driven methodology
- Goal driven methodology
What is waterfall model in DWH
First take requirements, then design system, then detail design. This method works best when requirements are known.
What is spiral model in DWH
It has iterative model. It is clear that all requirements are not known in advance.
What is RAD model in DWH
First we see scope. Then we do analysis. Then we do system design and implement.
What is the difference between RAD and waterfall method
In RAD, we check scope first and in waterfall we only get requirements without scope and build the software.
What are 5 keys to success in RAD
1- Make a small team
2- Make a team for end user who tells requirements
3- Make a user manual and UI for users
4- Make prototype system with visual tools
5- Give that system to end user. get their feedback as input and make real system
What is data driven development methodology
The development is driven by data supplied by user. First we develop a system, then we add goals and requirements in it.
What is goal driven development methodology
Semantic object modeling approach is used in it. We also see data hierarchy in it.
What is granularity of DWH
How to store data in DWH on hourly basis or on daily basis or weekly basis
What is user driven development methodology
Business user driven approach. They define questions/requirements.
What is problem definition
Problem described by the user.
What is test production environment
Test deployment of system for testing purposes.
