Unique surrogate key generation using cryptographic hashing

摘要

The present invention relates to a method or system of generating a surrogate key using cryptographic hashing. One embodiment of the method of the present invention may have steps such as selecting a field or group of fields that is or are unique among all records in the database and for each record, extracting the data from the fields; concatenating the extracted data into an input message; running the input message through a hash generator, either in batches or one at a time, for testing purposes perhaps; and outputting a surrogate key.

主权项

1. A method for generating a surrogate key using cryptographic hashing in a system having a database having records, the records having fields having data therein, the method comprising:
selecting a field that is unique among all records in the database and for each record, extracting the data from the fields; concatenating the extracted data to yield an input message; inputting the input message to a hash generator to perform the following steps:
dividing the input message into a set of chunks;dividing each chunk into a first set of words;generating a second set of words based on the first set of words;generating a third set of words based on the second set of words; andgenerating final results for each message based on the third set of words; and outputting a surrogate key based on the final results, wherein sequential generations of the surrogate key for an identical record by the hash generator yield identical results.