Querying by Concept Classifications in an Electronic Data Record System

• US 20100318548A1
• Filed: 06/16/2009
• Published: 12/16/2010
• Est. Priority Date: 06/16/2009
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Moores, Matthew Thomas, Mayr, Florian Alexander, Kuhnen, Gregory, Currie, Hamish Daniel, Shroff, Anand
• Granted Patent: US 8,856,104 B2
• Time in Patent Office: Days
• US Class Current: 707/759
• 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 computer-readable medium storing one or more sequences of instructions, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to generate a query to retrieve a set of stored data records from an electronic data record system, the by performing the steps comprising:

receiving a query request comprising a set of search criteria comprising a classification identifier;

generating a classification concept query comprising at least a subset of the search criteria that includes the classification identifier;

receiving a set of stored concepts associated with the classification identifier in response to submitting the classification concept query to a terminology service that manages a repository of terminology content, the terminology content comprising stored concept containers having corresponding classification identifiers; and

generating the query comprising predicates corresponding to the set of stored concepts.

2. The computer program product of claim 1 wherein the set of stored concepts associated with the classification identifier have an IS-A relationship with a concept container associated with the classification identifier.

3. The computer program product of claim 2 wherein a classification hierarchy comprises a first concept container and a set of concept containers having an IS-A relationship to the first concept container.

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

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

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

7. 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 concept query system, coupled to receive a concept query request comprising a set of search criteria that comprises a classification identifier, that generates a concept query result in response to submitting a classification concept query to a terminology service that manages a repository of terminology content comprising stored concept containers having corresponding classification identifiers, the concept query result comprising a set of stored concepts associated with the classification identifier; and

a database query generator, coupled to receive the concept query result, that generates the database query comprising predicates associated with the set of stored concepts.

8. The system of claim 7 wherein the concept query system comprises:

a concept query generator, coupled to receive the set of search criteria that comprises the classification identifier, that generates the classification concept query comprising the classification identifier; and

a concept query result generator, coupled to receive the classification concept query, that generates the concept query result in response to submitting the classification concept query to the terminology service that manages a repository of terminology content, the concept query result comprising the set of stored concepts associated with the classification identifier.

9. The system of claim 7 further comprising a database query processor, coupled to receive the database query, that retrieves the set of stored data records in response to submitting the database query to the electronic data record system.

10. The system of claim 9 further comprising a database query service API that receives the concept query request and returns a database query result comprising the retrieved set of stored data records.

11. The system of claim 7 wherein the set of stored concepts associated with the classification identifier have an IS-A relationship with a concept container associated with the classification identifier.

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

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

14. A method for generating a set of stored concepts that are associated with a classification, the method comprising:

receiving a set of search criteria comprising a classification identifier;

identifying a classification concept container that is associated with the classification identifier, the classification concept container being stored within a terminology content data repository; and

generating the set of stored concepts by retrieving concepts, stored within the terminology content data repository, that have an IS-A relationship to the stored classification concept container.

15. The method of claim 14 wherein a classification hierarchy comprises a first concept container and a set of concept containers having an IS-A relationship to the first concept container.

16. The method of claim 15 wherein the classification identifier is associated with one of the stored classification concept containers within the classification hierarchy.

17. The method of claim 16 wherein containment of a stored concept within any one of the classification concept containers within the classification hierarchy is determined in response to receiving the set of search criteria.

18. The method of claim 14 wherein the terminology content data repository comprises a plurality of code systems.

19. The method of claim 18 wherein a classification concept container is associated with a set of attributes that are described in a plurality of code systems.

20. The method of claim 18 wherein a concept container is associated with a set of attributes described in part by at least one terminology code, and a concept within the set of stored concepts is identified based in part on the at least one terminology code.