Fujitsu 5.0L10 User Manual

Page of 225
Glossary
 
   
 
Access
 
The operations of reading data from a storage device and writing data to a storage device. In this manual, reading 
data from a database and writing data to a database is called access. 
   
 
Application program
 
Generally, programs used by users for their work are defined as application programs. In this manual, programs that 
read data from, or write data to, databases in response to business processing performed by users are known as 
application programs. 
   
 
Base table
 
A table defined as a base table in logical structure definition. The data body is stored in a database space. 
   
 
BTREE structure
 
The storage structure for an index. Consists of an index part and a data part. The index part folds the values of 
information about the correspondence between groups of columns that are index keys and base table data, and 
manages the pages of the data part. The data part holds data consisting of values of information about the 
correspondence between groups of columns that are index keys and base table data. 
Related terms: 
Index part, storage structure, data part 
   
 
Bucket
 
A structure unique to RANDOM structures. A RANDOM structure uses a hash function as follows. The function 
specifies the collection of pages that sore data from the values in the group of columns that form the data key. The 
collection of pages is called a bucket. 
Related term: 
RANDOM structure 
   
 
B-tree structure
 
An index system using an effective retrieval technique for speedily finding table data satisfying the retrieval condition. 
SymfoWARE/RDB uses this effective data retrieval technique to record data storage location in the root-trunk-leaf 
format and retrieve data satisfying the retrieval condition in high speed. An index using this technique is calld "B-tree 
structure." SymfoWARE/RDB adopts the B-tree structure for the index that is a table storage structure. 
Related term: 
Hash structure 
   
 
201