Descriptive Analytics II: Business Intelligence and Data Warehousing - Data Warehousing Architectures
4 important questions on Descriptive Analytics II: Business Intelligence and Data Warehousing - Data Warehousing Architectures
What are the key similarities and differences between a 2-tiered architecture and a 3-tiered architecture?
key differences: in a 2-tier: application server runs on the same hardware platform as the datawarehouse / database server
How has the Web influenced data warehouse design?
It offers: ease of access, platform independence and lower cost
What issues should be considered when deciding which architecture to use in developing a data warehouse? List the 10 most important factors.
- information interdependence between organizational units
- Upper management's information needs
- Urgency of need for a data warehouse
- Nature of end-user tasks
- Constraints on resources
- Strategic view of the data warehouse prior to implementation
- Compatibility with existing systems
- Perceived ability of the in-house IT staff
- Technical issues
- Social/political factors
- Higher grades + faster learning
- Never study anything twice
- 100% sure, 100% understanding
Which data warehousing architecture is the best? Why?
Ranked, best above:
- 1 - Data mart bus architecture
- 1 - Hub-and-spoke architecture
- 1 - Centralized data warehouse :
- 2 - Federated data warehouse: not an optimal long-term solution
- 3 - Independent DM: poor architectural solution
The question on the page originate from the summary of the following study material:
- A unique study and practice tool
- Never study anything twice again
- Get the grades you hope for
- 100% sure, 100% understanding