Method for indexing encrypted column
AssigneeEglobal System Co.
InventorsHee-Chang Kang, Dae-Won Mun, Yu-Ho Kim
Life of this patent
Estimating the term…
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
Claims3
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.
Dependencies are inferred from the claim text.