数据库系统原理精品教学（吉林大学）ch18.pptVIP

Copyright: Silberschatz, Korth and Sudarshan Chapter 18: Data Analysis and Mining Chapter 18: Data Analysis and Mining Decision Support Systems Decision-Support Systems: Overview Data Analysis and OLAP Cross Tabulation of sales by item-name and color Relational Representation of Cross-tabs Data Cube Online Analytical Processing Hierarchies on Dimensions Cross Tabulation With Hierarchy OLAP Implementation OLAP Implementation (Cont.) Early OLAP systems precomputed all possible aggregates in order to provide online response Space and time requirements for doing so can be very high 2n combinatio