jiloliquid.blogg.se - Acid properties database

ACID PROPERTIES DATABASE SOFTWARE

For the purposes of this blog, we‘re going to focus on MySQL and its associates (Percona Server and MariaDB.) Don’t get discouraged, though – ACID works in pretty much the same way in all database management systems that support it – be it SQL Server, SQLite, PostgreSQL, or MySQL and the advice contained in this blog can be twisted and applied to other database management systems if necessary.īefore moving on to the more detailed explanation of the ACID properties, though, know this – the only storage engines that support the ACID model within MySQL are InnoDB and XtraDB (which is the same as InnoDB, but with a couple of Percona-made enhancements. The way ACID works, though, depends on the database management system that is being used – different database management systems deal with the concept in their own ways. Ever been in a situation where you‘re importing data into a table and your internet goes out for a couple of minutes? What about electricity going out for a minute or two? Without ACID compliance, such things would disrupt your database and the data within – with ACID, you would simply have to cancel (terminate) the transaction in question, then start anew until it‘s finished – no damage to your database instances would be inflicted. In other words, ACID in database management systems is a set of database properties that guarantee data integrity in the event of interruptions that affect data-related operations. D stands for Durability – durability in many database management systems refers to a log file that tracks all of the changes to the database.

I stands for Isolation – isolation means that one transaction is “isolated” (cannot be affected) by the results of other transactions.

C stands for Consistency – consistency is usually handled by the logging mechanisms inside of the database which records all of the changes to the database.

A stands for Atomicity – atomicity ensures that the statements in a given transaction operate as an indivisible unit and that their effects are either seen collectively or not at all.

In the database circles, ACID transactions are broken down in the following way:

ACID PROPERTIES DATABASE SOFTWARE

Software engineers working on ACID-compliant databases spare themselves from problems occurring to their data when a transaction gets interrupted. In these circles, acid is known as ACID – it‘s a set of four distinct database properties that make work with databases what it is today. For software engineers working with databases, acid has a completely different meaning. For some, though, acid has a different meaning – enter the world of software engineering. For those who make food, it‘s a known substance – citric acid is vitamin C, fizzy drinks contain acid, lemon juice contains citric acid, and so on.