Method and apparatus for providing a data interface between a plurality of test information sources and a database

• US 5,392,209 A
• Filed: 12/18/1992
• Issued: 02/21/1995
• Est. Priority Date: 12/18/1992
• Status: Expired due to Term

• Current Assignee: Abbott Laboratories Incorporated
• Original Assignee: Abbott Laboratories Incorporated
• Inventors: Forrest, Keith, Eason, Reginald
• Primary Examiner(s): McElheny, Jr., Donald E.
• Application Number:
  US07/992,550
• Time in Patent Office: 795 Days
• Field of Search: 395/500, 395/800, 364/413
• US Class Current: 1/1
• CPC Class Codes: G16H 10/40 for data related to laboratory analysis, e.g. patient specimen analysis
• CPC Class Codes: G16H 10/60 for patient-specific data, e.g. for electronic patient records
• CPC Class Codes: G16H 40/63 for local operation
• CPC Class Codes: G16H 50/20 for computer-aided diagnosis, e.g. based on medical expert systems
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

A data interface which is capable of receiving test information from a variety of biological fluid testing instruments employs first and second processes. The first process determines the type of data which is provided by analyzing the format of the test information using a master rules file. Once the type of the source is identified, the first process passes the data and a set of rules to use to parse the data to the second process. The second process extracts the test data from the information provided by the testing instrument using the set of rules identified by the first process. Furthermore, if the test information is received in pieces the present invention can marry the pieces to provide a complete data set to be stored in the database.

Claims

1. A method of extracting individual items of biological test data from a plurality of data files, each of the data files being received from a corresponding source and having different locations for storing individual items of biological test data therein, comprising the steps of:

receiving one of the data files from the corresponding source using a specified protocol;

generating at least one run file from the received data file;

examining the run file to identify specific locations of individual items of biological test data within the run file;

assigning a rules file to the run file which indicates the identified locations; and

parsing the run file with the assigned rules file to extract the individual items of biological test data within the run file.

2. The method of claim 1 further comprising the steps of:

providing a master rules file comprising a plurality of different rules, each one of the rules specifying the location of at least one item of biological test data within the run file, and a rules file which indicates locations for individual items of biological test data within a run file; and

assigning a match counter to each one of the plurality of rules within the master rules file.

3. The method of claim 2 wherein the examining step comprises the steps of:

comparing each line of the run file with each one of the plurality of rules contained within the master rules file; and

incrementing the assigned match counter for each one of the plurality of rules that matches a line within the run file.

4. The method of claim 3 wherein the assigning step comprises the steps of:

determining which one of the plurality of rules has the greatest number of matches based upon the assigned match counters; and

assigning the specified rules file from the determined one of the plurality of rules.

5. The method of claim 1 wherein the received data file comprises a tray Identification, an assay number, a tray position, and a plurality of samples.

6. The method of claim 5 further comprising the step of:

generating a slots table associated with the received data file, the slots table comprising tray and sample identifications for the received data file.

7. The method of claim 6 wherein the parsing step comprises the steps of:

parsing the run file with the assigned rules file to extract the individual items of biological test data within the run file; and

storing the extracted individual items of biological test data within an extracted file.

8. The method of claim 7 wherein the storing step comprises the step of:

merging the extracted individual items of biological test data with the slots table.

9. The method of claim 1 further comprising the steps of:

storing the extracted items of biological test data within an extracted file; and

storing the extracted file in a database.

10. The method of claim 1 wherein the generating step comprises the step of:

generating a plurality of run files from the received data file.

11. The method of claim 1 wherein said examining, assigning and parsing steps are performed simultaneously.

12. A system for extracting individual items of biological test data from a plurality of data files each of the data files being received from a corresponding source and having different locations for storing individual items of biological test data therein, comprising:

means for receiving one of the data files from the corresponding source using a specified protocol;

means for generating at least one run file from the received data file;

means for examining the run file to identify specific locations of individual items of biological test data within the run file;

means for assigning a rules file to the run file which indicates the identified locations; and

means for parsing the run file with the assigned rules file to extract the individual items of biological test data within the run file.

13. The system of claim 12 further comprising:

means for providing a master rules file comprising a plurality of different rules, each one of the rules specifying the location of at least one item of biological test data within the run file, and a rules file which indicates locations for individual items of biological test data within a run file; and

means for assigning a match counter to each one of the plurality of rules within the master rules file.

14. The system of claim 13 wherein the means for examining comprises:

means for comparing each line of the run file with each one of the plurality of rules contained within the master rules file; and

means for incrementing the assigned match counter for each one of the plurality of rules that matches a line within the run file.

15. The method of claim 14 wherein the means for assigning comprises:

means for determining which one of the plurality of rules has the greatest number of matches based upon the assigned match counters; and

means for assigning the specified rules file from the determined one of the plurality of rules.

16. The system of claim 12 wherein the received data file comprises a tray Identification, an assay number, a tray position, and a plurality of samples.

17. The system of claim 16 further comprising the step of:

means for generating a slots table associated with the received data file, the slots table comprising tray and sample identifications for the received data file.

18. The system of claim 17 wherein the means for parsing comprises:

means for parsing the run file with the assigned rules file to extract the individual items of biological test data within the run file; and

means for storing the extracted individual items of biological test data within an extracted file.

19. The system of claim 18 wherein the means for storing comprises:

means for merging the extracted individual items of biological test data with the slots table.

20. The system of claim 12 further comprising:

means for storing the extracted items of biological test data within an extracted file; and

means for storing the extracted file in a database.

21. The system of claim 12 wherein the means for generating comprises:

means for generating a plurality of run files from the received data file.

22. The system of claim 12 wherein said means for examining, assigning and parsing are performed simultaneously.