×

Database System Providing SQL Extensions for Automated Encryption and Decryption of Column Data

  • US 20060053112A1
  • Filed: 10/13/2004
  • Published: 03/09/2006
  • Est. Priority Date: 09/03/2004
  • Status: Active Grant
First Claim
Patent Images

1. In a database system, a method for providing automated encryption support for column data, the method comprising:

  • defining Structured Query Language (SQL) extensions for creating and managing column encryption keys, and for creating and managing database tables with encrypted column data;

    receiving an SQL statement specifying creation of a particular column encryption key;

    receiving an SQL statement specifying creation of a database table having particular column data encrypted with said particular column encryption key; and

    in response to a subsequent database operation that requires the particular column data that has been encrypted, automatically decrypting the particular column data for use by the database operation.

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