Patent ID: 8276206

Claim:
A method of retrieving targeted retained data, the method implemented by a system which comprises a receiver, a processor, a transmitter and a database, the method comprising the steps of: receiving, by the receiver, a request to access targeted retained data associated with a targeted user, the request including partial search matching criteria associated with the targeted user; accessing, by the processor, a first table in the database, the first table including a plain column having unencrypted identification data associated with a plurality of users, and the first table including an encrypted index column having an encrypted index associated with each of the plurality of users; selecting, by the processor, from the first table at least one encrypted index that matches the partial search matching criteria; accessing, by the processor, a second table in the database, the second table including a plain index column having unencrypted index associated with each of the plurality of users, and the second table including a retained data column having a plurality of retained data including the targeted retained data; selecting, by the processor, from the second table at least one unencrypted index associated with the at least one selected encrypted index; identifying, by the processor, the targeted retained data in the column of retained data, where the targeted retained data associated with the at least one selected unencrypted index; and, retrieving, by the processor, the targeted retained data from the database.