Benefits abd drawback of hashed file organisation, Database Management System

Assignment Help:

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.

 

 


Related Discussions:- Benefits abd drawback of hashed file organisation

In which format database schema is written, In which format database schema...

In which format database schema is written ? Data base schema is written in the DDL format.

Describe the storage structure of indexed sequential files, Describe the st...

Describe the storage structure of indexed sequential files and their access method.  Ans:   Storage structure of Indexed Sequential files and their access: To achieve fast rand

Describe integrity and security, Describe integrity and security? a)   ...

Describe integrity and security? a)      Domain constraint b)      Referential integrity A value that appears in one relation for a given set of attributes also appear fo

What was the method in which records are physically stored, What was the me...

What was the method in which records are physically stored in a specified order according to a key field in each record ? A method in which records are physically stored within

Describe queries with complex types, Describe queries with complex types? ...

Describe queries with complex types? The present extension of the SQL query language deal with the complex type Let us start with the simple example: Find the title and t

Assignment SQL Management Server 2012, Have database built but having probl...

Have database built but having problems with some questions that go with the database

What function divides one numeric expression, What function divides one num...

What function divides one numeric expression by another and returns the remainder? MOD function divides one numeric expression by another and returns the remainder.

The maximum no of key fields that can be used in a header, The Maximum no o...

The Maximum no of key fields that can be used in a header is?? 50

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd