System and method for generating reversible anonymized record identifiers from a remote data system

A method comprising:

• extracting, by at least one processor of a data retrieval server, at least one data value from a record in a remote data store as a primary key that uniquely represents the record in the remote data store;
• encrypting, by the at least one processor, the primary key using a secret key and an initialization vector to create a reversible public identifier that represents the primary key and the record in the remote data store, wherein the secret key and the initialization vector for the record are randomly generated;
• storing, by the at least one processor, the secret key and the initialization vector in a local data store associated with the data retrieval server and transmitting the reversible public identifier to a client computing device prior to the client computing device requesting data from the record;
• receiving, by the at least one processor, a request for data from the record including the reversible public identifier, decrypting the reversible public identifier using the secret key and the initialization vector from the local data store to determine the primary key, and querying at least one data value different from the primary key in the remote data store using the primary key;
• receiving the at least one data value different from the primary key from the remote data store;
• and
• transmitting, by the at least one processor, the at least one data value different from the primary key to the client computing device for display.

A non-transitory computer-readable storage medium, having instructions stored thereon that, when executed by a computing device cause the computing device to perform operations, the operations comprising:

• extracting at least one data value from a record in a remote data store as a primary key that uniquely represents the record in the remote data store;
• encrypting the primary key using a secret key and an initialization vector to create a reversible public identifier that represents the primary key and the record in the remote data store, wherein the secret key and the initialization vector for the record are randomly generated;
• storing the secret key and the initialization vector in a local data store and transmitting the reversible public identifier to a client computing device prior to the client computing device requesting data from the record;
• receiving request for data from the record including the reversible public identifier, decrypting the reversible public identifier using the secret key and the initialization vector from the local data store to determine the primary key, and querying at least one data value different from the primary key in the remote data store using the primary key;
• receiving the at least one data value different from the primary key from the remote data store;
• and
• transmitting the at least one data value different from the primary key to the client computing device for display.