Securing data storage of personally identifiable information in a database

1. A computer-implemented method for storing personally identifiable information, comprising:

receiving, by at least one hardware processor, a request to store a data record, wherein the data record comprises personally identifiable information for a person;

dividing, by the at least one hardware processor, the data record into at least two portions of the personally identifiable information;

selecting, by the at least one hardware processor, a database table cell for each portion of the at least two portions of the personally identifiable information, wherein the database table cells for different portions of the personally identifiable information for the same person are in different database rows, and wherein selecting the database table cell comprises:

determining a user ID associated with the personally identifiable information; and

determining, based on the user ID using a hashing function, at least one of a row ID, a table ID, or a column ID of each database table cell storing the respective portion of the personally identifiable information; and

storing, by the at least one hardware processor, the at least two portions of the personally identifiable information in the selected database table cells.

2. The method of claim 1 , further comprising:

receiving a query for the personally identifiable information;

determining the database table cells that store the at least two portions of the personally identifiable information for the personally identifiable information;

retrieving the at least two portions of the personally identifiable information from the database table cells;

combining the at least two portions of the personally identifiable information to reconstruct the data record; and

outputting the reconstructed data record in response to the query.

3. The method of claim 1 , wherein the at least two portions of the personally identifiable information comprise a first portion and a second portion, the first portion comprises a name of the person, and the second portion comprises at least one of an identification number, a phone number, a home address, or an email address of the person.

4. The method of claim 1 , wherein the user ID is determined based on the personally identifiable information.

5. The method of claim 1 , wherein the user ID is determined using a random number generator.

6. A non-transitory computer-readable medium storing instructions which, when executed, cause a computing device to perform operations comprising:

receiving, by at least one hardware processor, a request to store a data record, wherein the data record comprises personally identifiable information for a person;

dividing, by the at least one hardware processor, the data record into at least two portions of the personally identifiable information;

selecting, by the at least one hardware processor, a database table cell for each portion of the at least two portions of the personally identifiable information, wherein the database table cells for different portions of the personally identifiable information for the same person are in different database rows, and wherein selecting the database table cell comprises:

determining a user ID associated with the personally identifiable information; and

determining, based on the user ID using a hashing function, at least one of a row ID, a table ID, or a column ID of each database table cell storing the respective portion of the personally identifiable information; and

storing, by the at least one hardware processor, the at least two portions of the personally identifiable information in the selected database table cells.

7. The computer-readable medium of claim 6 , the operations further comprising:

receiving a query for the personally identifiable information;

determining the database table cells that store the at least two portions of the personally identifiable information for the personally identifiable information;

retrieving the at least two portions of the personally identifiable information from the database table cells;

combining the at least two portions of the personally identifiable information to reconstruct the data record; and

outputting the reconstructed data record in response to the query.

8. The computer-readable medium of claim 6 , wherein the at least two portions of the personally identifiable information comprise a first portion and a second portion, the first portion comprises a name of the person, and the second portion comprises at least one of an identification number, a phone number, a home address, or an email address of the person.

9. The computer-readable medium of claim 6 , wherein the user ID is determined based on the personally identifiable information.

10. The computer-readable medium of claim 6 , wherein the user ID is determined using a random number generator.

11. A device, comprising:

at least one hardware processor; and

a non-transitory computer-readable storage medium coupled to the at least one hardware processor and storing programming instructions for execution by the at least one hardware processor, wherein the programming instructions, when executed, cause the at least one hardware processor to perform operations comprising:

receiving a request to store a data record, wherein the data record comprises personally identifiable information for a person;

dividing the data record into at least two portions of the personally identifiable information;

selecting a database table cell for each portion of the at least two portions of the personally identifiable information, wherein the database table cells for different portions of the personally identifiable information for the same person are in different database rows, and wherein selecting the database table cell comprises:

determining a user ID associated with the personally identifiable information; and

determining, based on the user ID using a hashing function, at least one of a row ID, a table ID, or a column ID of each database table cell storing the respective portion of the personally identifiable information; and

storing the at least two portions of the personally identifiable information in the selected database table cells.

12. The device of claim 11 , the operations further comprising:

receiving a query for the personally identifiable information;

determining the database table cells that store the at least two portions of the personally identifiable information for the personally identifiable information;

retrieving the at least two portions of the personally identifiable information from the database table cells;

combining the at least two portions of the personally identifiable information to reconstruct the data record; and

outputting the reconstructed data record in response to the query.

13. The device of claim 11 , wherein the at least two portions of the personally identifiable information comprise a first portion and a second portion, the first portion comprises a name of the person, and the second portion comprises at least one of an identification number, a phone number, a home address, or an email address of the person.

14. The device of claim 11 , wherein the user ID is determined based on the personally identifiable information.