Quiz on different storage structures such as physical, flash, tertiary, data-dictionary and file structures like RAID, file record organisation and database buffers. In a database management system (DBMS), file structure defines how file records are mapped onto disk blocks. File organization describes the logical connections between the different records that make up a file.  Here are some types of file organization: Sequential file organization: Records are placed in the file in some sequential order based on the unique key field or search key. Hash file organization: Uses hash function... Show more

Quiz on different storage structures such as physical, flash, tertiary, data-dictionary and file structures like RAID, file record organisation and database buffers.

In a database management system (DBMS), file structure defines how file records are mapped onto disk blocks. File organization describes the logical connections between the different records that make up a file. 

Here are some types of file organization:
Sequential file organization: Records are placed in the file in some sequential order based on the unique key field or search key.
Hash file organization: Uses hash function computation on some fields of the records.
Indexed file organization: Data is stored in a file or table with an index. The index is a data structure that contains pointers to the location of the data within the file or table. 

Here are some components of a DBMS:
Query Processor: Receives the queries from the user and interprets them in the form of instructions.
Storage Manager: Acts as the interface between the data stored in the database and the queries received from the end-user.
Disk Storage: Represents the space where data is stored. 

Here are some storage types in DBMS:
Magnetic Disk: A flat disk covered with a magnetic coating and uses a magnetization process to read, write and access data. It stores data in the form of tracks, spots, and sectors. Floppy disks and zip disks are typical examples of magnetic disks.
Tape Storage: It is the cheapest storage medium than disks. Generally, tapes are used for archiving or backing up the data.
Compact Disk (CD): Can store 700 megabytes of data with a playtime of around 80 minutes.
Digital Video Disk (DVD): Can store 4.7 or 8.5 gigabytes of data on each side of the disk. 

Show less