Description

Level and Credits

• UG 3

Prerequisites

• 660, 670

Objectives

• Mastery of the use of advanced file structures for database management systems.
• Mastery of query processing techniques.
• Mastery of transaction processing techniques for concurrency control and crash recovery.

• Familiarity with physical database tuning.
• Familiarity with distributed databases.

Meeting Times

• MWF 12:30-1:18, DL 266

Instructor

• D. S. Kerr, DL 695, 292-1519, doug@cis.ohio-state.edu
• Instructor's Office Hours: (TENTATIVE) M 11:00 - 12:00, T 4:30 - 5:30, W 10:00 - 11:00, R 5:00 - 5:30 or by appointment

Textbook

Tentative Grading Plan - Note: adds to only 90%. To be revised when I determine if there will be a grader.

Problem Sets	10%
Midterm Exam	25%
Term Paper	15%
Final Exam	40%

Tentative Sylabus

Class	Topics	Readings	Pages
1	Introduction	GM: 1	19
2-7	Data Storage and Files Structures    Data Storage    Representing Data Elements    Index Structures    More About Indexes	GM: 2 GM: 3 GM: 4 GM: 5	61 39 62 47
8-14	Query Processing and Performance    Query Execution    The Query Processor	GM: 6 GM: 7	90 92
15	Midterm
16-20	Crash Recovery    Coping with System Faiilures	GM: 8	41
21-27	Concurrency Control    Concurrency Control    More About Transaction management	GM: 9 GM: 10	68 52
28	Review

Exams

• Midterm. Wednesday, February 7
• Final. 11:30-1:18, Wednesday, March 14
• "Senior" Final. 1:30-4:18 (2 hour period), Tuesday, March 6