A Data Warehouse is a Subject Oriented, Integrated, Non volatile and Time Variant repository of data that is generally used for querying and analyzing the past trends to support management decisions for the future.
Data warehouse is a relational database that is designed for query and analysis Rather than for transaction processing.
It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources. In addition to a relational database, a data warehouse environment includes an extraction, transportation, transformation, and loading (ETL) solution, an online analytical processing (OLAP) engine, client analysis tools, and other applications that manage the process of gathering data and delivering it to business users.
Course Roadmap
• What is Data Warehousing ?
• The evolution of Data Warehousing
• Need for Data Warehousing
• OLTP Vs Warehouse Applications
• Data marts Vs Data Warehouses
• Operational Data Stores
• Overview of Warehouse Architecture
• Data Warehouse Architectures
• Components of Data Warehousing Architecture
• An overview of each of the components
• Considerations for Data Warehouse Design
• Common mistakes in Warehouse designs
• An overview of Warehouse on the web
No comments:
Post a Comment