Nodal tree data structure for storing, consolidating, and displaying microbiological laboratory results

• US 5,551,022 A
• Filed: 07/11/1994
• Issued: 08/27/1996
• Est. Priority Date: 11/23/1992
• Status: Expired due to Fees

• Current Assignee: Motorola, Inc. (Motorola Solutions, Inc.)
• Original Assignee: Motorola, Inc. (Motorola Solutions, Inc.)
• Inventors: Tariq, M. Hasan, Ostler, Michael R.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Lintz, Paul R.
• Application Number:
  US08/272,450
• Time in Patent Office: 778 Days
• Field of Search: 395/600, 364/413.01, 364/413.02
• US Class Current: 1/1
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G16H 10/40 for data related to laboratory analysis, e.g. patient specimen analysis
• CPC Class Codes: G16H 15/00 ICT specially adapted for medical reports, e.g. generation or transmission thereof
• CPC Class Codes: G16H 70/40 relating to drugs, e.g. their side effects or intended usage
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

A method for building and storing a nodal tree structure and a composite display matrix from laboratory information which includes specimen, organism, and drug sensitivity information. The method consolidates microbiological lab results by building the composite display matrix based on the lab results and the relationships among specimens, organisms, and drugs tested. The method also displays the composite display matrix once the lab results are consolidated and the composite display matrix built.

Claims

1. A method executed by a computer as part of a computer program for displaying lab data in a composite display matrix on a display monitor, said lab data including data identifying one or more specimens, one or more organisms grown from each specimen, and one or more drugs tested against the organisms for a reaction, the lab data being entered into a lab computer to form a lab report, said lab computer coupled to said computer, said lab report being received by said computer from said lab computer, said method comprising the steps of:

a) determining relationships among said lab data including determining which of the organisms are grown from which of the specimens and which of the drugs are tested against which of the organisms;

b) storing said lab data and said relationships in a nodal tree structure in said computer if said lab data is not already stored in said computer;

c) consolidating said lab data into said composite display matrix by arranging and combining said lab data based on said relationships between said lab data, said composite display matrix having a first dimension for each of said organisms grown for each of said specimens, a second dimension for each of said drugs tested against any of said organisms, and a cell at each of a number of different coordinate combinations of said first and second dimension, said cell containing drug sensitivity information indicating sensitivity of said organisms to said drugs; and

d) displaying said composite display matrix on said display monitor.

2. A method as recited in claim 1, wherein said lab data comprises specimen information including a specimen name, organism information including a plurality of organism names, and said drug sensitivity information including a plurality of drug names, and wherein step (b) further comprises the steps of:

(b1) creating a specimen node;

(b2) storing specimen information in said specimen node;

(b3) creating a plurality of organism nodes and associating each of said organism nodes with said specimen node;

(b4) storing in a corresponding one of said organism nodes said organism information associated with each of said organism names;

(b5) creating a plurality of drug nodes and associating each of said drug nodes with said corresponding organism node; and

(b6) storing in a corresponding one of said drug nodes said drug information associated with each of said drug names.

3. A method as recited in claim 2, wherein step (b) further comprises the step of:

(b7) updating said specimen information, said organism information, and said drug sensitivity information if said specimen, organism, and drug sensitivity information differs from said lab data contained in said lab report.

4. A method as recited in claim 1, wherein said lab data comprises specimen information including a specimen name, and wherein step (b) comprises the steps of:

(b1) determining whether said specimen name is stored in said computer;

(b2) creating a specimen node if step (b1) determines that said specimen name is not stored in said computer;

(b3) storing said specimen information in said specimen node if said specimen node is created in step (b2); and

(b4) updating said specimen information stored in said specimen node if said specimen information stored in said specimen node differs from said specimen information contained in said lab data.

5. A method as recited in claim 1, wherein said lab data comprises organism information including a plurality of organism names, and wherein step (b) comprises the steps of:

(b1) determining whether each of said organism names is stored in said computer;

(b2) creating an organism node for each of said organism names which is determined in step (b1) not to be stored in said computer;

(b3) storing said organism information in said corresponding organism node for each of said organism nodes created in step (b2); and

(b4) updating said organism information stored in said corresponding organism node if said organism information stored in said organism node differs from said organism information contained in said lab data.

