CS634: Architecture of Database Systems

Department of Computer Science

UMass Boston

Spring 2014: MW 7:00-8:15 PM in M-2-209


Offered by: Elizabethm (Betty) O'Neil
email: eoneil@cs.umb.edu
Office: S-3-169


Description

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

Special topics for S14: Data warehousing, big data


Assignments

hw1 due Wednesday, March 5, in class and in your cs634/hw1 directories.  Relationships, Disks, Creating and Loading Databases, Indexes hw1 Solution
hw2 due Monday, March 14, in class. Hash indexing, Queries, Sorting, Cost Estimates hw2 Solution
hw3 due Monday, Apr. 28, in class. Query Processing, Concurrency Control 
hw3 Solution 
hw4, due Wednesday, May 14, in class. Crash Recovery, DW and Decision Support hw4 Solution


Course Notes/Slides
Mon., Jan 27 notes Intro, Review of integrity constraints: PKs, FKs
Wed., Jan 29 pdf pptx Review of Integrity constraints, E-R translation to tables, practical normalization
Mon, Feb. 3 pdf pptx Chap. 9: Disks and Files (createdb.sql handout) Also see link for load scripts below.
Wed., Feb 5 University closed because of snow storm.
Mon, Feb. 10 pdf pptx RAID in practice, Chap 8 Intro to Indexing
Wed., Feb. 12 pdf pptx I/O Cost Model, Tree Indexes
Wed., Feb. 19 pdf pptx Hash Indexes
Mon., Feb. 24 pdf pptx Managing Disk in Oracle
Wed, Feb. 26 pdf pptx Managing Disk in MySQL, Intro Queries (Chap. 12)
Mon., Mar. 3 pdf pptx Intro Queries
Wed., Mar. 5 pdf pptx External Sorting
Mon., Mar. 10 pdf pptx Evaluation of Relational Operators
Wed., Mar. 12 pdf pptx Query Optimization
Mon., Mar. 24 pdf pptx Query Optimization, Part 2
Wed., Mar. 26 pdf pptx Midterm Review
Monday, Mar 31 Midterm Exam
Wed., Apr. 2 pdf pptx Intro to Concurrency ControlMon., Apr. 7 pdf pptx Concurrency Control
Wed., Apr. 9 pdf pptx Concurrency Control, cont.
Mon., Apr. 14 pdf pptx Concurrency Control, part 3  Transfer.java (with retry on deadlock or serialization error)
Wed., Apr. 16 pdf pptx Recovery
Wed., Apr. 23 pdf pptx Recovery, part 2
Mon., Apr. 28 pdf pptx Data Warehousing and Decision Support
Wed., Apr. 30 pdf pptx Data Warehousing and Decision Support, part 2: Partioning
Mon., May 5 pdf pptx Data Warehousing and Decision Support, part 3: MVs
Wed., May 7 pdf pptx Big Data and MapReduce
Mon., May 12 Class Cancelled
Wed., May 14 pdf pptx Last class: Final Review, teacher eval's

Final Exam Friday May 23, 1:30-4:10, room TBA (meet at M-2-209, our usual classroom)


Resources:

Oracle CS430 Oracle setup instructions We are using version 10g.  Oracle 10g documentation (SQL)
Mysql: MySql Setup We are using version 5.1. docs (SQL)
DB2 v9.5 (SQL)

 Load scripts for text's sample tables, Oracle and mysql. These are also available in directory /data/htdocs/cs634/tables in the UNIX/Linux filesystem.
Visual Explain for DB2
Example of MS Sql Server visual explain plan