DBMS
One Tier, Two Tier and Three Tier Architecture
Tier architecture describes how many machines or layers a database request passes through. One tier is local, two tier puts the application on the cli...
Database Architecture
Single tier, two tier and three tier architecture, client server design, centralised and distributed databases, and DBMS components.
4 notes
Notes
DBMS
Client Server Architecture and Database Servers
In client server architecture the database server owns the data and answers requests, while clients ask questions. Understanding what the server keeps...
DBMS
Centralised and Distributed Databases
A centralised database keeps all data at one site; a distributed database spreads it across several. The choice changes availability, performance, com...
DBMS
Inside the DBMS: Components and How a Query Flows
A DBMS is built from a query processor, a storage manager, a transaction manager and a recovery manager. Following one query through all of them is th...