METHOD FOR INDEXING ENCRYPTED COLUMN
First Claim
Patent Images
1. In a database to store a table having encrypted columns, a method of configuring indexes for the encrypted columns comprising the steps of:
- (a) reading a encrypted column data from the table;
(b) decrypting the read encrypted column data;
(c) re-encrypting the decrypted column data to be able to maintain a sort ordering based on a plain text from the decrypted data;
(d) storing the re-encrypted column data in a table for indexes which is used by a domain index architecture;
(e) creating indexes of re-encrypted column of the table; and
(f) configuring a domain index which uses the table for the stored index and the stored indexes created in the table for indexes.
1 Assignment
0 Petitions
Accused Products
Abstract
The present invention relates to a method of creating indexes so that an index scan can be worked for columns in a database encrypted by means of secrete key cipher algorithm. The method of creating indexes according to the present invention comprises the steps of: re-encrypting to be able to maintain the sort ordering based on a plain text; creating new indexes based on the re-encrypted data; and configuring domain index architecture of encrypted columns so that the created index is used for the index scan in a query
-
Citations
3 Claims
-
1. In a database to store a table having encrypted columns, a method of configuring indexes for the encrypted columns comprising the steps of:
-
(a) reading a encrypted column data from the table; (b) decrypting the read encrypted column data; (c) re-encrypting the decrypted column data to be able to maintain a sort ordering based on a plain text from the decrypted data; (d) storing the re-encrypted column data in a table for indexes which is used by a domain index architecture; (e) creating indexes of re-encrypted column of the table; and (f) configuring a domain index which uses the table for the stored index and the stored indexes created in the table for indexes. - View Dependent Claims (2, 3)
-
Specification