Database Management Systems CS 542 Fall 2012 Instructor

Database Management Systems CS 542 --- Fall 2012 Instructor: Elke Rundensteiner Email: rundenst@cs. wpi. edu http: //web. cs. wpi. edu/~cs 542/f 12 2/24/2021 Elke A. Rundensteiner -- CS 542 1

Course Information n Goal – Introduction to theory and design of database management systems (DBMSs). n Who should attend? – Interested in database systems, database application development, and database research n Scope • Database application design and development • Fundamental concepts in database theory • Internals of database management systems n Meetings – Tu/Th. : 4 pm - 5: 20 pm at HL 202 – Office Hours : As posted on course page. 2/24/2021 Elke A. Rundensteiner -- CS 542 2

Contact and Communication n You will be registered in: cs 542 - I’ll say -- @cs. wpi. edu You can register yourself via majordomo 2/24/2021 Elke A. Rundensteiner -- CS 542 3

Textbook n Raghu Ramakrishnan and Johannes Gehrke DATABASE MANAGEMENT SYSTEMS Mc. Graw-Hill Publisher, Third Edition n Used copies are available ! n Book site – http: //www. cs. wisc. edu/~dbbook/ – Useful on-line solutions on some problems. – Useful project sample code 2/24/2021 Elke A. Rundensteiner -- CS 542 4

Course Material n http: //web. cs. wpi. edu/~cs 542/f 12 + lecture overheads + homework assignments + project guidelines and due dates 2/24/2021 Elke A. Rundensteiner -- CS 542 5

Optional Readings n n n n 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, 2 nd Edition H. F. Korth, and A. Silberschatz, Mc. Graw-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 -- CS 542 2/24/2021 Volume 1, J. D. Ullman, Computer Science Press, 6

Grading Policy n Final grades based on 100 points: – 20 points: Assignments (maybe Quizzes) – 40 points: Exams (Midterm: 20 pts, Final: 20 pts) – 30 points: Course Project (Report, Presentation, and Demonstration) – 10 points: Research Study/Presentation – tba. 2/24/2021 Elke A. Rundensteiner -- CS 542 7

Project Grading n n n n 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 2/24/2021 Elke A. Rundensteiner -- CS 542 8

Cheating and Late Policy n 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. n 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 -- CS 542 2/24/2021 9

Rough Time Schedule n 8/23: Organizational meeting (TODAY) n 9/18: Project Intent due n 10/2: Project Proposal due n 10/23: Midterm Exam n 11/6: Project Progress Report n 12/4: Final Exam n 12/11 -13: Final Projects (in class demos) 2/24/2021 Elke A. Rundensteiner -- CS 542 10