Home » Blog » Topic » How can we choose a file organization?

How can we choose a file organization?

Stephen West ~ Modified: February 25th, 2016 ~ ~ 1 Minute Reading

Home › Forums › How can we choose a file organization?

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • February 25, 2016 at 9:27 am #1173 Score: 0
    Stephen West
    Moderator
    4 pts

    What are the basic difference between Heap, Sorted and Hashed file system and which one is the best option to store the data for a newly created database?

    February 27, 2016 at 5:40 am #1259 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    There are four types of file organization system in SQL Server database, you can choose one of them as per your convenience.
    1. Heap file organization: when there is a huge number of data needs to load into the database at a time, then this method of file organization is best suited. Best suited for very small files as the fetching of records is faster.

    2. Hash file organization: The block address is known by hash function, accessing any record is very faster. It is suitable for online transaction systems like online banking, ticket booking system etc

    3. Sequential organization:. When there are large volumes of data, this method is very fast and efficient. This method is helpful when most of the records have to be accessed like calculating the grade of a student, generating the salary slips etc. This method is good in case of report generation or statistical calculations.

    4. Clustered organization: This file organization is not best suited for the large number of data because the ordering of records are not based on the primary key.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.