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)
Description
See the course syllabus. Prerequisite: 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 data
Assignments:
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)