Wednesday, June 24, 2020

File Organization in DBMS

File Organization

File Organization

The database contains a large amount of data that is stored within a table in the RDBMS (Relational Database Management System).
Each table has corresponding records or data. A user can see that records or the data are stored as DBMS tables. But in real terms, it is stored in physical memory in the form of a huge amount of data files.

File: - 

It is a collection of information and records, that is recorded on secondary storage such as magnetic disks, magnetic tables, and optical disks, etc.

File Organization: -

It refers to the logical relationship between records that relate to the means of identifying that file and accessing a specific record. In simple words, storing the file in some order called "File Organization".

Types Of File Organization

Types of file organization are: -
  • 1. Sequential file organization
  • 2. Heap file organization
  • 3. Hash file organization
  • 4. B+ tree file organization
  • 5. Cluster file organization

NOTE: - How did you like "File Organization in DBMS" post, you must tell us through the comments. We are eagerly waiting for your comments. If you have any questions or any suggestions, then tell us, we will publish it here within a day or two and definitely share the post.

No comments:

Post a Comment