The present application is related to the following applications that are concurrently filed and the entire contents of which are hereby incorporated by reference as if fully set forth herein. The related concurrently filed applications are: T
The present invention is directed to data security, and more specifically to protecting sensitive data that resides in a database and providing a mechanism for automating the re-encryption of selected data of the database using new encryption keys in order to further secure database with little or no impact on the database and on the applications that access the database.
It cannot be gainsaid that confidential information, such as credit card numbers, social security numbers, patient records, insurance data, etc., need to be protected. Although enterprises have instituted procedures for protecting such sensitive data when such data is in transit, more often than not, such data is stored in unencrypted format (“clear text” or “plain text”). For example, data is often stored as clear text in databases. The clear text is visible to attackers and disgruntled employees who can then compromise the data and/or use the data illegitimately. Further, not only is data security a feature that is highly desired by customers but it is also needed to comply with certain data security regulations. In order to adequately protect data, organizations need to institute procedures to protect data at all times including when the data is in storage, when the data is in transit, and when the data is being used.
Once the data in a target database has been encrypted, security of the data can be further enhanced by periodically re-encrypting the data in the database. It is desirable to automate the re-encryption process with as little impact on the administrator of the target database and/or the applications that access the target database.
According to certain embodiments, an unsecured relational database system is first converted to a secure system by providing mechanisms for converting existing data that resides in the relational database into encrypted format with minimal impact to the resources of the relational database. According to certain embodiments, after the relational database is converted to a secure system, the security of such a relational database is further enhanced by periodically re-encrypting the data in the database using new encryption keys. The periodic re-encryption of data in the database using new encryption keys is herein referred to as key rotation.
According to certain embodiments, a mechanism is provided for automatically selecting a new encryption key for re-encrypting data in the target database. According to certain embodiments, new initialization vectors may be specified for re-encrypting each column of data selected for re-encryption. According to certain embodiments, a new initialization vector may be specified for one or more rows of data in a database table that is selected for re-encryption.
According to certain embodiments, the mechanism that is used for automatically re-encrypting data in the target database includes the following functionality: 1) allow a user to select one or more previously encrypted columns for re-encryption, 2) allow the user to specify a new initialization vector at the column level for columns selected by the user for re-encryption, 3) allow the user to request for the generation of a new initialization vector at the row level for each row selected by the user for re-encryption, 4) allow the user to specify a new encryption key for use in the re-encryption of the column or row data selected by the user, 5) allow the user to specify a batch size for the re-encryption of the data selected by the user, 6) execute the re-encryption as specified by the user, 7) log the history of the encryption key usage to assist in data decryption of back-up data of the relational database at a later time, if so desired, and 8) allow the user to specify a different encryption mode, if desired.
According to certain embodiments, a mechanism is provided to allow the re-encryption of the user selected data to occur on a device that is separate from the relational database so as to not drain the computing and storage resources of the relational database. Such a mechanism can include a management console for managing the re-encryption of data specified by the user from the target relational database.
According to certain embodiments, the re-encryption of the database data that is selected for re-encryption is performed on a specialized piece of hardware that is designed to rapidly perform data encryption on large volumes of data from the relational database that is targeted for conversion to a secure system. Further, such a specialized piece of hardware is equipped with its own CPU and processing power in order to offload the database server that is associated with the target relational database. According to certain other embodiments, the re-encryption of the user selected data is performed by the target database server or by some other mechanism related to the target database.
Cryptography server 114 is also referred to as a network-attached cryptography server (NAE server). Relational database 108 includes, among other components, a plurality of data tables such as table 110 and a plurality of metadata tables such as metadata table 112. The metadata tables such as metadata table 112 in the relational database can be used for storing information that includes but is not limited to 1) each authorized user's access rights with respect to database tables and columns managed by the relational database, and 2) database table and column schema, 3) information on encryption methods, and 4) information on properties of tables and columns that are selected for encryption from the target database. The cryptography server retrieves target data selected by the user from the target relational database for re-encryption. The cryptography server then performs re-encryption on the user selected data using the new encryption key and/or new initialization vector selected by the user.
A user such as a security administrator or database administrator can use a client computer to manage the re-encryption process of data in the relational database by accessing a data management console associated with the cryptography server. According to certain embodiments, the data management console allows the user to login to a desired database server and select data for re-encryption. In certain other embodiments, the desired relational database may include a database provider and cryptography provider. According to certain embodiments, the database provider is that portion of the computer-implemented functionality that resides on the database server and that communicates with the NAE server. The cryptography provider communicates with the cryptography server to request for cryptography services. The cryptography provider is the API to the cryptography server, according to certain embodiments.
According to certain embodiments, the cryptography server, such as the NAE server, manages cryptography operations and encryption key management operations. The cryptography server allows a user or cryptography server client to perform cryptography operations including operations associated with the encryption and decryption of data, encryption keys, authentication, creation of digital signatures, generation and verification of Message Authentication Code (MAC).
According to certain embodiments, the cryptography server includes a key rotation tool that includes the following functionality: 1) allow a user to select one or more previously encrypted columns for re-encryption, 2) allow the user to specify a new initialization vector at the column level for columns selected by the user for re-encryption, 3) allow the user to request generation of a new initialization vector at the row level for each row selected by the user for re-encryption, 4) allow the user to specify a new encryption key for use in the re-encryption of the column or row data selected by the user, 5) allow the user to specify a batch size for the re-encryption of the data selected by the user, 6) execute the re-encryption as specified by the user, 7) log the history of the encryption key usage to assist in data decryption of back-up data of the relational database at a later time, if so desired, and 8) allow the user to specify a different encryption mode, if desired.
At block 202 of
When the user's login information is submitted, an attempt to connect to the target database server is initiated. According to certain embodiments, if the connection attempt is successful, the database connection information is stored on the cryptography server. Such database connection information can be collected and stored for each type of database so that during future login attempts, the user can be presented with a login screen that requires a minimum amount of data entry for a selected target database.
If the connection attempt to connect with to the target database is unsuccessful, then the user may be presented with an error message and is allowed to re-enter login information.
At block 204 of
At block 206 of
At block 210 of
At block 214, the user is allowed to specify a batch size for controlling the number of rows that are processed before being committed. At block 216 of
In the foregoing specification, embodiments of the invention have been described with reference to numerous specific details that may vary from implementation to implementation. The specification and drawings are, accordingly, to be regarded in an illustrative rather than a restrictive sense.