What is deployment topology?
The arrangement of hardware, software, and network components in a system
What factors influence deployment topology choice?
Scalability, performance, reliability, application type
What is single-tier architecture?
All components run on one machine
What components exist in single-tier architecture?
User interface, application logic, database
Give one disadvantage of single-tier architecture
Poor scalability or security
What is two-tier architecture?
Client-server architecture
What are the two layers in two-tier architecture?
Client layer and server layer
Where is the database in two-tier architecture?
On the server tier
How does the client connect to the database?
Using database APIs or drivers such as JDBC or ODBC
What is DBMS?
Database Management System
Name three DBMS layers
Data access layer, database engine layer, storage layer
What is three-tier architecture?
Client, application server, and database server layers
What does the presentation layer do?
Provides the user interface
What does the application layer do?
Handles business logic and communication with the database
Why is three-tier architecture used in production?
Better security, scalability, and performance
Why is direct access to database servers restricted?
Security, performance, maintainability
What is cloud-based database deployment?
Database hosted in a cloud environment
Give one advantage of cloud databases
Accessible anywhere, no installation, scalable
What is required to access a cloud database?
Internet connection
Where is the application server in cloud deployment?
In the cloud environment
Which topology is most secure for enterprise use?
Three-tier or cloud-based architecture
What is distributed database architecture?
A database system using multiple machines to share storage and processing
Why use distributed databases?
Scalability, high availability, fault tolerance, performance
