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
Can you help me with the following: Drop statements for all objects in the lab project. Create statements for all objects of the lab project Create indexes for foreign keys Cre

What is Structured Query Langauge (SQL)? SQL is a powerful set-oriented language which was formed by IBM research for the databases that adhere to the relational model. It havi

What is Asterisk in SQL? Asterisk (*): In SQL, the columns for all the tables and views in the FROM clause will be displayed.

Question: Using the data model express the following queries in SQL. (a) Create the Table named "Cinema" and make the cinema_code to be the primary key of the relation and

Design Documentation  The Design Document shall be an extension of Requirements Analysis Design. "The Design Document will comprise a revised and much more detailed descrip

Write short notes on relational model   The  relational  model  uses a  collection of  tables  to show  both data  and the relationships between those  data.  The relational mo

Name the various privileges in SQL? A) Delete B) Select C) Insert D) Update

what are the reasons having variable length records

This assignment concerns the Research database. The database ER model is shown above, where attributes are omitted for clarity. The relational model for the database is: Departm

I want a professional with strong IT background who provide me timely assignments Project Description: I want a professional who can do my assignments for my major i.e. Infor