GACS/ACS-4904-001
Data Warehousing
vs
Ron McFadyen, 3D21
Jan 6 |
Course Outline - wrong text listed Textbook: Star Schema, The complete reference by Adamson |
Jan 8 |
Introduction Northwind OLTP database |
Jan 13 |
Chapter 3
(type 2 updated Jan 15) |
Jan
15 |
DrillAcrossDb
(updated with 4 queries a, b, c, d Queries a and b are phase
1 Queries c and d are phase
2 Query c uses union (see
SQL view) Query d summarizes c. |
Jan 20 |
Chapter 5 conformed
dimensions Chapter 6 more on dimensions |
Jan 22 |
Assignment 1 due Send to 4904-001@acs.uwinnipeg.ca Hand in the database (OLTP tables and Star Schema tables)
with the two queries |
Jan 27 |
Review Assignment 1 – sample solution Assignment 2 –
due Feb 10 Chapter 7
Hierarchies |
Jan 29++ |
·
Types 1, 2, (3, 1/2 ß ignore for now) ·
Multi-valued dimensions/bridges · Hierarchies/bridges o Sample db
with hierarchy bridge
|
|
For Assignment 2: holidays 94 95 96 |
Feb 5 |
Test |
Feb 10 |
Review recursive hierarchies From test Nested sets a database |
Feb 12 |
TESTS
returned ß see
secretary if you were not present DRAFT …
Assignments 3,4,5 Recursive hierarchies (handout) Ch 12 Types of fact tables |
Feb 24 |
Assignment 2 marked Concerns? à see instructor |
Feb 26 |
Ch 12/14 Factless and
Pivoted fact tables Assignments
3, 4, 5 |
Mar 2 |
HOBI-TI (handed out; available at https://dl.acm.org/) 20xx exam HOBI is
not covered on Mar 4 test |
Mar 9 |
Ch 8 (revised) Types 1, 2, 3,
1/2 |
Mar 11 |
Return & review tests Not present à see ACS secretary for test Average: 30.7/40 Median: 31.5/40 3 students 40/40 |
Mar 16++ |
Please review – let me know of any
errors |
Mar 18 |
No office hours HOBI and
Time-HOBI slides ·
would have covererd during a class |
Mar 23 |
vs Possible Letter
Grades Ch 17: Extract
Transform Load (ETL) Loading data incrementally into a
star |