[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

what's advantage has indexed file over the hashed files and what's advantages has hashed files over indexed?

Posted on 2011-03-23
3
Medium Priority
?
621 Views
Last Modified: 2012-06-27
what's advantage has indexed file over the hashed files and what's advantages has hashed files over indexed?
0
Comment
Question by:antatiana
2 Comments
 
LVL 66

Expert Comment

by:btan
ID: 35207814
check out this and mainly their application are in search purposes where both fared better uniquely than sequential file search. simply have algorithm efficiency and space optimisation as comparison factors

http://markp3rry.blogspot.com/2007/12/indexed-vs-hashed-files.html

"...indexes are best used when there are no limits on storage space - a large database will always have space available for indexes because of the extra efficiency in searching. Also , I think that indexes are less prone to errors than hashing files - no chance of collision or clustering . However hashing isn ' t as wasteful in terms of needing extra resources to implement, and is quicker when done properly because there aren ' t two files to maintain."
0
 
LVL 6

Accepted Solution

by:
Melannk24 earned 2000 total points
ID: 35210446
Records in hashed files can be stored and retrieved quickly. However the difficulty in hashed files is that they are difficult to process in key order, which is important if you want to access all records with keys in a certain range.

Indexing is a data structure based technique for accessing records in a file.  Indexes are auxiliary access structures which are used to speed up the retrieval of records in response to certain search conditions.  A main file of records can be supplemented by one or more indexes. Indexes allow for efficient access to records based on the indexing fields that are used to construct the index.   Any field of the file can be used to create an index, and multiple indexes on different fields can be constructed on the same file.

IMO, hash files are quick where indexing can consume both time it takes to perform the index and space required.  Depends on the purpose of the database and environment limitations.
0

Featured Post

Evaluating UTMs? Here's what you need to know!

Evaluating a UTM appliance and vendor can prove to be an overwhelming exercise.  How can you make sure that you're getting the security that your organization needs without breaking the bank? Check out our UTM Buyer's Guide for more information on what you should be looking for!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Steps to fix error: “Couldn’t mount the database that you specified. Specified database: HU-DB; Error code: An Active Manager operation fail”
Exchange administrators are always vigilant about Exchange crashes and disasters that are possible any time. It is quite essential to identify the symptoms of a possible Exchange issue and be prepared with a proper recovery plan. There are multiple…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
Suggested Courses

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question