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.