5. Designing a Database

This chapter explains how to design tables, indexes, and DB areas, as well as how to estimate the size of each DB area.

Organization of this chapter

• 5.1 Database design procedure

• 5.2 Designing a table

• 5.3 Designing a B-tree index

• 5.4 Designing a text index

• 5.5 Designing a range index

• 5.6 Designing a data DB area

• 5.7 Designing a work table DB area

• 5.8 Estimating the size of the data DB area

• 5.9 Estimating the size of the work table DB area

• 5.10 Estimating the size of the master directory DB area

• 5.11 Estimating the size of the dictionary DB area

• 5.12 Estimating the size of the system-table DB area

To Page Top