IP Library › Granted Patent US 11,734,269
Granted Patent B2
US 11,734,269 · App. 17/136,778 · Granted Aug 22, 2023

Systems, methods, and storage media useful in a computer healthcare system to consume clinical quality language queries in a programmatic manner

Inventors: Cole Erdmann (Kansas City, MO); Joseph Marcus Overhage (Zionsville, IN); Bharat Sutariya (Parkville, MO)
Assignee: Cerner Innovation, Inc.
G06F16/24534G06F16/248G16H30/20G16H40/20G16H50/70G16H70/20
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,734,269
App. No.
17/136,778
Granted
Aug 22, 2023
Kind
B2
Abstract

Systems, methods, and storage media useful in a computer healthcare system to consume clinical quality language queries in a programmatic manner are disclosed. Exemplary implementations may: load a CQL query from a third party; transform the CQL query to a modified structured query language query; load medical data elements from a database record store for each patient in one or more defined patient populations; execute the modified SQL query on medical data elements from the database record store for each patient in one or more defined patient populations; and load results of the modified SQL query.

Claims (42)

1. A system configured to consume clinical quality language (CQL) queries in a programmatic manner, the system comprising:

one or more hardware processors configured by machine-readable instructions to:

load a CQL query from a third party;

transform the CQL query to a modified structured query language (SQL) query in a programmatic manner at least by:

consuming an Extensible Markup Language (XML) file that indicates a structure of data in the CQL query comprising Define, Function, and Operator constructs;

based on the structure of data in the CQL query as indicated by the XML file, validating and parsing the CQL query into an intermediate Expression Logical Model (ELM) form; and

generating the modified SQL query from the intermediate ELM form;

load medical data elements from a database record store for each patient in one or more defined patient populations;

execute the modified SQL query on medical data elements from the database record store for each patient in one or more defined patient populations; and

load results of the modified SQL query.

2. The system of claim 1 , wherein a structure of the modified SQL query is fast healthcare interoperability resources.

3. The system of claim 1 , wherein CQL is an hl7 standard authoring language that is a core component in an effort to harmonize standards used for electronic clinical quality measures and clinical decision support.

4. The system of claim 1 , wherein the CQL provides an ability to express logic that is human readable yet structured enough for processing a query electronically across electronic health record systems.

5. The system of claim 1 , wherein the results of the modified SQL query are patients in the one or more defined patient populations who satisfy the medical data elements of the CQL query.

6. The system of claim 1 , wherein the CQL query provides criteria for clinical healthcare guidelines.

7. A dynamic method useful in a computer healthcare system to consume clinical quality language (CQL) queries in a programmatic manner, the method comprising:

loading a CQL query from a third party;

transforming the CQL query to a modified structured query language (SQL) query in a programmatic manner at least by:

consuming an Extensible Markup Language (XML) file that indicates a structure of data in the CQL query comprising Define, Function, and Operator constructs;

based on the structure of data in the CQL query as indicated by the XML file, validating and parsing the CQL query into an intermediate Expression Logical Model (ELM) form;

generating the modified SQL query from the intermediate ELM form;

loading medical data elements from a database record store for each patient in one or more defined patient populations;

executing the modified SQL query on medical data elements from the database record store for each patient in one or more defined patient populations; and

loading results of the modified SQL query.

8. The method of claim 7 wherein a structure of the modified SQL query is fast healthcare interoperability resources.

9. The method of claim 7 , wherein CQL is an hl7 standard authoring language that is a core component in the effort to harmonize standards used for electronic clinical quality measures and clinical decision support.

10. The method of claim 7 , wherein the CQL provides the ability to express logic that is human readable yet structured enough for processing a query electronically across electronic health record systems.

11. The method of claim 7 , wherein the results of the modified SQL query are patients in the one or more defined patient populations who satisfy the medical data elements of the CQL query.

12. The method of claim 7 , wherein the CQL query provides criteria for clinical healthcare guidelines.

13. A non-transitory computer-readable storage medium having instructions embodied thereon, the instructions being executable by one or more processors to perform a method useful in a computer healthcare system to consume clinical quality language (CQL) queries in a programmatic manner, the method comprising:

loading a CQL query from a third party;

transforming the CQL query to a modified structured query language (SQL) query in a programmatic manner at least by:

consuming an Extensible Markup Language (XML) file that indicates a structure of data in the CQL query comprising Define, Function, and Operator constructs;

based on the structure of data in the CQL query as indicated by the XML file, validating and parsing the CQL query into an intermediate Expression Logical Model (ELM) form; and

generating the modified SQL query from the intermediate ELM form;

loading medical data elements from a database record store for each patient in one or more defined patient populations;

executing the modified SQL query on medical data elements from the database record store for each patient in one or more defined patient populations; and

loading results of the modified SQL query.

14. The computer-readable storage medium of claim 13 , wherein a structure of the modified SQL query is fast healthcare interoperability resources.

15. The computer-readable storage medium of claim 13 , wherein CQL is an hl7 standard authoring language that is a core component in an effort to harmonize standards used for electronic clinical quality measures and clinical decision support.

16. The computer-readable storage medium of claim 13 , wherein the CQL provides the ability to express logic that is human readable yet structured enough for processing a query electronically across electronic health record systems.

17. The computer-readable storage medium of claim 13 , wherein the results of the modified SQL query are patients in the one or more defined patient populations who satisfy the medical data elements of the CQL query.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 27, 2021
From: ERDMANN, COLE; OVERHAGE, JOSEPH MARCUS; SUTARIYA, BHARAT
To: CERNER INNOVATION, INC.
Reel/Frame 057612/0983 →
Continuity (2)
Provisional Application 62955808 · Dec 31, 2019
Related Publication 20210200766A1 · Jul 1, 2021
Cited By (1)
US 12,380,106