Architecture of Relational Databases
Relational databases consist of a number of common elements:
Data store— Contains the data and is held on disk.
Database engine— Provides the core functionality of the database system, including functions used by other components of the system.
Query optimizer— Determines the most efficient access path to the data store when data is requested.
Shared memory— Holds the database buffer cache as well as caches for other frequently used data. Facilitates interprocess communication.
Logger— Records modifications to the data in a log file to preserve the integrity of the database in the event of a database or system crash.
Pagecleaners (Database Writers in Oracle terms)— Flush modified pages from the database ...
Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
