Querying by concept classifications in an electronic data record system

• US 8,856,104 B2
• Filed: 06/16/2009
• Issued: 10/07/2014
• Est. Priority Date: 06/16/2009
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Mayr, Florian Alexander, Shroff, Anand, Currie, Hamish Daniel, Kuhnen, Gregory, Moores, Matthew Thomas
• Primary Examiner(s): KUDDUS, DANIEL A
• Application Number:
  US12/485,876
• Publication Number:
  US 20100318548A1
• Time in Patent Office: 1,939 Days
• Field of Search: None
• US Class Current: 707/721
• CPC Class Codes: G16H 10/60 for patient-specific data, e.g. for electronic patient records

Abstract

Embodiments of the present invention enable processing of concept-based query requests submitted to a query service within a healthcare transaction framework. In embodiments, a terminology service within the healthcare transaction framework manages terminology content (concepts represented by a set of terminologies). In embodiments, search criteria from a data access query request are submitted to the terminology service to extract a set of concepts from the terminology content that are associated with the search criteria. In embodiments, equivalence search criteria include a seed concept, and the terminology service returns a set of equivalent concepts comprising the seed concept. In embodiments, classification search criteria include a classification identifier, and the terminology service returns a set of concepts associated with the classification identifier. In embodiments, the query service generates and submits a data access query comprising predicates associated with the returned set of concepts.

Claims

1. A computer program product comprising at least one non-transitory computer-readable storage medium storing one or more sequences of instructions, wherein execution of the one or more sequences of instructions by one or more hardware processors causes the one or more hardware processors to perform the steps comprising:

providing a repository of terminology content stored in accordance with a reference information model, wherein the reference information model includes a plurality of backbone classes, wherein the plurality of backbone classes are associated with a plurality of other types of backbone classes to form data structures representing a plurality of higher level healthcare concepts;

receiving a concept query request specifying a set of search criteria, wherein the search criteria include

a first classification identifier corresponding to a first classification container, and

a semantic statement that defines, using the first classification identifier, an expected concept query result generated from a terminology service;

generating, via a concept query generator, a classification concept query from the concept query request, wherein the classification concept query includes at least a subset of the search criteria that includes the first classification identifier;

providing the classification concept query to the terminology service which manages the repository of terminology content, wherein the terminology content comprises a plurality of domains of concepts,

wherein a plurality of semantically equivalent concepts are

stored in one or more of said domains of concepts, and

mapped to one another using inter-domain or intra-domain mappings defined in the terminology content, and

wherein concepts in each domain are organized into a plurality of classification containers,

wherein each classification container represents a collection of semantically equivalent concepts having a corresponding classification identifier;

identifying, using the defined mappings and the semantic statement, one or more classification containers, wherein each of the one or more classification containers includes a concept semantically equivalent to a concept in the first classification container;

creating a concept query result by extracting a plurality of concepts associated with the first classification identifier, from the first classification container and the one or more identified classification containers; and

generating, from the concept query result, a modified query that includes predicates corresponding to the plurality of associated concepts, to retrieve a set of stored data records from an electronic data record system.

2. The computer program product of claim 1, wherein the plurality of associated concepts have an IS-A relationship with the classification container.

3. The computer program product of claim 1, wherein the classification container comprises a first classification container and a plurality of classification containers having an IS-A relationship to the first classification container.

4. The computer program product of claim 1, wherein the terminology content comprises stored concepts that are associated with at least one terminology.

5. The computer program product of claim 1, wherein the subset of search criteria comprises at least one attribute having a coded data type.

6. The computer program product of claim 1, wherein the classification container is associated with a set of attributes described in part by at least one terminology code, and wherein each concept within the classification container is identified based in part on the at least one terminology code.

7. The method of claim 1, wherein the plurality of associated concepts have an IS-A relationship with the classification container.

8. A system to generate a database query to retrieve a set of stored data records from an electronic data record system, the system comprising:

a computer that includes one or more hardware processors;

a repository of terminology content stored in accordance with a reference information model, wherein the reference information model includes a plurality of backbone classes, wherein the plurality of backbone classes are associated with a plurality of other types of backbone classes to form data structures representing a plurality of higher level healthcare concepts;

a concept query system that executes on the computer to

receive a concept query request comprising a set of search criteria, wherein the search criteria include

a first classification identifier corresponding to a first classification container, and

a semantic statement that defines, using the first classification identifier, an expected concept query result generated from a terminology service;

generate, via a concept query generator, a classification concept query from the concept query request, wherein the classification concept query includes at least a subset of the search criteria and the first classification identifier,

provide the classification concept query to the terminology service that manages the repository of terminology content, wherein the terminology content comprises a plurality of domains of concepts,

wherein a plurality of semantically equivalent concepts are stored in different domains of concepts, and are mapped to one another using inter-domain or intra-domain mappings defined in the terminology service, and

wherein concepts in each domain are organized into a plurality of classification containers,

wherein each classification container represents a collection of semantically equivalent concepts having a corresponding classification identifier,

identify, using the defined mappings and the semantic statement, one or more classification containers, wherein each of the one or more classification containers includes a concept semantically equivalent to a concept in the first classification container; and

create a concept query result by extracting a plurality of concepts associated with the first classification identifier, from the first classification container and the one or more identified classification containers; and

a database query generator to receive the plurality of associated concepts and generate the database query comprising predicates corresponding to the plurality of associated concepts.

9. A system to generate a database query to retrieve a set of stored data records from an electronic data record system, the system comprising:

a computer that includes one or more hardware processors;

a repository of terminology content stored in accordance with an information reference model, wherein the information reference model includes a plurality of backbone classes, wherein the plurality of backbone classes are associated with a plurality of other types of backbone classes to form data structures representing a plurality of higher level healthcare concepts;

