les02资料参考 学习.pptVIP

Data Warehousing, Business Intelligence, OLAP, and Data Mining Objectives After completing this lesson, you should be able to do the following: Describe the evolution of data warehouses from management information systems (MIS) Describe how extract processing for decision-support querying led to data warehouse solutions Identify the business intelligence (BI), online analytical processing (OLAP), and data mining tools from Oracle Identify the business drivers for data warehouses Define OLAP and the Oracle Database 11g OLAP option Compare Relational OLAP (ROLAP) and Multidimensional OLAP (MOLAP) Describe the data mining concepts Lesson Agenda Data warehousing and business intelligence (BI) The dimensional model Oracle OLAP Oracle data mining Evolution of BI Executive information systems (EIS) Decision support systems (DSS) Data warehousing (DW) and business intelligence (BI) Early Management Information Systems MIS systems provided business data. Reports were developed on request. Reports provided little analysis capability. Decision support tools gave personal ad hoc access to data. Analyzing Data from Operational Systems Data structures are complex. Systems are designed for high performance and throughput. Data is not meaningfully represented. Data is dispersed. Online transaction processing (OLTP) systems may be unsuitable for intensive queries. Why OLTP Is Not Suitable for Analytical Reporting Data Extract Processing End-user computing offloaded from the operational environment User’s own data Issues with Data Extract Programs Productivity Issues with Extract Processing Duplicated effort Multiple technologies Obsolete reports No common metadata Data Quality Issues with Extract Processing No common time basis Different calculation algorithms Different levels of extraction Different levels of granularity Different data field names Different data field meanings Missing information No data correction rules No drill-down capability Data Warehousing and Busin