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

Abstract

Disclosed is an XML based medical institution database integrated management system.
The XML-based medical institution database integrated management system according to an embodiment of the present invention includes a CDW-based database and a data collection unit that collects web-based structured and unstructured data, and the collected structured and unstructured data is XML-based hypertext language. ETL processing support to convert to XML-based database and convert it to XML, interface part to extract XML-based structured and unstructured data corresponding to user search term, and extracted XML-based structured and unstructured data based on web program or application It includes a visualization support processing unit that converts to a text language and provides it as a screen, so it is possible to construct an XML-based database by converting various structured and unstructured data into big data and converting them into XML (Extensible Markup Language) -based data.

Description

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

The present invention relates to a data integration management system of a medical institution that enables an integrated management of medical information including clinical data by constructing 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) is mainly emerging. Conventional CDW collects medical information and clinical data from a plurality of databases and medical related transaction systems operated in hospitals, clinical pathologies, research institutes, and the like. The collected medical information and clinical data are refined and restructured in the database to support data retrieval, summarization, and analysis stored and shared through the database.

CDW-based databases are mainly built through RDBMS (Relational DataBase Management System). RDBMS supports the representation of data in a two-dimensional table structured in rows and columns, and is provided to handle a large amount of data for a large number of computer systems. This, RDBMS was able to handle a large amount of data compared to a PC database, it was also possible to build an excellent business system in terms of reliability.

Conventional RDBMS manipulates data on the server or database according to data manipulation commands written in Structured Query Language (SQL), and any client can manipulate the data on the server as long as it can send commands such as modification to the server. It was configured to do.

Accordingly, conventional CDW-based databases or servers have been forced to increase the time and cost of data extraction, processing, classification, and analysis. In particular, since the data storage capacity of the database is largely required and all unstructured data needs to be purified and stored as structured data, there are practically unsuitable problems in building big data.

In addition, conventional CDW-based servers or databases had to store tables separately for each data in order to earn a multi-dimensional concept, and accordingly, due to the increase in capacity, serious problems such as data retrieval and slow processing were inevitable.

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

In addition, based on the medical standard information and the classification list of the 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 easily integrated and managed. It is to provide a database integrated management system.

In addition, it provides a database integrated 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.

The XML-based medical institution database integrated management system according to an embodiment of the present invention for achieving the above object is a CDW-based database and a data collection unit for collecting structured and unstructured data based on the web, the collected structured and ETL processing support unit that converts unstructured data into 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 a user search term, and extracted XML-based structured and unstructured It includes a visualization support processing unit that converts data into a text language based on a web program or an application and provides it to a screen.

The data collection unit is a big data collection unit that collects structured and unstructured data related to medical information through web-based sites and applications and homepages of other medical institutions, and collects structured and unstructured data related to medical information from CDW-based databases. RDBMS data collection unit, Web-based site and application, and CDW-based database and other EMR data collection unit to collect EMR data from the database of medical institutions, and Web-based site and application, and CDW-based It includes the EHR data collection unit for collecting EHR data from the database of other medical institutions and databases.

The ETL processing support unit writes at least one index or tag into each of the structured and unstructured data, the EMR data, and the EHR data to facilitate searching and sorting of the structured and unstructured data, EMR data, and EHR data collected by the data collection unit. Therefore, it has the technical characteristics of storing it in an XML-based database.

The XML-based medical institution database integrated management system according to an embodiment of the present invention minimizes storage and management capacity by converting various structured and unstructured data based on the CDW-based database and the web into big data and converting them into XML-based data. It has the effect of building a database.

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

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

In addition, it is possible to improve user satisfaction and reliability by visualizing and expressing medical data stored and managed through various indexes and tags in various forms according to user requests.

1 is a configuration block diagram specifically showing an XML-based medical institution database integrated management system according to an embodiment of the present invention.
FIG. 2 is a diagram illustrating a data processing and management process of the database integrated management system shown in FIG. 1.
FIG. 3 is a diagram for describing 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 the data collection and conversion process of the data collection unit and the ETL processing support unit illustrated in FIG. 1.
FIG. 5 is another diagram for explaining the data collection and conversion process of the data collection unit and the ETL processing support unit illustrated in FIG. 1 step by step.
FIG. 6 is a screen showing an XML processing program of the ETL processing support unit illustrated in FIG. 1.
FIG. 7 is a diagram illustrating a list of index and tag analysis by data of the DB analysis unit shown in FIG. 1.
8 is a diagram illustrating a data display method according to the index and tag analysis results of the visualization processing unit shown in FIG. 1.
9 is another diagram illustrating a data display method according to an index and tag analysis result of the visualization processor illustrated in FIG. 1.

