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

Project Description: Oracle Certified Professional with 20 years of practice, Oracle version 6.0.34, 7.3, 8.0, 8i, 9i, 10G, 11G, 12C. Crossplatform migration, Informix, MSSql

Q.  What is relational algebra and calculus? Explain the relational algebra operators :- Selection and predicate, set operation, joins and division. Sol. Relational Algebra

What are the ways in which the variable-length records arise in database systems? Storage of many record types in a file. Record types that permit variable lengths for one o


Find out the names of all employees who work for first Bank Corporation from database. SELECT EMPLOYEE_NAME FROM WORKS WHERE COMPANYNAME = ‘First Bank Corporation';


Why Like predicate used for? LIKE predicate: The LIKE predicate searches for strings in which have a certain pattern.

Concurrency Identification While designing analysis, model we map real world model into our analytical model. Real life objects are simultaneous in nature, but all the design

What are the time stamps associated with each data item? W-timestamp (Q) denotes the largest time stamp if any transaction that implemented WRITE (Q) successfully. R-timesta