Method and apparatus for protecting private information within a database
AssigneeOracle International Corporation
InventorVipin Samar
Life of this patent
Estimating the term…
Abstract
One embodiment of the present invention provides a system that facilitates protecting an item of private information in a database, wherein the item of private information is used as a key for retrieving data from the database. During operation, the system receives the item of private information and creates a hash of the item. The system then stores the hash in the database along with any associated information in a database record containing the hash.
Claims12
A method for protecting an item of private information in a database, wherein the method comprises:
- receiving the item of private information at a database in plain text, wherein the item of private information is used as a key for retrieving data from the database;
- creating a hash of the item of private information at the database, wherein creating the hash farther comprises checking a column attribute for a column, which stores the item of private information, in the database to determine that “privacy” is enabled for the column, and only upon privacy being enabled for the column, creating the hash, wherein the hash of the item of private information is created by the database in a manner that is transparent to an application which manipulates the private information, and wherein the hash is a one-way hash;
- storing the hash of the item of private information in the database, wherein the hash of the item of private information is a unique lookup key within the database, and wherein the item of private information does not exist in the database in plain-text form;
- creating an index based on the hash;
- and
- discarding the item of private information.
A computer-readable storage medium storing instructions that when executed by a computer cause the computer to perform a method for protecting an item of private information in a database, wherein the method comprises:
- receiving the item of private information at a database in plain text, wherein the item of private information is used as a key for retrieving data from the database;
- creating a hash of the item of private information at the database, wherein creating the hash farther comprises checking a column attribute for a column, which stores the item of private information, in the database to determine that “privacy” is enabled for the column, and only upon privacy being enabled for the column, creating the hash, wherein the hash of the item of private information is created by the database in a manner that is transparent to an application which manipulates the private information, and wherein the hash is a one-way hash;
- storing the hash of the item of private information in the database, wherein the hash of the item of private information is a unique lookup key within the database, and wherein the item of private information does not exist in the database in plain-text form;
- creating an index based on the hash;
- and
- discarding the item of private information.
Dependencies are inferred from the claim text.