FINE DIAMOND DETAIL DATABASE DESIGN

User

Remote Users can connect via the Internet to access the Database.

Internet

Possible risk social engineering and/or phishing to gain access. Unsecured Wi-Fi.

Internal Users access the Database

Firewall to prevent unauthorized access.

Possible risk social engineering and/or phishing to gain access.

The Web Server processes incoming requests via HTTP which stores, processes, and displays web pages to the users.

The Master Database with virtual storage connects to the Application Server.

It also syncs to the Slave Database for replication.

The Application Server handles the operations between the users and backend business database.

The Slave Database is the replication of the Master Database with virtual storage.

Application Server

Virtual Storage

Master DatabaseSlave Database

Possible risk, corrupt data, backup data integrity is compromised, not properly maintained database.