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 similarities: Client workstation runs on a PC
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 is an important solution for managing corporate data.
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.

  1. information interdependence between organizational units
  2. Upper management's information needs
  3. Urgency of need for a data warehouse
  4. Nature of end-user tasks
  5. Constraints on resources
  6. Strategic view of the data warehouse prior to implementation
  7. Compatibility with existing systems
  8. Perceived ability of the in-house IT staff
  9. Technical issues
  10. Social/political factors
  • Higher grades + faster learning
  • Never study anything twice
  • 100% sure, 100% understanding
Discover Study Smart

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
Remember faster, study better. Scientifically proven.
Trustpilot Logo