Chapter 1
Cloud Architecture
Course: Comptia Cloud Cv0 004
Subject: Comptia Cloud Cv0004
Chapter: Cloud Architecture
Databases are foundational to almost every software application, system, or digital service. Understanding database concepts—such as types and deployment models—is critical for designing scalable, efficient, and maintainable systems that can meet business and technical requirements.
1. Types of Databases
Databases are fundamental components in modern software systems, and their design impacts scalability, performance, data integrity, and application architecture. The choice between relational and non-relational databases depends on data structure, workload patterns, and business requirements.
a. Relational Databases (RDBMS)
Definition: Relational databases organize data into structured tables with rows and columns. Each table enforces a schema — a predefined blueprint specifying data types, constraints, and relationships. Tables are linked using keys, enabling complex queries that combine data across multiple tables.
Core Characteristics:
- SQL-based Querying: Use Structured Query Language (SQL) as the standard for data manipulation, supporting powerful operations like joins, nested queries, transactions, and aggregations.
- ACID Compliance: Ensures reliable and consistent transactions through: