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
Compare three clustering algorithms in Weka. For this comparison, you will need to use at least two different datasets. Run the algorithms on the datasets, and use the visual

Give an example of enforcement in Typing. You can understand the idea of enforcement as it makes sure objects of dissimilar classes may not be interchanged as below:  Exampl

I want to fragment existing table using java code... help me..!!

What is Specialization? Specialization: Specialization permits you to describe new types of information (new structural types or latest domains of information), although reusin

Failure Controlling Methods: Failures can be handled using different recovery methods that are talk about later in the unit. But the first question is doing we really require recov

Define average seek time. The average seek time is the average of the seek times, calculated over a sequence of random requests.

Creating views with Read only option : In the view definition this option is used to make sure that no DML operations can be done on the view.

Consider the table student and list names of students in the departments other than maths and computer. SELECT std_name FRM student WHERE dept_name NOT IN (‘Maths','Computer);

1. Which model is used to store data in tree structures Ans: Hierarchical model is used to store data in tree structures