Chapter 4

Database Security Introduction

ACID, BASE of DB, and CIA Compliance

Modern databases (DBs) have moved beyond basic tables and simple Structured Query Language (SQL) versions of simple Excel sheets and tables. Now a DB can have tables, relations, XML data, JSON objects, and more. However, the basic idea behind a DB still remains as the ACID principles: atomicity, consistency, isolation, and durability. ACID is the gold standard for databases that use a relational structure. Databases called “noSQL” databases follow the BASE principles: basically available, soft state, and eventually consistent.

Since security is important for databases and their applications, the transactions that happen on a DB must conform to the basic security triad ...

Get Database and Application Security: A Practitioner's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.