Transaction Processing (CRUD, ACID)

?
  • Created by: arrey
  • Created on: 23-04-19 20:49
Define Transaction Processing
Processing where operations are INDIVIDUAL and INDIVISIBLE. These operatons are called Transaction - each transaction must SUCCEED or FAIL as a complete unit; never can it be partially complete.
1 of 11
Context of such + Transactions
Classically covers operations by banks to customers, or cinema / theatre tickets. TRANSACTIONS change the Contents of a Database.
2 of 11
Define CRUD (not individually) - think transactional database
CRUD Functionality is the Minimum Requirement for a Transaction Database.
3 of 11
ACID Meaning + stand for
Atomicity Consistency Isolation Durability. Transactions only make changes to the database (COMMITS) when it ensurs the user has entered everything required. No PARTIAL SUCCESS. Only then will transaction be COMMITTED to database.
4 of 11
What is Atomicity - think of connotation. Atomic. 1.
Requires a change in a database to be made or not made at all. In previous eg, if a payment fails or other loss of data, transaction would not be complete.
5 of 11
What is Consistency - think of connotation of word
When a Transaction is complete, the database must go from one consistent state to another. It MUST ALSO stay within rules of the database.
6 of 11
What is Isolation - connotation of word. Data.
In ticket example, when one attempts to by a ticket the ticket is reserved and ISOLATED from others while he takes time to pay. Purchase is LOCKED so others cannot affect the purchase.
7 of 11
what is Durability - think of data.
Back-ups being made locally all through the process. Only when everything is done will we COMMIT to the database, which will also be backed up.
8 of 11
Define Deadlock
Where 2 users or competing for / attempting to make changes to the same record/part of DB at same time. This is AVOIDED by Locking System.
9 of 11
What is Data Mining?
Analysis of large sets of data to identify patterns, trends, relationships that are not otherwise obvious for commercial / other advantage.
10 of 11
Examples for how Data Mining is used as an advantage
Amazon/retail: Predicts demand, makes personal recommendation, ads. Govs: identify changes in demand for service, predict large-scale behaviour, identify security threats. WE SHOULD QUESTION ETHICS OF THIS.
11 of 11

Other cards in this set

Card 2

Front

Context of such + Transactions

Back

Classically covers operations by banks to customers, or cinema / theatre tickets. TRANSACTIONS change the Contents of a Database.

Card 3

Front

Define CRUD (not individually) - think transactional database

Back

Preview of the front of card 3

Card 4

Front

ACID Meaning + stand for

Back

Preview of the front of card 4

Card 5

Front

What is Atomicity - think of connotation. Atomic. 1.

Back

Preview of the front of card 5
View more cards

Comments

No comments have yet been made

Similar Computing resources:

See all Computing resources »See all Databases resources »