DBMS architectures
Optimization of databases

DBMS architecture defines its structure, i.e. the organization of its various components. There are several DBMS architectures, corresponding to different needs. The choice of architecture for a DBMS can have a strong influence on system operation, i.e. response times, transaction throughput, data availability or database reliability in the event of failure. It can also have an impact on the system's lifespan, i.e. its long-term evolution.

Optimization here means adapting system architecture to application requirements. The aim is to obtain the best possible data access performance, to make the system easier to use for users, and to respond to natural changes in needs, data, uses and hardware. The main criteria to be taken into account are response time (number of disk accesses, communication costs), data availability (frequency of access faults...