Department of Computer Science
UMass Boston
Fall 2011: TuTh 4:00-5:15 PM in M-3-415
Offered by: Elizabethm
(Betty) O'Neil
email: eoneil@cs.umb.edu
Office: S-3-169
Description
See the course syllabus. Prerequisite: CS430/630 or experience with database and my permission.
Special topics for F11:
data warehouses, map-reduce vs. databases for data analysis, XML
generation from a database and storage in a database
Assignments
hw1 CS630
Review and CS634 Setup, due Thursday, Sept. 15 hw1 Solution
hw2 Integrity and Views, due
Monday, Sept. 26 hw2 Solution
hw3 (create_mixedup.sql
for #3) Triggers and Catalog Tables, due Wed., Oct. 12 hw3 Solution
hw4 Indexes, due Wed., Oct. 26 hw4 Solution
hw5 Queries, due Wed., Nov. 23 BufferSim.java hw5 Solution
hw6 Transactions, due Mon., Dec.
12 Transfer.java TransferTool.java hw6 Solution
Course Notes:
Tu, Sept. 6 notes Intro
Th, Sept. 8 notes Start Chap
7: Constraints
Tu, Sept. 13 notes Oracle and MySql
basics, more on Constraints
Th, Sept. 15 notes Normalization
and constraints, Alter table, start on triggers
Tu, Sept. 20 notes FKs and loading
tables, Triggers (handout)
Th, Sept. 22 notes Views, Grant
command
Tu, Sept. 27 notes System Catalogs,
start on Indexing
Th, Sept. 29 notes Disk, Files,
Tablespaces (handout)
Tu, Oct. 4 notes RAID, Tablespaces,
Tables, ROWIDs
Th, Oct 6 notes RAID for 10TB Oracle
DB, B-tree indexes
Tu, Oct. 11 notes 10TB mysql DB,
Oracle Bitmap indexes, Clustered Index Concept
Th, Oct. 13 notes Clustered Indexes
(including Oracle IOT), Partitioning
Tu, Oct. 18 notes Partitioning,
Master-detail tables, Darts in Slots (finish Chap. 8)
Th, Oct 20 notes Chap 9: Query
Optimization intro (handout
on EXPLAIN PLAN)
Tu, Oct. 25 notes Index Scans
Th, Oct. 27 notes Midterm Review
Tu, Nov. 1 notes Index Scans, cont.
(midterm postponed to Nov. 3)
Th, Nov. 3 Midterm Exam Practice
Midterm (solution)
Tu, Nov. 8 Makeup Midterm Exam
Th, Nov. 10 notes (handout) Index Scans,
Multiple Index Access
Tu, Nov. 15 notes Query Trees,
finish Index Access (will cover joins at end of term)
Th, Nov. 17 notes Transactions,
their operations, conflicts
Tu, Nov. 22 notes Serializability
and 2PL
Tu, Nov. 29 notes Locking Thm,
Deadlocks, Isolation Levels
Th, Dec. 1 notes Predicate Handling,
Recovery
Tu, Dec. 6 notes Finish Crash
Recovery, Media Recovery
Th, Dec. 8 notes Join Queries (visual plans)
Tu, Dec. 13 notes Star schema
queries, review since midterm
Final Exam Dec. 20 6:30-9:30 (try to start at 6:15) in M-1-616
Practice Final (solution)
loadcap: files for loading the
CAP database (pg. 28) into Oracle
mysql_loadcap: files for loading the CAP database into
MySql
jdbc: simple JDBC programs like those in
Chap. 5
JDBC
tutorial
JDK API
(JDBC is part of the standard JDK)