The configurations shown in the embodiments and drawings described in this specification are only one of the most preferred embodiments of the present invention, and do not represent all of the technical spirit of the present invention, and thus can replace them at the time of application. It should be understood that there may be equivalents and variations. In addition, terms to be described later are terms defined in consideration of functions in the present invention, which may vary according to a user's or operator's intention or practice. Therefore, the definition of these terms should be made based on the contents throughout the present specification.

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

1 is a configuration block diagram specifically showing an XML-based medical institution database integrated 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 database integrated management system shown in FIG. 1.

First, referring to FIG. 1, the database integrated 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, a server, and a web-based site. Specifically, the data collection unit 100 may collect a variety of structured and unstructured data related to medical information through a web-based site or application program, and homepages of other medical institutions.

In addition, the data collection unit 100 may collect various structured and unstructured data related to medical information from CDW-based databases and servers and databases of other medical institutions.

The data collection unit 100 is a big data collection unit 110, RDBMS data collection unit 120, EMR data collection unit 130, in order to collect a variety of structured and unstructured data from a database and a web-based server, etc. And it may be configured to include an EHR data collection unit 140.

Thus, the data collection unit 100, through the big data collection unit 110, RDBMS data collection unit 120, EMR data collection unit 130, and EHR data collection unit 140, the structured and unstructured data EMR data (Electronic Medical Record Data) and EHR data (Electronic Health Record Data) are collected and transmitted in real time to the ETL processing support unit 200.

The ETL processing support unit 200 includes structured and unstructured data and EMR 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 that uses W3C (World Wide Web Consortium) standard machine control metadata, and it has a feature that there is no limitation in the use of metadata when using structural languages such as RDB and NoSQL. Accordingly, the ETL processing support unit 200 converts various 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 is structured and unstructured data and EMR to facilitate retrieval and sorting of the structured and unstructured data and EMR data and EHR data collected by the data collection 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, and tag terms included in the preset medical standard information, and ETLs the collected medical terms, office terms, and indexes for medical data. Provided as processing support and XML-based database.

Accordingly, the ETL processing support unit 200 may be configured with the structured and unstructured data according to various classification lists such as a use, a file format, a medical standardization list, a source, and an expiration date that are initially set or provided from the medical standard information support unit 800. The EMR data and EHR data can be indexed and tagged and stored in the XML-based database 300.

Similarly, the XML-based database 300 is initially preset or provided by the medical standard information support unit 800 by matching indexes and tags according to various classification lists such as usage, file format, medical standardization list, source, and expiration date. 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 describing 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 in structured and unstructured data, EMR data, and EHR data, respectively, index and tag classification type, use, and file Data is stored in a variety of classification lists (eg, lists corresponding to indexes and tags) such as format, medical standardization list, source and expiration date.

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

In addition, among the classification list of the XML-based database 300, the unstructured classification list is classified into research search result information, clinical result index, clinical progress indicator, statistical information, medical analysis information, customer description result information, medical record information, and the like. Can be.

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

Meanwhile, the DB analysis unit 400 analyzes the XML-based structured and unstructured data stored in the XML-based database 300 according to analysis lists such as usage, file format, medical standardization list, source and expiration date, and XML-based Extract index and tag contents for structured and unstructured data. Here, the 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 indexes and tag lists for XML-based structured and unstructured data stored in the XML-based database 300 Additionally.

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

Meanwhile, 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 XML-based structured and unstructured data extracted from the interface unit 600 into a text language based on a web program or an application, and performs visualization processing. In addition, 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 the data collection and conversion process of the data collection unit and the ETL processing support unit illustrated in FIG. 1. And, FIG. 5 is another diagram for explaining the data collection and conversion process of the data collection unit and the ETL processing support unit illustrated in FIG. 1 step by step.

4 and 5, the data collection unit 100 through the big data collection unit 110, RDBMS data collection unit 120, EMR data collection unit 130, and EHR data collection unit 140 , Collects the structured and unstructured data, EMR data, and EHR data, and transmits it in real time to the ETL processing support unit 200.

More specifically, the big data collection unit 110 collects structured and unstructured data related to medical information through a web-based site or application, and a homepage of another medical institution.

The big data collection unit 110 collects medical-related structured data and unstructured data as much as possible from a web-based site or application, and a homepage of another medical institution, so that the XML-based database 300 can be converted into big data. It is programmed.

The RDBMS data collection unit 120 collects structured and unstructured data related to medical information from a CDW-based database. Since the CDW-based database is constructed with a relational database management system (RDBMS), the RDBMS data collection unit 120 extracts medical information related data from the database according to a command for data manipulation written in a structured query language (SQL). It is 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, the EMR data is a computerized processing of medical records, and is a data set to be used for remote medical treatment with a computer embedded in the medical device interconnected with a central system.

The EHR data collection unit 140 collects EHR data from a web-based site or application program, a CDW-based database, and a database of another medical institution. The EHR is set to integrate and share electronic medical records of all medical institutions into the network, so the EHR data collection unit 140 is programmed to search for and collect medical related data of patients individually managed by each medical institution. .

