期末考试总结(据仓库与数据挖掘).pptVIP

HD-ITR HD-ITR HD-ITR HD-ITR HD-ITR School of Computer Science and Technology School of Computer Science and Technology School of Computer Science and Technology School of Computer Science and Technology * HD-ITR * What is a data warehouse Properties of data warehouse Differences between OLAP and OLTP Operations Slice, Dice, aggregation, Cube, roll-up, drill-down, rotate ROLAP and MOLAP Indexing techniques Bitmap index Generalized index Join index * HD-ITR * MOLAP-Based aggregations G M Prefix Infix MOLAP based Cube Iceberg Cube Range query processing Query optimization of a single query * HD