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
Design an EER schema for the following application and translate the EER schema into relational schemas (and constraints). It is possible that some requirements cannot be captured

Event Occurrence of a process is called event. In other words, the object can receive many input instructions. The changes which occur due to these instructions are known as e

What is substitutability? Any method of a class-say A can equally well be adjured with any object belonging to any subclasses B of A. This characteristic leads to code reuse, a

Create a view emp_dep containing e_name and number of dependents from the tables employee and dependent of (i) CREATE VIEW emp_dept AS SELECT ename, COUNT(*) FROM employee, dep

Wait-die" scheme : The idea is based on non-preventive method. It is based on a simple rule:                                 If Ti requests a database resource that is held by T

What is Nested Queries explain in details? Nested Queries - A SELECT query could have subquery(s) in it. While a SELECT query having another SELECT query in it, is known as n

i need to submit in this topic.

What are the requirements to ensure the objectives of file management principle is realized?

What do you understand by a view? What does WITH CHECK OPTION clause for a view do? - A view is a virtual table which comprises fields from one or more real tables. - It is