Functional Architecture of a Relational DBMS

Users interact with the DB using SQL commands, either by writing queries directly into an SQL interface or by embedding queries in an application.

Commands are evaluated in a query evaluation engine. First they are syntactically analyzed, then an algebraic tree is generated.

The optimizer can be used to optimize the execution path of a query's operations (since the same query can have several execution paths, the optimizer can be used to choose the best one).

Generation of a query execution plan.

The concurrent access manager module ensures that multiple users have concurrent access to the database and generates access conflicts.

The failure manager maintains a log of the various instructions running on the DB to ensure the recovery of the DB in the event of a failure.

The physical space manager generates memory and provides data storage and access.