×

Virtual masked database

  • US 9,311,369 B2
  • Filed: 08/15/2008
  • Issued: 04/12/2016
  • Est. Priority Date: 04/28/2008
  • Status: Active Grant
First Claim
Patent Images

1. A system, comprising:

  • a data store configured to store a database table that stores sets of data corresponding to records in respective rows, where the database table includes an unmasked column that stores an unmasked version of given data and a masked column that stores a masked version of the data such that each row includes i) a unmasked field in the unmasked column that stores an unmasked version of data, and ii) a masked field in the masked column that stores the masked version of the data;

    view logic configured to;

    receive a request from a first user to view data in a record;

    access a row in the database table that stores the record;

    determine that the first user is not authorized to view an unmasked version of the data; and

    provide a view that includes a masked version of the data in a masked field in the row; and

    update logic configured to;

    receive, from the first user, a modification to the masked version of data in the masked field;

    access a mapping table to identify an unmasked field that stores an unmasked version of the data; and

    update the unmasked version of the data in the identified unmasked field to correspond to the modification made to the masked version of the data.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×