Benefits and drawbacks of heap files, Database Management System

Benefits of heap files

1.   This is a easy file Organisation method.

2.   Insertion is somehow capable.

3.   Good for bulk-loading data into a table.

4.   Best if file scans are general or insertions are frequent.

 

Drawbacks of heap files

1.   Retrieval needs a linear search and is inefficient.

2.   Deletion can result in unused space/require for reorganisation.

 

Posted Date: 3/7/2013 6:13:56 AM | Location : United States







Related Discussions:- Benefits and drawbacks of heap files, Assignment Help, Ask Question on Benefits and drawbacks of heap files, Get Answer, Expert's Help, Benefits and drawbacks of heap files Discussions

Write discussion on Benefits and drawbacks of heap files
Your posts are moderated
Related Questions
Question 1 Create a table student with attributes student name, roll number, total marks and percentage. Do the following operations Insert details in to the table Update

Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

Create 1 experiment to demonstrate an aspect of query optimisation by using access-path structures (indexes), decomposition, or denormalisation. Once satisfied with your experiment

Example -Find the employee name, salary, department number and average salary of his/her department, for those employees whose salary is more than the average salary of that depart

What Count function return in SQL? Count function within SQL returns the number of values. (Count function counts all the not null values in the exact column. If we need to cou

These are interactive interfaces, graphical that hide the difficulty of the DBMS and query language behind an intuitive, simple to understand, and convenient interface. This permit

Determine the advantage of object-orientation Finally, object-orientation has advantage of continuity throughout analysis, persistent representation and design implementation.

what are the reasons having variable length records

MySQL statements for extending the database to incorporate new facilities Deliverables for submission You must submit the following deliverables in the Assignment Dropbox in

Describe Physical Data independence ? Physical Data Independence - It is capacity to modify the internal schema without having to change conceptual schema. Therefore, the exter