Database Management Systems CS 542 --- Fall 2012

1. Database Management SystemsCS 542 --- Fall 2012 Instructor: Elke Rundensteiner Email: rundenst@cs.wpi.edu http://web.cs.wpi.edu/~cs542/f12 Elke A. Rundensteiner -- CS542

2. 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. Elke A. Rundensteiner -- CS542

3. Contact and Communication • You will be registered in: cs542 - I’ll say -- @cs.wpi.edu You can register yourself via majordomo Elke A. Rundensteiner -- CS542

4. 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 Elke A. Rundensteiner -- CS542

5. Course Material • http://web.cs.wpi.edu/~cs542/f12 + lecture overheads + homework assignments + project guidelines and due dates Elke A. Rundensteiner -- CS542

6. 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, Volume 1, J.D. Ullman, Computer Science Press, Elke A. Rundensteiner -- CS542

7. 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. Elke A. Rundensteiner -- CS542

8. 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 Elke A. Rundensteiner -- CS542

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

10. 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) Elke A. Rundensteiner -- CS542