Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
12 Cards in this Set
- Front
- Back
Every relation has
|
a name,
a set of attributes, and each attribute associated with a domain. |
|
Relation
|
An instance of a relation is a finite set of tuples.
|
|
Keys for a Relation
|
A minimal set of attributes whose values uniquely
identify a tuple in any instance of the relation. No proper subsets of the attributes retain the property. |
|
Types of Indexes
|
B-tree: Fits most common situations
Hash: Only handles equality comparisons GiST: Generalized Search Tree is a balanced tree structure GIN: Generalized Inverted Index is designed for composite value keys |
|
Transaction
|
a single logical database operation.
|
|
ACID Properties of Relational Databases
|
Atomicity, Consistency, Isolation, Durability
|
|
Atomicity
|
Insert/update/delete is performed completely or not at all
|
|
Consistency
|
No part of a transaction can violate constraints
|
|
Isolation
|
Each application runs transactions independently
|
|
Durability
|
Completed transactions persist
|
|
SQL Savepoints
|
used to record intermediate points within a transaction, but before a commit.
|
|
RELEASE
|
has the effect of deleting the save point, but keeping results of the statements that followed.
|