Benefits abd drawback of hashed file organisation, Database Management System

Benefits of Hashed file Organisation

1.      Insertion or search on hash-key is quick.

2.      Best if equality search is required on hash-key.

Drawbacks of Hashed file Organisation

1.      It is a difficult file Organisation method.

2.      Search is slow.

3.      It suffers from disk space overhead.

4.      Unbalanced buckets degrade performance.

5.      Range search is slow.

 

 

Posted Date: 3/7/2013 6:17:52 AM | Location : United States







Related Discussions:- Benefits abd drawback of hashed file organisation, Assignment Help, Ask Question on Benefits abd drawback of hashed file organisation, Get Answer, Expert's Help, Benefits abd drawback of hashed file organisation Discussions

Write discussion on Benefits abd drawback of hashed file organisation
Your posts are moderated
Related Questions

What is the use of rename operation? Rename operation is used to rename both relations and an attributes. It uses the as clause, taking the form: Old-name as new-name.

Attributes that are directly kept in the data base. For example, 'Birth date' attribute of a person.   Derived  Attributes that are not stored directly but can be derived

What is deadlock? Neither of the transaction can ever proceed with its normal implementation. This situation is known as deadlock.

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

Improved availability: The data in a distributed system may be replicated so that it is at more than one site. Thus, the failure of a node or a communication link does not necessar

The ABC Bank authority now wants to create a database for their customers. So you are requested to modify your program of Assignment A3 as follows. The main program first displa

This report identifies and outlines my CIS 499 project named Traffic Data Management  Systems (TDMS) .   My goal is to design a replica of all traffic issues to be implemented i

What are the difference between clustered and a non-clustered index? A clustered index is a special type of index that reorders the way records in the table are physically stor

Normalize the given relation to 3NF, justifying each step