6.893 Architecture of Database Systems

Topic Outline

  1. Data Models and Query Languages(6 lectures)
    IMS and Codasyl - DL/1 and Codasyl DML
    Relational - SQL
    Post-relational data models
    System D
    Object-Relational - SQL++
    Object-oriented - persistent C++
    XMLSchema-- XQuery
  2. Implementation of Relational DBMS (6 lectures)
    Query optimization
    Transaction processing - tried and true plus new ideas
    Access methods
    Buffer management
    Parallelism
  3. Object-relational extensions (2 lectures)
    User-defined functions
    User-defined operators
    Query optimization revisited
  4. Object-oriented implementations (1 lecture)
    Pointer-swizzling
    Virtual memory techniques
  5. Warehousing (2 lectures)
    Model and ETL
    Metadata management
    Cubes
    Visualization
    Data mining
  6. Federated DBMS (3 lectures)
    Semantic heterogeneity
    Local autonomy
    Query optimization
    Adaptors
    Federated DBMS as general middleware
  7. Data Base Machines (2 lectures)
    Diary of failed ideas
  8. Benchmarking DBMSs (1 lecture)
    How to lie with numbers
    Why benchmarks are hard
  9. Web applications and DBMS (3 lectures)
    Three tier computing
    Net markets
    Supply chain automation
    caching
  10. Visiting firemen (2 lectures)
  11. Niche Markets (5 lectures)
    GIS
    Time series DBMS
    Media asset management
    Really big stores
    Main memory DBMS
  12. What's next (2 lectures)
    What's hot
    What's not
  13. slop(4 lectures)