KR102358038B1 - Database integrated management system of a medical institution based xml - Google Patents

Abstract

An XML-based medical institution database integrated management system is disclosed.
An XML-based integrated medical institution database management system according to an embodiment of the present invention includes a CDW-based database and a data collection unit for collecting web-based structured and unstructured data, and an XML-based hypertext language for the collected structured and unstructured data. ETL processing support unit that converts to XML and stores it in an XML-based database, an interface unit that extracts XML-based structured and unstructured data corresponding to user search terms, and an XML-based structured and unstructured data that is stored in a web program or application-based It includes a visualization support processor that converts text language into a screen and provides it as a screen. By converting various structured and unstructured data into big data and converting it into XML (Extensible Markup Language)-based data, an XML-based database can be built.

Description

XML-based medical institution database integrated management system {DATABASE INTEGRATED MANAGEMENT SYSTEM OF A MEDICAL INSTITUTION BASED XML}

The present invention relates to an integrated data management system of a medical institution that enables the integrated management of medical information including clinical data by establishing an XML (Extensible Markup Language)-based database.

As a database used by medical institutions for the purpose of retrieving medical information, a Clinical Data Warehouse (CDW), etc. is mainly emerging. The conventional CDW collects medical information and clinical data from a plurality of databases and medical-related transaction systems operated in hospitals, clinical pathology, laboratories, and the like. The collected medical information and clinical data are refined and restructured in the database to support data retrieval, summary and analysis, etc. stored and shared through the database.

CDW-based databases are mainly built through RDBMS (Relational DataBase Management System). RDBMS supports to express data in a two-dimensional table structured in rows and columns, and is provided so that many users can handle large amounts of data for large-scale computer systems. This RDBMS can handle a large amount of data compared to a database for PC, and it was possible to build a business system superior in reliability.

Conventional RDBMS manipulates data on the server or database according to commands for data manipulation written in Structured Query Language (SQL). designed to do so.

Accordingly, the conventional CDW-based databases or servers inevitably increase the time and cost required for data extraction, processing, classification, and analysis. In particular, the data storage capacity of the database is greatly required, and all unstructured data had to be stored and used after refining it into structured data, so there were practically unsuitable problems for building big data.

In addition, conventional CDW-based servers or databases had to classify and store tables for each data in order to accumulate a multidimensional concept, and consequently, due to an increase in capacity, serious problems such as a decrease in data retrieval and processing speed were inevitable.

It is an object of the present invention to integrate various structured and unstructured data, including data stored in a CDW-based database, into big data and convert it into XML (Extensible Markup Language)-based data, thereby constructing an XML-based database. to provide a management system.

In addition, based on the classification list of medical standard information and XML-based database, each structured and unstructured data can be classified and managed by various indexes and tags, so that medical-related data can be more easily integrated and managed. It is to provide an integrated database management system.

In addition, it is to provide an integrated database management system that can visualize and express medical-related data classified, stored, and managed by various indexes and tags in various forms according to user requests.

XML-based medical institution database integrated management system according to an embodiment of the present invention for achieving the above object is a data collection unit for collecting CDW-based database and web-based structured and unstructured data, the collected structured and An ETL processing support unit that converts unstructured data into an XML-based hypertext language and stores it in an XML-based database, an interface unit that extracts XML-based structured and unstructured data corresponding to user search terms, and the extracted XML-based structured and unstructured data It includes a visualization support processing unit that converts data into a text language based on a web program or an application program and provides it as a screen.

The data collection unit collects structured and unstructured data related to medical information from the big data collection unit, which collects structured and unstructured data related to medical information through web-based sites and applications, and the homepage of other medical institutions, and a CDW-based database. RDBMS data collection unit that collects EMR data from web-based sites and applications, CDW-based databases and databases of other medical institutions, and web-based sites and applications, and CDW-based It includes an EHR data collection unit that collects EHR data from the database of the hospital and the database of other medical institutions.

The ETL processing support unit writes at least one index or tag to each of the structured and unstructured data, the EMR data, and the EHR data so that the structured and unstructured data, EMR data, and EHR data collected by the data collection unit can be easily searched and sorted Therefore, it has the technical characteristics of storing it in an XML-based database.

The XML-based integrated medical institution database management system according to an embodiment of the present invention converts a CDW-based database and web-based various structured and unstructured data into big data and converts them into XML-based data, thereby minimizing storage and management capacity. This has the effect of building a database.

