Systems and methods for secure provisioning of access to tiered databases
Implementations are disclosed herein to provide tiered access to databases. In some implementations, a method includes an enrollment processor, generating, at the enrollment processor, an encryption key specific to a computing device associated with the tiered data; providing the encryption key to the computing device; receiving, at the enrollment processor, the tiered data that includes at least first tier data and second tier data, storing the tiered data, receiving, at the enrollment processor, an access request from a second computing device associated with a user, determining, using the in-memory cache, whether there is a match between the data elements and the stored second tier data, based on determination that there is the match, performing a decryption of a portion of the first tier data using the encryption key, and storing the decrypted portion of the first tier data in a third database connected to the enrollment processor.
1 . A computer-implemented method to provide access to tiered data comprising:
providing an enrollment processor, wherein the enrollment processor is connected to a network via a firewall, and wherein the enrollment processor is communicatively coupled to a bastion host and a load balancer;
generating, at the enrollment processor, an encryption key specific to a computing device associated with the tiered data;
providing the encryption key to the computing device;
receiving, at the enrollment processor, the tiered data that includes at least first tier data and second tier data, wherein the first tier data comprises encrypted data that has been encrypted using the provided encryption key and the second tier data comprises unencrypted data;
storing the tiered data, wherein the first tier data is stored at a first database connected to the enrollment processor, and the second tier data is stored in an in-memory cache connected to the enrollment processor;
receiving, at the enrollment processor, an access request from a second computing device associated with a user, wherein the access request includes data elements from the second tier data, and wherein the data elements are associated with the user;
determining, using the in-memory cache, whether there is a match between the data elements and the stored second tier data;
based on determination that there is the match, performing a decryption of a portion of the first tier data using the encryption key; and
storing the decrypted portion of the first tier data in a third database connected to the enrollment processor.
2 . The computer-implemented method of claim 1 , further comprising based on a determination that there is no match between the data elements and the stored second tier data, retrieving additional data elements from the first database.
3 . The computer-implemented method of claim 1 , wherein receiving the tiered data comprises receiving the tiered data via one of: a web interface and a file exchange.
4 . The computer-implemented method of claim 1 , wherein receiving the tiered data comprises receiving the tiered data as a batch-wise addition to the first database.
5 . The computer-implemented method of claim 1 , wherein determining whether there is a match between the data elements and the stored second tier data comprises performing a cache hit of the in-memory cache.
6 . The computer-implemented method of claim 1 , further comprising preloading the first tier data and the second tier data into a grid, and wherein determining whether there is the match comprises determining whether a threshold number of data elements in the access request match data elements in the first tier data and the second tier data.
7 . The computer-implemented method of claim 1 , wherein receiving the access request from a second computing device associated with a user comprises receiving the access request via a short messaging service (SMS) message and wherein the method further comprises parsing the access request to determine a language of the access request.
8 . A system, comprising:
a user device configured to transmit an access request; and
an enrollment processor, coupled to a data cache memory and to a first database, an in-memory cache, and a third database, wherein the enrollment processor is connected to a network via a firewall, and wherein the enrollment processor is communicatively coupled to a bastion host and a load balancer, and wherein the enrollment processor is configured to:
generating an encryption key specific to a computing device associated with tiered data;
providing the encryption key to the computing device;
receiving the tiered data that includes at least first tier data and second tier data, wherein the first tier data comprises encrypted data that has been encrypted using the provided encryption key and the second tier data comprises unencrypted data;
storing the tiered data, wherein the first tier data is stored at a first database connected to the enrollment processor, and the second tier data is stored in an in-memory cache connected to the enrollment processor;
receiving an access request from a second computing device associated with a user, wherein the access request includes data elements from the second tier data, and wherein the data elements are associated with the user;
determining, using the in-memory cache, whether there is a match between the data elements and the stored second tier data;
based on determination that there is the match, performing a decryption of a portion of the first tier data using the encryption key; and
storing the decrypted portion of the first tier data in a third database connected to the enrollment processor.
9 . The system of claim 8 , wherein the enrollment processor is further configured to based on a determination that there is no match between the data elements and the stored second tier data, retrieving additional data elements from the first database.
10 . The system of claim 8 , wherein receiving the tiered data comprises receiving the tiered data via one of: a web interface and a file exchange.
11 . The system of claim 8 , wherein receiving the tiered data comprises receiving the tiered data as a batch-wise addition to the first database.
12 . The system of claim 8 , wherein determining whether there is a match between the data elements and the stored second tier data comprises performing a cache hit of the in-memory cache.
13 . The system of claim 8 , wherein the enrollment processor is further configured to preloading the first tier data and the second tier data into a grid, and wherein determining whether there is the match comprises determining whether a threshold number of data elements in the access request match data elements in the first tier data and the second tier data.
14 . The system of claim 8 , wherein receiving the access request from a second computing device associated with a user comprises receiving the access request via a short messaging service (SMS) message and wherein the enrollment processor is further configured to parsing the access request to determine a language of the access request.
15 . A non-transitory computer-readable medium comprising instructions that, responsive to execution by a processing device, cause the processing device to perform operations comprising:
providing an enrollment processor, wherein the enrollment processor is connected to a network via a firewall, and wherein the enrollment processor is communicatively coupled to a bastion host and a load balancer;
generating, at the enrollment processor, an encryption key specific to a computing device associated with tiered data;
providing the encryption key to the computing device;
receiving, at the enrollment processor, the tiered data that includes at least first tier data and second tier data, wherein the first tier data comprises encrypted data that has been encrypted using the provided encryption key and the second tier data comprises unencrypted data;
storing the tiered data, wherein the first tier data is stored at a first database connected to the enrollment processor, and the second tier data is stored in an in-memory cache connected to the enrollment processor;
receiving, at the enrollment processor, an access request from a second computing device associated with a user, wherein the access request includes data elements from the second tier data, and wherein the data elements are associated with the user;
determining, using the in-memory cache, whether there is a match between the data elements and the stored second tier data;
based on determination that there is the match, performing a decryption of a portion of the first tier data using the encryption key; and
storing the decrypted portion of the first tier data in a third database connected to the enrollment processor.
16 . The non-transitory computer-readable medium of claim 15 , wherein the operations further comprise based on a determination that there is no match between the data elements and the stored second tier data, retrieving additional data elements from the first database.
17 . The non-transitory computer-readable medium of claim 15 , wherein receiving the tiered data comprises receiving the tiered data via one of: a web interface and a file exchange.
18 . The non-transitory computer-readable medium of claim 15 , wherein receiving the tiered data comprises receiving the tiered data as a batch-wise addition to the first database.
19 . The non-transitory computer-readable medium of claim 15 , wherein determining whether there is a match between the data elements and the stored second tier data comprises performing a cache hit of the in-memory cache.
20 . The non-transitory computer-readable medium of claim 15 , wherein receiving the access request from a second computing device associated with a user comprises receiving the access request via a short messaging service (SMS) message and wherein the operations further comprise parsing the access request to determine a language of the access request.