6. A method as recited in claim 1, wherein said lab data comprises said drug sensitivity information including a plurality of drug names, and wherein step (b) comprises the steps of:

(b1) determining whether each of said drug names is stored in said computer;

(b2) creating a drug node for each of said drug names which is determined in step (b1) not to be stored in said computer;

(b3) storing said drug information in said corresponding drug node for each of said drug nodes created in step (b2); and

(b4) updating said drug information stored in said corresponding drug node if said drug information stored in said drug node differs from said drug information contained in said lab data.

7. A method as recited in claim 1, wherein said lab data comprises specimen information including a specimen name and collection time, organism information including a plurality of organism names, and said drug sensitivity information including a plurality of drug names, wherein step (c) comprises the steps of:

(c1) creating a display matrix row in said composite display matrix for each combination of said specimen name, said collection time, and each of said organism names;

(c2) creating a display matrix column for each of said drug names;

(c3) alphabetizing said display matrix columns created for each of said drug names; and

(c4) saving said drug sensitivity information in a display cell where said display matrix row and said display matrix column intersect.

8. A method as recited in claim 1, wherein said lab data comprises specimen information including a specimen name and collection time, organism information including a plurality of organism names, and said drug sensitivity information including a plurality of drug names, wherein step (c) further comprises the steps of:

(c1) creating a display matrix row in said composite display matrix for each combination of said specimen name, said collection time, and each of said organism names if said display matrix row does not exist in said composite display matrix;

(c2) creating a display matrix column for each of said drug names if said display matrix column does not exist in said composite display matrix;

(c3) alphabetizing said display matrix columns created for each of said drug names; and

(c4) saving said drug sensitivity information in a display cell where said display matrix row and said display matrix column intersect.

9. A method as recited in claim 1, further comprising the step of:

d) notifying said lab computer of invalid lab data if said lab data contained in said lab report is determined to be invalid.

10. A method executed by a computer as part of a computer program for displaying lab data in a composite display matrix on a display monitor, said lab data being entered into a lab computer to form a lab report, said lab computer being coupled to said computer, said lab report being received by said computer from said lab computer, said lab data comprising specimen information including a specimen name and collection time, organism information including a plurality of organism names, and drug sensitivity information including a plurality of drug names, said method comprising the steps of:

a) determining relationships among said specimen, organism, and drug information;

b) storing said lab data and said relationships in a nodal tree structure in said computer if said lab data is not already stored in said computer;

c) consolidating said specimen, organism, and drug information by building said composite display matrix based on said relationships among said specimen, organism, and drug information, said composite display matrix having a first dimension for each of said organisms grown for each of said specimens, a second dimension for each of said drugs tested against any of said organisms, and a cell at each of a number of different coordinate combinations of said first and second dimension, said cell containing said drug sensitivity information indicating sensitivity of said organisms to said drugs; and

d) displaying said composite display matrix on said display monitor.

11. A method executed by a computer as part of a computer program for displaying lab data contained in a lab report in a composite display matrix on a display monitor, said lab data being entered into a lab computer to form a lab report, said lab computer being coupled to said computer, said lab report being received by said computer from said lab computer, said lab data comprising specimen information including a specimen name and collection time, organism information including a plurality of organism names, and drug sensitivity information including a plurality of drug names, said method comprising the steps of:

(a) creating a specimen node;

(b) storing specimen information in said specimen node;

(c) creating a plurality of organism nodes and associating each of said organism nodes with said specimen node;

(d) storing in a corresponding one of said organism nodes said organism information associated with each of said organism names;

(e) creating a plurality of drug nodes and associating each of said drug nodes with at least one of said organism nodes;

(f) storing in a corresponding one of said drug nodes said drug information associated with each of said drug names;

(g) updating said specimen information, said organism information, and said drug sensitivity information if said specimen, organism, and drug sensitivity information differs from said lab data contained in said lab report;

(h) creating a display matrix row in said composite display matrix for each combination of said specimen name, said collection time, and each of said organism names if said display matrix row does not exist in said composite display matrix;

(i) creating a display matrix column for each of said drug names if said display matrix column does not exist in said composite display matrix;

(j) alphabetizing said display matrix columns created for each of said drug names;

(k) saving said drug sensitivity information in at least one display cell which is formed by where one of said display matrix rows and one of said display matrix columns intersect; and

(l) displaying said composite display matrix on said display monitor.