+
Related Flashcards
Related Topics
Cards In This Set
| Front | Back |
|
Field
|
The smallest unit of named application data recognized by software systems.
|
|
Data Type
|
A detailed scheme recognized by the system software.
|
|
Physical Record
|
A group of fields stored in the adjacent memory locations and retrieved and written together by a DBMS unit.
|
|
Page
|
The amount of data read and written by a database operating system in one secondary memory disk input or output. (Record Block)
|
|
Blocking Factor
|
The number of physical records per page
|
|
Denormalization
|
The process of transforming normalized relations into unnormalized physical record specifications.
|
|
Horizontal Partitioning
|
Distributing the rows of a table into several seperate files.
|
|
Verticle Partitioning
|
Distributing the colums of a table into several seperate physical records.
|
|
Physical File
|
A named portion of secondary memory allocated for the purpose of storing physical records
|
|
Tablespace
|
A named set of disk storage elements in which physical files from database tables may be stored.
|
|
Extent
|
A contigious section of disk storage space.
|
|
Pointer
|
A field of data that can be used to locate a related field or record of data.
|
|
File Organization
|
A technique for physically arranging the records of a file on secondary storage devices
|
|
Sequential File Organization
|
The storage of records in a file in sequence according to a primary key value.
|
|
Indexed file organization
|
The storage of records either sequentially or nonsequentially with an index that allows software to locate individual records
|
