Course Outline(2) ° Data warehousing Introduction; basic concepts of data warehousing; data warehouse VS. Operational DB, data warehouse and the industry Architecture and design; two-tier and three tier architecture, star schema and snowflake schema, data capturing, replication, transformation and cleansing Data characteristics metadata static and dynamic data; derived data Data Marts; OLAP, data mining, data Warehouse administration7 Course Outline (2) • Data warehousing. – Introduction; basic concepts of data warehousing; data warehouse vs. Operational DB; data warehouse and the industry. – Architecture and design; two-tier and threetier architecture; star schema and snowflake schema; data capturing, replication, transformation and cleansing. – Data characteristics; metadata; static and dynamic data; derived data. – Data Marts; OLAP; data mining; data warehouse administration