DATABASE ARCHITECTURE
it's the design, structure, and organization
of a database system
and determines how data is stored, accessed, and managed
DATABASE ARCHITECTURE
What are the three-tier architecture model?
•Presentation Tier
•Application Tier
•Data Tier
It's the user interface layer. Handles user interaction.
Examples:
•web browsers
•mobile apps
•desktop applications.
Presentation Tier
•Also known as the middle tier or logic tier.
•Contains the business logic that processes user
requests and interacts with the database.
Application Tier
•The database layer.
•Manages data storage and retrieval.
Examples:
•MSQL
•MySQL
•Firestore
DATA TIER
The front-end application that interacts with the user and sends requests to the server.
Examples: web browsers, desktop applications.
Client
The back-end system that processes client requests and interacts with the database.
Server
•All data is stored and managed in a single location.
•Easier to manage and maintain but can be a single point of failure.
Examples: a single server or data center
Centralized Database Architecture
•Data is distributed across multiple locations or nodes.
•Provides better availability, fault tolerance, and
scalability.
Examples: cloud databases, geographically
distributed databases.
Distributed Database Architecture
•Data is stored in the cloud and managed by cloud service
providers.
Examples: Amazon RDS, Google Cloud SQL,
Microsoft Azure SQL Database.
Cloud storage
•Database as a Service (DBaaS) allows users to use database services without managing the underlying infrastructure.
Examples: Amazon DynamoDB, MongoDB Atlas
Cloud Services
•refers to the entire system in which a
database operates
•includes all the hardware, software, and
associated resources necessary to create,
manage, and interact with a database
system.
Database Environment