Title
Storage and Query over Encrypted Character and Numerical Data in Database
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 Wang1281.62
Wei Wang238221.84
Baile SHI367957.46