Reasons to use an SQL database
Last updated on: 2018-04-23
Authored by: Satyakam Mishra
Many businesses use both relational databases and non-relational databases. While NoSQL databases are gaining popularity due to their speed and scalability, highly structured SQL databases might be preferable in certain cases.
Prerequisite
For an introduction to relational databases and NoSQL databases, see Types of databases
Understand when a SQL database might be preferable
You might choose an SQL database for the following reasons:
-
You want to ensure ACID compliance. ACID stands for atomicity, consistency, isolation, and durability. ACID compliance reduces anomalies and protects the integrity of your database by prescribing exactly how transactions interact with the database.
-
Your data is structured and unchanging. If your business isn’t experiencing significant growth that would require additional servers and you’re only working with data that is consistent, then an SQL database might be adequate.
Next step
Reasons to use a NoSQL database
©2020 Rackspace US, Inc.
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License
