Scribd
Upload
59 views1 page

SQL vs NoSQL: ACID and BASE Properties

The document compares structured, semi-structured, and unstructured data across various features such as schema, storage, querying, and flexibility. It also outlines ACID properties for SQL databases, ensuring transaction reliability, and BASE properties for NoSQL databases, focusing on availability and scalability. Key examples of each data type are provided, along with descriptions of the respective properties.

Uploaded by

Amazing Deals
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
59 views1 page

SQL vs NoSQL: ACID and BASE Properties

The document compares structured, semi-structured, and unstructured data across various features such as schema, storage, querying, and flexibility. It also outlines ACID properties for SQL databases, ensuring transaction reliability, and BASE properties for NoSQL databases, focusing on availability and scalability. Key examples of each data type are provided, along with descriptions of the respective properties.

Uploaded by

Amazing Deals
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

📍 Comparison Table: Structured vs Semi-Structured vs Unstructured

Feature Structured Data Semi-Structured Data Unstructured Data

Schema Fixed (SQL) Flexible (JSON/XML) No schema

Storage SQL Databases NoSQL, Cloud, APIs Data lakes, Cloud

Querying SQL Queries JSON Queries, NoSQL NoSQL

Examples Banking, ERP Emails, JSON APIs Videos, Social Media

Flexibility Rigid Schema Flexible & Scalable Flexible & Scable

ACID Properties in Databases

ACID properties ensure reliability, consistency, and integrity of database transactions,


especially in SQL databases.

ACID Description
A - Atomicity Transactions are all-or-nothing (either fully complete or fully fail).
C - Consistency Database remains valid before and after a transaction.
I - Isolation Transactions execute independently, avoiding conflicts.
D - Durability Data is permanently saved, even after system failures.

BASE Properties in NoSQL Databases

While SQL databases follow ACID properties for strong consistency, NoSQL databases use
BASE properties for high availability and scalability.

BASE Description
B - Basically Available System is always available, even if some data is temporarily
inconsistent.
A - Soft state Data may change over time due to eventual consistency.
S - Eventual Data becomes consistent over time, not immediately.
consistency

You might also like