CN111259633A - System for converting document into format and automatically establishing database - Google Patents

System for converting document into format and automatically establishing database Download PDF

Info

Publication number
CN111259633A
CN111259633A CN202010087680.0A CN202010087680A CN111259633A CN 111259633 A CN111259633 A CN 111259633A CN 202010087680 A CN202010087680 A CN 202010087680A CN 111259633 A CN111259633 A CN 111259633A
Authority
CN
China
Prior art keywords
data
module
analysis
database
patient
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
Application number
CN202010087680.0A
Other languages
Chinese (zh)
Inventor
郑擎
邹国宾
高圳昱
黄宇
刘雯
徐鸣俊
陈静
陈树强
郑玲
何燕
刘源
石桂秀
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Xiamen University
First Affiliated Hospital of Fujian Medical University
Original Assignee
Xiamen University
First Affiliated Hospital of Fujian Medical University
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Xiamen University, First Affiliated Hospital of Fujian Medical University filed Critical Xiamen University
Priority to CN202010087680.0A priority Critical patent/CN111259633A/en
Publication of CN111259633A publication Critical patent/CN111259633A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G16INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
    • G16HHEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
    • G16H50/00ICT specially adapted for medical diagnosis, medical simulation or medical data mining; ICT specially adapted for detecting, monitoring or modelling epidemics or pandemics
    • G16H50/20ICT specially adapted for medical diagnosis, medical simulation or medical data mining; ICT specially adapted for detecting, monitoring or modelling epidemics or pandemics for computer-aided diagnosis, e.g. based on medical expert systems
    • GPHYSICS
    • G16INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
    • G16HHEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
    • G16H50/00ICT specially adapted for medical diagnosis, medical simulation or medical data mining; ICT specially adapted for detecting, monitoring or modelling epidemics or pandemics
    • G16H50/70ICT specially adapted for medical diagnosis, medical simulation or medical data mining; ICT specially adapted for detecting, monitoring or modelling epidemics or pandemics for mining of medical data, e.g. analysing previous cases of other patients