In addition, by constructing W3C (World Wide Web Consortium) standard medical information such as HL7 (Health Level 7) as an XML format-based database, it is possible to actively respond to international data exchange in the future. Here, since the data format for constructing the database is a standard data format, it is possible to easily achieve an effect of data exchange with other industries other than the medical field.

In addition, each structured and unstructured data is classified by various indexes and tags and stored and managed in a database, so that medical-related data can be more easily integrated and managed using indexes and tags.

In addition, there is an effect of improving user satisfaction and reliability by visualizing and expressing medical-related data stored and managed through various indexes and tags in various forms according to user requests.

1 is a block diagram specifically illustrating an XML-based integrated medical institution database management system according to an embodiment of the present invention.
FIG. 2 is a view for explaining a data processing and management process of the integrated database management system shown in FIG. 1 .
FIG. 3 is a diagram for explaining a data classification and storage path management process of the XML-based database shown in FIG. 1 .
FIG. 4 is a block diagram illustrating step-by-step data collection and conversion processes of the data collection unit and the ETL processing support unit shown in FIG. 1 .
FIG. 5 is another diagram for explaining step-by-step data collection and conversion processing of the data collection unit and the ETL processing support unit shown in FIG. 1 .
FIG. 6 is a screen showing the XML processing program of the ETL processing support unit shown in FIG. 1 .
FIG. 7 is a view showing an index and tag analysis list for each data of the DB analysis unit shown in FIG. 1 .
FIG. 8 is a diagram illustrating a data display method according to an index and tag analysis result of the visualization processing unit shown in FIG. 1 .
FIG. 9 is another diagram illustrating a data display method according to an index and tag analysis result of the visualization processing unit shown in FIG. 1 .

The configuration shown in the embodiments and drawings described in this specification is only one of the most preferred embodiments of the present invention, and does not represent all of the technical spirit of the present invention, so at the time of the present application, various It should be understood that there may be equivalents and variations. In addition, the terms to be described later are terms defined in consideration of functions in the present invention, which may vary according to the intention or custom of the user or operator. Therefore, definitions of these terms should be made based on the content throughout this specification.

Hereinafter, an XML-based integrated medical institution database management system according to an embodiment of the present invention will be described in detail.

1 is a block diagram specifically illustrating an XML-based integrated medical institution database management system according to an embodiment of the present invention. And, FIG. 2 is a diagram for explaining a data processing and management process of the integrated database management system shown in FIG. 1 .

First, referring to FIG. 1 , the integrated database management system includes a data collection unit 100 , an ETL processing support unit 200 , an XML-based database 300 , a DB analysis unit 400 , an index and tag setting support unit 500 , It may be configured to include an interface unit 600 , a visualization support processing unit 700 , and a medical standard information support unit 800 .

The data collection unit 100 collects structured and unstructured data from a CDW (Clinical Data Warehouse)-based database, server, and web-based site. Specifically, the data collection unit 100 may collect various types of structured and unstructured data related to medical information through web-based sites or applications, and homepages of other medical institutions.

Also, the data collection unit 100 may collect various structured and unstructured data related to medical information from a CDW-based database, a server, and databases of other medical institutions.

The data collection unit 100 includes a big data collection unit 110, an RDBMS data collection unit 120, an EMR data collection unit 130, in order to variously collect structured and unstructured data from databases and web-based servers, etc. And it may be configured to include the EHR data collection unit (140).

Accordingly, the data collection unit 100 performs structured and unstructured data and EMR data (Electronic Medical Record Data) and EHR data (Electronic Health Record Data) are collected and transmitted to the ETL processing support unit 200 in real time.

The ETL processing support unit 200 includes EMR and structured and unstructured data collected from the big data collection unit 110 , the RDBMS data collection unit 120 , the EMR data collection unit 130 , and the EHR data collection unit 140 , respectively. Data and EHR data are converted into an XML (Extensible Markup Language)-based hypertext language and stored in the XML-based database 300 .

XML is a computer language using W3C (World Wide Web Consortium) standard machine control metadata. Accordingly, the ETL processing support unit 200 converts various types of structured and unstructured data, EMR data, and EHR data collected by the data collection unit 100 into an XML structure language.

1 and 2 , the ETL processing support unit 200 provides structured and unstructured data and EMR to facilitate searching and sorting of the structured and unstructured data, EMR data, and EHR data collected by the data collecting unit 100 . At least one index or tag is added to each of the data and the EHR data and stored in the XML-based database 300 .

