Hashed file organisation, Database Management System

Hashed File Organisation

Hashing is the most common form of purely random access to a database or file. It is also used to access columns that do not have an index as an optimisation method. Hash functions determine the address of the page in which the record is to be stored based on one or more fields in the record. The records in a hash file appear randomly distributed across the available space. It needs some hashing algorithm and the method. Hashing Algorithm changes a primary key value into a record address. The mainly popular form of hashing is division hashing with chained overflow.

 

Posted Date: 3/7/2013 6:17:22 AM | Location : United States







Related Discussions:- Hashed file organisation, Assignment Help, Ask Question on Hashed file organisation, Get Answer, Expert's Help, Hashed file organisation Discussions

Write discussion on Hashed file organisation
Your posts are moderated
Related Questions

properties of derirable decomposition

Explain CNT in the respects of QBE ? CNT: It is one of the aggregation commands given in QBE. It is used to identify number of tuples

Q.1 Briefly discuss the different layers of ANSI SPARC architecture. Ans: The three layers of ANSI SPARC architecture are like this: 1. Internal view is at the lowest leve

Question: Describe briefly the three parts of the Relational Model. (a) The term integrity refers to the accuracy or correctness of the data in the database. Define the fol

Increases efficiency : Data is stored close to most often used site, therefore retrieval would be faster. Also, data that is not required by local applications is not stored, there

, write the relational schema, and draw the new dependency diagrams. Identify the normal forms for each table structure you created

What are the benefits of document scanning? Document scanning, in addition to being cost-efficient, also enhances productivity. This service enhances security as you set the pa

What are the failures of Controlling Events Between Objects  Failure Unintentional termination of system. Several possible causes: failure of system hardware, o

what characterizes the levels in RAID technology