Database architecture

Database architecture

The database architecture is the set of specifications, rules, and processes that dictate how data is stored in a database and how data is accessed by components of a system.

Basic Client-Server Architectures

* Specialized Servers with Specialized functions
  * Clients
  * DBMS Server

   * File Servers
   * Printer Servers
   * Web Servers
   * E-mail Servers

Clients

Provide appropriate interfaces and a client-version of the system to access and utilize the server resources. 

Clients maybe diskless machines or PCs or Workstations with disks with only the client software installed.

Connected to the servers via some form of a network.(LAN: local area network, wireless network, etc.)

DBMS Server

* Provides database query and transaction services to the clients.

* Some times called query and transaction servers.

Database architecture divided into two types

Logical 2 tier client server architecture

Logical 3 tier client server architecture

Two tier client server architecture

*Is used for user interface programs and application programs that run on client side.

Three tier client server architecture

This is used in web application