Data Warehousing and Data Mining

Handouts

Some handouts contain links to papers which are accessible via the College Library subscriptions to journals: such links will work from a Birkbeck College machine or VPN connection.

Course Outline
SQL - Data Manipulation
Using Oracle 11 on PCs
SQL Exercise (Non-Coursework)
Normalization
SQL - Data Definition
Oracle Storage Structures
Oracle Query Optimization
Query Optimization Exercise (Non-Coursework)
Data Warehousing Overview
Data Warehousing Logical Design
FoodMart Exercise (Non-Coursework)
OLAP
OLAP Exercise (Non-Coursework)
Data Warehousing Physical Design
FoodMart Exercise (Coursework)
Data Warehousing Construction
Data Mining Concepts
Data Mining Technologies and Implementations
PASW Modeler Tutorial
PASW Modeler Exercise (Optional Non-Coursework)
Data Mining Research Trends

Other Module Resources

Oracle Documentation
Connecting to Oracle from Outside the College
SQL Statements to Create and Populate the Example Supplier-Parts-Projects Database Tables
SQL Statements to Create and Populate the Example Election Database Tables (50 constituencies)
Zipped dump of Oracle Foodmart database produced with Oracle "exp" utility
Zipped mdb file for Access Foodmart database
SQL Example Queries
More Challenging SQL Exercise
Query Optimizer Plan Table Definition (with example)
Example JDM program for association rule mining

Related WWW Resources

Oracle Website
SQL Server Website
SQL Server Analysis Services Data Mining Tutorials
IBM InfoSphere Warehouse Website
Interactive SQL Tutorial - by Andrew Cumming, School of Computing, Napier University
LGI Data Warehousing Information Centre
The Data Warehousing Institute
OLAP Council
Data Warehousing and OLAP Research-Oriented Bibliography
KDNuggets - Data Mining