Database Management Systems CS 542 — Fall 2009 Instructor: Murali

Database Management Systems CS 542 --- Fall 2009 Instructor: Murali Mani Email: [email protected] http://www.cs.wpi.edu/ cs542/f09 01/14/23 Murali Mani -- CS542 1

Contact and Communication Mailing list of all students instructor [email protected] 01/14/23 Murali Mani -- 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 – Tuesday: 6:00 pm - 8:50 pm at FL-320 – Office Hours : After class M 10:00 – 11:00 am 01/14/23 Murali Mani -- CS542 3

Textbook Raghu Ramakrishnan and Johannes Gehrke DATABASE MANAGEMENT SYSTEMS McGraw-Hill Publisher, Third Edition The book is available in WPI bookstore. Book site – http://www.cs.wisc.edu/ dbbook/ – Useful on-line solutions to some problems. 01/14/23 Murali Mani -- CS542 4

Course Material http://www.cs.wpi.edu/ cs542/f09 lecture overheads homework assignment project due dates 01/14/23 Murali Mani -- 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: The Complete Book by Hector Garcia-Molina, Jeff Ullman and Jennifer Widom, (Prentice-Hall) 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. Principles of Data and Knowledge Base Systems, Volume 1, J.D. Ullman, Computer Science Press, 01/14/23 Murali Mani -- CS542 6

Grading Policy Final grades based on 100 points: – 30 points: Assignments (and maybe Quizzes) – 40 points: Exams (Final: 40pts) – 30 points: Course Project (Report, Presentation, and Demonstration) 01/14/23 Murali Mani -- 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) If done as a team, the understanding of each team member of his or her part of the project 01/14/23 Murali Mani -- 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 Assignments – Late assignments will be graded, but no credit will be given – If unavoidable situations, let the instructor know WELL IN ADVANCE 01/14/23 Murali Mani -- CS542 9

Schedule – Important Dates Sep 8: Organization meeting Sep 22: Project Intent due Oct 20: Project Phase I (Design) Due Nov 10: Project Phase II (Operations) Due Dec 8: Project Phase III (Interface) Due along with in class demo, presentation Dec 15: Final Exam 01/14/23 Murali Mani -- CS542 10