ACID: Difference between revisions
Content deleted Content added
No edit summary |
clarify Durability |
||
| (16 intermediate revisions by 12 users not shown) | |||
Line 1:
'''ACID''' is a concept used with [[Database|databases]].<ref>{{Cite web|date=2022-07-02|title=What are the ACID properties? {{!}} Data Basecamp|url=https://databasecamp.de/en/data/acids|access-date=2022-07-07|language=en-US}}</ref> It is the way some databases keep their data true and meaningful. Not all databases use the concept of ACID, but [[relational database]]s usually do.
'''ACID''' is a concept used with [[Database]]s. It is an abbreviation. It stands for▼
*''Consistency'' - The database is in a legal state at all times. When a [[transaction]] occurs, it can not break the rules. These rules are about ''integrity'', what is allowed and what is not allowed in certain locations of the database.▼
[[Category:Databases]]▼
*''Atomicity'' - A change to the data in the database is either done completely, or not done at all. The process of doing it is not visible to users of the database. Users (people and [[computer program|programs]]) only see the result.
▲*''Consistency'' -
*''Isolation'' - There can be more than one transaction occurring at the same time. Isolation means that one transaction can only see the changes of another transaction at the right time. Sometimes isolation means that transactions happening at the same time would do the same thing if they were done one after another.
*''Durability'' - When a transaction is done, if the result is unwanted it can be rolled back, which means it is made to go away as if it never happened. If the result of a transaction is still wanted, it can be committed, which makes the change permanent. After a transaction is committed, the change it made will still be there even if the database is shut down.
== References ==
<references />{{tech-stub}}
| |||