The standard information support unit 800 collects medical terms, office terms, indexes for medical data, tag terms, etc. included in preset medical standard information, and ETL the collected medical terms, office terms, and indexes and tags for medical data. It provides processing support and XML-based database.

Accordingly, the ETL processing support unit 200 is initially set in advance or provided from the medical standard information support unit 800 with structured and unstructured data and Indexes and tags may be written to the EMR data and EHR data and stored in the XML-based database 300 .

Similarly, the XML-based database 300 matches indexes and tags according to various classification lists, such as usage, file format, medical standardization list, source, and expiration date, which are initially preset or provided from the medical standard information support unit 800 . It stores structured and unstructured data, EMR data, and EHR data. The XML-based database 300 will be described in more detail as follows.

FIG. 3 is a diagram for explaining a data classification and storage path management process of the XML-based database shown in FIG. 1 .

As shown in FIG. 3 , the XML-based database 300 corresponds to indexes and tags additionally set and written to structured and unstructured data, EMR data, and EHR data, respectively, index and tag classification types, uses, and files Store data according to various classification lists (eg, indexes and tags-corresponding lists), such as format, medical standardization list, source, and expiration date.

Among the classification lists of the XML-based database 300 , the standardized classification list may be classified into patient information, prescription information, examination result information, medical record information, organization information, revenue information, examination list information, reception information, and the like.

In addition, the atypical classification list among the classification list of the XML-based database 300 is classified into research search result information, clinical result index, clinical progress index, statistical information, medical treatment analysis information, customer explanation result information, medical record information, etc. can be

In this case, the XML-based database 300 may classify indexes and tags to correspond to the standardized classification list and the unstructured classification list, and store structured and unstructured data, EMR data, and EHR data.

On the other hand, the DB analysis unit 400 analyzes the XML-based structured and unstructured data stored in the XML-based database 300 according to the analysis list such as use, file format, medical standardization list, source and expiration date, and Extracts index and tag contents for structured and unstructured data. Here, index and tag contents for the extracted structured and unstructured data are supplied to the index and tag setting support unit 500 .

The index and tag setting support unit 500 statistically analyzes the contents of the index and tag extracted from the DB analysis unit 400 , and lists the index and tag for XML-based structured and unstructured data stored in the XML-based database 300 . set additionally.

The ETL processing support unit 200 adds a classification list by additionally setting the index and tag list additionally set in the index and tag setting support unit 500 to the XML-based database 300 , and the format collected by the data collection unit 100 . And it is possible to write additionally set and classified tags and indexes to unstructured data, EMR data, and EHR data.

On the other hand, the interface unit 600 converts a user search term through a web program or application program screen into an XML-based hypertext language, and extracts XML-based structured and unstructured data corresponding to the converted search term.

Accordingly, the visualization support processing unit 700 converts the XML-based structured and unstructured data extracted from the interface unit 600 into a text language based on a web program or an application program and performs visualization processing. Then, the visualized graphic is provided to the user through a web program or an application screen.

FIG. 4 is a block diagram illustrating step-by-step data collection and conversion processes of the data collection unit and the ETL processing support unit shown in FIG. 1 . And, FIG. 5 is another diagram for explaining step by step the data collection and conversion processing of the data collection unit and the ETL processing support unit shown in FIG. 1 .

4 and 5 , the data collection unit 100 is a big data collection unit 110 , an RDBMS data collection unit 120 , an EMR data collection unit 130 , and an EHR data collection unit 140 through the , structured and unstructured data, EMR data, and EHR data are collected and transmitted to the ETL processing support unit 200 in real time.

More specifically, the big data collection unit 110 collects structured and unstructured data related to medical information through web-based sites or applications, and homepages of other medical institutions.

The big data collection unit 110 collects medical-related structured data and unstructured data as much as possible from web-based sites or applications, and homepages of other medical institutions, so that the XML-based database 300 can be converted into big data. programmed

The RDBMS data collection unit 120 collects structured and unstructured data related to medical information from a CDW-based database. The CDW-based database is built with RDBMS (Relational DataBase Management System), and the RDBMS data collection unit 120 extracts medical information-related data from the database according to a data manipulation command written in structured query language (SQL). programmed

The EMR data collection unit 130 collects EMR data from web-based sites or applications, CDW-based databases, and databases of other medical institutions. Here, EMR data is a computerized medical record task, and is data set so that a computer built in a medical device is interconnected with a central system and is used for telemedicine.

