Tim, I was thinking, maybe erroneously, that you meant a database like Oracle. I'm familiar with hash database files that perl can create directly or act as an interface to other key/value databases like BerkeleyDB, LevelDB, etc. There's a module named 'Tie::Hash::DBD' that can create a key/value store within an Oracle table, but it's pretty slow. I was hoping you were referring to something similar that was much quicker. I'm pulling a massive amount of data from an Oracle database, and I thought some kind of hashing mechanism, short of creating a hash in a pl/sql block, would help me organize the data and get it out more efficiently.
Thanks for responding. John -----Original Message----- From: tim.bu...@pobox.com [mailto:tim.bu...@pobox.com] Sent: Sunday, April 17, 2016 4:41 PM To: John Martel Cc: tim.bu...@pobox.com; dbi-users@perl.org Subject: Re: DBI Utility Functions - more documentation? Hello John. The DBI::hash function simply returns an integer that hash been derived from a string by some maths. See https://en.wikipedia.org/wiki/Hash_function That kind of 'hash' is (mostly) unrelated to a Perl hash like my %foo; also known as an associative array. I've CC'd this to the dbi-users mailing list. If you reply with more details about what you're trying to achieve then I'm sure you'll get some useful replies. Meanwhile I'll clarify the docs of the DBI::hash function. Thanks. Tim. On Fri, Apr 15, 2016 at 06:45:19PM +0000, John Martel wrote: > Tim, > > While reading through your DBI documentation in CPAN, I came across > `DBI::hash' under the `DBI Utility > Functions' header and > > was intrigued about how to `store hash values in a database'. The example > and verbiage is very sparse > here, so I was wondering if > > there was any other documentation. I just want to know how a hash can be > stored in a database using > DBI. I have your eBook version of > > `Programming the Perl DBI', but I didn't find anything when I searched for > `DBI::hash'. > > > > John Martel | Programmer / Analyst, Data Services | KBM Group | Part of > the Wunderman Network > (Tel) 303 228 5051 | (Fax) 303 926 1367 | (Mob) 720 473 9000 | kbmg.com > 2051 Dogwood Street, Suite 220 | Louisville, CO 80027 > [1]john.mar...@kbmg.com > > > > > [2]cid:image001.png@01D11719.76FB7FB0[3]cid:image003.png@01D04A97.81E3 > 03C0 > > This email - including attachments - may contain confidential information. > If you are not the intended > recipient, do not copy, distribute or act on it. Instead, notify the > sender immediately and delete the > message. > > > > > > > ---------------------------------------------------------------------- > ---------------------------------- > > This email - including attachments - may contain confidential information. > If you are not the intended > recipient, do not copy, distribute or act on it. Instead, notify the > sender immediately and delete the > message. > > > ---------------------------------------------------------------------- > ---------------------------------- > > References > > Visible links > 1. mailto:aundra.thomp...@kbmg.com This email ? including attachments ? may contain confidential information. If you are not the intended recipient, do not copy, distribute or act on it. Instead, notify the sender immediately and delete the message. This email - including attachments - may contain confidential information. If you are not the intended recipient, do not copy, distribute or act on it. Instead, notify the sender immediately and delete the message.
