Patient care pathway shape analysis

1. A computer-implemented method comprising:

receiving, by one or more processors and from a client device, a query for pathway shapes for a particular medical condition;

accessing, by the one or more processors and from one or more healthcare data systems, treatment data for a plurality of patients receiving treatment for the particular medical condition, the treatment data for each patient indicating (i) a series of patient events for a particular patient receiving treatment for the particular medical condition, (ii) a particular sequence of patient events within the series of patient events;

generating, by the one or more processors, a respective care pathway shape for each of the plurality of patients, comprising:

determining, by one or more processors and for each of the patient events, one or more medical conditions associated with a particular patient event;

in response to determining the one or more medical conditions associated each of the patient events, generating, by the one or more processors and for each of the patient events, event shape descriptive of the one or more medical conditions associated with a particular patient event;

combining, by the one or more processors, the event shape for each of the patient events in accordance with the particular sequence of patient events within the series of patient events;

generating, by the one or more processors, a unique value representing the series of patient events based at least on combining the event shapes for each of the patient events in accordance with the particular sequence of patient events within the series of patient events; and

storing, by the one or more processors, at a custom extension to a relational database, the unique value representing the series of patient events;

analyzing, by the one or more processors, the unique values of the care pathway shapes for the plurality of patients;

selecting, by the one or more processors and based on analyzing the unique values of the care pathway shapes for the plurality of patients, a subset of care pathway shapes from among the care pathway shapes for the plurality of patients, the subset of care pathway shapes comprising care pathway shapes that each share (i) two or more identical event shapes, and (ii) an identical sequence of the two or more identical event shapes within a corresponding series of patient events; and

providing, by the one or more processors and for output to the client device responsive to the received query for pathway shapes for the particular medical condition, query results indicating the subset of pathway shapes.

2. The method of claim 1 wherein generating a care pathway data shape for the condition comprises linking each of the one or more patient events to the one or more medical conditions.

3. The method of claim 2 wherein the linked patient events, related to the one or more medical conditions, are represented as a single value.

4. The method of claim 1 wherein the care pathway data shape is represented as a custom C# data type value.

5. The method of claim 1 wherein the care pathway data shape is represented as a common language runtime (CLR) compatible programming language data type value.

6. The method of claim 1 wherein providing the query results for output to the client device comprises providing real-time query results in response to receiving the query request submitted by the user.

7. The method of claim 1 further comprising:

identifying a patient event as having a point of interest attribute; and

grouping the care pathway shape data utilizing the point of interest attribute.

8. The method of claim 1 wherein:

The relational database comprises a structured query language (SQL) server database; and

the unique value comprises a representation of a user-defined type (UTD) extension to the SQL server database.

9. The method of claim 8 wherein the unique value is stored in a single database column of the SQL database server.

10. A system comprising:

one or more computers and one or more storage devices storing instructions that are operable, when executed by one or more computers, to cause the one or more computers to perform operations comprising:

receiving, by one or more processors and from a client device, a query for pathway shapes for a particular medical condition;

accessing, by the one or more processors and from one or more healthcare data systems, treatment data for a plurality of patients receiving treatment for the particular medical condition, the treatment data for each patient indicating (i) a series of patient events for a particular patient receiving treatment for the particular medical condition, (ii) a particular sequence of patient events within the series of patient events;

generating, by the one or more processors, a respective care pathway shape for each of the plurality of patients, comprising: determining, by one or more processors and for each of the patient events, one or more medical conditions associated with a particular patient event;

in response to determining the one or more medical conditions associated each of the patient events, generating, by the one or more processors and for each of the patient events, event shape descriptive of the one or more medical conditions associated with a particular patient event;

combining, by the one or more processors, the event shape for each of the patient events in accordance with the particular sequence of patient events within the series of patient events;

generating, by the one or more processors, a unique value representing the series of patient events based at least on combining the event shapes for each of the patient events in accordance with the particular sequence of patient events within the series of patient events; and

storing, by the one or more processors, at a custom extension to a relational database, the unique value representing the series of patient events;

analyzing, by the one or more processors, the unique values of the care pathway shapes for the plurality of patients;

selecting, by the one or more processors and based on analyzing the unique values of the care pathway shapes for the plurality of patients, a subset of care pathway shapes from among the care pathway shapes for the plurality of patients, the subset of care pathway shapes comprising care pathway shapes that each share (i) two or more identical event shapes, and (ii) an identical sequence of the two or more identical event shapes within a corresponding series of patient events; and

providing, by the one or more processors and for output to the client device responsive to the received query for pathway shapes for the particular medical condition, query results indicating the subset of pathway shapes.

11. The system of claim 10 wherein generating a care pathway data shape for the condition comprises linking each of the one or more patient events to the one or more medical conditions.

12. The system of claim 11 wherein the linked patient events, related to the one or more medical conditions, are represented as a single value.

13. The system of claim 10 wherein the care pathway data shape is represented as a custom C# data type value.

14. The system of claim 10 wherein the care pathway data shape is represented as a common language runtime (CLR) compatible programming language data type value.

15. The system of claim 10 wherein providing the query results for output to the client device comprises providing real-time query results in response to receiving the query request submitted by the user.

16. The system of claim 10 further comprising:

identifying a patient event as having a point of interest attribute; and

grouping the care pathway shape data utilizing the point of interest attribute.

17. A non-transitory computer-readable medium storing software comprising instructions executable by one or more which, upon such execution, cause the one or more computers to perform operations comprising:

receiving, by one or more processors and from a client device, a query for pathway shapes for a particular medical condition;

accessing, by the one or more processors and from one or more healthcare data systems, treatment data for a plurality of patients receiving treatment for the particular medical condition, the treatment data for each patient indicating (i) a series of patient events for a particular patient receiving treatment for the particular medical condition, (ii) a particular sequence of patient events within the series of patient events;

generating, by the one or more processors, a respective care pathway shape for each of the plurality of patients, comprising: determining, by one or more processors and for each of the patient events, one or more medical conditions associated with a particular patient event;

in response to determining the one or more medical conditions associated each of the patient events, generating, by the one or more processors and for each of the patient events, event shape descriptive of the one or more medical conditions associated with a particular patient event;

combining, by the one or more processors, the event shape for each of the patient events in accordance with the particular sequence of patient events within the series of patient events;

generating, by the one or more processors, a unique value representing the series of patient events based at least on combining the event shapes for each of the patient events in accordance with the particular sequence of patient events within the series of patient events; and

storing, by the one or more processors, at a custom extension to a relational database, the unique value representing the series of patient events;

analyzing, by the one or more processors, the unique values of the care pathway shapes for the plurality of patients;

selecting, by the one or more processors and based on analyzing the unique values of the care pathway shapes for the plurality of patients, a subset of care pathway shapes from among the care pathway shapes for the plurality of patients, the subset of care pathway shapes comprising care pathway shapes that each share (i) two or more identical event shapes, and (ii) an identical sequence of the two or more identical event shapes within a corresponding series of patient events; and

providing, by the one or more processors and for output to the client device responsive to the received query for pathway shapes for the particular medical condition, query results indicating the subset of pathway shapes.

18. The medium of claim 17 wherein generating a care pathway data shape for the condition comprises linking each of the one or more patient events to the one or more medical conditions.

19. The medium of claim 17 wherein providing the query results for output to the client device comprises providing real-time query results in response to receiving the query request submitted by the user.