Landscapes

  • Engineering & Computer Science (AREA)
  • Health & Medical Sciences (AREA)
  • Medical Informatics (AREA)
  • Public Health (AREA)
  • Biomedical Technology (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Pathology (AREA)
  • Epidemiology (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • Medical Treatment And Welfare Office Work (AREA)

Abstract

The invention provides a system for converting a document into a format and automatically establishing a database, belongs to the technical field of medical systems, and aims to solve the problems that common medical data are mostly input manually and uniformly into the database of a hospital system, the efficiency is low, and a large amount of manpower and material resources are wasted; the system comprises a data analysis module, a data storage module, a data visualization module and a data export module; the medical report importing and exporting functions are integrated, the functions of storing all indexes according to the object serial numbers after analysis are achieved, and meanwhile, the view function of analyzing data according to time is achieved, so that the working time of doctors is saved, and the working efficiency is improved; the correctness of the data is higher; the user can detect, record and analyze the basic indexes of the patient in different time periods, and a doctor can find the process of the development of a specific disease on the patient and simultaneously make effective response so as to improve the state of illness of the patient. Through the data-driven diagnostic model, the procedural efficiency of the treatment diagnosed by the doctor will be greatly improved.

Description

System for converting document into format and automatically establishing database
Technical Field
The invention relates to the technical field of medical systems, in particular to a system for converting a document into a format and automatically establishing a database.
Background
In the existing medical diagnosis, a diagnosis result is often supported by a basic index detection report, and is judged by adding abundant professional knowledge and experience of doctors, so that a diagnosis result and a diagnosis report are finally obtained. At present, a system which can be used for converting a word or pdf format inspection report in a specific format into a database format and realizing importing, exporting and inquiring various indexes and displaying the indexes according to time axis trends is not customized for specific clinical research in the market, and various data are usually manually input, so that a large amount of time is wasted for medical staff, and the input error condition is easy to occur, and the diagnosis and treatment efficiency of doctors is influenced.
Disclosure of Invention
Aiming at the technical defects, the invention aims to provide a system for converting a document into a format and automatically establishing a database, which integrates the functions of importing and exporting various medical reports, stores each index function according to an object serial number after analysis, and has a view function of analyzing data according to time, thereby saving the working time of doctors and improving the working efficiency; the correctness of the data is higher; the user can detect, record and analyze the basic indexes of the patient in different time periods, and a doctor can find the process of the development of a specific disease on the patient and simultaneously make effective response so as to improve the state of illness of the patient. Through the data-driven diagnostic model, the procedural efficiency of the treatment diagnosed by the doctor will be greatly improved.
In order to solve the technical problems, the invention adopts the following technical scheme:
a system for converting a document into a format and automatically establishing a database is applied to an intelligent computer provided with an operation platform and is characterized by comprising a data analysis module, a data storage module, a data visualization module and a data export module; the data analysis module is used for leading in scattered data to be analyzed by a user, automatically storing the led-in file according to time and various indexes in a name analysis report of an analysis object, and automatically presenting the analyzed result to a main view of the platform system; through a single object name, index data stored by the object on the same day can be acquired according to time; the data storage module is used for storing all data blocks in a data table of the access database; the data visualization module is used for searching a specific object, acquiring index data of the object imported into the system through an object name, acquiring all detailed data in an index data analysis report through the index data, and graphically displaying the index data by taking time as a sequence; the data export module is configured to export all selected reports for the selected object.
The invention has the beneficial effects that: the system integrates the import and export functions of various medical reports, stores each index function according to the object serial number after analysis, and has a view function of analyzing data according to time, thereby saving the working time of doctors and improving the working efficiency; compared with manual entry, the data correctness is higher; the user can detect, record and analyze the basic indexes of the patient in different time periods, and a doctor can find the process of the development of a specific disease on the patient and simultaneously make effective response so as to improve the state of illness of the patient. Through the data-driven diagnostic model, the procedural efficiency of the treatment diagnosed by the doctor will be greatly improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a block diagram of a process of converting a document into a format and automatically creating a database according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
As shown in fig. 1, the system is applied to an intelligent computer equipped with an operating platform, and comprises a data analysis module, a data storage module, a data visualization module and a data export module; the data analysis module is used for leading in scattered data to be analyzed by a user and supporting rtf, doc, docx and txt format files. The user can select a corresponding folder or file to import a desired file. After the file is imported, the file is automatically stored according to the time and various indexes in the name analysis report of the analysis object. After the analysis is finished, the result can be automatically presented to the main view, a single object name is clicked, and the index data stored by the object on the current day can be listed in the drawing list according to the time; the whole process is automatic, manual intervention is not needed, and automatic reminding can be realized when an error occurs or the input cannot be realized; the data storage module is used for storing all the data blocks in a data table of the access database; the first column of the data visualization module is an object column, and a specific object can be clicked or searched according to the name; after clicking the name of the object, displaying all indexes of the object imported into the system in the right column according to the time sequence (day is a unit); after double clicking the index data, all data in the report of the index analysis can be browsed in detail; the right click of the index can graphically display the index in a time sequence, a statistical chart can facilitate a doctor to quickly observe the change trend, and data are comprehensive and are not omitted. The function facilitates the filing of historical data by doctors, and simultaneously, the graphical analysis is carried out, so that the seeking rules of the doctors are conveniently sought; the data export module can export all the selected objects and all reports, and also can export a certain kind of reports and indexes of the selected objects more flexibly and quickly extract and export the reports and the indexes, and the important indexes concerned by doctors do not consume resources; the derived data format is the xcls format of excel.
When the system works, after related files are imported in batches on the platform system, the platform system identifies whether the files are detection reports, if the files do not meet the requirements, the files need to be imported again, if the files meet the requirements, the imported files are analyzed, and the results are stored in a database; displaying the result on the main interface: updating the object list; and searching all history indexes of the object according to the name of the object: updating the index list; the diagnosis history of past diagnosis data is displayed and checked by drawing data of a formulated index line graph by taking time as a horizontal axis; and selecting a designated object and designated data, and exporting selected contents into excel.
The system integrates the import and export functions of various medical reports, stores each index function according to the object serial number after analysis, and has a view function of analyzing data according to time, thereby saving the working time of doctors and improving the working efficiency; compared with manual entry, the data correctness is higher; the user can detect, record and analyze the basic indexes of the patient in different time periods, and a doctor can find the process of the development of a specific disease on the patient and simultaneously make effective response so as to improve the state of illness of the patient. Through the data-driven diagnostic model, the procedural efficiency of the treatment diagnosed by the doctor will be greatly improved.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present invention without departing from the spirit and scope of the invention. Thus, if such modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include such modifications and variations.

Claims (1)

1. A system for converting a document into a format and automatically establishing a database is applied to an intelligent computer provided with an operation platform and is characterized by comprising a data analysis module, a data storage module, a data visualization module and a data export module;
the data analysis module is used for leading in scattered data to be analyzed by a user, automatically storing the led-in file according to time and various indexes in a name analysis report of an analysis object, and automatically presenting the analyzed result to a main view of the platform system; through a single object name, index data stored by the object on the same day can be acquired according to time;
the data storage module is used for storing all data blocks in a data table of the access database; the data visualization module is used for searching a specific object, acquiring index data of the object imported into the system through an object name, acquiring all detailed data in an index data analysis report through the index data, and graphically displaying the index data by taking time as a sequence;
the data export module is configured to export all selected reports for the selected object.
CN202010087680.0A 2020-02-03 2020-02-03 System for converting document into format and automatically establishing database Pending CN111259633A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010087680.0A CN111259633A (en) 2020-02-03 2020-02-03 System for converting document into format and automatically establishing database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010087680.0A CN111259633A (en) 2020-02-03 2020-02-03 System for converting document into format and automatically establishing database

Publications (1)

Publication Number Publication Date
CN111259633A true CN111259633A (en) 2020-06-09

Family

ID=70943696

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010087680.0A Pending CN111259633A (en) 2020-02-03 2020-02-03 System for converting document into format and automatically establishing database

Country Status (1)

Country Link
CN (1) CN111259633A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112133430A (en) * 2020-10-15 2020-12-25 丁玉 Clinical biochemical dynamic monitoring system

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104616136A (en) * 2015-02-15 2015-05-13 王任直 Clinical data management system
CN105718495A (en) * 2015-08-21 2016-06-29 哈尔滨安天科技股份有限公司 Exporting method and system of database hierarchical HTML (Hypertext Markup Language) statement
CN110364233A (en) * 2018-04-09 2019-10-22 首都医科大学附属北京儿童医院 Medical data acquisition manages follow-up system
CN110415831A (en) * 2019-07-18 2019-11-05 天宜(天津)信息科技有限公司 A kind of medical treatment big data cloud service analysis platform

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104616136A (en) * 2015-02-15 2015-05-13 王任直 Clinical data management system
CN105718495A (en) * 2015-08-21 2016-06-29 哈尔滨安天科技股份有限公司 Exporting method and system of database hierarchical HTML (Hypertext Markup Language) statement
CN110364233A (en) * 2018-04-09 2019-10-22 首都医科大学附属北京儿童医院 Medical data acquisition manages follow-up system
CN110415831A (en) * 2019-07-18 2019-11-05 天宜(天津)信息科技有限公司 A kind of medical treatment big data cloud service analysis platform

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
余建明 等: "《CR、DR成像技术学》", 30 September 2009 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112133430A (en) * 2020-10-15 2020-12-25 丁玉 Clinical biochemical dynamic monitoring system

Similar Documents

Publication Publication Date Title
CN109346169A (en) A kind of artificial intelligence assisting in diagnosis and treatment system and its construction method, equipment and storage medium
US11119762B1 (en) Reusable analytics for providing custom insights
CN111081329A (en) Automatic clinical data entry method and device, electronic equipment and storage medium
US20160070751A1 (en) Database management system
CN115497631A (en) Clinical scientific research big data analysis system
US20210202111A1 (en) Method of classifying medical records
US11875884B2 (en) Expression of clinical logic with positive and negative explainability
CN116312914A (en) Medical record quality control method, system, terminal and storage medium
CN111259633A (en) System for converting document into format and automatically establishing database
US20130246425A1 (en) Document visualization system
Hu Research on monitoring system of daily statistical indexes through big data
Mandell et al. Development of a visualization tool for healthcare decision-making using electronic medical records: A systems approach to viewing a patient record
CN112967773A (en) Chronic disease clinical version reporting method and system based on big data sharing platform
CN114706625A (en) Method, device and storage medium for constructing patient information global query plug-in
CN106709246A (en) Kidney disease follow-up visit system
EP3654339A1 (en) Method of classifying medical records
CN111584089A (en) Patient data searching method, device and storage medium
CN112599210B (en) Data management method and device, electronic equipment and storage medium
CN116150475B (en) Information retrieval method, device, electronic equipment and storage medium
Deghmani et al. Applications of Graph Databases and Big Data Technologies in Healthcare
Wang et al. Design and realization of pharmaceutical survey data acquisition and analysis system based on principal component analysis algorithm
Lathrop et al. Medical terminology coding systems and medicolegal death investigation data: Searching for a standardized method of electronic coding at a statewide medical examiner’s office
CN114398407A (en) Case data query method, device, equipment and storage medium
CN116682539A (en) Three-major first-aid center data synchronization method based on configuration
Xin Conception on Public Health Surveillance System Based on Big Data in Health and Medical Care

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
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20200609