The EHR data collection unit 140 collects EHR data from web-based sites or applications, CDW-based databases, and databases of other medical institutions. EHR is set so that the electronic medical records of all medical institutions can be shared and utilized by integrating them into a network, and the EHR data collection unit 140 is programmed to search and collect the patient's treatment-related data managed individually by each medical institution. .

The structured and unstructured data and EMR data and EHR data collected by the big data collection unit 110 , the RDBMS data collection unit 120 , the EMR data collection unit 130 , and the EHR data collection unit 140, respectively, are subjected to ETL processing It is transmitted to the support unit 200 .

Accordingly, the ETL processing support unit 200 sets, as indexes and tags, various classification lists such as usage, file format, medical standardization list, source and validity period, which are initially preset or provided from the medical standard information support unit 800 . Then, at least one index or tag is written in each of the structured and unstructured data, EMR data, and EHR data collected by the data collection unit 100 , and transmitted to the XML-based database 300 .

Accordingly, in the XML-based database 300, a classification list such as usage, file format, medical standardization list, source and expiration date, and indexes and tags of structured and unstructured data and EMR data and EHR data are matched to obtain structured and unstructured data. and EMR data and EHR data are stored.

FIG. 6 is a screen showing the XML processing program of the ETL processing support unit shown in FIG. 1 .

Referring to FIG. 6 , the ETL processing support unit 200 includes a compilation program that converts CDW-based programming languages into a hypertext machine language including XML-based metadata and an option tool that can set conversion options. includes software.

The ETL processing support unit 200 uses self-configured compilation software to convert the CDW-based structured and unstructured data, EMR data, and EHR data collected by the data collection unit 100 into a hypertext language including XML-based metadata. convert to

In addition, the ETL processing support unit 200 writes at least one index or tag in each of the structured and unstructured data, EMR data, and EHR data converted into the XML-based text language, and transmits it to the XML-based database 300 .

FIG. 7 is a view showing an index and tag analysis list for each data of the DB analysis unit shown in FIG. 1 .

Referring to FIG. 7 , the DB analysis unit 400 analyzes XML-based structured and unstructured data stored in the XML-based database 300 according to an analysis list such as use, file format, medical standardization list, source, and expiration date. Extracts index and tag contents for XML-based structured and unstructured data.

For example, the DB analysis unit 400 includes indexes and tags initially set based on exception management details, various report details, user addition setting list, user analysis result list, user's department setting history, and user's report format contents, etc. In addition, other indexes and tags are additionally extracted.

Accordingly, the index and tag setting support unit 500 statistically analyzes the contents of the index and tag additionally extracted from the DB analysis unit 400, and additionally sets the index and tag list for indexes and tags with statistically high numerical values. do.

When the index and tag list is additionally set in the index and tag setting support unit 500, the ETL processing support unit 200 is an XML-based database 300 according to the index and tag list additionally set in the index and tag setting support unit 500 The classification list of ' is additionally set and classified. In addition, the ETL processing support unit 200 may additionally write additionally set and classified tags and indexes to the structured and unstructured data, EMR data, and EHR data collected by the data collection unit 100 . Accordingly, indexes, tags, and classification lists applied to structured and unstructured data, EMR data, and EHR data may be automatically updated in real time according to the amount of data stored.

FIG. 8 is a diagram illustrating a data display method according to an index and tag analysis result of the visualization processing unit shown in FIG. 1 . And, FIG. 9 is another diagram illustrating a data display method according to the index and tag analysis results of the visualization processing unit shown in FIG. 1 .

As described above, the CDW-based programming languages and the hypertext language including XML-based metadata are different programming languages. In particular, languages applied to web programs or application programs are CDW-based programming languages.

Accordingly, the interface unit 600 converts a CDW-based user search term through a web program or application program screen into an XML-based hypertext generation language. Then, XML-based structured and unstructured data is extracted from the XML-based database 300 according to the index and tag corresponding to the converted search term. The extracted XML-based structured and unstructured data is transmitted to the visualization support processing unit 700 .

As shown in FIGS. 8 and 9 , the visualization support processing unit 700 compiles the XML-based structured and unstructured data extracted from the interface unit 600 into a web program or application program-based CDW text language to a preset graphic format. Visualize according to In addition, graphic information in the formatted visualization is provided to the user through a web program or application program screen.

As described above, the integrated database management system according to an embodiment of the present invention converts a CDW-based database and web-based various structured and unstructured data into big data and converts them into XML-based data, thereby storing and managing them. It becomes possible to build a database in a form that minimizes the capacity.

