Abstract: A method includes performing by a host system processor: receiving a record insert request for a database, the record insert request comprising a primary key value and a semi-unique key value, the database comprising a record structure comprising a first primary key field, a second primary key field, and a semi-unique key field, the first primary key field comprising a flag portion for which a first flag value is indicative of the first primary key field containing a primary key and a second flag value is indicative of the first primary key field containing an alternate primary key, generating an alternate primary key value based on the primary key value and the semi-unique key value, the alternate primary key value having a portion thereof corresponding to the flag portion of the first primary key field set to the second flag value, generating a record comprising the alternate primary key value in the first primary key field, the primary key value in the second primary key field, and the semi-unique key valu