Transcript Introduction to Database Systems

Database Management Systems
CS 542 --- Fall 2012
Instructor: Elke Rundensteiner
Email: [email protected]
http://web.cs.wpi.edu/~cs542/f12
4/8/2016
Elke A. Rundensteiner -- CS542
1
Course Information

Goal
– Introduction to the theory and design of database
management systems (DBMSs).

Who should attend?
– Interested in database systems, database
application development, and database research

Scope
• Database application design and development
• Fundamental concepts in database theory
• Internals of database management systems

Meetings
– Tu/Th.: 4pm - 5:20 pm at HL 202
– Office Hours : As posted on course page.
4/8/2016
Elke A. Rundensteiner -- CS542
2
Contact and Communication

You will be registered in:
cs542 - I’ll say -- @cs.wpi.edu
You can register yourself via majordomo
4/8/2016
Elke A. Rundensteiner -- CS542
3
Textbook

Raghu Ramakrishnan and Johannes Gehrke
DATABASE MANAGEMENT SYSTEMS
McGraw-Hill Publisher, Third Edition

Used copies are available !

Book site
– http://www.cs.wisc.edu/~dbbook/
– Useful on-line solutions on some problems.
– Useful project sample code
4/8/2016
Elke A. Rundensteiner -- CS542
4
Course Material

http://web.cs.wpi.edu/~cs542/f12
+ lecture overheads
+ homework assignments
+ project guidelines and due dates
4/8/2016
Elke A. Rundensteiner -- CS542
5
Optional Readings








Understanding the New SQL: A Complete Guide J.
Melton and A. R. Simon, Morgan-Kaufmann, 1993.
A Guide to the SQL Standard (third edition) C. J.
Date and H. Darwen, Addison-Wesley, 1994.
Database Systems Impl. by Hector Garcia-Molina,
Jeff Ullman and Jennifer Widom, (Prentice-Hall)
A First Course in Database Systems, by Ullman and
Widom, (Prentice-Hall, 1999)
Fundamentals of Database Systems R. Elmasri, and
S. Navathe, Benjamin Cummings, any edition.
Database System Concepts, 2nd Edition H.F. Korth,
and A. Silberschatz, McGraw-Hill, any edition.
A First Course in Database Systems, J. Widom and
J. D. Ullman, Prentice-Hall, 1997.
Principles of Data and Knowledge Base Systems,
Elke A. Rundensteiner -- CS542
4/8/2016
Volume
1, J.D. Ullman,
Computer Science Press,
6
Grading Policy

Final grades based on 100 points:
– 20 points: Assignments (maybe Quizzes)
– 40 points: Exams (Midterm: 20pts, Final: 20pts)
– 30 points: Course Project (Report,
Presentation, and Demonstration)
– 10 points: Research Study/Presentation – tba.
4/8/2016
Elke A. Rundensteiner -- CS542
7
Project Grading







the difficulty of the project you have chosen
solution approach, design and
implementation
the oral project presentation
the written documentation of your project
successful completion of your intended
(even if later modified) project goals
the demonstration of your system (including
successful example runs)
the understanding of each team member of
his or her part of the project
4/8/2016
Elke A. Rundensteiner -- CS542
8
Cheating and Late Policy

NO CHEATING!
– All work is to be done on an individual basis;
unless otherwise indicated.
– No violation of the WPI's guidelines for academic
integrity.

Late Penalty
– One penalty-free late turn-in, as long as approved
by instructor.
– Turned in within the first 24 hours after the due
date: subtracting 30% of the total achievable
points of that deliverable
– Between 24 to 48 hours late: reduction of 70% of
the total achievable points.
– Certain deliverables may not have ANY LATE
day, as announced.
Elke A. Rundensteiner -- CS542
4/8/2016
9
Rough Time Schedule
8/23: Organizational meeting (TODAY)
 9/18: Project Intent due
 10/2: Project Proposal due
 10/23: Midterm Exam
 11/6: Project Progress Report
 12/4: Final Exam
 12/11-13: Final Projects (in class demos)

4/8/2016
Elke A. Rundensteiner -- CS542
10