DBMS Architecture Flashcards
It is a user machine the provides user interface capabilities and local processing
Client
This DBMS combines everything into single system, including DBMS software, hardware, application programs, and user interface processing software. In this DBMS, user can still connect through a remote terminal, however, all processing is done at centralized site
Centralized DBMS
It may be diskless machines or PC’S or Workstations with disks with only the client software installed.
Client
It is connected to servers via some form of a network
Client
This type of client is dependent of another machine (e.g., server) to complete a process.
For example: Online ticket booking systems
Thin Client
This type of client can provide functionality independent of the server
Thick Client
These are server with specialized functions. Clients can access these servers as needed.
Print Server
File Server
Web Server
Email Server
DBMS Server
Specialized Servers
It is a system that contains both hardware and software that can provide services to the client machines such as file access, printing, archiving, or database access.
Server
In the two tier Client service architecture, which approach is when client contains the user interface and application program while the server contains the DBMS.
1st Approach
In the Two Tier Client-Server Architecture, this approach is where the DBMS was divided into client and server. Client may handle user interface, application programs, data dictionary function, DBMS interactions with the compilers, query optimizers, etc. The server may include software responsible for handling data storage or disks, buffering of disk pages. Also known as data server
2nd Approach
What type of Client-Server Architecture is when client communications with the application server through a form’s interface?
-> The application server stores the business rules (procedures) that are used to access data from the database
-> The database server will provide the data
Three Tier Client Service Architecture
The three tier enhances what by making database server only accessible via middle tier and client cannot directly access database server
Security
