GACS/ACS-4904-001 Data Warehousing

 

Possible Letter Grades

vs

"S" Standing Grades

Ron McFadyen, 3D21

ron.mcfadyen@gmail.com

 

Jan 6

Course Outline - wrong text listed

Textbook: Star Schema, The complete reference by Adamson

Jan 8

Introduction

Chapter 1 / Chapter 2

Northwind OLTP database

Assignment 1

Jan 13

Chapter 3 (type 2 updated Jan 15)

Jan 15

Chapter 4

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.

Previous tests (2018Test1, 2018Test2)

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++

Chapters 8, 9, 10

        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

immediate children

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

Aggregates

Assignment 2 marked

Concerns? see instructor

Feb 26

Ch 12/14 Factless and Pivoted fact tables

indexes

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++

Term marks to date

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

 

 

 

"S" Standing Grades

vs

Possible Letter Grades

 

Ch 17: Extract Transform Load (ETL)

Loading data incrementally into a star