Maintaining Database Referential Integrity Using Different Primary and Foreign Key Values

摘要

A computing device managing a database receives a database command comprising first and second identifiers identifying first and second datasets, respectively, in the database. The database command further comprises a key translation indicator identifying a key value translation function. Responsive to receiving the database command, the computing device generates a translated key value from a primary key value of a first record in the first dataset using the key value translation function, and generates a second record in the second dataset. The second record comprises the translated key value. Subsequently, the computing device selects the first and second records from the first and second datasets, respectively. To select the first and second records, the computing device applies the key value translation function to one of the primary or translated key value to determine the other of the primary or translated key value.