In addition, by allowing each structured and unstructured data to be stored and managed in a database through various indexes and tags, medical-related data can be more easily integrated and managed through indexes and tags.

In addition, there is an effect of improving user satisfaction and reliability by visualizing and expressing medical-related data stored and managed through various indexes and tags in various forms according to user requests.

Although the present invention has been described with reference to the embodiments shown in the drawings, this is merely exemplary, and those of ordinary skill in the art to which various modifications and equivalent other embodiments are possible. will understand Accordingly, the true technical protection scope of the present invention should be defined by the following claims.

100: data collection unit
200: ETL processing support department
300: XML-based database
400: DB analysis unit
500: Index and Tag Setup Support Department
600: interface unit
700: visualization support processing unit
800: Medical Standards Information Support Department

Claims (9)

a data collection unit that collects CDW-based database and web-based structured and unstructured data;
XML-based structured and unstructured data is generated by converting the collected structured and unstructured data into an XML-based hypertext generation language, and indexes and tags to the XML-based structured and unstructured data according to an initially preset classification list ETL processing support unit to write and store in an XML-based database;
an interface unit for extracting XML-based structured and unstructured data corresponding to user search terms;
a visualization support processing unit that converts the extracted XML-based structured and unstructured data into a text language based on a web program or an application program and provides a screen;
a DB analysis unit that analyzes the XML-based structured and unstructured data stored in the XML-based database according to an analysis list to extract additional indexes and tags for the XML-based structured and unstructured data; and
and an index and tag setting support unit that statistically analyzes the additional index and tag to update the classification list and the index and tag for the XML-based structured and unstructured data,
The ETL processing support unit,
To update the XML-based database by additionally writing the updated classification list, index, and tag to the XML-based structured and unstructured data by the index and tag setting support unit,
The classification list includes at least one of a use, a file format, a medical standardization list, a source, and an expiration date, and includes patient information, prescription information, test result information, medical record information, organization information, revenue information, It includes at least one of checklist information and reception information, and the unstructured classification list includes at least one of research search result information, clinical outcome indicator, clinical progress indicator, statistical information, treatment analysis information, customer description result information, and medical record information. is set to contain one,
The analysis list is set to include at least one of exception management details, various report details, user addition setting list, user analysis result list, user department setting details, and user report format contents,
A database integrated management system for medical institutions.
The method of claim 1,
The data collection unit
a big data collection unit that collects structured and unstructured data related to medical information through web-based sites and applications, and homepages of medical institutions;
an RDBMS data collection unit that collects structured and unstructured data related to medical information from a CDW-based database;
an EMR data collection unit for collecting EMR data from the web-based site and application program, CDW-based database, and database of medical institutions;
Including an EHR data collection unit that collects EHR data from the web-based site and application program, and a CDW-based database and a database of medical institutions,
A database integrated management system for medical institutions.
3. The method of claim 2,
The ETL processing support unit
At least one index or tag is added to each of the structured and unstructured data, the EMR data, and the EHR data to facilitate retrieval and sorting of the structured and unstructured data, the EMR data, and the EHR data collected by the data collection unit. written and stored in the XML-based database,
A database integrated management system for medical institutions.
delete delete The method of claim 1,
The interface unit converts a user search term through a web program or application screen into an XML-based hypertext language, and extracts XML-based structured and unstructured data corresponding to the converted search term,
A database integrated management system for medical institutions.
7. The method of claim 6,
Further comprising a visualization support processing unit that converts the XML-based structured and unstructured data extracted from the interface unit into a text language based on the web program or application program to perform visualization processing, and provides the visualized graphic on a screen,
A database integrated management system for medical institutions.
The method of claim 1,
Medical terms, office terms, indexes for medical data, tag terms, etc. included in preset medical standard information are collected, and the collected medical terms, office terms, and indexes and tags for medical data are stored in the ETL processing support unit and the XML-based Further comprising a medical standard information support unit 800 provided as a database,
A database integrated management system for medical institutions.
9. The method of claim 8,
The ETL processing support unit writes indexes and tags on structured and unstructured data, EMR data, and EHR data according to the classification list that is initially preset or provided from the medical standard information support unit, and transmits it to an XML-based database,
The XML-based database stores the structured and unstructured data, EMR data, and EHR data by matching the tag and the index written in the ETL processing support unit according to the classification list,
A database integrated management system for medical institutions.

Images