ppt课件-chapter22advancedqueryingandinformationretrieval.pptVIP

Copyright: Silberschatz, Korth and Sudarshan Chapter 22: Advanced Querying and Information Retrieval Decision Support Systems Decision-Support Systems: Overview Data Analysis and OLAP Cross Tabulation of sales by item-name and color Relational Representation of Crosstabs Three-Dimensional 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 combinations