ACS-4904

Data Warehousing  Winter 2018

Ron McFadyen

Exam: April 11 @ 1:30

Office hours:

Tues April 10: 10:00-3:00

Wed April 11: 10:00-noon


Outline

course outline 

Jan 8

Chapter 1

Databases

Operational example (MS Access)

Star schema example (2018 Northwind Star Schema.accdb)

Jan 10

Chapter 1 Querying a star schema

Chapter 2 Architectures

 

Jan 10,

Chapter 3 Stars and cubes

Assignment 1 due Jan 28

Each table must have a primary key.

Referential integrity must be enforced between fact table and each dimension.

If you are not using MS Access or PostgreSQL you must send an email requesting to use a different datatbase.

 

Types 0 1 2

 

Chapter 4 One star per process

Jan 29

Ch 4 (slides revised near end)

Database

 

Assignment 2 due Feb 11

Feb 5,7

Chapter 5

Chapter 6

Chapter 7

Chapter 8

 

Feb 12 @ 12:00

Review questions

Include assignments too

Example: Assignment 2 Ms Access solution

Chapter 6 banding tables

Chapter 8 types 1, 2, 3 as time permits

 

 

Feb 14

Test

Feb 26

Test returned

 

Test papers are available in 3C13

 

Feb 28+

Next topics:

Type 3 & Type 1 / 2 hybrid

Multivalued Dimensions

Assignment 3

Recursive Hierarchies (Bridge tables)

 

 

 

 

March 7

Test

March 12

Return and review test

Not present see secretary to get your test

March 14

Recursive hierarchies

Bridge tables

Nested sets

Sample database

 

 

March 19

Multivalued attributes (ch 9)

Fact table types (ch 11)

Assignments 4&5 due April 5

 

 

March 26

Factless fact tables

Aggregation

March 28

Indexes

Time-HOBI

Reference: Time-HOBI: Indexing Dimension Hierarchies by Means of Hierarchically Organized Bitmaps; Oct 2010

April 2

Time-HOBI

Reference: Time-HOBI: Indexing Dimension Hierarchies by Means of Hierarchically Organized Bitmaps; Oct 2010

 

Previous exam (and suggested answers)

UW course evaluation

April 4

No class April 4

Office hours

 

April 10: 10:00am till 3:00pm

April 11: 10:00am till noon

 

 

April 11 @ 1:30

Exam for ACS-4904

Course outline has incorrect date