Chapter 1
Query Processing and Optimization
Algorithms for executing relational operations
medium • 1 min read
Evaluation of expressions and pipelining
medium • 2 min read
Heuristic and cost-based query optimization
medium • 3 min read
Materialized views and query execution plans
medium • 4 min read
Optimization algorithms (dynamic programming, genetic)
medium • 5 min read
ACID properties and schedule serializability
medium • 1 min read
Lock-based protocols (2PL, Strict 2PL)
medium • 2 min read
Timestamp-based and validation-based protocols
medium • 3 min read
Multiple granularity locking and deadlocks
medium • 4 min read
Advanced recovery mechanisms (ARIES algorithm)
medium • 5 min read
Chapter 3
Parallel and Distributed Databases
Inter-query and intra-query parallelism
medium • 1 min read
Data partitioning and parallel join algorithms
medium • 2 min read
Distributed database architectures and fragmentation
medium • 3 min read
Distributed query processing and optimization
medium • 4 min read
Distributed transactions and Two-Phase Commit algorithm
medium • 5 min read
Chapter 4
Object-Oriented and XML Databases
Object-Relational mapping and ODBMS design
medium • 1 min read
Complex data types and inheritance in databases
medium • 2 min read
XML data models and querying (XPath, XQuery)
medium • 3 min read
Stating constraints in XML DTDs and Schemas
medium • 4 min read
Transforming XML to relational data
medium • 5 min read
Chapter 5
NoSQL and New Database Trends
CAP theorem and BASE properties
medium • 1 min read
Key-value stores, Document stores, Column-family stores
medium • 2 min read
Graph databases and Cypher query language
medium • 3 min read
Data warehousing, OLAP, and Star schemas
medium • 4 min read
In-memory databases and column-oriented databases
medium • 5 min read