CN111768846A - Clinical data management method - Google Patents
Clinical data management method Download PDFInfo
- Publication number
- CN111768846A CN111768846A CN202010462469.2A CN202010462469A CN111768846A CN 111768846 A CN111768846 A CN 111768846A CN 202010462469 A CN202010462469 A CN 202010462469A CN 111768846 A CN111768846 A CN 111768846A
- Authority
- CN
- China
- Prior art keywords
- data
- clinical
- layer
- clinical data
- entity
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16H—HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G16H40/00—ICT specially adapted for the management or administration of healthcare resources or facilities; ICT specially adapted for the management or operation of medical equipment or devices
- G16H40/20—ICT specially adapted for the management or administration of healthcare resources or facilities; ICT specially adapted for the management or operation of medical equipment or devices for the management or administration of healthcare resources or facilities, e.g. managing hospital staff or surgery rooms
Abstract
The invention provides a clinical data management method, which comprises the following steps: step one, establishing a clinical entity data layer, collecting medical service data in a database of a clinical data center, forming a medical service data model, and storing the medical service data model into the clinical entity data layer; step two, establishing a clinical data warehouse layer, and transmitting data in the clinical entity data layer to the clinical data warehouse layer; and step three, establishing a clinical data mart layer, and cleaning and storing data in the clinical data warehouse layer to the clinical data mart layer. According to the clinical data management method, the clinical entity data layer, the clinical data warehouse layer and the clinical data market layer are established, the availability of clinical data is improved after the original clinical data is sorted and reconstructed, and convenience is brought to a final clinical data user.
Description
Technical Field
The invention relates to the technical field of clinical data information, in particular to a clinical data management method.
Background
The clinical data center platform is based on the existing information systems of hospitals, releases the medical data enclosed in a plurality of sets of isolated information systems, and realizes physical concentration; and then the data is converted into various valuable information through discretization processing, so as to help hospitals to realize continuous quality improvement and service innovation. Because the information is more complete and the use is more convenient, the working efficiency of various users is improved, the decision-making judgment basis is more sufficient, the service response is more timely, and the system and the method have very important meanings for promoting the management system transformation and the service innovation of the public hospital, developing various people-benefiting services and solving the difficult problems of 'difficult and expensive' seeing of the masses. Meanwhile, through the construction of a whole hospital data center platform, the overall informatization level of the hospital can be greatly improved, and the leap-type development of the information construction of the hospital is realized.
We have seen that the technical emphasis of most hospital data center construction at present in China is on collecting data, but only the physical concentration of a large amount of originally dispersed data is realized, and the concentrated data is not sorted and reconstructed, so that the unscrambled and reconstructed data cannot help the end users (clinicians, medical managers and decision makers) of the information to make informed clinical, administrative, research and financial decisions.
Although various other solutions exist, such as building Web-based portals, building information warehouses, and building analysis tools. However, using these various methods of crushing, may not be the best solution.
Disclosure of Invention
In view of the above-mentioned drawbacks of the prior art, an object of the present invention is to provide a clinical data management method for solving the problems in the prior art: the collected data is merely a physical centralization of a large amount of otherwise scattered data, and the centralized data is not consolidated and reconstructed, so that the uncommitted and reconstructed data cannot help the end user of the information to make an informed clinical decision.
In order to solve the technical problem, the invention is realized as follows: a method of clinical data management, the method comprising the steps of:
step one, establishing a clinical entity data layer, collecting medical service data in a database of a clinical data center, forming a medical service data model, and storing the medical service data model into the clinical entity data layer;
step two, establishing a clinical data warehouse layer, and transmitting data in the clinical entity data layer to the clinical data warehouse layer;
and step three, establishing a clinical data mart layer, and cleaning and storing the data in the clinical data warehouse layer to the clinical data mart layer.
Further, the first step comprises copying a database of a clinical data center and enabling a change data capturing mechanism to perform the real-time medical service data acquisition.
Further, the first step includes unifying the recorded information of each activity in the healthcare business data and the raw documents into the clinical entity data layer through HL7RIM model.
Further, the medical service data comprises disease course records, test results, examination reports, medical advice information, influence information, medication information, expense information and treatment information.
And the clinical operation type data storage is respectively connected with the clinical entity data layer and the clinical data warehouse layer, and the clinical operation type data storage is converged into real-time data in the clinical entity data layer by extracting, converting and loading the data in the clinical entity data layer.
Further, the third step includes performing bidirectional referral and remote consultation through the data of the clinical data mart layer.
Further, data verification is conducted on the clinical entity data layer, the clinical data warehouse layer and the clinical data mart establishing layer.
Further, a data log schedule is added to verify the data.
Further, the fields of the data log time table include a log time stamp field, a success or failure field, a number of pouring lines field, a number of inserting lines field, a number of updating lines field, a number of deleting lines field, a data source read start time field, a data source read completion time field, and an import completion time field.
Further, the data is verified using the Validation tool.
As described above, according to the clinical data management method provided by the invention, the clinical entity data layer, the clinical data warehouse layer and the clinical data mart layer are established, and the usability of the clinical data is improved after the original clinical data is sorted and reconstructed, so that convenience is brought to the final clinical data user.
Drawings
FIG. 1 is a flow chart of a method for clinical data management according to an embodiment of the present invention;
FIG. 2 is a flowchart of medical data collection in a clinical data management method according to an embodiment of the present invention;
FIG. 3 is a diagram illustrating a data structure of a method for clinical data management according to an embodiment of the present invention;
FIG. 4 is a data frame diagram illustrating a method for clinical data management according to an embodiment of the present invention;
FIG. 5 is a diagram illustrating a medical service data structure of a clinical data management method according to an embodiment of the present invention;
FIG. 6 is a diagram illustrating a data log schedule of a clinical data management method according to an embodiment of the invention.
Detailed Description
The embodiments of the present invention are described below with reference to specific embodiments, and other advantages and effects of the present invention will be easily understood by those skilled in the art from the disclosure of the present specification. The invention is capable of other and different embodiments and of being practiced or of being carried out in various ways, and its several details are capable of modification in various respects, all without departing from the spirit and scope of the present invention. It is to be noted that the features in the following embodiments and examples may be combined with each other without conflict.
It should be noted that the drawings provided in the following embodiments are only for illustrating the basic idea of the present invention, and the components related to the present invention are only shown in the drawings rather than drawn according to the number, shape and size of the components in actual implementation, and the type, quantity and proportion of the components in actual implementation may be changed freely, and the layout of the components may be more complicated.
Referring to fig. 1 to 6, the present invention provides a clinical data management method, including the following steps:
establishing a clinical entity data layer, copying a database of a clinical data center, and starting a change data capturing mechanism to acquire real-time medical service data, wherein the medical service data comprises a course record, a test result, an examination report, medical advice information, influence information, medication information, expense information and treatment information.
And unifying the information recorded by each activity object in the medical service data and each original document into the clinical entity data layer through an HL7RIM model to form a medical service data model, and storing the medical service data model into the clinical entity data layer. HL7(Health Level 7) is a standard for Health information exchange, a standardized Health information transmission protocol, and is a protocol for electronic transmission between different applications in the medical field. HL7 collected standard formats used by different vendors to design interfaces between applications that would allow various healthcare institutions to interact with data between heterogeneous systems. RIM is a static model of health information that synthesizes agreed-upon views of HL7 workgroups and international members about the information. It is the most fundamental source of all HL7 protocol specification standards.
And step two, establishing a clinical data warehouse layer, and transmitting the data in the clinical entity data layer to the clinical data warehouse layer. And the clinical operation type data storage is connected between the clinical entity data layer and the clinical data warehouse layer and is converged into the data in the real-time clinical entity data layer by extracting, converting and loading the data in the clinical entity data layer. The clinical operation type data storage can update and refine the medical service data in real time, so that the data quality in the bed data warehouse layer is higher. Clinical operational data storage plays a key supporting role in leveraging the collaborative application needs of both cross-system operational data and related analysis results data.
And step three, establishing a clinical data mart layer, and cleaning and storing data in the clinical data warehouse layer to the clinical data mart layer. And filling the vacancy values by using the attribute average values for the data in the clinical data warehouse layer. The use of binning, clustering, and regression on the data in the clinical data warehouse layer removes random errors or deviations in the data variables. Data is sorted first, sorted into bins of equal depth, and then smoothed by the mean of the bins, or by the bin values, or by the bin boundaries; data was monitored and outliers were removed, followed by outliers. Therefore, the data availability from the clinical data marketing layer is high, and convenience is brought to the final clinical data user. Bidirectional referral and remote consultation can be performed through data of a clinical data mart layer, so that certain regions with low medical level can be treated well.
And carrying out data verification on the clinical entity data layer, the clinical data warehouse layer and the clinical data mart layer so as to improve the accuracy of the data. And adding a data log schedule to verify the data. The fields of the data log schedule include a log timestamp field, a success or failure field, a number of pouring rows field, a number of inserting rows field, a number of updating rows field, a number of deleting rows field, a data source read start time field, a data source read completion time field, and an import completion time field. The data can also be verified using the Validation tool.
In summary, according to the clinical data management method provided by the invention, the clinical entity data layer, the clinical data warehouse layer and the clinical data market layer are established, and the usability of the clinical data is improved after the original clinical data is sorted and reconstructed, and the accuracy of the decision made by the final user of the clinical data is improved. Therefore, the present invention effectively overcomes various disadvantages of the prior art and has high industrial utilization value.
The foregoing embodiments are merely illustrative of the principles and utilities of the present invention and are not intended to limit the invention. Any person skilled in the art can modify or change the above-mentioned embodiments without departing from the spirit and scope of the present invention. Accordingly, it is intended that all equivalent modifications or changes which can be made by those skilled in the art without departing from the spirit and technical spirit of the present invention be covered by the claims of the present invention.
Claims (10)
1. A method of clinical data management, the method comprising the steps of:
step one, establishing a clinical entity data layer, collecting medical service data in a database of a clinical data center, forming a medical service data model, and storing the medical service data model into the clinical entity data layer;
step two, establishing a clinical data warehouse layer, and transmitting data in the clinical entity data layer to the clinical data warehouse layer;
and step three, establishing a clinical data mart layer, and cleaning and storing the data in the clinical data warehouse layer to the clinical data mart layer.
2. The method of claim 1, wherein the first step comprises copying a database of a clinical data center and enabling a change data capture mechanism to perform the real-time medical service data collection.
3. The method according to claim 1, wherein the step one comprises unifying the information recorded by each activity in the healthcare business data and the original documents into the clinical entity data layer through HL7RIM model.
4. The method of claim 1, wherein the medical business data includes medical records, test results, examination reports, medical order information, influence information, medication information, cost information, and visit information.
5. The method of claim 1, comprising a clinical operation type data storage, wherein the clinical operation type data storage is connected to the clinical entity data layer and the clinical data warehouse layer respectively, and the clinical operation type data storage is converged into the data in the clinical entity data layer in real time by extracting, converting and loading the data in the clinical entity data layer.
6. The method of claim 1, wherein step three comprises performing two-way referral and remote consultation through the data of the clinical data mart layer.
7. The method of claim 1, comprising performing data verification on the clinical entity data layer, the clinical data warehouse layer, and the clinical data mart layer.
8. A method of clinical data management according to claim 7, wherein a data log schedule is added to validate the data.
9. The method of claim 8, wherein the fields of the data log schedule include a log timestamp field, a success field, a number of pouring lines field, a number of inserting lines field, a number of updating lines field, a number of deleting lines field, a data source read start time field, a data source read completion time field, and an import completion time field.
10. A method of clinical data management according to claim 7, wherein the data is validated using a Validation tool.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010462469.2A CN111768846A (en) | 2020-05-27 | 2020-05-27 | Clinical data management method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010462469.2A CN111768846A (en) | 2020-05-27 | 2020-05-27 | Clinical data management method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111768846A true CN111768846A (en) | 2020-10-13 |
Family
ID=72719999
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010462469.2A Pending CN111768846A (en) | 2020-05-27 | 2020-05-27 | Clinical data management method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111768846A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20050034274A (en) * | 2003-10-09 | 2005-04-14 | 주식회사 이수유비케어 | System and method of managing medical data |
| CN105608327A (en) * | 2015-12-31 | 2016-05-25 | 复旦大学附属华山医院 | Method and equipment for realizing clinical information sharing |
| CN106250691A (en) * | 2016-07-29 | 2016-12-21 | 广州天健软件有限公司 | A kind of medicinal data processing method |
| CN108509982A (en) * | 2018-03-12 | 2018-09-07 | 昆明理工大学 | A method of the uneven medical data of two classification of processing |
| CN108769076A (en) * | 2018-07-06 | 2018-11-06 | 北京绪水互联科技有限公司 | Data collecting system, method and device with network isolation function |
| CN109830303A (en) * | 2019-02-01 | 2019-05-31 | 上海众恒信息产业股份有限公司 | Clinical data mining analysis and aid decision-making method based on internet integration medical platform |
-
2020
- 2020-05-27 CN CN202010462469.2A patent/CN111768846A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20050034274A (en) * | 2003-10-09 | 2005-04-14 | 주식회사 이수유비케어 | System and method of managing medical data |
| CN105608327A (en) * | 2015-12-31 | 2016-05-25 | 复旦大学附属华山医院 | Method and equipment for realizing clinical information sharing |
| CN106250691A (en) * | 2016-07-29 | 2016-12-21 | 广州天健软件有限公司 | A kind of medicinal data processing method |
| CN108509982A (en) * | 2018-03-12 | 2018-09-07 | 昆明理工大学 | A method of the uneven medical data of two classification of processing |
| CN108769076A (en) * | 2018-07-06 | 2018-11-06 | 北京绪水互联科技有限公司 | Data collecting system, method and device with network isolation function |
| CN109830303A (en) * | 2019-02-01 | 2019-05-31 | 上海众恒信息产业股份有限公司 | Clinical data mining analysis and aid decision-making method based on internet integration medical platform |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110335647B (en) | Clinical data standardization system and standardized data acquisition method | |
| US8428966B2 (en) | System and method for analyzing, collecting, and tracking quality data across a vast healthcare provider network | |
| WO2019112664A1 (en) | Medical imaging and patient health information exchange platform | |
| CN101622622A (en) | Individual health record system and device | |
| CN111223534B (en) | Industry and financial fusion fine management system | |
| CN112349369A (en) | Medical image big data intelligent analysis method, system and storage medium | |
| CN111882203B (en) | Traditional Chinese medicine cloud service experimental system | |
| CN110766332A (en) | Comprehensive quality index monitoring system for regional sanitation | |
| WO2019129884A1 (en) | Method of using medical data related to patients suffering a given disease | |
| Niland et al. | An informatics blueprint for healthcare quality information systems | |
| CN112185497A (en) | Occupational health supervision method and system | |
| Wood et al. | ASH Research Collaborative: a real-world data infrastructure to support real-world evidence development and learning healthcare systems in hematology | |
| Keenan et al. | The HANDS project: studying and refining the automated collection of a cross-setting clinical data set | |
| CN206741488U (en) | A kind of disease research management system of more mechanisms combines | |
| CN102103734A (en) | Medical information integration system and method | |
| CN108899094A (en) | A kind of disease research management system of more mechanisms combines | |
| CN113393922A (en) | Auxiliary diagnosis and treatment type artificial intelligent application evaluation framework and evaluation method | |
| CN111768846A (en) | Clinical data management method | |
| CN107153758A (en) | A kind of method for estimating curative effect and system that symptom operation is standardized based on the traditional Chinese medical science | |
| US20220076814A1 (en) | Health administration method, apparatus, and system, and data collection apparatus | |
| Zhou et al. | New approaches in Philips ECG database management system design | |
| Alghamdi | Health data warehouses: reviewing advanced solutions for medical knowledge discovery | |
| Xie et al. | An assessment technique for information quality support in emergency response | |
| Parker et al. | Data quality: How the flow of data influences data quality in a small to medium medical practice | |
| Wen et al. | Applying latest data science technology in cancer screening programs |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |