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 statement.
Legal claims defining the scope of protection, as filed with the USPTO.
1. In a database to store a table having encrypted columns, a computer implemented method of configuring indexes for the encrypted columns comprising the steps of: (a) reading an 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, in the computer, the re-encrypted column data in a table for indexes which is used by a domain index architecture (e) creating indexes according to the sort ordering based on the plain text from the decrypted data of a re-encrypted column of the table for indexes; and (f) configuring a domain index which uses the table for indexes and the indexes created in the table for indexes.
Cooperative Patent Classification codes for this invention. Click any code to explore related patents in that topic.
September 28, 2007
October 2, 2012
Browse 5M+ US patents with plain-English claim translations and AI-generated analysis.