CS4432: Database Systems II

1
CS4432 Database Systems II

• Course Logistics

2
Textbook

• Required
• Database Systems The Complete Book, Second
  Edition
• Hector Garcia-Molina, Jeffrey D. Ullman and
  Jennifer D. Widom
• Prentice Hall, 2009.
• ISBN 9780131873254
• Other Good Books
• Database Management Systems, by Raghu
  Ramakrishnan and Johannes Gehrke, McGraw-Hill.
• Fundamentals of Database Systems, by Ramez
  Elmasri and Shamkant Navathe, Addison Wesley.
• An Introduction to Database Systems, by C. J.
  Date, Addison Wesley.

3
Course Logistics

• Web Page http//web.cs.wpi.edu/cs4432/d14
• Electronic WPI system blackboard.wpi.edu
• Lectures
• Mon. Thurs. (100pm - 250pm)
• Grading

4
H/Ws and Projects

• Homeworks (4)
• Individual effort (to assure you practice and
  know the material well)
• Projects (2)
• Team effort of two (to collaborate and have
  feedback cycles on design)
• Work inside a mini DBMS and add extensions

5
Tentative Deadlines and Late Submission Policy

• Check the website regularly
• Late Submission Policy
• One-day late ?15 off the max grade
• Beyond that, no late submission is accepted

6
Course Management

• Two systems will be maintained
• Web Page http//web.cs.wpi.edu/cs4432/d14
• Electronic WPI system blackboard.wpi.edu
• Homework/Project submissions
• Electronically on blackboard.wpi.edu
• Viewing Grades
• On blackboard.wpi.edu

7
Lectures Exams
8
Office Hours

• Posted on the course web page
• Covers most days of the week
• Make use of them they are there for YOU !

TAs
Maryam Hasan
Qingyan Wang
9
Doing well

• Exams
• Master the topics (attend lectures, homeworks,
  projects)
• Master the topics on time
• Projects
• Start early
• Need to spend time first to understand the system
  before you add your code
• Need to know Java

10
Project
11
SimpleDB mini DBMS

• You will use a small DBMS design for students
  learning (SimpleDB)
• It has basic functionalities, subset of SQL, few
  error checking
• It is written in Java
• Your task is to extend its functionality as will
  be given in the projects

12
SoTake Action

• Form teams of two in the first week and be ready
• Each team should be comfortable working with Java
• Understand, Understand, Understand.
• You must understand how things work before you
  add your code
• What you will add at the end is relatively very
  small
• You can go ahead, download it, play with it

13
Needed Background

• Beginning database knowledge as gained in CS3431
  (or, job experience)
• Some knowledge of software development (such as
  CS3733).