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
Competition entrants can be either Individuals, or Teams. A Team is usually sponsored by a business, and, in that case, the team members would all wear T-shirts with the sponsoring

What is persistency? Persistency ensures which data is stored and that after the object is no longer available (program stops running) the data will be available to other users

What is banker's algorithm?  Banker's algorithm is a deadlock avoidance algorithm that is applicable to a resource-allocation system with multiple instances of each resource ty

what benefit can a company gain by managing its own infrasture and services

You want to implement following relationships when designing tables. How would you do it? a.) One-to-one b.) One-to-many c.) Many-to-many a.) One-to-One relationship -

Atomicity : Either all functions are laid out or none are. Users could not have to think about the effect of incomplete operations. DBMS ensures this by undoing the functions

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

FDs in Entities : Student entity :                                                Enrolment number →  Student name, Address Course Entity :

1. Which model is used to store data in tree structures Ans: Hierarchical model is used to store data in tree structures

What are aggregate functions? And list the aggregate functions supported by SQL? Aggregate functions are functions that take a collection of values as input and return a one va