Database Components
The typical database components can be seen in the following diagram. These components include the following:
- Query Engine & Interface: A translation unit that translates the query into a machine-readable language.
- Tables: Collection of rows where the actual data is stored. Tables can be accessed via the query engine.
- Schemas: Collection of tables where each schema represents a functional group of tables; for example, HR and Payroll.
- Buffer pool: A component that holds recent or intermediate transaction data in memory for optimized operation execution: