Term
|
Definition
| the smallest unit of application data recognized by system software |
|
|
Term
|
Definition
| a detailed coding scheme recognized by system software, such as DBMS, for representing organizational data |
|
|
Term
|
Definition
| the process of transforming normalized relations into non-normalized physical record specifications |
|
|
Term
|
Definition
| distribution of the rows of a logical relation into several separate tables |
|
|
Term
|
Definition
| distribution of the columns of a logical relation into several separate physical tables |
|
|
Term
|
Definition
| a named portion of secondary memory (such as hard disk) allocated for the purpose of strong physical records |
|
|
Term
|
Definition
| a named logical storage unit in which data from one or more database tables, views, or other database objects may be stored |
|
|
Term
|
Definition
| a contiguous section of disk storage space |
|
|
Term
|
Definition
| a technique for physically arranging the record of a file on secondary storage devices |
|
|
Term
| sequential file organization |
|
Definition
| the storage of records in a file in sequences according to primary key value |
|
|
Term
| indexed file organization |
|
Definition
| the storage of records either sequentially or consequentially with an index that allows software to locate individual records |
|
|
Term
|
Definition
| a table or other data structure used to determine in a file the location of records that satisfy some condition |
|
|
Term
|
Definition
| one field or a combination of fields for which more than one record may have the same combination of values; also called a nonunique key |
|
|
Term
|
Definition
| an index on columns from two or more tables than come from the same domain of values |
|
|
Term
|
Definition
| a storage system in which the address for each record is determined using a hashing algorithm |
|
|
Term
|
Definition
| a routine that converts a primary key value into a relative record number or relative file address |
|
|
Term
|
Definition
| a file organization that uses hashing to map a key into a location in an index, where there is a pointer to the actual data record matching the hash key |
|
|
Term
|
Definition
| a filed of data indication a target address that can be used to locate a related field or record of data |
|
|
