PPT Slide
Relational DBMS "Goodies"
- Relational query processing
- Queries range over tables and/or views
- Programmers use a declarative language (SQL)
- Query optimizer picks the lowest-cost query plan
- Alternative access paths, join orders, join methods, and so on (based on indices and database characteristics)
- Result: data independence
- Support for (shared) business logic
- Integrity constraints
- Check constraints, referential integrity constraints
- Triggers, stored procedures, views, authorization
- Performance and robustness
- Buffering, locking, crash recovery, replication, ...