Let's Peek Inside The Database That You Use Everyday
Making Database Internals Easy To Grasp (+ A Look At Postgres' Internals)
A Database management system or DBMS is usually a distributed system consisting of multiple clusters that are in turn formed by database nodes. These nodes act as database servers.
These database nodes store the data and execute operations on it.
Most DBMSs usually follow a client-server model where application instances (like web applications, software, or other client tools) act as clients.
These clients interact with the database nodes/servers by typically sending queries (in the form of query languages such as SQL) and receiving results.
This communication is managed by the Transport Subsystem.
