CS 523 Database Topics Exam Reviews 1 Exam

CS 523 Database Topics Exam Reviews 1

Exam #1 Class Introduction • Definitions • Introduction to OLAP processing • Introduction to Data Mining Processing Data Warehousing • Differences between a data warehouse and a transactional database • Data organization – the star schema • Bit Map Indexes 2

Exam #1 (cont) Introduction to ETL • Data Preprocessing Activities • SQL Commands to copy data Extraction/transformation/load • Sqlldr • Externally stored tables • Dblinks OLAP Introduction OLAP in SQL • Rollups and Cubes 3

Exam #2 More OLAP in SQL • Partitioning • Analytical functions (cume_dist, ntile, etc. ) Introduction to data mining • No prediction – time series, clustering • Predict one thing – decision trees, value prediction • Predict everything – association, sequential patterns. 4

Review for Final I Class Introduction • Basic Definitions Introduction to ETL • • • Data Preprocessing Activities SQL Commands to copy data Extraction/transformation/load Sqlldr Externally stored tables Dblinks 5

Review for Final II Data Warehousing • • Definitions Star Schema – Dimensions and facts. Snowflakes, Constellations Bit-Map Index 6

Review for Final III Decision Support • Data Warehousing Definitions, Tools • OLAP Roll up, drill down, slice and dice SQL: Partitions, Rank, N-Tiles, Distributions, etc. • Data Mining Preprocessing techniques Clustering, Time sequences, Classification, Value Prediction, Association, Sequential Patterns 7

Review for Final IV Data Mining Agorithms • Association – a priori • Association – fp growth • Decision Trees – ID 3 8

Review for Final V DON’T FORGET TO BRING A CALCULATOR!!! 9