CS448: Introduction to Database Systems

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

Homework, Projects & Handouts

Homework

• Homework1 Due 09/09/2016 before class.

• Homework2 Due 09/26/2016 before class.

• Homework3 Due 10/14/2016 before class.


• Homework4 Due 11/18/2016 before class.
  

   
***Handwritten assignments will be accepted too, but please write legibly!   

***If you cannot make it to class, please leave your assignment in the TA's mailbox or email before the deadline.

Projects

• Project1 Due Sep 9, 2016 at 11:59 pm

• Project2 (Slides) Due Oct 14, 2016 at 11:59 pm

• Project3 Due November 30, 2016 at 11:59 pm

Other Handouts





Cloud Computing

• 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.

•  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

Other Reading Material

• 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