CS_540_Week_06.pdf - Database Administration I Storage Structure and Relationships Describe the logical structure of the database List the segment types

CS_540_Week_06.pdf - Database Administration I Storage...

This preview shows page 1 - 13 out of 99 pages.

Database Administration I
Image of page 1
Storage Structure and Relationships Describe the logical structure of the database List the segment types and their uses List the keywords that control block space usage Obtain information about storage structures from the data dictionary List the criteria for separating segments
Image of page 2
Overview
Image of page 3
Type of Segments
Image of page 4
Segments are space-occupying objects in a database. They use space in the data files of a database. Table A table is the most common means of storing data within a database. A table segment stores that data for a table that is neither clustered nor partitioned. Data within a table segment is stored in no particular order, and the database administrator has very little control over the location of rows within the blocks in a table. All the data in a table segment must be stored in one tablespace. Type of Segments
Image of page 5
Table Partition Scalability and availability are major concerns when there is a table in a database with high concurrent usage. In such cases, data within a table may be stored in several partitions, each of which resides in a different tablespace. The database server currently supports partitioning by a range of key values or by a hashing algorithm. If a table is partitioned, each partition is a segment, and storage parameters can be specified to control them independently. Use of this type of segment requires the Partitioning option within the database enterprise edition. Type of Segments
Image of page 6