Home | Previous Page | Next Page Disk, Memory, and Process Management >

Data Storage

In This Chapter

Physical and Logical Units of Storage

Disk Allocation for Chunks

Disk Access on Windows

Unbuffered or Buffered Disk Access on UNIX

Control of Where Data Is Stored

Temporary Dbspaces

Advantages of Using Sbspaces

Sbspaces and Enterprise Replication

Metadata, User Data, and Reserved Area

Control of Where Data Is Stored

Storage Characteristics of Sbspaces

Extent Sizes for Sbspaces

Average Smart-Large-Object Size

Last-Access Time

Levels of Inheritance for Sbspace Characteristics

More Information About Sbspaces

Temporary Sbspaces

Comparison of Temporary and Standard Sbspaces

Temporary Smart Large Objects

Table Types for Dynamic Server

Standard Permanent Tables

Properties of Table Types

Loading of Data Into a Table

Fast Recovery of Table Types

Backup and Restore of RAW Tables

Temporary Tables

Temporary Tables That You Create

Temporary Tables That the Database Server Creates

Maximum Number of Tblspaces in a Table

Table and Index Tblspaces

Extent Interleaving

Table Fragmentation and Data Storage

Amount of Disk Space Needed to Store Data

Size of the Root Dbspace

Physical and Logical Logs

Temporary Tables

Amount of Space That Databases Require

Disk-Layout Guidelines

Dbspace and Chunk Guidelines

Table-Location Guidelines

Sample Disk Layouts

Sample Layout When Performance Is Highest Priority

Sample Layout When Availability Is Highest Priority

Logical-Volume Manager

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]