# US 12,001,445 B1 · Systems and methods for implementing secure database requests in a role-based application environment > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 12,001,445 B1 - Document ID: US12001445B1 - Status: Granted - Kind: B1 - Application number: 18/192,074 - Filed: 2023-03-29 - Granted: 2024-06-04 - Earliest claimed: 2017-10-21 - Assignees: TeleTracking Technologies, Inc. - Applicants: TeleTracking Technologies, Inc. - Inventors: Anjali Tomer; Mark Wuslich; Deepak Bhurani; Jamie Slater; Kenneth Poling; Bhavya Sangars; Carol Cheng; Raghen Morrow; Twesha Mitra - Web page: https://patentgrep.com/patent/US12001445B1 ## CPC - G06F 16/252: {between a Database Management System and a front-end application} - G06F 16/24522: {Translation of natural language queries to structured queries} - G06F 16/2456: {Join operations} - G06F 16/26: Visual data mining; Browsing structured data - G06F 21/6227: {where protection concerns the structure of data, e.g. records, types, queries} - G06F 21/6245: {Protecting personal data, e.g. for financial or medical purposes} - G16H 10/60: for patient-specific data, e.g. for electronic patient records - G16H 40/20: for the management or administration of healthcare resources or facilities, e.g. managing hospital staff or surgery rooms - H04L 67/63: Routing a service request depending on the request content or context - H04W 4/029: Location-based management or tracking services - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - G16H: HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA - H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M) - H04W: WIRELESS COMMUNICATION NETWORKS (broadcast communication H04H; communication systems using wireless links for non-selective communication, e.g. wireless extensions H04M1/72) ## Abstract 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 aggregate, within a database, patient-specific data and bed-specific data into aggregated data comprising one or more statistics; receive a request to access the aggregated data; extract the aggregated data from the database based upon the request; and generate a graphical user interface for a user from the extracted aggregated data. ## Claims ### Claim 1 A method for fulfilling secure database requests from a role-based application, the method comprising: aggregating, within a database, patient-specific data and bed-specific data into aggregated data comprising one or more statistics, wherein the aggregating comprises converting the aggregated data from a relational database to a plurality of objects; receiving, at a server and from a user device, a request to access the aggregated data; extracting, at the server, the aggregated data from the database based upon the request, wherein the extracting comprises matching, utilizing a matching technique, an object of the plurality of objects to the request, wherein the extracting comprises encrypting at least a portion of the request corresponding to private information of the request and encrypting at least a portion of the aggregated data corresponding to private information of the aggregated data; and generating, using a graphical user interface generator, a graphical user interface for a user from the extracted aggregated data and customized for a role of the user, wherein the graphical user interface comprises a screen displaying at least a portion of the one or more statistics, wherein generating the graphical user interface comprises converting the objects of the extracted aggregated data into a format corresponding to the graphical user interface generator. ### Claim 2 (depends on 1) The method of claim 1, wherein the graphical user interface comprises a breakdown screen displaying statistics of the one or more statistics corresponding to a category. ### Claim 3 (depends on 1) The method of claim 1, wherein the graphical user interface is formatted based upon the role of the user and displays statistics of the one or more statistics corresponding to the role. ### Claim 4 (depends on 1) The method of claim 1, wherein the graphical user interface displays a warning based upon one of the one or more statistics exceeding a predetermined threshold. ### Claim 5 (depends on 1) 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. ### Claim 6 (depends on 1) The method of claim 1, wherein the graphical user interface comprises graphical representations of the aggregated data. ### Claim 7 (depends on 1) The method of claim 1, wherein a format of the graphical user interface is based upon the aggregated data extracted based upon the request. ### Claim 8 (depends on 1) The method of claim 1, wherein the aggregated data is encrypted. ### Claim 9 (depends on 8) The method of claim 8, wherein the extracting comprises decrypting the aggregated data. ### Claim 10 (depends on 1) The method of claim 1, wherein the request is generated automatically based upon user navigation within an application on the user device. ### Claim 11 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 database; the instructions comprising instructions that: aggregate, within the database, patient-specific data and bed-specific data into aggregated data comprising one or more statistics, wherein the aggregating comprises converting the aggregated data from a relational database to a plurality of objects; receive, at the server and from a user device, a request to access the aggregated data; extract, at the server, the aggregated data from the database based upon the request, wherein the extracting comprises matching, utilizing a matching technique, an object of the plurality of objects to the request, wherein the extracting comprises encrypting at least a portion of the request corresponding to private information of the request and encrypting at least a portion of the aggregated data corresponding to private information of the aggregated data; and generate, using a graphical user interface generator, a graphical user interface for a user from the extracted aggregated data and customized for a role of the user, wherein the graphical user interface comprises a screen displaying at least a portion of the one or more statistics, wherein generating the graphical user interface comprises converting the objects of the extracted aggregated data into a format corresponding to the graphical user interface generator. ### Claim 12 (depends on 11) The device of claim 11, wherein the graphical user interface comprises a breakdown screen displaying statistics of the one or more statistics corresponding to a category. ### Claim 13 (depends on 11) The device of claim 11, wherein the graphical user interface is formatted based upon the role of the user and displays statistics of the one or more statistics corresponding to the role. ### Claim 14 (depends on 11) The device of claim 11, wherein the graphical user interface displays a warning based upon one of the one or more statistics exceeding a predetermined threshold. ### Claim 15 (depends on 11) The device of claim 11, 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. ### Claim 16 (depends on 11) The device of claim 11, wherein the graphical user interface comprises graphical representations of the aggregated data. ### Claim 17 (depends on 11) The device of claim 11, wherein a format of the graphical user interface is based upon the aggregated data extracted based upon the request. ### Claim 18 (depends on 11) The device of claim 11, wherein the aggregated data is encrypted and wherein the extracting comprises decrypting the aggregated data. ### Claim 19 (depends on 11) The device of claim 11, wherein the request is generated automatically based upon user navigation within an application on the user device. ### Claim 20 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 aggregates, within a database, patient-specific data and bed-specific data into aggregated data comprising one or more statistics, wherein the aggregating comprises converting the aggregated data from a relational database to a plurality of objects; code that receives, at a server and from a user device, a request to access the aggregated data; code that extracts, at the server, the aggregated data from the database based upon the request, wherein the extracting comprises matching, utilizing a matching technique, an object of the plurality of objects to the request, wherein the extracting comprises encrypting at least a portion of the request corresponding to private information of the request and encrypting at least a portion of the aggregated data corresponding to private information of the aggregated data; and code that generates, using a graphical user interface generator, a graphical user interface for a user from the extracted aggregated data and customized for a role of the user, wherein the graphical user interface comprises a screen displaying at least a portion of the one or more statistics, wherein generating the graphical user interface comprises converting the objects of the extracted aggregated data into a format corresponding to the graphical user interface generator.