6.893
Architecture of Database Systems
Topic Outline
- 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
- Implementation of Relational DBMS (6 lectures)
Query optimization
Transaction processing - tried and true plus new ideas
Access methods
Buffer management
Parallelism
- Object-relational extensions (2 lectures)
User-defined functions
User-defined operators
Query optimization revisited
- Object-oriented implementations (1 lecture)
Pointer-swizzling
Virtual memory techniques
- Warehousing (2 lectures)
Model and ETL
Metadata management
Cubes
Visualization
Data mining
- Federated DBMS (3 lectures)
Semantic heterogeneity
Local autonomy
Query optimization
Adaptors
Federated DBMS as general middleware
- Data Base Machines (2 lectures)
Diary of failed ideas
- Benchmarking DBMSs (1 lecture)
How to lie with numbers
Why benchmarks are hard
- Web applications and DBMS (3 lectures)
Three tier computing
Net markets
Supply chain automation
caching
- Visiting firemen (2 lectures)
- Niche Markets (5 lectures)
GIS
Time series DBMS
Media asset management
Really big stores
Main memory DBMS
- What's next (2 lectures)
What's hot
What's not
- slop(4 lectures)