Database System Providing SQL Extensions for Automated Encryption and Decryption of Column Data
First Claim
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.
1 Assignment
0 Petitions
Accused Products
Abstract
A database system providing SQL extensions for automated encryption and decryption of column data is described. In one embodiment, for example, in a database system, a method is described for providing automated encryption support for column data, the method comprises steps of: 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 the 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.
209 Citations
99 Claims
-
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 Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36)
-
-
37. A database system providing automated encryption support for column data, the system comprising:
-
a parser that supports Structured Query Language (SQL) extensions for creating and managing column encryption keys, and for creating and managing database tables with encrypted column data; and
an execution unit, operating in response to SQL statements parsed by the parser, for creating a particular column encryption key, for creating a database table having particular column data encrypted with said particular column encryption key, and for automatically decrypting the particular column data for use by a subsequent database operation that requires the particular column data that has been encrypted. - View Dependent Claims (38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70)
-
-
71. In a database system, a method for encrypting column data, the method comprising:
-
in response to a first query language statement, creating an encryption key for encrypting a particular column of a database table;
in response to a second query language statement, encrypting the particular column using said encryption key; and
during a subsequent database operation requiring column data from the particular column, automatically decrypting the column data for use by the database operation. - View Dependent Claims (72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99)
-
Specification