CS448: Introduction to Database Systems

Home | Syllabus | Schedule | Homework, Projects, & Handouts | Readings

Homework, Projects & Handouts

Homework

    ***Handwritten assignments will be accepted too, but please write legibly!    ***If you cannot make it to class, please leave your assignment in my or TA's ( Mani) mailbox before the deadline. ***

• Homework 1 Due on 01/18/2018 before class.

• Homework 2 Due on 02/06/2018 before class.

• Homework 3 Due on 02/22/2018 before class.


• Homework 4 Due on 04/05/2018 before class.
  


• Homework 5 Due on 04/26/2018 before class.
  



Projects

• Project 1

• Project2
  
  

  Other Handouts

  • SQL Questions & Answers

  • Operating System Support for Database Management, Michael Stonebraker, Communications of the ACM, Volume 24 Issue 7, Pages 412-418, July 1981. [PDF]
  • The Raid Distributed Database System, Bharat Bhargava and John Riedl, IEEE Trans on Software Engineering, 15(6), June 1989. [PDF]
  
  

  Secure data warehouse & Privacy Preserving Data Dissemination

  • Talk for Secure Data Warehouse
  • Secure Data Warehouse
  • Privacy Preserving Data Dissemination

  Concurrency Control Handouts

  • 2PL and conflict graph
  
  
  • Locking-Serializability
  
  
  • Optimistic-time stamps-Failure-Commitment
  
  
  • It will help you learn about CC ideas on 2PL, optimistic, time stamps) and about transaction failures and help you do the hm work. You may read the papers on CC under handouts https://www.cs.purdue.edu/homes/bb/cs542-11Spr/cc.pdf and check sections 2 up to 2.3.2
  
  
  • You may read slides on chapter 21 (7th edition) up to slides 21-22 and then 27-29 for answers to hm work https://www.cs.purdue.edu/homes/bb/cs448_Fall2017/lpdf/Chapter21.pdf
  
  
  • Logs, failures, serializability is discussed in slides for chapter 20 https://www.cs.purdue.edu/homes/bb/cs448_Fall2017/lpdf/Chapter20.pdf
  
  
  • Concurrency Control in Database Systems, Bharat Bhargava, IEEE Trans on Knowledge and Data Engineering,11(1), Jan.-Feb. 1999
  
  
  • The Transaction Concept: Virtues and Limitations , Jim Gray, VLDB, 1981.

  Cloud Computing

  •  Hey, You, Get Off of My Cloud, T. Ristenpart, E. Tromer, H. Shacham, S. Savage.in Proceedings of CCS 2009, pages 199Ð212. ACM Press, Nov. 2009.

  • Amazon's response to "Hey, you, get off my cloud"

  • Relational Algebra Tree-Optimizations

  Reading Material

  • Design of intelligent query systems for large databases, Bharat Bhargava, in Lecture notes in Computer Science 2005

  • ExpoDB: An Exploratory Data Science Platform, Mohammad Sadoghi, CIDR, 2017.

  
  
  

  Notes from CS641 Multimedia Database Systems

  • notes

  
  Other

  • Data Science and Prediction

  • Example of proving loss less join

  • Oracle certification exam (sample questions)

  • Big Data (Michael Stonebraker) (slides)

  • Above the Clouds: A Berkeley View of Cloud Computingpa

  • Secure Data Warehouse (slides)

  • Private and Trusted Interactions (slides)

  • PL/SQL Tutorial code

  • JDBC Tutorial code

  • Handout on SAP Software /SAP online training

  • SQL Tutorial Questions and Answers

  • Handout on Natural and Outer Joins & Relational Calculus

  • Engineering the Object-Relation Database Model in O-Raid

  • Normalization and lossless joins and FD preservations

  • The design and implementation of INGRES by Stonebraker