Installing and Configuring the Hash64 Function

Topics:

Omni-Patient HealthViews relies on a Hash64 function to create unique keys for the tables in the Omni-Patient HealthViews schema. In addition, the Hash64 function is used to create integer values for fields that are character strings in Omni-Patient. Joining integer fields provides improved performance than joining character strings.

Installing the Hash64 Function

The Hash64 function code is contained in the ibi_functions.so file. A system administrator who has the required authorization, must place the ibi_functions.so file in a known location (the default is /opt/pgsql) and set permissions to 755 (readable to all, executable by all).

A shell script (register.sh) is used to install the Hash64 function. Execute this script by typing the following command:

./register.sh [database_name]

where:

[database_name]

Is the name of the database where you want to install the Hash64 function.

Note: Only a system administrator who has the required authorization must perform the steps described in this section.