Comprehensive Overview of Database Concepts and OLAP Processing Techniques
This resource provides an in-depth review of key database concepts, including data warehousing and OLAP processing. It outlines the differences between data warehouses and transactional databases, explores data organization using the star schema, and delves into ETL processes and data preprocessing activities. Additionally, it covers SQL commands for data manipulation, analytical functions, and various data mining techniques such as decision trees and clustering. Ideal for students preparing for exams on database topics and OLAP methodologies.
Comprehensive Overview of Database Concepts and OLAP Processing Techniques
E N D
Presentation Transcript
CS 523 Database Topics Exam Reviews
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
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
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.
