Filter
Top Products
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