Home | Previous Page | Next Page   An Overview of the Optical Subsystem > Storage of TEXT and BYTE Data >

Storing TEXT and BYTE Data in a Cluster

Optical clustering attempts to store logically related TEXT or BYTE data objects together on the same volume. In applications where related TEXT or BYTE data objects are often retrieved together, optical clustering minimizes time-consuming platter exchanges on the drives. This practice improves performance.

Optical clustering does not imply that TEXT or BYTE data objects that share a particular key value are stored next to each other on the optical platter. Instead, each optical cluster represents a reservation of some number of kilobytes (the clustersize) on a volume. However, the reserved kilobytes and the TEXT or BYTE data objects that are eventually stored might not be contiguous. The benefit of clustering is that you can find related TEXT or BYTE data objects on the same volume far faster than you can find them on separate volumes or platters.

Figure 2 illustrates the difference between sequential and clustered organization. In this example, the optical platters store TEXT or BYTE data objects that are scanned pictures of merchandise. The pictures belong to the cat_descr column in the stores_demo database. If you cluster the pictures, you must cluster them by reference to some other column, such as the manufacturer's name, as pictures do not have an inherent order themselves.

When stored sequentially, the optical-storage subsystem writes the pictures to the optical platter in the same order that they are inserted in the table. If you cluster them by the manufacturer code (the cluster key), the pictures for a given manufacturer are stored together. The clustered organization reduces platter exchanges on the optical drives.

Figure 2. Sequential Storage Versus Clustering by manu_code
begin figure description - The figure shows two sets of platters, with two platters in each set. Each platter contains pictures of products from the cat_descr column of the stores_demo database. The first set of platters is clustered sequentially, so the pictures are stored on the platters in the same order in which they occur in the table. The pictures on the sequential set of platters appear to be placed in random order. The pictures in the second, clustered set of disks have been stored with reference to the product manufacturer's name, so the pictures on the clustered platters appear in ordered groups. - end figure description
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]