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 system for fulfilling secure database requests from a role-based application, the system comprising:
at least one memory storing instructions; and
at least one processor configured to execute the instructions to:
receive, from a user device, a request comprising an application program interface (API) pull of a data in a data serialized format from a relational database, wherein the request is generated automatically based upon user navigation within an application, wherein the relational database comprises data associated with a health facility;
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, the generated object having the joined data;
convert the object to the data serialized format configured for use in a graphical user interface generator of the user device; and
transmit the data serialized format to the user device.
2. The system of claim 1 wherein:
the relational database is in communication with a mobile store, the mobile store having a plurality of mobile applications that store and receive data.
3. The system of claim 2 wherein:
the request to access data is transmitted to the mobile store.
4. The system of claim 2 wherein:
the request to access data is transmitted to the mobile store and data stored on the plurality of mobile applications is aggregated based on the request.
5. The system of claim 1 wherein:
the request to access data is transmitted at regular intervals to maintain a real-time access to the data.
6. The system of claim 1 , the data comprising:
a total number of available beds, a total number of occupied beds, and a total number of patients.
7. The system of claim 1 , the data comprising:
a percentage of available beds, a percentage of patients awaiting care, and a percentage of patients receiving care.
8. The system of claim 1 , the data comprising:
a percentage of vacant beds, a percentage of vacant beds that are clean, and a percentage of vacant beds that are dirty.
9. A non-transitory, computer-readable medium storing instructions for generating secure database requests in a role-based application, the instructions causing one or more processors to:
generate a request comprising an application program interface (API) pull of data in a data serialized format from a relational database, wherein the request is generated automatically based upon user navigation within an application, wherein the relational database comprises data associated with a health facility;
transmit the request to a remote device;
receive, in response to the request, the data in a data serialized format including the data; and
generate a graphical user interface comprising visual representations of the data in the data serialized format, wherein:
the data requested is selected based on user input and based on a role of the user, and
the generated graphical user interface is selected from a plurality of graphical user interfaces based on the requested data and based on the role.
10. The computer readable medium of claim 9 wherein:
the relational database is in communication with a mobile store, the mobile store having a plurality of mobile applications that store and receive data.
11. The computer readable medium of claim 10 wherein:
the request to access data is transmitted to the mobile store.
12. The computer readable medium of claim 10 wherein:
the request to access data is transmitted to the mobile store and data stored on the plurality of mobile applications is aggregated based on the request.
13. The computer readable medium of claim 9 wherein:
the request to access data is transmitted at regular intervals to maintain a real-time access to the data.
14. The computer readable medium of claim 9 , the data comprising:
a total number of available beds, a total number of occupied beds, and a total number of patients.
15. The computer readable medium of claim 9 , the data comprising:
a percentage of available beds, a percentage of patients awaiting care, and a percentage of patients receiving care.
16. The computer readable medium of claim 9 , the data comprising:
a percentage of vacant beds, a percentage of vacant beds that are clean, and a percentage of vacant beds that are dirty.
17. A computer implemented method for generating secure database requests in a role-based application, the method comprising:
receiving, from a user device, a request comprising an application program interface (API) pull of a data in a data serialized format from a relational database, wherein the request is generated automatically based upon user navigation within an application, wherein the relational database comprises data associated with a health facility;
extracting the data from the relational database based on the request;
performing one or more join commands on the data to generate an object in an object-oriented programming language, the generated object having the joined data;
converting the object to a data serialized format configured for use in a graphical user interface generator of the user device; and
transmitting the data serialized format to the user device.
18. The computer implemented method of claim 17 wherein:
the relational database is in communication with a mobile store, the mobile store having a plurality of mobile applications that store and receive data.
19. The computer implemented method of claim 18 wherein:
the request to access data is transmitted to the mobile store.
20. The computer implemented method of claim 18 wherein:
the request to access data is transmitted to the mobile store and data stored on the plurality of mobile applications is aggregated based on the request.