|
Old News and Notes
Course Materials
Project and Assignments
| Project Step 0: Team formation
|
| Postscript
| PDF
| Due: September 20 |
[September 17, 2012]
|
| Assignment 1: Critique of DB research directions
|
| Postscript
| PDF
| Due: October 2 |
[September 19, 2012]
|
| Assignment 2: Project Stage 1
|
| Postscript
| PDF
| Due: October 11 |
[October 1, 2012]
|
| Assignment 3: Individual Work: Survey topic/bibliography
|
| Postscript
| PDF
| Due: October 9 |
[October 1, 2012]
|
Assignment 4: Project proposal commentary
|
| Postscript
| PDF
| Due: November 6 |
[November 1, 2012]
| Assignment 5: NoSQL to MySQL comparative study
|
| Postscript
| PDF
| Due: November 20 |
[November 1, 2012]
|
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]
|
Reading Material
- Due: November 8 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 23 F. Chang, J. Dean, S. Ghemawat, W. Hsieh, D. Wallach, M. Burrows,
T. Chandra, A. Fikes, R. Gruber. Bigtable: A Distributed Storage System for Structured Data,
Proceedings, Eigth Symposium on Operating System Design and Implementation
(OSDI'06). PDF
- Due: October 18/23. J. Dean, S. Ghemawat,
MapReduce: Simplified Data Processing on Large Clusters,
Proceedings, Sixth Symposium on Operating System Design and Implementation
(OSDI'04), San Francisco, CA, December 2004. PDF
- Due: October 18/23. G. Copeland, S. Khoshafian, A Decomposition Storage Model,
Proceedings ACM SIGMOD 1985, pp. 268-279.
PDF
- C. Mohan, D. Haderle, B. Lindsay, H. Pirahesh, P. Schwarz,
ARIES: A Transaction Recovery Method Supporting Fine-Granularity Locking
and Partial Rollbacks Using Write-Ahead Logging,
ACM Transactions of Database Systems, Vol 17, No. 1, pp. 95 -- 162.
PDF
[October 3, 2012]
- K.P. Eswaran, J.N. Gray, R.A. Lorie, I.L. Traiger,
The Notions of Consistency and Predicate Locks in a Database System,
Communications of the ACM, Vol. 19, No. 22, pp. 624--633.
PDF
[October 2, 2012]
- Due: Thursday, September 20.
The Claremont Report on Database Research,
Communications of the ACM, Vol. 52, No. 8, 2009.
PDF.
- Due: Thursday, September 20.
Challenges and Opportunities with Big Data,
a community white paper developed by leading researchers
across the United States, 2012.
PDF
- Extra reading for September 20. 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.
September 17, 2012, dekhtyar at csc.calpoly.edu
|