Transcript CS4432: Database Systems II

CS4432: Database Systems II
Course Logistics
1
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.
2
Course Logistics
– Web Page: http://web.cs.wpi.edu/~cs4432/d14
•Electronic WPI system: blackboard.wpi.edu
•Lectures
– Mon. & Thurs.: (1:00pm - 2:50pm)
•Grading
3
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
4
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
5
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
6
Lectures & Exams
7
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
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
9
Project
10
SimpleDB mini DBMS
• You will use a small DBMS design for student’s
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
11
So……Take 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…
12
Needed Background
• Beginning database knowledge as
gained in CS3431 (or, job experience)
• Some knowledge of software
development (such as CS3733).
13