CSC 560: Advanced Topics in Databases: Modern DBMS Architectures
Fall 2014

Instructor: Alexander Dekhtyar, dekhtyar@calpoly.edu, 14-215

Office Hours:

When		Who	Where
Monday	9:30pm - 12:00pm	Alex	14-215
Tuesday	11:10pm - 12:00pm	Alex	14-215
Wednsday	10:10am - 11:00am	Alex	14-215

Additional appoinments: send email.

Final Exam Date: Thursday, December 4, 2010, 10:10 - 1:00pm

News and Notes

Course Materials

Project and Assignments

Project Step 0: Project Overview/Team formation		Postscript	PDF	Due: September 24	[September 22, 2014]
Project Step 0: DBMS Architectures		Postscript	PDF		[September 22, 2014]
Assignment 1: Critique of DB research directions		Postscript	PDF	Due: October 2	[September 22, 2014]
Assignment 2: Project Proposal		Postscript	PDF	Due: October 7	[September 13, 2014]

Lecture Notes

Lecture 1	DBMS and ACID	Postscript	PDF	[September 17, 2012]
Lecture 2	DBMS Organization Chart		PDF	[September 17, 2012]
Lecture 3	Research Challenges	Postscript	PDF	[September 19, 2012]
Lecture 4	RDBMS Organization: Storage of Data	Postscript	PDF	[September 24, 2012]
Lecture 5	RDBMS Organization: Buffer Management	Postscript	PDF	[September 26, 2012]
Lecture 6	RDBMS Organization: Concurrency Control	Postscript	PDF	[October 2, 2012]
Lecture 7	RDBMS Organization: Crash Recovery	Postscript	PDF	[October 2, 2012]
Lecture 8	Parallel Databases: Overview	Postscript	PDF	[October 17, 2012]
Lecture 9	Parallel Databases: Parallel Query Processing	Postscript	PDF	[October 17, 2012]
Lecture 10	MapReduce	Postscript	PDF	[November 6, 2012]
Lecture 11	CAP Theorem	Postscript	PDF	[October 21, 2014]
Lecture 12	Consistent Hashing	Postscript	PDF	[October 21, 2014]

Reading Material

• Due: October 2 S. Gilbert, N. Lynch. Brewer's Conjecture and the Feasibility of Consistent, Available, Partition-Tolerant Web Services, SIGACT News 33(2): 51-59 (2002). PDF

• Due: October 2 Eric Brewer. Towards Robust Distributed Systems, Invited Talk (slides) (2000), PDF

• Due: Tuesday, September 30. The Claremont Report on Database Research, Communications of the ACM, Vol. 52, No. 8, 2009. PDF.
• Due: Tuesday, September 30. Challenges and Opportunities with Big Data, a community white paper developed by leading researchers across the United States, 2012. PDF
• Extra reading for September 30. State of database research over the years:
  • 1988:Future Directions in DBMS Research. PDF.
  • 1995: Achievements and Opportunities. Postscript. PDF.
  • 1996: Strategic directions in database systems. PDF.
  • 1998: Asilomar report. PDF.
  • 2005: Lowell self-assessment. PDF.