Some advantages of partitioning include: efficiency, security, and load balancing.

More Questions from Physical Database Design

• When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.
• Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.
• Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
• Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.
• Denormalization and clustering can work well to minimize data access time for small records.
• An extent is a contiguous section of disk storage space.
• A pointer is a detailed coding scheme recognized by system software for representing organizational data.
• It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.
• The primary goal of physical database design is data processing efficiency.
• A field represents each component of a composite attribute.

Discussion & Comments