Abstract | ||
---|---|---|
There is some private and sensitive data in database, which need to be protected from attacking. In order to reinforce the security of data, an effective mechanism, cryptographic support has been widely used. However, we must make a tradeoff between the performance and the security because encryption and decryption greatly degrade the query performance. To solve such a problem, a novel approach is proposed in this paper that can quickly execute SQL query on the encrypted data. For character data, it not only encrypts them, but also turns the character data into characteristic values via a characteristic function and stores them as additional fields. For numerical data, it not only encrypts them, but also creates its B+ tree index before the encryption in order to keep the ordering of each record in the index. Furthermore, we give the algorithms of querying the encrypted data based on the storage models. Results of sets of experiments validate the functionality and usability of our approach |
Year | DOI | Venue |
---|---|---|
2005 | 10.1109/CIT.2005.174 | CIT |
Keywords | Field | DocType |
database management systems,numerical data,cryptographic method,b+ tree index,cryptography,encrypted data,tree data structures,data security,storage model,tree index,sql query performance,sensitive data,database management system,sql query,query performance,characteristic value,encrypted character,characteristic function,character data,novel approach,query processing,sql,indexation,b tree index | SQL,Data mining,Data security,Computer science,Cryptography,Tree (data structure),B-tree,Encryption,Storage model,Link encryption,Database | Conference |
ISBN | Citations | PageRank |
0-7695-2432-X | 13 | 0.77 |
References | Authors | |
5 | 3 |
Name | Order | Citations | PageRank |
---|---|---|---|
Zheng-Fei Wang | 1 | 28 | 1.62 |
Wei Wang | 2 | 382 | 21.84 |
Baile SHI | 3 | 679 | 57.46 |