The 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, and the EMR data and the EHR data are ETL processed. It is transmitted to the support unit 200.

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

Accordingly, in the XML-based database 300, structured and unstructured data by matching indexes and tags of EMR data and EHR data with classification lists such as usage, file format, medical standardization list, source and expiration date, and structured and unstructured data And EMR data and EHR data.

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

Referring to FIG. 6, the ETL processing support unit 200 compiles a CDW-based programming language into a hypertext machine language containing XML-based metadata and an option tool for setting conversion options, and the like. Includes software.

The ETL processing support unit 200 uses a self-compiled compilation software, and hypertext language including XML-based metadata of EMR data and EHR data and EMR data and CDW-based structured data collected by the data collection unit 100 Convert to

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

FIG. 7 is a diagram illustrating a list of index and tag analysis by 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 analysis lists such as usage, file format, medical standardization list, source, and expiration date. Extract index and tag contents for XML-based structured and unstructured data.

For example, the DB analysis unit 400 may initially set indexes and tags based on exception management history, various report history, user additional setting list, user analysis result list, user department setting history, and user report format content. In addition, additional indexes and tags are 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 high numerical values. do.

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

8 is a diagram illustrating a data display method according to the index and tag analysis results of the visualization processing unit shown in FIG. 1. And, FIG. 9 is another diagram showing 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 are 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.

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

As described above, according to the above, the database integrated management system according to an embodiment of the present invention can store and manage various types of structured and unstructured data based on CDW and web-based data, and convert them into XML-based data. It is possible to build a database with a minimal 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, it is possible to improve user satisfaction and reliability by visualizing and expressing medical data stored and managed through various indexes and tags in various forms according to user requests.

The present invention has been described with reference to the embodiment shown in the drawings, but this is only exemplary, and those skilled in the art to which the art belongs, various modifications and equivalent other embodiments are possible therefrom. Will understand. Therefore, the true technical protection scope of the present invention should be defined by the claims below.

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

Claims (9)

A data collection unit for collecting structured and unstructured data based on a CDW-based database and a web;
An ETL processing support unit that converts the collected structured and unstructured data into an XML-based hypertext generation language and stores it in an XML-based database;
An interface unit for extracting XML-based structured and unstructured data corresponding to a user search term; And
And 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, and provides a screen,
Medical institution database integrated management system.
According to 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 application programs, 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 that collects EMR data from the web-based sites and applications, and CDW-based databases and databases of medical institutions;
Including the web-based site and application, and CDW-based database and EHR data collection unit for collecting EHR data from the database of medical institutions,
Medical institution database integrated management system.
According to claim 2,
The ETL processing support unit
At least one index or tag is assigned to each of the structured and unstructured data and the EMR data and the EHR data to facilitate retrieval and sorting of the structured and unstructured data and the EMR data and the EHR data collected by the data collection unit. Fill in and store in the XML-based database,
Medical institution database integrated management system.
The method of claim 3,
A DB analysis unit that further analyzes XML-based structured and unstructured data stored in the XML-based database according to an analysis list to further extract index and tag contents for the stored XML-based structured and unstructured data; And
Further comprising an index and tag setting support for statistically analyzing the contents of the additionally extracted index and tag to further set the index and tag list for the stored XML-based structured and unstructured data,
Medical institution database integrated management system.
The method of claim 4,
The ETL processing support unit
The additionally set index and tag list is additionally set and classified in the XML-based database, and the additional set and classified tags and indexes are additionally written in the structured and unstructured data, EMR data, and EHR data, and the XML is added. To update the base database,
Medical institution database integrated management system.
According to claim 1,
Further comprising an interface unit for converting a user search term through a web program or application screen into an XML-based hypertext language, and extracting XML-based structured and unstructured data corresponding to the converted search term,
Medical institution database integrated management system.
The method of claim 6,
Further comprising a visualization support processing unit for converting XML-based structured and unstructured data extracted from the interface unit into a text language based on the web program or application, and performing visualization, and providing the visualized graphic on a screen.
Medical institution database integrated management system.
According to claim 1,
Medical terminology, office terminology, index for medical data, tag terminology, etc. included in preset medical standard information are collected and the collected medical terminology, office terminology, medical data index and tag are based on the ETL processing support and the XML Further comprising a medical standard information support unit 800 provided as a database,
Medical institution database integrated management system.
The method of claim 8,
The ETL processing support unit may be structured and unstructured data, EMR data, and EHR data according to at least one classification list that is preset in advance or provided from the medical standard information support unit, a file format, a medical standardization list, a source, and an expiration date. Index and tag the fields and send them to the XML-based database.
The XML-based database matches the indexes and tags written by the ETL processing support unit according to various classification lists such as the purpose, file format, medical standardization list, source, and expiration date, so that the structured and unstructured data, EMR data, and EHR Storing data,
Medical institution database integrated management system.

Images