Term
|
Definition
| The process of transforming normalized relations into nonnormalized 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 that stores physical records |
|
|
Term
|
Definition
| a named logical storage unit which stores data from one or more database objects |
|
|
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 with an index that allows software to locate individual records |
|
|
Term
|
Definition
| a table or other data structure used to determine the location of records that satisfy some condition |
|
|
Term
|
Definition
| a field or fields for which more than one record may have the same combination of values |
|
|
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 with a hashing algorithm |
|
|
Term
|
Definition
| a routine that converts a primary key value into a relative record number or file address |
|
|
Term
|
Definition
| a file organization system 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 locate a field or record of data |
|
|
Term
|
Definition
| a table in the relational data model containing the inserted raw data |
|
|
Term
|
Definition
| a table which a DBMS constructs automatically as needed |
|
|
Term
|
Definition
| a virtual table that a user creates dynamically |
|
|
Term
|
Definition
| copies or replicas of data based on SQL queries created dynamically |
|
|
Term
|
Definition
| a computer responsible for database storage and processing in a client/server environment |
|
|
Term
|
Definition
| software that allows an application to interoperate with other software without requiring the use to understand and code low level operations |
|
|
Term
|
Definition
| set of routines that an application program uses to direct the performance of procedures by the OS |
|
|
Term
|
Definition
| an approach to filling a data warehouse that involves bulk rewriting of the target data at periodic intervals |
|
|
Term
|
Definition
| an approach to filling a data warehouse in which only changes in the source data are written to the data warehouse |
|
|
Term
|
Definition
| the process of moving inactive data to another storage location where it can be accessed when needed |
|
|
Term
|
Definition
| a query that a DBA submits to test the current performance of a database or to predict the response time for queries with promised response times |
|
|
Term
|
Definition
| a joining operation used with distributed databases in which only the joining attribute from one site is transmitted to the other site rather than all the selected attributes from every qualified row |
|
|
