System and method for secure database management
A method includes encrypting a request received from a user device to generate an encrypted request. Encrypted data items are searched based on the encrypted request to identify desired encrypted data items. In response to determining that two or more encrypted data items of the desired encrypted data items have a same interaction identification, the two or more encrypted data items are locked and masked, and the masked two or more encrypted data items are removed. Algebraic operations are determined based on the encrypted request. An encrypted response is determined by performing the algebraic operations on the desired encrypted data items. The encrypted response is decrypted to obtain a decrypted response. An error is determined due to the algebraic operations performed on the desired encrypted data items. In response to determining that the error is less than an error threshold, the decrypted response is sent to the user device.
1. A database management system communicatively coupled to a data storage system and a user device of a user, the system comprising:
a memory configured to store an error threshold; and
a processor communicatively coupled to the memory, wherein the processor is configured to:
receive a request from the user device;
encrypt the request to generate an encrypted request;
search a plurality of encrypted data items stored in the data storage system based on the encrypted request to identify a plurality of desired encrypted data items;
in response to determining that two or more encrypted data items of the plurality of desired encrypted data items have a same interaction identification:
lock the two or more encrypted data items;
mask the two or more encrypted data items; and
remove the masked two or more encrypted data items from the plurality of desired encrypted data items;
retrieve the plurality of desired encrypted data items from the data storage system;
determine one or more algebraic operations based on the encrypted request;
determine an encrypted response based on the encrypted request and the plurality of desired encrypted data items by performing the one or more algebraic operations on the plurality of desired encrypted data items;
decrypt the encrypted response to obtain a decrypted response;
determine an error for the decrypted response due to the one or more algebraic operations performed on the plurality of desired encrypted data items; and
in response to determining that the error is less than the error threshold, send the decrypted response to the user device.
2. The database management system of claim 1 , wherein the processor is further configured to, in response to determining that the error is not less than the error threshold:
perform an error correction process on the decrypted response to obtain a corrected decrypted response;
determine a second error for the corrected decrypted response; and
in response to determining that the second error is less than the error threshold, send the corrected decrypted response to the user device.
3. The database management system of claim 1 , wherein encrypting the request comprises executing a homomorphic encryption algorithm.
4. The database management system of claim 1 , wherein the one or more algebraic operations comprise addition or multiplication.
5. The database management system of claim 1 , wherein:
the processor is further configured to generate a public key; and
encrypting the request to generate the encrypted request comprises encrypting the request using the public key.
6. The database management system of claim 1 , wherein:
the processor is further configured to generate a secret key; and
decrypting the encrypted response to obtain the decrypted response comprises decrypting the encrypted response using the secret key.
7. The database management system of claim 1 , wherein locking the two or more encrypted data items comprises preventing updates to the two or more encrypted data items.
8. A method comprising:
receiving a request from a user device;
encrypting the request to generate an encrypted request;
searching a plurality of encrypted data items stored in a data storage system based on the encrypted request to identify a plurality of desired encrypted data items;
in response to determining that two or more encrypted data items of the plurality of desired encrypted data items have a same interaction identification:
locking the two or more encrypted data items;
masking the two or more encrypted data items; and
removing the masked two or more encrypted data items from the plurality of desired encrypted data items;
retrieving the plurality of desired encrypted data items from the data storage system;
determining one or more algebraic operations based on the encrypted request;
determining an encrypted response based on the encrypted request and the plurality of desired encrypted data items by performing the one or more algebraic operations on the plurality of desired encrypted data items;
decrypting the encrypted response to obtain a decrypted response;
determining an error for the decrypted response due to the one or more algebraic operations performed on the plurality of desired encrypted data items; and
in response to determining that the error is less than an error threshold, sending the decrypted response to the user device.
9. The method of claim 8 , further comprising, in response to determining that the error is not less than the error threshold:
performing an error correction process on the decrypted response to obtain a corrected decrypted response;
determining a second error for the corrected decrypted response; and
in response to determining that the second error is less than the error threshold, sending the corrected decrypted response to the user device.
10. The method of claim 8 , wherein encrypting the request comprises executing a homomorphic encryption algorithm.
11. The method of claim 8 , wherein the one or more algebraic operations comprise addition or multiplication.
12. The method of claim 8 , further comprising generating a public key, wherein encrypting the request to generate the encrypted request comprises encrypting the request using the public key.
13. The method of claim 8 , further comprising generating a secret key, wherein decrypting the encrypted response to obtain the decrypted response comprises decrypting the encrypted response using the secret key.
14. The method of claim 8 , wherein locking the two or more encrypted data items comprises preventing updates to the two or more encrypted data items.
15. A non-transitory computer-readable medium storing instructions that, when executed by one or more processors, cause the one or more processors to:
receive a request from a user device;
encrypt the request to generate an encrypted request;
search a plurality of encrypted data items stored in a data storage system based on the encrypted request to identify a plurality of desired encrypted data items;
in response to determining that two or more encrypted data items of the plurality of desired encrypted data items have a same interaction identification:
lock the two or more encrypted data items;
mask the two or more encrypted data items; and
remove the masked two or more encrypted data items from the plurality of desired encrypted data items;
retrieve the plurality of desired encrypted data items from the data storage system;
determine one or more algebraic operations based on the encrypted request;
determine an encrypted response based on the encrypted request and the plurality of desired encrypted data items by performing the one or more algebraic operations on the plurality of desired encrypted data items;
decrypt the encrypted response to obtain a decrypted response;
determine an error for the decrypted response due to the one or more algebraic operations performed on the plurality of desired encrypted data items; and
in response to determining that the error is less than an error threshold, send the decrypted response to the user device.
16. The non-transitory computer-readable medium of claim 15 , wherein the instructions, when executed by the one or more processors, further cause the one or more processors to:
in response to determining that the error is not less than the error threshold:
perform an error correction process on the decrypted response to obtain a corrected decrypted response;
determine a second error for the corrected decrypted response; and
in response to determining that the second error is less than the error threshold, send the corrected decrypted response to the user device.
17. The non-transitory computer-readable medium of claim 15 , wherein encrypting the request comprises executing a homomorphic encryption algorithm.
18. The non-transitory computer-readable medium of claim 15 , wherein the one or more algebraic operations comprise addition or multiplication.
19. The non-transitory computer-readable medium of claim 15 , wherein the instructions, when executed by the one or more processors, further cause the one or more processors to generate a public key, wherein encrypting the request to generate the encrypted request comprises encrypting the request using the public key.
20. The non-transitory computer-readable medium of claim 15 , wherein the instructions, when executed by the one or more processors, further cause the one or more processors to generate a secret key, wherein decrypting the encrypted response to obtain the decrypted response comprises decrypting the encrypted response using the secret key.