120 likes | 125 Views
LM 7 Data Warehouse. Dr. Lei Li. Learning Objectives. Describe the needs for data warehouse Describe the three levels of a data warehouse Explain the independent and dependent data mart Explain the basic concept of big data, NoSQL , OLAP, data visualization, and data mining.
E N D
LM 7Data Warehouse Dr. Lei Li
Learning Objectives • Describe the needs for data warehouse • Describe the three levels of a data warehouse • Explain the independent and dependent data mart • Explain the basic concept of big data, NoSQL, OLAP, data visualization, and data mining.
Data Warehouse • A relational database designed for query and analysis. • Subject-oriented: e.g. customers, patients, students, products • Integrated: consistent naming conventions, formats, encoding structures; from multiple data sources • Time-variant: can study trends and changes • Non-updatable: read-only, periodically refreshed • Data Mart • A data warehouse that is limited in scope
Why Data Warehouse? • Integrated, company-wide view of high-quality information (from disparate databases) • Separation of operational and informational systems and data (for improved performance)
Three Tier Data Warehouse Architecture Image source: http://www.tutorialspoint.com/dwh/dwh_architecture.htm
Data Mart • Stand-alone data mart • Dependent data mart
Stand-alone data mart Image source: http://www.zentut.com/data-warehouse/data-mart/
Other Database Concepts • Data mining – knowledge discovery in database • Big Data • No-SQL database