Differences between revisions 3 and 6 (spanning 3 versions)
⇤ ← Revision 3 as of 2013-11-29 15:19:57 →
Size: 882
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 8: Line 8:

[[/TeachingNotes|Notes on teaching this course]]
Line 22: Line 24:
=== Option A === === Option 2 ===
Line 29: 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)