Chapter 8, Problem 8.12RQ

Explanation of Solution

Enterprise Data Warehouse (EDW) Architecture:

• The combination of data warehouse and data mart is referred as enterprise data warehouse.
  • A database system that contains data, programs and personnel that are specialized in preparing the data contents being used in the Business Intelligence application is called as data warehouse.
  • Data Mart is used to hold a small collection of data to address specific functional area of business.
• When data warehouse architecture is linked with the specialized data marts along with the central of data warehouse in obtaining data consistency and also in performing efficient operations.
• It serves as centralized warehouse which is used to provide service for the entire enterprise...