Blood collection tube sample data integration method and system
By employing techniques such as barcode generation, fuzzy matching, data cleaning, and outlier verification, the problems of high cost and insufficient standardization in the blood collection and management system have been solved, achieving efficient and standardized blood data management and resource sharing.
Patent Information
- Application Number
- CN202510157270.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-02-13
- Publication Date
- 2025-03-11
- Estimated Expiration
- 2045-02-13
AI Technical Summary
The existing blood collection and management system suffers from problems such as high procurement costs, lax information management, and lack of standardization, making it difficult to guarantee blood safety and quality.
A data integration method for blood collection tube samples was adopted, including generating barcodes, numbering, fuzzy matching, data cleaning, missing value imputation, establishing a blood database and verifying outliers. Fuzzy matching algorithms, quartile interval methods and other technical means were used for data integration and management.
It has improved the efficiency of blood collection and management, reduced the workload, increased operational standardization, and enabled resource sharing, thus ensuring the safety and quality of blood.
Smart Images

Figure CN119597747A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of data management, and in particular to a method and system for integrating blood collection tube sample data. Background Art
[0002] Blood is an indispensable resource in medical treatment. However, it is very easy to produce unsafe factors during the collection and transmission of blood. Therefore, in order to ensure the quality and safety of blood, it is necessary to control the safety of blood by implementing information transmission control and comparison. With the development of computer technology, the use of information technology to manage blood is an important means to improve blood quality. Although some blood stations have established blood collection and management systems, there are still many problems in actual work, such as high procurement costs of blood collection institutions, lax external audit procedures for blood information management systems, and lack of standardization of management. Summary of the invention
[0003] In order to solve the above technical problems, a method and system for integrating blood collection tube sample data are provided. This technical solution solves the problems raised in the above background technology.
[0004] In order to achieve the above purpose, the technical solution adopted by the present invention is: The blood collection tube sample data integration method includes: During the blood collection process, a barcode is generated based on the sample collection information, and the collection information is entered into the blood collection tube sample data, wherein the collection information includes patient information, collection date and collection site; Number each sample data based on the barcode of the blood collection tube sample data, and use the number as the unique identifier of the sample data; The fuzzy matching algorithm is used to associate blood collection tube sample data from different sources; Testing the blood collection tube samples and merging the test results with the corresponding blood collection tube sample data; Perform preliminary data cleaning on the collected blood collection tube sample data to remove duplicate and redundant blood collection tube sample data; First-order linear interpolation was used to fill in missing values in blood collection tube sample data; Establishing a blood database for storing blood collection tube sample data, and entering the associated blood collection tube sample data into the blood database; The interquartile range method is used to verify the blood collection tube sample data in the blood database, and abnormal values in the blood collection tube sample data are detected and eliminated; The user obtains the number of the corresponding blood collection tube sample data by scanning the barcode, and obtains the test result based on the number.
[0005] Preferably, the method of associating blood collection tube sample data from different sources using a fuzzy matching algorithm specifically includes: creating a summary record of the basic standardized match, the summary record including the type of matched data that has been repaired; Select and map attributes based on the fuzzy matching that will occur; A fuzzy matching technique is selected for each attribute. Text information is matched based on keyboard distance and name variants, and numeric information is matched based on numeric similarity indicators. Preset weights for each attribute, and attributes with high weights have a greater impact on the overall matching confidence than attributes with low weights; Run the fuzzy matching algorithm and calculate the fuzzy matching confidence of blood collection tube sample data from different sources; Preset matching confidence threshold; Determine whether the fuzzy matching confidence of blood collection tube sample data from different sources is higher than a preset matching confidence threshold. If so, output the group of data as related data; if not, do not output; The blood collection tube samples from the same patient at different times are matched and associated and output as a dataset of the same patient.
[0006] Preferably, the preliminary data cleaning process of the collected blood collection tube sample data to remove duplicate and redundant blood collection tube sample data specifically includes: Obtain the same patient dataset; Determine whether the attribute values of records in the same patient data set are completely equal. If so, output the equal records as duplicate data and merge the equal records into one record. If not, do not output them. Perform multiple regression on each response variable in the blood collection tube sample data and the explanatory variables in the blood collection tube sample data; The fitted value of each response variable is obtained through the regression model, that is, the corresponding value on the regression line; Output the difference between the observed and fitted values of the response variable as residuals; Output includes the fitted value matrix and residual matrix of all response variables; Perform principal component analysis on the fitted value matrix to obtain the canonical eigenvector matrix; The original data matrix is used to obtain the sample plot order coordinates in the original variable space, and the obtained coordinates are set as the sample plot scores; Use the fitted value matrix to obtain the sample plot order coordinates in the explanatory variable space, and the obtained coordinates are set as sample plot constraints; Add the sample score and the sample constraint to get the redundancy score of each data; Determine whether the redundancy score of each data is lower than the preset redundancy threshold. If so, output the data as redundant data and delete the data record. If not, do not output it.
[0007] Preferably, the method of filling missing values in blood collection tube sample data using first-order linear interpolation method specifically includes: Read blood collection tube sample data from the same patient dataset and mark known data points and missing data points; Select two known data points that are immediately adjacent to the missing data point as the basis for interpolation; Use the first-order linear interpolation formula to calculate the interpolation point values of missing data points; The calculated interpolation point values are used to replace the missing values in the same patient data set; The first-order linear interpolation formula is: , In the formula, are the collection date value and interpolation point value of the missing data point, respectively. are the collection date value and data value of the known data point immediately before the missing data point, are the collection date value and data value of the known data point immediately following the missing data point, respectively.
[0008] Preferably, the step of establishing a blood database for storing blood collection tube sample data and entering the associated blood collection tube sample data into the blood database specifically includes: Construct an entity-relationship model to describe the relationship between blood collection tube sample data. In the blood database, entities include patient entities, blood collection tube sample entities, and test result entities, and determine the association relationship between each entity; Converting the entity-relationship model into a logical structure of a blood database, wherein the logical structure includes a table structure, a field type, and an index; Based on the logical structure design of the blood database, determine the storage structure, storage path and storage device of the database; The associated blood collection tube sample data is entered into the blood database.
[0009] Preferably, the method of verifying the blood collection tube sample data in the blood database by using the interquartile range method to detect and remove abnormal values in the blood collection tube sample data specifically includes: Sort the blood collection tube sample data; Calculate the data points at the 25% position in the data set and output them as the first quartile; Calculate the data points at the 75% position in the data set and output them as the third quartile; The interquartile range formula was used to calculate the normal value range of sample data; Determine whether the blood collection tube sample data exceeds the normal value range of the sample data. If so, output the data as an abnormal value, remove the data in the database, and use the first-order linear interpolation method to fill the missing value. If not, do not output it; The interquartile range formula is: , In the formula, is the normal value of the sample data, is the first quartile, The third quartile.
[0010] Furthermore, a blood collection tube sample data integration system is proposed, which is used to implement the blood collection tube sample data integration method as described above, comprising: A data collection module, which is used to generate a barcode based on the sample collection information during the blood collection process, and enter the collection information into the blood collection tube sample data; A data processing module, the data processing module is used to number each sample data based on the barcode of the blood collection tube sample data, and use the number as the unique identifier of the sample data, use a fuzzy matching algorithm to associate blood collection tube sample data from different sources, test the blood collection tube samples, and merge the test results with the corresponding blood collection tube sample data, perform preliminary data cleaning processing on the collected blood collection tube sample data, remove duplicate and redundant blood collection tube sample data, and use a first-order linear interpolation method to fill in missing values in the blood collection tube sample data; A data integration module is used to establish a blood database for storing blood collection tube sample data, enter the associated blood collection tube sample data into the blood database, verify the blood collection tube sample data in the blood database using the interquartile range method, detect and remove abnormal values in the blood collection tube sample data, and the user obtains the number of the corresponding blood collection tube sample data by scanning the barcode, and obtains the test result based on the number.
[0011] Optionally, the data processing module specifically includes: A data numbering unit, which is used to number each sample data based on the barcode of the blood collection tube sample data, and use the number as a unique identifier of the sample data; A data association unit, the data association unit is used to associate blood collection tube sample data from different sources using a fuzzy matching algorithm; A sample testing unit, which is used to test the blood collection tube sample and merge the test result with the corresponding blood collection tube sample data; A data cleaning unit, the data cleaning unit is used to perform preliminary data cleaning processing on the collected blood collection tube sample data to remove duplicate and redundant blood collection tube sample data; A data interpolation unit is used to fill in the missing values in the blood collection tube sample data using a first-order linear interpolation method.
[0012] Optionally, the data integration module specifically includes: A database establishment unit, the database establishment unit is used to establish a blood database for storing blood collection tube sample data, and enter the associated blood collection tube sample data into the blood database; A data verification unit, the data verification unit is used to verify the blood collection tube sample data in the blood database using the interquartile range method, and detect and remove abnormal values in the blood collection tube sample data; A user query unit is used for a user to obtain a number corresponding to the blood collection tube sample data by scanning a barcode, and to obtain a test result based on the number.
[0013] Compared with the prior art, the present invention has the following beneficial effects: By setting up data acquisition modules, data processing modules and data integration modules, and utilizing the advantages of computers in calculation, storage and transmission, unnecessary work links can be eliminated, work efficiency can be improved, work burden can be reduced, and operational standardization can be increased. All information in this system can be accessed by all legitimate users on the network, who can quickly and easily obtain information within their authority and realize resource sharing. BRIEF DESCRIPTION OF THE DRAWINGS
[0014] Figure 1 It is a flow chart of the blood collection tube sample data integration method of the present invention; Figure 2 This is a flow chart of a method for associating blood collection tube sample data from different sources using a fuzzy matching algorithm according to the present invention; Figure 3 A flow chart of a method for performing preliminary data cleaning processing on collected blood collection tube sample data according to the present invention; Figure 4 This is a flow chart of the method for filling missing values in blood collection tube sample data of the present invention; Figure 5 A flow chart of a method for establishing a blood database for storing blood collection tube sample data according to the present invention; Figure 6 The present invention is a flow chart of a method for verifying blood collection tube sample data in a blood database using the interquartile range method. DETAILED DESCRIPTION
[0015] The following description is used to disclose the present invention so that those skilled in the art can implement the present invention. The preferred embodiments described below are only examples, and those skilled in the art may think of other obvious variations.
[0016] Reference Figure 1 As shown, the blood collection tube sample data integration method includes: During the blood collection process, a barcode is generated based on the sample collection information, and the collection information is entered into the blood collection tube sample data, wherein the collection information includes patient information, collection date and collection site; Number each sample data based on the barcode of the blood collection tube sample data, and use the number as the unique identifier of the sample data; The fuzzy matching algorithm is used to associate blood collection tube sample data from different sources; Testing the blood collection tube samples and merging the test results with the corresponding blood collection tube sample data; Perform preliminary data cleaning on the collected blood collection tube sample data to remove duplicate and redundant blood collection tube sample data; First-order linear interpolation was used to fill in missing values in blood collection tube sample data; Establishing a blood database for storing blood collection tube sample data, and entering the associated blood collection tube sample data into the blood database; The interquartile range method is used to verify the blood collection tube sample data in the blood database, and abnormal values in the blood collection tube sample data are detected and eliminated; The user obtains the number of the corresponding blood collection tube sample data by scanning the barcode, and obtains the test result based on the number.
[0017] Reference Figure 2 As shown, the fuzzy matching algorithm is used to associate blood collection tube sample data from different sources, specifically including: creating a summary record of the basic standardized match, the summary record including the type of matched data that has been repaired; Select and map attributes based on the fuzzy matching that will occur; A fuzzy matching technique is selected for each attribute. Text information is matched based on keyboard distance and name variants, and numeric information is matched based on numeric similarity indicators. Preset weights for each attribute, and attributes with high weights have a greater impact on the overall matching confidence than attributes with low weights; Run the fuzzy matching algorithm and calculate the fuzzy matching confidence of blood collection tube sample data from different sources; Preset matching confidence threshold; Determine whether the fuzzy matching confidence of blood collection tube sample data from different sources is higher than a preset matching confidence threshold. If so, output the group of data as related data; if not, do not output; The blood collection tube samples from the same patient at different times are matched and associated and output as a dataset of the same patient.
[0018] Fuzzy matching is a data matching technique that compares two or more records and calculates the likelihood that they belong to the same entity. Fuzzy matching does not produce a match or mismatch result, but rather a percentage that describes the likelihood that the record belongs to the same customer, product, or employee. Effective fuzzy matching algorithms can handle a range of data ambiguities, such as first / last name reversals, acronyms, abbreviations, phonetic and intentional spelling errors, abbreviations, added / deleted punctuation, etc.
[0019] Reference Figure 3 As shown, the collected blood collection tube sample data is initially cleaned to remove duplicate and redundant blood collection tube sample data, including: Obtain the same patient dataset; Determine whether the attribute values of records in the same patient data set are completely equal. If so, output the equal records as duplicate data and merge the equal records into one record. If not, do not output them. Perform multiple regression on each response variable in the blood collection tube sample data and the explanatory variables in the blood collection tube sample data; The fitted value of each response variable is obtained through the regression model, that is, the corresponding value on the regression line; Output the difference between the observed and fitted values of the response variable as residuals; Output includes the fitted value matrix and residual matrix of all response variables; Perform principal component analysis on the fitted value matrix to obtain the canonical eigenvector matrix; The original data matrix is used to obtain the sample plot order coordinates in the original variable space, and the obtained coordinates are set as the sample plot scores; Use the fitted value matrix to obtain the sample plot order coordinates in the explanatory variable space, and the obtained coordinates are set as sample plot constraints; Add the sample score and the sample constraint to get the redundancy score of each data; Determine whether the redundancy score of each data is lower than the preset redundancy threshold. If so, output the data as redundant data and delete the data record. If not, do not output it.
[0020] In statistics, redundancy analysis is to analyze the causes of variation in the original variables through the correlation between the original variables and the typical variables. Specifically, a linear regression model is established with the original variables as the dependent variable and the typical variables as the independent variable. The corresponding coefficient of determination is equal to the square of the correlation coefficient between the dependent variable and the typical variable. It describes the proportion of the variation in the dependent variable caused by the linear relationship between the dependent variable and the typical variable in the total variation in the dependent variable.
[0021] Reference Figure 4As shown in the figure, the missing values in the blood collection tube sample data are filled using the first-order linear interpolation method, specifically including: Read blood collection tube sample data from the same patient dataset and mark known data points and missing data points; Select two known data points that are immediately adjacent to the missing data point as the basis for interpolation; Use the first-order linear interpolation formula to calculate the interpolation point values of missing data points; The calculated interpolation point values are used to replace the missing values in the same patient data set; The first-order linear interpolation formula is: , In the formula, are the collection date value and interpolation point value of the missing data point, respectively. are the collection date value and data value of the known data point immediately before the missing data point, are the collection date value and data value of the known data point immediately following the missing data point, respectively.
[0022] Interpolation usually refers to interpolation, which is a term in discrete mathematics. It refers to interpolating a continuous function based on discrete data so that the continuous curve passes through all given discrete data points. As an important method of approximating discrete functions, interpolation can be used to estimate the approximate value of the function at other points based on the value of the function at a finite number of points.
[0023] Reference Figure 5 As shown, establishing a blood database for storing blood collection tube sample data and entering the associated blood collection tube sample data into the blood database specifically includes: Construct an entity-relationship model to describe the relationship between blood collection tube sample data. In the blood database, entities include patient entities, blood collection tube sample entities, and test result entities, and determine the association relationship between each entity; Converting the entity-relationship model into a logical structure of a blood database, wherein the logical structure includes a table structure, a field type, and an index; Based on the logical structure design of the blood database, determine the storage structure, storage path and storage device of the database; The associated blood collection tube sample data is entered into the blood database.
[0024] For blood databases, commonly used database systems include relational databases, such as MySQL, and NoSQL databases. Relational databases are suitable for storing structured data, while NoSQL databases are more suitable for processing unstructured or semi-structured data.
[0025] Reference Figure 6As shown, the interquartile range method is used to verify the blood collection tube sample data in the blood database, and the abnormal values in the blood collection tube sample data are detected and eliminated, specifically including: Sort the blood collection tube sample data; Calculate the data points at the 25% position in the data set and output them as the first quartile; Calculate the data points at the 75% position in the data set and output them as the third quartile; The interquartile range formula was used to calculate the normal value range of sample data; Determine whether the blood collection tube sample data exceeds the normal value range of the sample data. If so, output the data as an abnormal value, remove the data in the database, and use the first-order linear interpolation method to fill the missing value. If not, do not output it; The interquartile range formula is: , In the formula, is the normal value of the sample data, is the first quartile, The third quartile.
[0026] The interquartile range method is a commonly used statistical method for detecting outliers or extreme values in a data set. This method does not rely on the assumption of normal distribution of the data, so it is particularly suitable for data with non-normal distribution or skewed distribution. In the data verification of blood collection tube samples in the blood database, the interquartile range method can effectively identify and eliminate outliers, thereby improving the accuracy and reliability of the data.
[0027] Further, based on the same inventive concept as the above blood collection tube sample data integration method, the present solution also proposes a blood collection tube sample data integration system, comprising: A data collection module, which is used to generate a barcode based on the sample collection information during the blood collection process, and enter the collection information into the blood collection tube sample data; A data processing module, the data processing module is used to number each sample data based on the barcode of the blood collection tube sample data, and use the number as the unique identifier of the sample data, use a fuzzy matching algorithm to associate blood collection tube sample data from different sources, test the blood collection tube samples, and merge the test results with the corresponding blood collection tube sample data, perform preliminary data cleaning processing on the collected blood collection tube sample data, remove duplicate and redundant blood collection tube sample data, and use a first-order linear interpolation method to fill in missing values in the blood collection tube sample data; A data integration module is used to establish a blood database for storing blood collection tube sample data, enter the associated blood collection tube sample data into the blood database, verify the blood collection tube sample data in the blood database using the interquartile range method, detect and remove abnormal values in the blood collection tube sample data, and the user obtains the number of the corresponding blood collection tube sample data by scanning the barcode, and obtains the test result based on the number.
[0028] The data processing module specifically includes: A data numbering unit, which is used to number each sample data based on the barcode of the blood collection tube sample data, and use the number as a unique identifier of the sample data; A data association unit, the data association unit is used to associate blood collection tube sample data from different sources using a fuzzy matching algorithm; A sample testing unit, which is used to test the blood collection tube sample and merge the test result with the corresponding blood collection tube sample data; A data cleaning unit, the data cleaning unit is used to perform preliminary data cleaning processing on the collected blood collection tube sample data to remove duplicate and redundant blood collection tube sample data; A data interpolation unit is used to fill in the missing values in the blood collection tube sample data using a first-order linear interpolation method.
[0029] The data integration module specifically includes: A database establishment unit, the database establishment unit is used to establish a blood database for storing blood collection tube sample data, and enter the associated blood collection tube sample data into the blood database; A data verification unit, the data verification unit is used to verify the blood collection tube sample data in the blood database using the interquartile range method, and detect and remove abnormal values in the blood collection tube sample data; A user query unit is used for a user to obtain a number corresponding to the blood collection tube sample data by scanning a barcode, and to obtain a test result based on the number.
[0030] Furthermore, the present solution also proposes a computer-readable storage medium on which a computer-readable program is stored. When the computer-readable program is called, the above-mentioned blood collection tube sample data integration method is executed.
[0031] It is understandable that the storage medium may be a magnetic medium, such as a floppy disk, a hard disk, or a magnetic tape; an optical medium, such as a DVD; or a semiconductor medium, such as a solid state drive (SSD).
[0032] To sum up, the advantages of the present invention are: by setting up a data acquisition module, a data processing module and a data integration module, utilizing the advantages of computers in calculation, storage and transmission, eliminating unnecessary work links, improving work efficiency, reducing work burden, and increasing operational standardization, all information of this system can be accessed by all legitimate users on the network, and they can easily and quickly obtain information within their authority and realize resource sharing.
[0033] The above shows and describes the basic principles, main features and advantages of the present invention. Those skilled in the art should understand that the present invention is not limited to the above embodiments. The above embodiments and descriptions only describe the principles of the present invention. The present invention may be subject to various changes and improvements without departing from the spirit and scope of the present invention. These changes and improvements fall within the scope of the present invention. The scope of protection claimed by the present invention is defined by the attached claims and their equivalents.
Claims
1. A method for integrating blood collection tube sample data, characterized in that: include: During the blood collection process, a barcode is generated based on the sample collection information, and the collection information is entered into the blood collection tube sample data, wherein the collection information includes patient information, collection date and collection site; Number each sample data based on the barcode of the blood collection tube sample data, and use the number as the unique identifier of the sample data; The fuzzy matching algorithm is used to associate blood collection tube sample data from different sources; Testing the blood collection tube samples and merging the test results with the corresponding blood collection tube sample data; Perform preliminary data cleaning on the collected blood collection tube sample data to remove duplicate and redundant blood collection tube sample data; First-order linear interpolation was used to fill in missing values in blood collection tube sample data; Establishing a blood database for storing blood collection tube sample data, and entering the associated blood collection tube sample data into the blood database; The interquartile range method is used to verify the blood collection tube sample data in the blood database, and abnormal values in the blood collection tube sample data are detected and eliminated; The user obtains the number of the corresponding blood collection tube sample data by scanning the barcode, and obtains the test result based on the number.
2. The blood collection tube sample data integration method according to claim 1, characterized in that: The method of associating blood collection tube sample data from different sources using a fuzzy matching algorithm specifically includes: creating a summary record of the basic standardized match, the summary record including the type of matched data that has been repaired; Select and map attributes based on the fuzzy matching that will occur; A fuzzy matching technique is selected for each attribute. Text information is matched based on keyboard distance and name variants, and numeric information is matched based on numeric similarity indicators. Preset weights for each attribute, and attributes with high weights have a greater impact on the overall matching confidence than attributes with low weights; Run the fuzzy matching algorithm and calculate the fuzzy matching confidence of blood collection tube sample data from different sources; Preset matching confidence threshold; Determine whether the fuzzy matching confidence of blood collection tube sample data from different sources is higher than a preset matching confidence threshold. If so, output the group of data as related data; if not, do not output; The blood collection tube samples from the same patient at different times are matched and associated and output as a dataset of the same patient.
3. The blood collection tube sample data integration method according to claim 2, characterized in that: The preliminary data cleaning process of the collected blood collection tube sample data to remove duplicate and redundant blood collection tube sample data specifically includes: Obtain the same patient dataset; Determine whether the attribute values of records in the same patient data set are completely equal. If so, output the equal records as duplicate data and merge the equal records into one record. If not, do not output them. Perform multiple regression on each response variable in the blood collection tube sample data and the explanatory variables in the blood collection tube sample data; The fitted value of each response variable is obtained through the regression model, that is, the corresponding value on the regression line; Output the difference between the observed and fitted values of the response variable as residuals; Output includes the fitted value matrix and residual matrix of all response variables; Perform principal component analysis on the fitted value matrix to obtain the canonical eigenvector matrix; The original data matrix is used to obtain the sample plot order coordinates in the original variable space, and the obtained coordinates are set as the sample plot scores; Use the fitted value matrix to obtain the sample plot order coordinates in the explanatory variable space, and the obtained coordinates are set as sample plot constraints; The redundancy score of each data is obtained by adding the sample score to the sample constraint; Determine whether the redundancy score of each data is lower than the preset redundancy threshold. If so, output the data as redundant data and delete the data record. If not, do not output it.
4. The blood collection tube sample data integration method according to claim 3, characterized in that: The method of using the first-order linear interpolation method to fill the missing values in the blood collection tube sample data specifically includes: Read blood collection tube sample data from the same patient dataset and mark known data points and missing data points; Select two known data points that are immediately adjacent to the missing data point as the basis for interpolation; Use the first-order linear interpolation formula to calculate the interpolation point values of missing data points; The calculated interpolation point values are used to replace the missing values in the same patient data set; The first-order linear interpolation formula is: , In the formula, are the collection date value and interpolation point value of the missing data point, respectively. are the collection date value and data value of the known data point immediately before the missing data point, are the collection date value and data value of the known data point immediately following the missing data point, respectively.
5. The blood collection tube sample data integration method according to claim 4, characterized in that: The step of establishing a blood database for storing blood collection tube sample data and entering the associated blood collection tube sample data into the blood database specifically includes: Construct an entity-relationship model to describe the relationship between blood collection tube sample data. In the blood database, entities include patient entities, blood collection tube sample entities, and test result entities, and determine the association relationship between each entity; Converting the entity-relationship model into a logical structure of a blood database, wherein the logical structure includes a table structure, a field type, and an index; Based on the logical structure design of the blood database, determine the storage structure, storage path and storage device of the database; The associated blood collection tube sample data is entered into the blood database.
6. The blood collection tube sample data integration method according to claim 5, characterized in that: The method of using the interquartile range method to verify the blood collection tube sample data in the blood database and detecting and removing abnormal values in the blood collection tube sample data specifically includes: Sort the blood collection tube sample data; Calculate the data points at the 25% position in the data set and output them as the first quartile; Calculate the data points at the 75% position in the data set and output them as the third quartile; The interquartile range formula was used to calculate the normal value range of sample data; Determine whether the blood collection tube sample data exceeds the normal value range of the sample data. If so, output the data as an abnormal value, remove the data in the database, and use the first-order linear interpolation method to fill the missing value. If not, do not output it; The interquartile range formula is: , In the formula, is the normal value of the sample data, is the first quartile, The third quartile.
7. A blood collection tube sample data integration system, used to implement the blood collection tube sample data integration method according to any one of claims 1 to 6, characterized in that: include: A data collection module, which is used to generate a barcode based on the sample collection information during the blood collection process, and enter the collection information into the blood collection tube sample data; A data processing module, the data processing module is used to number each sample data based on the barcode of the blood collection tube sample data, and use the number as the unique identifier of the sample data, use a fuzzy matching algorithm to associate blood collection tube sample data from different sources, test the blood collection tube samples, and merge the test results with the corresponding blood collection tube sample data, perform preliminary data cleaning processing on the collected blood collection tube sample data, remove duplicate and redundant blood collection tube sample data, and use a first-order linear interpolation method to fill in missing values in the blood collection tube sample data; A data integration module is used to establish a blood database for storing blood collection tube sample data, enter the associated blood collection tube sample data into the blood database, verify the blood collection tube sample data in the blood database using the interquartile range method, detect and remove abnormal values in the blood collection tube sample data, and the user obtains the number of the corresponding blood collection tube sample data by scanning the barcode, and obtains the test result based on the number.
8. The blood collection tube sample data integration system according to claim 7, characterized in that: The data processing module specifically includes: A data numbering unit, which is used to number each sample data based on the barcode of the blood collection tube sample data, and use the number as a unique identifier of the sample data; A data association unit, the data association unit is used to associate blood collection tube sample data from different sources using a fuzzy matching algorithm; A sample testing unit, which is used to test the blood collection tube sample and merge the test result with the corresponding blood collection tube sample data; A data cleaning unit, the data cleaning unit is used to perform preliminary data cleaning processing on the collected blood collection tube sample data to remove duplicate and redundant blood collection tube sample data; A data interpolation unit is used to fill in the missing values in the blood collection tube sample data using a first-order linear interpolation method.
9. The blood collection tube sample data integration system according to claim 8, characterized in that: The data integration module specifically includes: A database establishment unit, the database establishment unit is used to establish a blood database for storing blood collection tube sample data, and enter the associated blood collection tube sample data into the blood database; A data verification unit, the data verification unit is used to verify the blood collection tube sample data in the blood database using the interquartile range method, and detect and remove abnormal values in the blood collection tube sample data; A user query unit is used for a user to obtain a number corresponding to the blood collection tube sample data by scanning a barcode, and to obtain a test result based on the number.
Citation Information
Patent Citations
Method and system for predicting water lettuce invasion distribution areas
CN111178631A
Matching data from variant databases
WO2014182725A1
