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
| A named portion of secondary memory (such as a hard disk) allocated for purpose of storing physical records. |
|
|
Term
|
Definition
| A named logical storage unit in which data from one or ore 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 records of a file on secondary storage devices. |
|
|
Term
| Sequential File Organization |
|
Definition
| The storage of records in a file in sequence according to a primary key value. |
|
|
Term
| Indexed File Organization |
|
Definition
| The storage of records either sequentially or non-sequentially 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 non-unique key. |
|
|
Term
|
Definition
| An Index on columns from two or more tables that 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 field of data indicating a target address that can be used to locate a related field or record of data |
|
|
