CS634: Architecture of Database Systems

Department of Computer Science
UMass Boston

Spring 2018: MW 5:30-6:45 in M-3-204

Offered by: Elizabeth (Betty) O'Neil
email: eoneil@cs.umb.edu
Office Hours: MW 3:45-5:15 and by appointment, in S-3-169
Grader: JohnPaul Kambazza (jkamby at cs.umb.edu)


See the course syllabusPrerequisite:  CS430/630 or experience with database and my permission.

Student Information sheet, with list of essential skills needed for this course

Special topics for S18: Using the cloud to run your own mysql installation on Linux, big dat


Homework 1 due Monday, Feb. 5 in class, on paper. Relationships, Creating and Loading Databases, Generated PKs (15 points) Solution (user/pw in email)
Homework 2 due Wednesday, Feb. 21 in class, on paper. Intro to Indexes (20 points) Solution
Homework 3 due Monday, Mar. 5 in class, on paper, plus site in Google cloud. Being a DBA in a cloud VM, Indexing, Intro Query Evaluation (20 points) Solution
Homework 4 due Mon., Mar. 26 in class, on paper. Query Operators and Query Plans (20 points) Solution
Homework 5 due Wed., April 18 in class, on paper. Transactions, Locking, MariaDB in the Cloud Solution
Homework 6 due Mon., May 7 in class, on paper. Docker containers, Crash Recovery, Multidimensional Data  Solution

Course Notes/Slides: 6pp means format of six slides per page

Mon, Jan. 22 slides (6pp) Intro
Wed., Jan. 24 slides (6pp) Integrity Constraints, Relationships
Mon., Jan. 29 slides (6pp) Normalization, Generated Keys, Disks, RAID (Chap. 9)
Wed., Jan. 31 slides (6pp) RAID in Practice, Intro to Indexing (Chap. 8)
Mon., Feb. 5 slides (6pp) I/O Cost Model, Tree Indexes (Chap. 10)  
Wed., Feb. 7 slides (6pp) Bench Table Example, Hash Indexes (Chap. 11)
Mon., Feb. 12 slides (6pp) Oracle Tablespaces, etc,: Managing the Disk Resource (now with info from Rick Martin in slides 8-9)
Wed., Feb. 14 slides (6pp) Disk, Memory Resources, Intro to Query Processing
Mon., Feb. 19 Holiday
Wed., Feb. 21 slides (6pp) Query Processing Overview (Chap. 12)
Mon., Feb. 26 slides (6pp) External Sorting (Chap. 13)
Wed., Feb. 28 slides (6pp) Evaluating Relational Operators (Chap. 14)
Mon., Mar. 5 slides (6pp) Query Optimization (Chap. 15)
Wed., Mar. 7 Campus closed by bad weather, no class
Mon., Mar. 19 finish Query Optimization (Chap. 15), slides (6pp) Query Optimization in Practice
Wed., Mar. 21 Campus closed by bad weather, no class, turn in hw4 on Mon., Mar. 26
Mon., Mar. 26 slides (6pp) Midterm Review
Wed., Mar. 28 Midterm Exam Practice Midterm Exam Solution
Mon., Apr. 2 Midterm exams returned, slides (6pp) Query Optimization in Practice
Wed., Apr. 4 slides (6pp) Intro. Transactions (Chap. 16)
Mon., Apr. 9 slides (6pp) Concurrency Control, part 1 (Chap. 17)
Wed., Apr. 11 slides (6pp) Concurrency Control, part 2
Mon., Apr. 16 Holiday
Wed., Apr. 18 Crash Recovery, part 1 slides (6pp) Chap. 18
Mon. Apr. 23 Crash Recovery, part 2 slides (6pp)
Wed., Apr. 25 slides (6pp) Cloud Basics, Docker Containers
Mon., Apr.30 slides (6pp) Intro Data Warehouse Chap. 25
Wed., May 2 slides (6pp) Data Warehousing, part 2   FYI: slides (6pp) Bitmaps for the Data Warehouse
Mon., May 7 slides (6pp) Data Warehousing, part 3 slides (6pp) NoSQL DBs and BigData Trends
Wed., May 9 slides (6pp) Final Review

Mon., May 14 6:30-9:30 in M-3-204 Final Exam (try to start at 6:15) Practice Final Exam (Solution)

Piazza Class Site
Spring '16 slides, etc.
Access to cs.umb.edu Hosts Updated Feb. 1 about hosts dbs3, pe07

SQL2003 data types
Oracle:We are using version 12c on dbs3.  Oracle 12c documentation (SQL) Explain Plan Doc
SQLPlus quick guide: QuickStart  and links to other topics
Mysql: MySql Setup We are using version 5.7 on pe07.cs.umb.edu. docs (SQL)
For later in term: be the DBA of your own database in the cloud: setup instructions

SQL92 Standard

ARIES paper Basis of Chap. 18, Crash Recovery