DW Architectures 3-tier ③+日 architecture ier 2. Tier 3: Client workstation Application server Database server 2-tier retie architecture Architecture Tier 2. Client workstation pplication database server Copynight@ 2014 Pearson Education, Inc Slide 2-16
Copyright © 2014 Pearson Education, Inc. Slide 2- 16 DW Architectures Tier 2: Application server Tier 1: Client workstation Tier 3: Database server Tier 1: Client workstation Tier 2: Application & database server
Data Warehousing Architectures Issues to consider when deciding which architecture to use Which database management system (DBMS) should be used? Will parallel processing and/or partitioning be used? Will data migration tools be used to load the data warehouse? What tools will be used to support data retrieval and analysis? Copynight@ 2014 Pearson Education, Inc Slide 2-17
Copyright © 2014 Pearson Education, Inc. Slide 2- 17 Data Warehousing Architectures ▪ Issues to consider when deciding which architecture to use: ▪ Which database management system (DBMS) should be used? ▪ Will parallel processing and/or partitioning be used? ▪ Will data migration tools be used to load the data warehouse? ▪ What tools will be used to support data retrieval and analysis?