Differences between revisions 5 and 6
⇤ ← Revision 5 as of 2014-02-18 21:26:48 →
Size: 934
Editor: scot
Comment:
← Revision 6 as of 2014-04-01 01:46:21 → ⇥
Size: 1060
Editor: scot
Comment:
Deletions are marked like this. Additions are marked like this.
Line 24: Line 24:
=== Option A === === Option 2 ===
Line 31: Line 31:

=== Option 3 ===

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

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.

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
  2. providing new operators for the new data types.
    1. recursive queries
    2. join operations
    3. spatial operations
  3. 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.
  2. Storing and retrieving the physical data from files - strategy
  3. Interface that accepts index Plugins different types of indexes

Option 3

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

AdvancedDatabases (last edited 2014-04-02 21:37:21 by scot)