Domain 8Software Development SecurityADVANCED

Database Security & Application Vulnerabilities

Relational database security, ACID transaction properties, multi-level security (polyinstantiation), inference/aggregation defenses, and web application attacks (SQLi, XSS, CSRF).

Domain: Domain 8: Software Development Security•Updated: 2026-08-26
#Database Security#SQL Injection#XSS#CSRF#Polyinstantiation#ACID#Inference & Aggregation

CISSP Domain 8: Database Security & Application Vulnerabilities — Mindmap Review Study Guide

═══════════════════════════════════

PART 1: MERMAID MINDMAP

═══════════════════════════════════

mindmap
  root((Databases))
    Database Fundamentals
      Relational databases
      Database Management System
    DBMS Components
      Hardware
      Software
        MySQL
        Oracle RDBMS
        IBM DB2
        Microsoft SQL Server
        Amazon RDS
      Database
      Tables
      Rows Tuples Records
      Columns Attributes
      Fields
      Primary Keys
      Foreign Keys
      Structured Query Language
      Users
      Data
    Maintaining Data Integrity
      Concurrency
      Transactions
      Locks
      ACID Properties
        Atomicity
        Consistency
        Isolation
        Durability
    Database Attacks
      SQL Injection

═══════════════════════════════════

PART 2: TECHNICAL DEFINITIONS & CONCEPTS

═══════════════════════════════════

Database Fundamentals

Databases — Provide a means to store an organized collection of structured data in a table with rows and columns, making it easy to add, access, modify, and analyze the data.

Relational databases — Allow data in different tables to be related and connected with data in other tables based on a relational model.

Database Management System (DBMS) — A collection of components that allow the database to be controlled and used by people and processes.

DBMS Components

Hardware — The physical server that the DBMS runs on, which must provide sufficient processing power and storage space.

Software — The operating system and the DBMS software itself that runs on the operating system.

MySQL — An example of a Database Management System (DBMS) software.

Oracle RDBMS — An example of a Database Management System (DBMS) software.

IBM DB2 — An example of a Database Management System (DBMS) software.

Microsoft SQL Server — An example of a Database Management System (DBMS) software.

Amazon RDS — An example of a Database Management System (DBMS) software.

Database — The actual data store controlled by the DBMS software, which can contain one or more tables.

Tables — The structures within a database that contain rows and columns of data.

Rows — The horizontal entries in a database table.

  • Also referred to as Tuples or Records.

Columns — The vertical entries in a database table.

  • Also referred to as Attributes.

Fields — The intersection of a Tuple (row) and an Attribute (column).

  • Represents a single cell of data in the table.

Primary Keys — A unique identifier for a specific record or row of data.

  • Examples include a Social Insurance Number, Passport Number, or Student ID.

Foreign Keys — A column in a table whose values correspond to primary keys in another table.

  • Used to link and form a relationship to another table.

Structured Query Language (SQL) — The language used to communicate with and control a relational DBMS.

  • Users or processes send SQL commands to store new data, modify data, or delete data.

Users — The people or processes that send SQL commands to the DBMS to interact with the data.

Data — The final major component of a DBMS, representing all the information stored within it.

Maintaining Data Integrity

Concurrency — The ability of a modern, high-performance database to allow multiple transactions to run concurrently or in parallel.

Transactions — A unit of work that typically encapsulates several operations, including reads, writes, and acquiring locks.

Locks — A major control used to prevent data corruption when multiple transactions run concurrently.

  • A record (a tuple) can be locked so that only one user or process may update the record until the lock is released by either committing the update or rolling back.

ACID Properties — A standard set of properties that guarantee database transactions are processed reliably to ensure data integrity.

Atomicity — The “A” in ACID; means that all changes being made as part of a transaction take effect or None.

Consistency — The “C” in ACID; means updates to the database are consistent with the rules, and the rules are enforced.

Isolation — The “I” in ACID; means transactions are Invisible to other users until complete.

Durability — The “D” in ACID; means Completed transactions will not be Lost – they are durable.

Database Attacks

SQL Injection — A major type of attack where an attacker injects SQL code through a web application to control the database behind it. ⚠️ EXAM TIP: The speaker explicitly states you definitely need to understand SQL injection for the exam, and security professionals should always work to prevent it. (Referenced in Domain 3, video 4).