CSE :: Database System 2 - CS
- When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.
- A pointer is a detailed coding scheme recognized by system software for representing organizational data.
- Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
- The three newest database architectures in use today are relational, multidimensional and hierarchical.
- Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.
- In general, larger block sizes are used for online transaction processing applications and smaller block sizes are used for databases with a decision support or data warehousing system.
- It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.
Whatsapp
Facebook
