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
external and internal mapping with examples

Explain Transaction manager and their work? Transaction Manager: Ensure the database remains in a constant (correct) state despite system failure, and in which concurrent trans


You are managing the following database system: • DBMS: Oracle 11g • OS: Sun Solaris • System architecture: Web-based application using ASP.Net • Purpose of Server: HR managem

You are required to program (in a high level language such as C, C++, Java) and implement a cache simulator which will have the following inputs and outputs:- INPUTS

What are the features of embedded SQL? Explain. Embedded SQL - SQL could be implemented within two ways. It can be used interactively or embedded in a host language or throu

Architectural standard: Designation : Architect , Consultant Job Profile : As a part of Oracle Fusion Middleware at Satyam, I am involved with Presales, Delivery, A

Hardware failure :  Hardware failures are the failures when some disk or hardware chip fails. This may result in loss of data. One such trouble can be that a disk gets damaged and

Explain Stand Alone Query Language in details? Stand alone Query Language - The query language that can be used interactively is known as stand alone query language. It does no

These permit the user to unload a database or parts of a database and reload the data on the similar machine, or on another machine in a dissimilar location. This can be useful in