Advanced Database Systems

Required Text Books


Advanced database systems covers topics taken from relational, spatial temporal and constraint databases and may include data modeling, storage, indexing, query processing/optimization, transactions, concurrency data warehousing, information retrieval and Issues related to business intelligence.

Goals, Purpose and Objectives:

The purpose of this course is to introduce students to advanced topics in database systems useful in the real world and in research. This course builds on CPTR 319. Students will learn about storage, indexing and querying at the physical layer and the concepts related to transactions and concurrency control.

Requirements, Methods of Instruction & Grade Categories

THIS IS A READING INTENSIVE COURSE! You will be expected to read voluminous amounts of information and present certain portions of it. Your grade will be based on the following



Hand-in Policy

Grading Scale



In Person


90% - 100%



Demonstration in Person


80% - 89%





70% - 79%



Online + Demonstration


60% - 69%


< 60%


Exams will cover material from discussions, resources, and textbooks. You may be required to demonstrate a specific element of knowledge on a computer section. No collaboration on exams allowed.

Research Paper Presentations

You will be required to give a twenty minute research presentation on a published paper to be determined by the professor.


Homework always includes the READING from the chapter/resources listed to be covered that day! Each chapter will have regular assigned homework. There may be quizzes (counting in the homework category) at the beginning of class.


In case you missed it, reading is extremely important for this class. You will not be able to pass without reading the chapters assigned before you come to class. I will expect participation in class and you will be docked points in the Homework/Discussion category for not participating.


The course website contains details for your project. You will be required to hand in the code for your project and demonstrate it for class.

Computer Policy

The student is required to make use of a computer in the class. Bring a computer that can access virtual machines or run database software. A development environment is necessary for the project and links to the necessary software will be provided on eclass.

Attendance Policy

Under no circumstances are you to come and see me or attend class sick. Email or Instant Message me letting me know you won’t be in class and why. We can Google-hangout you in!

Extra Credit

There is no such thing as extra credit in a graduate class I teach.

Academic Honesty

Cheating will not be tolerated. Collaboration constitutes cheating unless specifically stated. Verified incidents of dishonesty may receive a (2. b) punishment from the catalog. The school of computing has an additional policy that enhances consequences.

Disability Policy

This class abides by the Disability Policy as stated on the school website at

AdvancedDatabaseSystems (last edited 2020-01-08 18:48:14 by scot)