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
The natural join is equal to which product? The natural join is equal to Combination of projection and Cartesian product

Example : Search the name, department number and salary of employees drawing minimum salary in that department. SELECT ENAME, SAL, DEPTNO  FROM EMP WHERE SAL IN (SELECT MI

Differentiate between a Global and a Local temporary table? - A local temporary table exists only for the duration of a connection or if defined inside a compound statement, fo

My cut off date is very soon in a Database subject and i dont know how to solve anything in it

What is document scanning and imaging? Document scanning and imaging, or digital archiving, is the method of scanning a document into a digital image to archive and retrieve a

Illustrate the Deployment Diagram A deployment diagram shows all nodes on network, their processor execution and interconnections. In a dynamic model, this is used to represen

What is a Phantom Deadlock? In distributed deadlock detection, the delay in propagating local information might cause the deadlock detection algorithms to recognize deadlocks

What are referential integrity constraints? A value that appears in single relation for a given set of attributes also appears for a particular set of attributes in another rel

Describe the static hash file with buckets and chaining and show how insertion, deletion and modification of a record can be performed. In static hash file organization, the wo

How can you connect to the MySQL Server? In order to connect to the MySQL server it is necessary to give the username and password so this be able to done with The following