[prev] 17 [next]

Relational DBMS Functionality

Relational DBMSs provide a variety of functionalities:
  • storing/modifying data and meta-data  (data defintions)
  • constraint definition/storage/maintenance/checking
  • declarative manipulation of data (via SQL)
  • extensibility via views, triggers, procedures
  • query re-writing (rules), optimisation (indexes)
  • transaction processing, concurrency/recovery
  • etc. etc. etc.
Common feature of all relational DBMSs: relational model, SQL.