Relational Database Systems 2

• Architecture
  • Definition Database
  • Definition DBMS
  • File Systems as Database
  • Characterstics of DB
  • Data Models
  • DBMS Meta-data
  • ANSI/SPARC 1975 Architecture
  • DBMS System Structure
  • Components
  • DBMS Quality (TPPC)
• Physical storage
  • Storage Media
  • Indexing
  • Trees
• Query processing
  • Query Processor
  • Query Parser
  • Query Translator (cf. VL 06)
  • Operator execution (cf. VL 06)
  • Relational Algebra
  • Query Execution
• Query optimization
  • Query Optimizer
  • Pipelining
  • Algebraic query rewriting
  • Cost-based optimization
  • SQL EXPLAIN
  • Query Plan generation
  • Heuristic optimization
  • Optimizer hints
  • Join Trees
• Transaction processing
  • Transaction
  • Page Model
  • Transaction Manager
  • Schedule
  • Scheduler
  • Deadlocks
  • Altruistic Locking
  • Predicate Locking
  • Non-Locking Schedulers
  • Locking Protocols
  • Lock Implementation
  • Transaction Recovery
  • Recovery concepts
  • Recovery components
  • Recovery without logs
  • Recovery with logs
  • Recovery protocols
  • Catastrophic recovery
  • Application Recovery
• Security
  • Security
  • Security: Measures
  • Access Control: Access policy + limitation
  • SQL Injection
  • Anonymization
  • Statistical security
  • Inference protection
• Privacy
  • Privacy
  • Privacy: Risks + Protection
  • k-Anonymity
  • L-Diversity
  • Sparse data: Deanonymization
  • Social Networks