Filter
Top Products
[Figure: Example in which DSOs and DSIs are associated in a 1:n correspondence]
As Figure: Storage structure components shows, the four types of storage structures are SEQUENTIAL, RANDOM,
OBJECT, and BTREE. The SEQUENTIAL, RANDOM, and OBJECT structures are used as storage structures for
tables. The BTREE structure is used as a storage structure for indexes. Each of these storage structures consists of
one or more components as shown in Figure: Storage structure components.
[Figure: Storage structure components]
A DSI can consist of multiple database spaces. The configuration of the multiple database spaces is divided into two
types. In one configuration, a database space is allocated for each component in the storage structure shown in
Figure: Storage structure components. In the other configuration, a database space is allocated to increase the size of
each component. Figure: Example in which a database space is allocated to each component is an example in which
a database space is allocated to each component. An example of allocating multiple database spaces to increase the
size of each component is shown in Figure: Example of allocating multiple database spaces to increase the size of
each component.
9