a concept query system that executes on the computer to

receive a concept query request comprising a set of search criteria, wherein the search criteria include

a first classification identifier corresponding to a first classification container, and

a semantic statement that defines, using the first classification identifier, an expected concept query result generated from a terminology service;

generate, via a concept query generator, a classification concept query from the concept query request, wherein the classification concept query includes at least a subset of the search criteria and the first classification identifier,

provide the classification concept query to the terminology service that manages the repository of terminology content, wherein the terminology content comprises a plurality of domains of concepts,

wherein a plurality of semantically equivalent concepts

are stored in different domains of concepts, and

are mapped to one another using inter-domain or intra-domain mappings defined in the terminology service, and

wherein concepts in each domain are organized into a plurality of classification containers,

wherein each classification container represents a collection of semantically equivalent concepts having a corresponding classification identifier,

identify, using the defined mappings and the semantic statement, one or more classification containers, wherein each of the one or more classification containers includes a concept semantically equivalent to a concept in the first classification container; and

create a concept query result by extracting a plurality of concepts associated with the first classification identifier, from the first classification container and the one or more identified classification containers; and

a database query generator to receive the plurality of associated concepts and generate the database query comprising predicates corresponding to the plurality of associated concepts.

10. The system of claim 9, further comprising a database query service application programming interface (API) that receives the plurality of associated concepts and returns a database query result comprising the retrieved set of stored data records.

11. The system of claim 9, wherein the associated concepts have an IS-A relationship with the classification container associated with the classification identifier.

12. The system of claim 9, wherein the terminology content comprises concepts that are associated with at least one terminology.

13. The system of claim 9, wherein the classification container is associated with a set of attributes described in part by at least one terminology code, and wherein each concept within the classification container is identified based in part on the at least one terminology code.

14. A computer implemented method for generating a set of stored concepts for generating a database query for retrieving a set of stored data records from an electronic data record system, the method comprising:

providing a repository of terminology content stored in accordance with a reference information model, wherein the reference information model includes a plurality of backbone classes, wherein the plurality of backbone classes are associated with a plurality of other types of backbone classes to form data structures representing a plurality of higher level healthcare concepts;

receiving a concept query request specifying a set of search criteria, wherein the search criteria include

a first classification identifier corresponding to a first classification container, and

a semantic statement that defines, using the first classification identifier, an expected concept query result generated from a terminology service;

generating, via a concept query generator, a classification concept query from the concept query request, wherein the classification concept query includes at least a subset of the search criteria that includes the first classification identifier;

providing the classification concept query to the terminology service which manages the repository of terminology content, wherein the terminology content comprises a plurality of domains of concepts,

wherein a plurality of semantically equivalent concepts are stored in one or more od said domains of concepts

mapped to one another using inter-domain or intra-domain mappings defined in the terminology service, and

wherein concepts in each domain are organized into a plurality of classification containers,

wherein each classification container represents a collection of semantically equivalent concepts having a corresponding classification identifier;

identifying, using the defined mappings and the semantic statement, one or more classification containers, wherein each of the one or more classification containers includes a concept semantically equivalent to a concept in the first classification container;

creating a concept query result by extracting a plurality of concepts associated with the first classification identifier, from the first classification container and the one or more identified classification containers; and

generating, from the concept query result, a modified query that includes predicates corresponding to the plurality of associated concepts, to retrieve a set of stored data records from an electronic data record system;

wherein the steps of receiving, identifying, and generating are performed by one or more hardware processors.

16. The method of claim 14, wherein the plurality of associated concepts have an IS-A relationship with the classification container.

15. A computer implemented method for generating a set of stored concepts for generating a database query for retrieving a set of stored data records from an electronic data record system, the method comprising:

providing a repository of terminology content stored in accordance with an information reference model, wherein the information reference model includes a plurality of backbone classes, wherein the plurality of backbone classes are associated with a plurality of other types of backbone classes to form data structures representing a plurality of higher level healthcare concepts;

receiving a concept query request specifying a set of search criteria, wherein the search criteria include

a first classification identifier corresponding to a first classification container, and

a semantic statement that defines, using the first classification identifier, an expected concept query result generated from a terminology service;

generating, via a concept query generator, a classification concept query from the concept query request, wherein the classification concept query includes at least a subset of the search criteria that includes the first classification identifier;

providing the classification concept query to the terminology service which manages the repository of terminology content, wherein the terminology content comprises a plurality of domains of concepts,

wherein a plurality of semantically equivalent concepts are

stored in one or more of said domains of concepts, and

mapped to one another using inter-domain or intra-domain mappings defined in the terminology content, and

wherein concepts in each domain are organized into a plurality of classification containers,

wherein each classification container represents a collection of semantically equivalent concepts having a corresponding classification identifier;

identifying, using the defined mappings and the semantic statement, one or more classification containers, wherein each of the one or more classification containers includes a concept semantically equivalent to a concept in the first classification container;

creating a concept query result by extracting a plurality of concepts associated with the first classification identifier, from the first classification container and the one or more identified classification containers; and

generating, from the concept query result, a modified query that includes predicates corresponding to the plurality of associated concepts, to retrieve a set of stored data records from an electronic data record system;

wherein the steps of receiving, identifying, and generating are performed by one or more hardware processors.

17. The method of claim 15, wherein the terminology content repository comprises a plurality of terminology codes.

18. The method of claim 17, wherein the classification container is associated with a set of attributes that are described in the plurality of terminology codes.

19. The method of claim 17, wherein the classification container is associated with a set of attributes described in part by at least one terminology code, and wherein each concept within the classification container is identified based in part on the at least one terminology code.

20. The method of 15, wherein the modified query is a SQL query.