Chapter 11:Storage and File Structure Overview of Physical Storage Media Magnetic Disks RAID Tertiary Storage Storage Access File Organization Organization of Records in Files Data-Dictionary Storage Storage Structures for Object-Oriented Databases Database System Concepts-5th Edition,Oct 23,2005. 11.2 ©Silberschat乜，Korth and Sudarshan
Database System Concepts - 5 11.2 ©Silberschatz, Korth and Sudarshan th Edition, Oct 23, 2005. Chapter 11: Storage and File Structure Overview of Physical Storage Media Magnetic Disks RAID Tertiary Storage Storage Access File Organization Organization of Records in Files Data-Dictionary Storage Storage Structures for Object-Oriented Databases
Classification of Physical Storage Media Speed with which data can be accessed Cost per unit of data Reliability data loss on power failure or system crash physical failure of the storage device Can differentiate storage into: volatile storage:loses contents when power is switched off non-volatile storage: Contents persist even when power is switched off. Includes secondary and tertiary storage,as well as batter- backed up main-memory. Database System Concepts-5th Edition,Oct 23,2005. 11.3 @Silberschatz,Korth and Sudarshan
Database System Concepts - 5 11.3 ©Silberschatz, Korth and Sudarshan th Edition, Oct 23, 2005. Classification of Physical Storage Media Speed with which data can be accessed Cost per unit of data Reliability data loss on power failure or system crash physical failure of the storage device Can differentiate storage into: volatile storage: loses contents when power is switched off non-volatile storage: Contents persist even when power is switched off. Includes secondary and tertiary storage, as well as batterbacked up main-memory
Physical Storage Media Cache-fastest and most costly form of storage;volatile;managed by the computer system hardware. Main memory: fast access(10s to 100s of nanoseconds;1 nanosecond =10-9 seconds) generally too small (or too expensive)to store the entire database capacities of up to a few Gigabytes widely used currently Capacities have gone up and per-byte costs have decreased steadily and rapidly (roughly factor of 2 every 2 to 3 years) Volatile-contents of main memory are usually lost if a power failure or system crash occurs. Database System Concepts-5thEdition,Oct 23,2005. 11.4 @Silberschatz,Korth and Sudarshan
Database System Concepts - 5 11.4 ©Silberschatz, Korth and Sudarshan th Edition, Oct 23, 2005. Physical Storage Media Cache – fastest and most costly form of storage; volatile; managed by the computer system hardware. Main memory: fast access (10s to 100s of nanoseconds; 1 nanosecond = 10–9 seconds) generally too small (or too expensive) to store the entire database capacities of up to a few Gigabytes widely used currently Capacities have gone up and per-byte costs have decreased steadily and rapidly (roughly factor of 2 every 2 to 3 years) Volatile — contents of main memory are usually lost if a power failure or system crash occurs
Physical Storage Media(Cont.) Flash memory Data survives power failure Data can be written at a location only once,but location can be erased and written to again Can support only a limited number(10K-1M)of write/erase cycles. Erasing of memory has to be done to an entire bank of memory Reads are roughly as fast as main memory But writes are slow(few microseconds),erase is slower Cost per unit of storage roughly similar to main memory Widely used in embedded devices such as digital cameras Is a type of EEPROM(Electrically Erasable Programmable Read-Only Memory) Database System Concepts-5th Edition,Oct 23,2005. 11.5 ©Silberschat乜，Korth and Sudarshan
Database System Concepts - 5 11.5 ©Silberschatz, Korth and Sudarshan th Edition, Oct 23, 2005. Physical Storage Media (Cont.) Flash memory Data survives power failure Data can be written at a location only once, but location can be erased and written to again Can support only a limited number (10K – 1M) of write/erase cycles. Erasing of memory has to be done to an entire bank of memory Reads are roughly as fast as main memory But writes are slow (few microseconds), erase is slower Cost per unit of storage roughly similar to main memory Widely used in embedded devices such as digital cameras Is a type of EEPROM (Electrically Erasable Programmable Read-Only Memory)
Physical Storage Media (Cont.) Magnetic-disk Data is stored on spinning disk,and read/written magnetically Primary medium for the long-term storage of data;typically stores entire database. Data must be moved from disk to main memory for access,and written back for storage Much slower access than main memory (more on this later) direct-access-possible to read data on disk in any order,unlike magnetic tape Capacities range up to roughly 400 GB currently Much larger capacity and cost/byte than main memory/flash memory Growing constantly and rapidly with technology improvements (factor of 2 to 3 every 2 years) Survives power failures and system crashes disk failure can destroy data,but is rare Database System Concepts-5thEdition,Oct 23,2005. 11.6 @Silberschatz,Korth and Sudarshan
Database System Concepts - 5 11.6 ©Silberschatz, Korth and Sudarshan th Edition, Oct 23, 2005. Physical Storage Media (Cont.) Magnetic-disk Data is stored on spinning disk, and read/written magnetically Primary medium for the long-term storage of data; typically stores entire database. Data must be moved from disk to main memory for access, and written back for storage Much slower access than main memory (more on this later) direct-access – possible to read data on disk in any order, unlike magnetic tape Capacities range up to roughly 400 GB currently Much larger capacity and cost/byte than main memory/flash memory Growing constantly and rapidly with technology improvements (factor of 2 to 3 every 2 years) Survives power failures and system crashes disk failure can destroy data, but is rare