RE: Help with hash function

  • From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
  • To: "'Harvinder.Singh@xxxxxxxxxxxxx'" <Harvinder.Singh@xxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 18 Oct 2004 11:04:34 -0400

Harvinder,

How about a simple database table that associates the account with the
bucket?  
I'm not exactly sure what you mean by "bucket".  What exactly are you
storing?

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: Harvinder Singh [mailto:Harvinder.Singh@xxxxxxxxxxxxx] 
Sent: Monday, October 18, 2004 10:59 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Help with hash function


Hi,

We have a requirement that we need to separate our accounts (one of column
in table) into 1024 buckets so I am thinking of applying hash function to
this column and based on the hash send the account to one of bucket.=20 So
basically we have to write a hash function that will take 1 input and
associate it will particular bucket and it is deterministic that for each
value it will always send it to same bucket. Any article or link will be
helpful that can explain how to write this hash function?

Thanks
--Harvinder

--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l

Other related posts: