= Advanced Database Systems CPTR 521 =

 * Taught Even Winter Semesters
 * Prerequisites: CPTR 319, MATH 280 
 * Main Textbook: Database System Concepts 6th Ed. ISBN: 978-0-07-352332-3

See http://eclass.e.southern.edu for current course information. 

[[/TeachingNotes|Notes on teaching this course]]

== Project ==

=== Option 1 ===

Extend PostgreSQL to include a constraint layer on top of the physical one by:

 1. providing new data types
 1. providing new operators for the new data types.
    a. recursive queries
    a. join operations
    a. spatial operations
 1. Provide a native Datalog interface to PostgreSQL

=== Option 2 ===

Re-create MLPQ from the ground up one layer per project. 

 1. Modeling constraint data in general and as specialized types.
 1. Storing and retrieving the physical data from files - strategy 
 1. Interface that accepts index Plugins different types of indexes

=== Option 3 ===

In 2014 we opted talk about spatial database systems and worked through GeographicInformationSystems. 

See https://www.bingmapsportal.com/Report/Usage to get Bing maps key/usage.