Hi Karol-

I'm trying to uniquely identify a parameter combination by generating a hash value, and then to use that hash value as a foreign key in a bunch of analysis product tables.  That is, the hash acts as a message digest for some combination of parameters.  By doing things this way, I'm delinking the analysis product tables from the parameters tables -- otherwise I'd have to duplicate a set of analysis product tables for every model.

Of course my original idea was to plan on using the entire combination of parameters as a compound index, but that became unwieldy as larger models had parameter counts climbed over 100, and I'd still have to duplicate the analysis product tables anyway.

On August 16, 2018 at 2:09 AM "liviuslivius liviuslivius@... [firebird-support]" <firebird-support@yahoogroups.com> wrote:

Hi,

may i ask what is the purpose of this hash?

Regards,

Karol Bieniaszewski

 

Elias Sabbagh
Victor Technologies, LLC
ehs@...