RE: Help with hash function

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Mon, 18 Oct 2004 11:04:34 -0400
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE07A7F9A2@exchsen0a1ma>

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_at_MetraTech.com] Sent: Monday, October 18, 2004 10:59 AM
To: oracle-l_at_freelists.org
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

--

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

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 18 2004 - 10:00:03 CDT