Systems and methods for implementing secure database requests in a role-based application environment
The present disclosure relates to systems and methods for implementing secure database requests in a role-based application. In one example, the system may include at least one memory storing instructions and at least one processor configured to execute the instructions. The instructions may include instructions to receive, from a user device, a request to access data from a relational database; based on the request, extract the data from the relational database; perform one or more join commands on the data to generate an object in an object-oriented programming language having the joined data; convert the object to a data serialized format configured for use in a graphical user interface generator; and transmit the data serialized format to the user device.
1. A method for fulfilling secure database requests from a role-based application, the method comprising:
receiving, at a server and from a user device, a request to access data associated with a health facility from a non-relational database comprising patient-specific data and bed-specific data, wherein the request comprises a pull;
extracting, at the server, the data from the database based upon the request, wherein the extracting comprises directly extracting the data in a serialized format based upon the pull, wherein the extracting comprises encrypting a portion of the data in the serialized format corresponding to the patient-specific data and wherein the bed-specific data remains unencrypted; and
generating a graphical user interface for a user from the extracted data, wherein information displayed in the graphical user interface is customized from the data based upon a role of the user, wherein the information comprises statistics of the health facility and corresponding to the role of the user, wherein the graphical user interface displays different statistics for different user roles.
2. The method of claim 1 , wherein the information displayed comprises at least one warning indicating that at least one statistic included in the information has exceeded a threshold.
3. The method of claim 1 , comprising transmitting a notification to the user responsive to determining a threshold set by the user and based upon the role of the user has been reached.
4. The method of claim 1 , wherein the data is encrypted and wherein the information for display is encrypted to the user device.
5. The method of claim 1 , wherein the request is generated automatically based upon user navigation within an application on the user device.
6. A device for fulfilling secure database requests from a role-based application, the device comprising:
a server comprising a processor and memory device that stores instructions executable by the processor; and
a non-relational database operatively coupled to the server and comprising patient-specific data and bed-specific data;
the instructions comprising instructions that:
receive, at the server and from a user device, a request to access data associated with a health facility from the database, wherein the request comprises a pull;
extract, at the server, the data from the database based upon the request, wherein the extracting comprises directly extracting the data in a serialized format based upon the pull, wherein the extracting comprises encrypting a portion of the data in the serialized format corresponding to the patient-specific data and wherein the bed-specific data remains unencrypted; and
generate a graphical user interface for a user from the extracted data, wherein information displayed in the graphical user interface is customized from the data based upon a role of the user, wherein the information comprises statistics of the health facility and corresponding to the role of the user, wherein the graphical user interface displays different statistics for different user roles.
7. The device of claim 6 , wherein the information displayed comprises at least one warning indicating that at least one statistic included in the information has exceeded a threshold.
8. The device of claim 6 , comprising transmitting a notification to the user responsive to determining a threshold set by the user and based upon the role of the user has been reached.
9. The device of claim 6 , wherein the data is encrypted and wherein the information for display is encrypted to the user device.
10. The device of claim 6 , wherein the request is generated automatically based upon user navigation within an application on the user device.
11. A product for fulfilling secure database requests from a role-based application, the product comprising:
a storage device that stores code, the code being executable by a processor and comprising:
code that receives, at a server and from a user device, a request to access data associated with a health facility from a non-relational database comprising patient-specific data and bed-specific data, wherein the request comprises a pull;
code that extracts, at the server, the data from the database based upon the request, wherein the extracting comprises directly extracting the data in a serialized format based upon the pull, wherein the extracting comprises encrypting a portion of the data in the serialized format corresponding to the patient-specific data and wherein the bed-specific data remains unencrypted; and
code that generates a graphical user interface for a user from the extracted data, wherein information displayed in the graphical user interface is customized from the data based upon a role of the user, wherein the information comprises statistics of the health facility and corresponding to the role of the user, wherein the graphical user interface displays different statistics for different user roles.