Durability - Deepstash

Durability

Durability is the property which guarantees that transactions that have committed will survive permanently. For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes.

STASHED IN:

6

STASHED IN:

0 Comments

MORE IDEAS FROM ACID properties

Transactions are often executed concurrently. Isolation ensures that concurrent execution of transactions leaves the database in the same state that would have been obtained if the transactions were executed sequentially. There are four layers: read uncommitted, read committed, repeatable reads and serializable. In PostgreSQL the default one is READ COMMITED, meaning that when a transaction runs on this isolation level, a SELECT query sees only data committed before the query began and never sees either uncommitted data or changes committed during query execution by concurrent transactions.

STASHED IN:

6

The ANSI/ISO standard SQL 92 refers to three different read phenomena when a transaction reads data that another transaction might have changed. These are dirty reads (when a transaction is allowed to read data from a row that has been modified by another running transaction and not yet committed), non-repeatable reads (during the course of a transaction, a row is retrieved twice and the values within the row differ between reads) and phantom reads (when, in the course of a transaction, new rows are added or removed by another transaction to the records being read).

STASHED IN:

6

Consistency ensures that a transaction can only bring the database from one valid state to another, maintaining database invariants: any data written to the database must be valid according to all defined rules, including constraints, cascades, triggers, and any combination thereof. This prevents database corruption by an illegal transaction, but does not guarantee that a transaction is correct.

STASHED IN:

6

Transactions are often composed of multiple statements. Atomicity guarantees that each transaction is treated as a single "unit", which either succeeds completely, or fails completely: if any of the statements constituting a transaction fails to complete, the entire transaction fails and the database is left unchanged. An atomic system must guarantee atomicity in every situation, including power failures and errors/crashes. For example, a transfer of funds between two banks, even involving multiple changes such as debiting one account and crediting another, is a single transaction.

STASHED IN:

6

Deepstash helps you become inspired, wiser and productive, through bite-sized ideas from the best articles, books and videos out there.

GET THE APP:

RELATED IDEA

From Bitcoin to Smart Contracts

Bitcoin created a decentralized monetary system which can transfer money from one person to another. That only allowed for monetary transactions, there was no way to add conditions to those transactions: 

Alice can send Bob 5 BTC, but she couldn’t tell Bob that he will get the money only if he performed certain tasks.

These conditions are a smart contract: self-executing with specific instructions written in its code which get executed when certain conditions are made.

Say Alice wants to buy a house. The seller will receive the funds only if property rights are cleared and after the rights have been transferred over.

2

STASHED IN:

47

What is Blockchain Technology, and How Does It Work?

Blockchain is a peer-to-peer decentralized distributed ledger technology that makes the records of any digital asset transparent and unchangeable and works without involving any third-party intermediary. It is an emerging and revolutionary technology that is attracting a lot of public attention due to its capability to reduce risks and fraud in a scalable manner.

7

STASHED IN:

24

A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure. Indexes are used to quickly locate data without having to search every row in a database table every time a database table is accessed. 

4

STASHED IN:

9

STASHED IN:

0 Comments