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
610 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 63

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 500 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

One of the biggest challenges facing freelancers is balancing multiple projects and deadlines. Organizational skills and time management are key to keeping up with projects and staying on track. Luckily, we’ve curated seven tools to help you focus o…
Many businesses neglect disaster recovery and treat it as an after-thought. I can tell you first hand that data will be lost, hard drives die, servers will be hacked, and careless (or malicious) employees can ruin your data.
In this Micro Tutorial viewers will learn how to restore their server from Bare Metal Backup image created with Windows Server Backup feature. As an example Windows 2012R2 is used.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

740 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