ch 10/11 stuff

10 cards·by pacey_nj

A column distribution of values or the number of different values a column could have.

Data sparsity

What is a transaction?

Logical unit of work that must be either entirely completed or aborted.

What is the term for data that is used during transaction cannot be used by second transaction until the first is completed.

Isolation

What is Serializability?

Concurrent execution of several transactions yields consistent results.

What are the twp phases of the two-Phase Locking?

Growing phase and shrinking phase.

What is a Deadlock?

A Condition that occurs when two transactions wait for each other to unlock data.

What is Database performance tuning?

is a set of activities and procedures designed to reduce response time of database system.

What does RAID stand for?

Redundant Array of Independent Disks

What is Wait/die ?

Older transaction waits and younger is rolled back and rescheduled

What is Wound/wait ?

Older transaction rolls back younger transaction and reschedules it