can any one help me in knowing wot is hashing tecnique in dbms?

Question

hello i am bca student,pls explain me hashing in dbms,1stly wot hashing means
wot is internal hashing
wot is external hasing

Answer 1

Hashing: The conversion of a column's primary key value to a database page number on which the row will be stored. Retrieval operations that specify the key column value use the same hashing algorithm and can locate the row directly. Hashing provides fast retrieval for data that contains a unique key value.

You can find what you need to start by going to http://euler.vcsu.edu:7000/11577/

HTH

Answer 2

Hashing is a process by which one can convert a string into an equivalent number. first of all it is not a dbms concept it is a Datastructures concept. What hashin does is, it converts a string into an equivalent number using an algorithm. and the reverse can also be done. for eg, if u specify mod 10,all no will be from 0 to 9. and storae is done according to it. thus it will be convinient for storing data.