CSCI432 – Summer 2017 – Syllabus

Instructor

Aspen Olmsted
Course website : http://blogs.cofc.edu/olmsteda
Tel: 843.953.6600
Email: Please use olmsteda@cofc.edu with Subject = CSCI432
Office: Harbor Walk East 315
Office hours: Via Email

Class place and time

Online – Asychronous

Catalog description

CSIS 432 Concepts of Database Implementation –

A course to study aspects of the implementation of some of the concepts from CSCI 332. Topics include file organization on secondary storage devices, buffer management, B-trees, hash tables, join algorithms and query from an advanced standpoint: device management, physical database design, query processing, and optimization. Lectures three hours per week.

Prerequisites: CSCI 332, MATH 307.

Course Outcomes

1. Have mastered the concepts of physical data organization including B-Trees, Graphs, Hash Tables, Bitmap , and Multidimensional
2. Have mastered the concepts of parallel and distributed databases including the map-reduce parallelism framework, data replication and distributed query processing
3. Be familiar with query compiler technology including parse trees, logical query plans and physical query plans.
4. Understand methods of handling system failure including undo/redo logs and data redundancy
5. Have mastered the concepts of concurrency control including locking and timestamp algorithms and transaction management including serializability and deadlocks

Required text

Database Systems Complete Book, 2nd Edition, ISBN-9780131873254 , Prices Range from $95 (Used) to $172.20 New Hard Cover)

Online Lectures

I have recorded a series of lectures have been recorded and available to you online at oaks.cofc.edu

Lecture Topic Book Reading Online Quizzes
1 Introduction
2 Hardware 13.1, 13.2, 13.4 13B, 13C
3 File and System Structure 13.3 13A
4 File and System Structure 13.5-13.8 13D
5 Indexing and Hashing 14 14A,14B
6 Indexing and Hashing 14 14C,14D
7 Indexing and Hashing/ Query Processing 14 15A
8 Query Processing 15 15B,15C
9 Query Processing 16 16A-16C
10 Crash Recovery 17 17A
11 Crash Recovery 17 17B-17C
12 Concurrency Control 18 18A,18B
13 Concurrency Control 18 18C
14 Concurrency Control 18 18D
15 Transaction Processing 19 19A,19B
16 Transaction Processing 19 19C,19D

Grading Scale

100-92 (A); 91-89 (A-); 88-86 (B+); 85-82 (B); 81-79 (B-); 78-76 (C+); 75-72 (C); 71-69 (C-); 68-62 (D); else (F)

Evaluation schedule

80% Online Quizzes
20% Virtual Presentation

Quizzes/Labs

Please use token (BABE3750)  to enroll in http://www.newgradiance.com.  Each week there will be several quizzes in the system.  You can take the quizzes anywhere you have internet access. You are allowed to retake each quiz up to 3 times, but you must wait 60 minutes between each take.  The questions change with each take.  I will count the last one you took per quiz.  Each quiz has a due date and after the due date full explanations will be available for every question. Once the due date has reached the quiz will not be available for retake.

Virtual Presentation

All student will produce a PowerPoint presentation (not more than 10 slides) with audio, which will be uploaded on youtube.  The presentation will be on a research paper for a topic we cover in class. The presentation should be between 10 to 12 minutes.

Classroom disruption

Please read the College of Charlestons Student Code of Conduct. When you come to class please turn off your cell phones and all other electronic communication devices. I do encourage discussion so if you have a question do not hold back from interrupting me if you are afraid I have moved on. If it is something I will talk about a little later, I will note it on the board so we do not forget.

Disabilities

If you have a documented disability and are approved to receive accommodations through SNAP Services, please contact me.

Student Honor Code

I expect you to abide by the Honor Code and the Student Handbook: A Guide to Civil and Honorable Conduct. If you have a question about how to interpret the Honor Code, ask before acting! I encourage collaboration, but you must document it. Thus, each student will submit their own homework and, when collaborating, provide a reference to those people and documents consulted.