SQL Terms

10 cards·by miller.keith.bradley

When speaking of databases what does RAID stand for?

Redundant Array of Independent Disks

Special Instructions for the optimizer embedded in the SQL command text.

Optimizer hints

Number of different values a comlumn could possibly have.

Data Sparsity

DBMS retrives the data and sends the result back to the client.

Fetching

Low-level data access operation to/from computer devices.

Input/output request

Shared, reserved memory area

Data/Buffer cache

Stores most recent executed SQL statements.

SQL cache

Logical grouping of several data files that store data with similar characteristics.

File group

Set of activities and procedures designed to reduce response time of database system.

Database performance tuning

All operations of a transaction must be completed.

Atomicity