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;
15 Cards in this Set
- Front
- Back
Field data integrity
|
Default value
Range control Null value control Referential integrity (null/range control for foreign/primary keys) |
|
Benefit of denormalization
|
Improved performance - fewer table lookups
|
|
Cost of denormalization
|
Wasted space
Data integrity threats |
|
Vertical partitioning and primary keys?
|
The primary key column must be repeated
|
|
Advantages of partitioning?
|
Efficiency
Local optimization Security, recovery Load balancing Enables parallel processing |
|
Disadvantages of partitioning?
|
Inconsistent access speed across partitions
Complexity Extra space or update time |
|
Factors to consider when choosing file organization
|
Data retrieval speed
Space utilization Protection from failure/data loss Security from unauthorized access Need for reorganization Accommodating growth |
|
Types of File Organizations
|
Indexed - seperate table that contains organization of records for quick retrieval
Hash Sequential |
|
Sequential FO
|
n/2
If sorted: insert and delete requires resort |
|
Hashed FO
|
MOD function
Collision - use lists |
|
Bitmap index FO
|
Rows: Possible values of attributes
Columns: Fields |
|
B-tree index
|
avg time: depth of tree
|
|
Rules for using indexes (part 1)
|
Use on larger tables
Index PK Index WHERE, ORDER BY and GROUP BY Index when >100 values but not when <30 values |
|
Rules for using indexes (part 2)
|
Don't index fields with long values
Null values will not be referenced Use for non-volatile |
|
RAID
|
Multiple disks mimic single disk
Can write to disks simultaneously |