Filter
Top Products
[Figure: Storage structure definition procedure]
DSO definition
The DSO definition specifies the type of storage structure for storing data and rules such as whether to apply split
table operation.
The two types of DSO definitions are table DSO definitions and index DSO definitions.
Table DSO definition
A table DSO definition specifies the type of storage structure for storing data and rules such as whether to apply split
table operation for a base table. Use the CREATE DSO statement to specify a table DSO definition using.
The storage structures for base tables can be categorized according to the size of the stored data. The storage
structures for handling character and numeric data are different from the storage structures for handling multimedia
data. For information about handling multimedia data, see 2.7.2 "Table DSO definition for multimedia data storage."
Index DSO definition
An index DSO definition defines the columns that form the index and information such as the type of storage structure
for storing index data. Use the CREATE DSO statement to specify an index DSO definition.
DSI definition
A DSI definition specifies an association with the database space where the data is actually stored and information
such as split key values for performing split table operation.
The two types of DSI definitions are table DSI definitions and index DSI definitions.
Table DSI definition
A table DSI definition specifies an association with a database space according to a table DSO definition. The table
DSI definition also specifies information such as split key values for performing split table operation. Use the CREATE
DSI statement to specify a table DSI definition.
Index DSI definition
An index DSI definition specifies an association with a database space according to an index DSO definition. Use the
CREATE DSI statement to specify an index DSI definition.
Storage structure definition statements consist of table and index DSO definition statements and DSI definition
statements. Details about these definition statements are explained in 2.7.1 "Table DSO definition," 2.7.3 "Index DSO
definition," 2.7.4 "Table DSI definition," and 2.7.5 "Index DSI definition."
Scope definition
Scope defines the range of table data that is to be manipulated. The user can specify a range in advance so that only
data within that range is processed. Application and release of the scope can be specified for each user.
A sample of using scope follows.
Example:
Define scope TOKYO, apply it to user SUZUKI, and retrieve a limited table from an application
program.
50