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
Write an sql statement to find what is the percentage of home policies which are from the state of Arizona out of all Home policies by Policy Value.

4. Describe three ways to handle missing field values

Build a database application for a sports league. Assume your application is to keep track of teams and equipment that is checked out to teams. Explain the steps that is needed and

Explain controlled redundancy? Controlled redundancy : The replication of data within the data warehouse for the purposes of improved data access or understand ability.

Single-Valued Dependencies A database is a collection of related information and it is therefore inevitable that some items of information in the database would depend on some

What types of adjustments are required to increase chances of inheritance. a)   Some attributes can be added or ignored in  the base class operation  b) Some changes can be

How do you find the final model after iterative analysis? Why is iterative analysis of any of the problem needed? The final model serves as the base for system architectur

I have a homework assignment due today by midnight. I need help understanding databasse normalization and determining the type of form violation & how to fix the violation.

Multi-list file Organisation Multi-list file organisation is a multi-index linked file organisation. A linked file organisation is a logical organisation where physical orderin

What is Relational calculus? Relational calculus is a Non- Procedural language.