Database Management Systems (DBMS)
Unit-7
Overview of Storage
and Indexing
,Data on External Storage
Section – 1
,What is Data on External Storage?
In Database Systems, most data is stored on external storage (secondary storage d
hard disks, SSDs, magnetic tapes, optical disks or cloud storage) because main mem
is too small and volatile, where large volumes of data are stored permanently..
Understanding how data is stored, accessed, and retrieved from external storage is
query processing and indexing.
Unlike main memory (RAM), external storage is:
Non- volatile (data persists even after power is off)
Large in capacity (terabytes or more)
Slower (access time in milliseconds, compared to nanoseconds in RAM)
Since databases are often huge, DBMS primarily stores data in external storage a
blocks into main memory only when needed.
#3130703 (DBMS) Unit 6 – Storage Strategies
, File Organization
Section – 2
Unit-7
Overview of Storage
and Indexing
,Data on External Storage
Section – 1
,What is Data on External Storage?
In Database Systems, most data is stored on external storage (secondary storage d
hard disks, SSDs, magnetic tapes, optical disks or cloud storage) because main mem
is too small and volatile, where large volumes of data are stored permanently..
Understanding how data is stored, accessed, and retrieved from external storage is
query processing and indexing.
Unlike main memory (RAM), external storage is:
Non- volatile (data persists even after power is off)
Large in capacity (terabytes or more)
Slower (access time in milliseconds, compared to nanoseconds in RAM)
Since databases are often huge, DBMS primarily stores data in external storage a
blocks into main memory only when needed.
#3130703 (DBMS) Unit 6 – Storage Strategies
, File Organization
Section – 2
