CS609 Course Notes
Fall 2016

 History of Databases  8/17

Transaction Processing Concepts:
   
Transactions (Chap. 21) 8/22, 8/24
   
Concurrency Control (Chap. 22) 8/24, 8/29, 9/1
   
Schedule Recovery (Notes) 9/7
   
Eventual Consistency  9/7, 9/12
            
    Read:  Eventual Consistency Paper
   
Transactional Recovery and Checkpointing  (Chap. 23)  9/12, 9/14

Discuss homework#1 9/19

 Parallel and Distributed Databases:  
    Parallel/Distributed Databases  (Chap. 25) 9/21, 9/26

Exam Oct. 12

     CAP theorem  9/28
              
 Read:  CAP 12 years later paper  
                        Also, Greiner, Robert. "
CAP Theorem: Revisited."
                        Burgess, Mark. "
Deconstructing the 'CAP theorem' for CM and DevOps."
   
 BASE consistency  9/28
                Read:  BASE paper 

NoSQL (Not only SQL):  10/3, 10/5, 10/10
   
Introduction to NoSQL (NoSQL by Strauch)
   
        Read:
 Vector Clock paper
Review for exam, discuss HW#2 10/10
Exam 10/12
Discuss Exam 10/17
   
NoSQL continued - (partitioning, querying, storage) 10/19

Out-of-Class - 10/24 complete HW2 for submission if needed
Out-of-Class - 10/26 prepare presentation of NoSQL DB

NoSQL Presentations:
        Oct. 31:   Neo4j:  Pezhman,  KumoFS: Matthew
        Nov. 2:    DynamoDB: Ben,  Nasir: CouchDB
        Nov. 7:   Apache HBASE:  Alekhya, Cassandra:  Vidya

Query processing and Performance: 11/9
          Select operations (Indexing) and Query Optimization  -
 (Chaps. 18, 19)
         
Query Optimization (Chap. 19) 

Research Papers for Discussion:
            Nov. 14: 
Paper1, Paper2 (Pezhman, Matt)
            Nov. 16:  Paper3, Paper4 (Ben, Alekhya)

Out-of-Class Final Project Work  11/21

            Nov. 28:  Paper5  (Nasir)
            Nov. 30: 
Paper6  (Vidya) Conclusions: NoSQL

Final Exam Demo:  3:30-6 pm