官术网_书友最值得收藏!

  • Learning PostgreSQL 11
  • Salahaldin Juba Andrey Volkov
  • 263字
  • 2021-07-02 13:11:37

ACID properties

In a relational database, a single logical operation is called a transaction. The technical translation of a transaction is a set of database operations, which are createread, update, and delete (CRUD). An example of explaining a transaction is a budget assignment to several projects in the company assuming we have a fixed amount of money. If we increase a certain project budget, we need to deduct this amount of increase from another project. The ACID properties in this context could be described as follows:

  • Atomicity: All or nothing, which means that if a part of a transaction fails, then the transaction fails as a whole.
  • Consistency: Any transaction gets the database from one valid state to another valid state. Database consistency is governed normally by data constraints and the relation between data and any combination thereof. For example, imagine if someone would like to completely purge his account on a shopping service. In order to purge his account, his account details, such as a list of addresses, will also need to be purged. This is governed by foreign key constraints, which will be explained in detail in the coming chapter.
  • Isolation: Concurrent execution of transactions results in a system state that would be obtained if the transactions were executed serially.
  • Durability: The transactions that are committed—that is, executed successfully—are persistent even with power loss or some server crashes. In PostgreSQL, this is done normally by a technique called Write-Ahead Logging (WAL). Another database refers to this as a transaction log such as in Oracle.
主站蜘蛛池模板: 宜良县| 东城区| 汝南县| 南宫市| 津南区| 城步| 青河县| 鄯善县| 剑川县| 霍山县| 天镇县| 措勤县| 武汉市| 渭源县| 莱西市| 棋牌| 汝州市| 土默特右旗| 邯郸市| 宾川县| 大连市| 蓬莱市| 灵山县| 垣曲县| 花莲市| 容城县| 吉安市| 望谟县| 宁陕县| 宁安市| 大余县| 于都县| 镇沅| 嘉定区| 辽阳县| 白城市| 山东省| 岱山县| 泰顺县| 宽城| 金沙县|