KR20080090792A - Method of managing database for electronic medical record and database thereof - Google Patents

Abstract

A method for managing a medical record database and the database thereof are provided to enable a user to directly manage the medical record database based on a row base data structure applying an attribute value structure in an EMR(Electronic Medical Record) system. A user terminal displays a medical record including different items according to each medical record and registered to an attribute value structure database storing a value of each item(200). The requested item is added to the medical record when a request for adding the item to the displayed medical record is received from the user terminal(204). The requested item is deleted from the medical record when the request for deleting the item from the displayed medical record is received from the user terminal. A value of each item included in the medical record is received from the user terminal and the received value of each item is stored to the database(208).

Description

Method of managing database of medical record information and its database {Method of managing database for Electronic Medical Record and database

1 is a diagram showing the structure of a conventional medical record information database.

2 is a diagram showing the structure of a medical record information database of the present invention.

3A to 3C (hereinafter, referred to as FIG. 3) show additional information according to a preferred embodiment of the present invention.

4 is a block diagram of a medical record information database management system according to a preferred embodiment of the present invention.

5 is a flow chart of a medical record information database management method according to a preferred embodiment of the present invention.

6 to 11 illustrate examples of screen display in a user terminal according to an exemplary embodiment of the present invention.

The present invention relates to an electronic medical record system, and more particularly, to a method for managing a medical record information database of the electronic medical record system and a database accordingly.

In the Electronic Medical Record (EMR) system, there are between 1500 and 4000 forms of forms, and tens of thousands of items of medical record information that make up the form.

As a database for such medical record information, a method of constructing a table having a plurality of items in a relational database management system (RDBMS) and recording medical record information corresponding to the items is employed.

Referring to FIG. 1, which illustrates an exemplary implementation of a patient information database, the patient information table includes a key item (KEY) for distinguishing patients, a patient name item (PT_NAME), a gender item (PT_SEX), and an age item. (PT_AGE), a resident registration number item (PT_REGISTRYNO), etc. are provided, and the data for each patient is recorded for each item of the patient information table. In other words, in the patient information of a patient named Kim Ah-mu, 1 is inputted in the key item KEY, Kim Ah-myeon in the name item PT_NAME, male in the gender item PT_SEX, 21 years old in the age item PT_AGE, social security number item Data such as 970105-1234567 is recorded in (PT_REGISTRYNO).

As described above, as items of data about a patient are written and stored in a predetermined table, it is not easy to change or delete the items of the table.

That is, when additional items are needed for only one patient according to the characteristics of the patient, the corresponding items are added to all patients, and thus the efficiency of the patient information table may be reduced.

In addition, since the modification of the table must be carried out by an expert with database expertise, easy management of the database is a big problem in an electronic medical record system environment that changes frequently due to user needs and the development of medical knowledge. It is becoming.

The present invention is to solve the above-mentioned problems of the prior art, the medical record information database management method and a database according to which the user can directly manage the medical record information database based on the low-base data structure applying the attribute value structure To provide that purpose.

The method of managing a medical record information database according to the present invention for solving the above-described problems of the prior art includes an attribute value having different items for each medical record information, and corresponding values are stored correspondingly. Displaying any medical record information registered in the database of the structure through the user terminal; Adding the requested item to the medical record information when the item is requested to the displayed medical record information through the user terminal; If the deletion of the item is requested to the displayed medical record information through the user terminal, it characterized in that it comprises the step of deleting the requested item for the medical record information.

In addition, the medical record information database according to the present invention is characterized in that a different value is provided for each medical record information, and an attribute value structure in which a value for each item is correspondingly stored.

The present invention provides a database based on a row base data structure using an attribute value structure.

A patient information table constructed of the attribute value structure according to the present invention described above will be described with reference to FIG.

The patient information table is composed of key items, attributes, values, and additional information. The key items are used to distinguish patients, and different key values are assigned to the patients. Each patient information is provided with a plurality of different attributes, and each of the plurality of attributes stores corresponding values and additional information of each value.

As described above, the present invention facilitates the addition and deletion of items according to the attribute information structure. For example, when the address item (PT_ADDRESS) is to be added to the first patient information, it is only necessary to add the address item as an attribute and the address information and the additional information of the address information as the attribute to the first patient information. For example, modification of the database structure as a whole is unnecessary.

Additional information provided to apply the attribute value structure to the medical record information is shown in FIG. 3.

The form item name indicates the name of each form item.

The item control type is a factor for determining which form item is to be represented. The item control type is an element for determining whether the item is to be displayed over several lines or determined by a list of certain items. The above item control types include MTEXT, TEXT, IMEGE, MCHECK, MRADIO, CHECK, and COMBO. The MTEXT represents a multi-line text form, the TEXT represents a short text form, the IMEGE represents a form that can hold an image, the MCHECK represents a form that can contain multiple check boxes, and the MRADIO can contain a radio button. CHECK represents a form that can contain a single check box, and COMBO represents a form that can contain values in a list form.

The default value of the item control is basic values that the item control type can have, and the content of the item control value is determined by the value of the item.

More specifically, {DIAGNOSE} in MTEXT is used to record coronary control, {OP / PROCEDURE} is used to record surgical control, {MEDICATION} is used to record oral medication control, and {INJECTION} Is used when recording the injection control, {SYMPTON} is used when recording the symptom related control, and blank space is used when recording the free text in the form of multi-line.

In addition, ##. ## of TEXT is a mask for inputting time-related information, ####-####-#### is a mask for inputting a telephone number, and other input values are input by a user. It is a selectable input type, and a blank space is used to record short free text.

IMAGE is used when an item needs to handle content in the form of an image rather than text. Here, the image storing method of the medical record information shows an image creation control that displays a body part of the human body as a sketch on the screen, and stores it when the specific part is displayed or entered as text. Here, the entire stored image is displayed as it is or in the form of a thumb nail.

In addition, the additional item refers to the data type of the item for defining the type of data, the size of the item for defining the size of the number when the data type is a number, the basic unit for defining the basic unit of the item, and the item. Value, an item's reference value to show a reference value for this item, an item's quality control value for symptom or progress management, an item's order to determine the order in which it appears on the screen, and the date the item was created. The date of creation to manage the item, the creation time to manage the time the item was created, and the remarks, which are items to be used when the item wants to contain certain notices or contents that need attention, Format codes, and indents between items to indicate high and low relationships between items. It is hereinafter.

Now, a configuration of a medical record information database management system that enables a user to directly manage a medical record information database based on a low base data structure according to the present invention as described above will be described with reference to FIG. 4.

The server 100 adds and deletes medical information of the medical record information database stored in the database 102 according to a request of any one of the plurality of user terminals 104 and 106 according to the database management service according to the preferred embodiment of the present invention. To implement the modifications.

The tool for the database management service is provided through a plurality of user terminals (104, 106) installed in the server 100 in the case of a large hospital as shown in Figure 4 and connected through a network, or in a small hospital It can be installed directly to add, delete, modify the mandatory information, which will be apparent to those skilled in the art by the present invention.

A medical record information database management method according to a preferred embodiment of the present invention will be described with reference to FIG.

The server 100 displays a medical record information management window when any one of the user terminals 104 and 106 approaches any medical record information (step 200). Referring to FIG. 6, which shows an example of the medical record information management window, the medical record information illustrated in FIG. 6 is patient information, and a plurality of attributes such as a diagnosis name and a date for the patient and a value for each item. (value) and additional information. The additional information may include an input type and a basic input value.

After the medical record information management window is displayed, the server 100 checks whether an item for corresponding medical record information is requested through the user terminal (step 202).

When an item addition is requested through the user terminal, the server 100 checks whether an item is added according to any one of adding an item directly or adding an item using a medical record item tab, and adds an item according to the result. (Step 204).

<Adding items manually>

First, a method of directly adding an item will be described in detail with reference to FIG. 7.

When the user clicks the right button on the medical record information management window through the user terminal, the server 100 is the right side such as cut, copy, insert one line, insert multiple lines, delete as shown in FIG. Button Function Displays the menu. If one or multiple lines of the menu are selected, the server 100 inserts one or several lines into the corresponding medical record information management window as shown in (b) of FIG. 7, and the item of the inserted line. An item is added to the corresponding medical record information by receiving an item in an input field and an additional information in an additional information input field through a user terminal.

<Adding Items Using the Medical Record Items Tab>

And it will be described in detail with reference to Figure 8 for adding an item using the medical record item tab.

When the user selects a position to insert a new item in the medical record information management window through the user terminal as shown in FIG. 8 (a), and clicks a preset medical record item tab, the server 100 ) Indicates medical record items as shown in (b) of FIG. 8, and when the user selects any one of the displayed medical record items through the user terminal, the server 100 displays (FIG. As shown in c), the corresponding item is inserted at the selected position.

After inserting the item, the server 100 receives the additional information through the user terminal in the additional information input field of the item, and adds the item to the medical record information.

In addition, when the user instructs a value to be input in a slip method while displaying the medical record information management window, the server 100 receives and stores the value in the sleep method (steps 206 and 208).

Here, the slip method will be described with reference to FIG. 9.

When the user clicks the value portion of any one item as shown in (a) of FIG. 9 through the user terminal, the server 100 displays a list of various values for each code as shown in (b) of FIG. do. When the user selects a value, the server 100 stores the selected value in the value part of the corresponding item as shown in FIG. 9C.

In addition, when the user clicks the right button to activate the right button menu and executes the right button menu while displaying the medical record information management window, the server 100 performs an operation according to the menu (steps 210 and 212). The right button menu includes a cut, a copy, a paste, a single line insert, a multiline insert, and a delete.

Herein, copying or deleting using the right button menu is performed for all parts displayed in the medical record information management window, and only a copy and deletion function for the following items will be described in detail.

<Copy>

First, the copy function of the item will be described in detail with reference to FIG. When the user drags or selects an item in the medical record information management window through the user terminal and clicks the right button, as shown in FIG. 10A, the server 100 displays the figure. As shown in 10 (b), the right button function menu such as cut, copy, paste, single line insert, multi line insert, delete, etc. is displayed. When the copy button of the menu is clicked, the server 100 temporarily stores the selected item. Thereafter, the user selects any item of the medical record information management window as shown in FIG. 10C, clicks the right button to display the right button function menu, and then clicks the paste menu as shown in FIG. 10D. As shown in (e) of FIG. 10, the server 100 copies the temporarily stored item to a corresponding location.

<Delete>

The deleting function of the item will be described in detail with reference to FIG. When the user selects any item of the medical record information management window and clicks the right button, the server 100 displays the user terminal of FIG. 10 through the user terminal. As in (b), the right button function menu such as cut, copy, paste, single line insert, multiline insert, delete, etc. is displayed. When the delete button of the menu is clicked, the server 100 deletes the selected item as shown in FIG.

As described above, the present invention enables a user to directly manage a medical record information database based on a low base data structure, thereby managing the database in an electronic medical record system environment that is frequently changed due to user's needs and the development of medical knowledge. Make it easy.

In addition, the present invention enables the addition and deletion of items for each medical information, thereby enabling efficient management of the database.

As described above, the present invention enables a user to directly manage a medical record information database based on a low base data structure, thereby managing the database in an electronic medical record system environment that is frequently changed by user's needs and medical knowledge. There is an advantage to facilitate this.

In addition, the present invention has the advantage of enabling the efficient management of the database by enabling the addition and deletion of items for each medical information.

As described above, the present invention has been described by way of limited embodiments and drawings, but the present invention is not limited to the above-described embodiments, which can be variously modified and modified by those skilled in the art to which the present invention pertains. Modifications are possible.

Accordingly, the spirit of the present invention should be understood only by the claims set forth below, and all equivalent or equivalent modifications thereof will belong to the scope of the present invention.

Claims (8)

In the management method of medical record information database, Displaying one medical record information registered in a database having an attribute value structure in which different items are provided for each medical record information and corresponding values are stored correspondingly; Adding the requested item to the medical record information when the item is requested to the displayed medical record information through the user terminal; Deleting an item requested for the medical record information if the item is requested to be displayed on the displayed medical record information through the user terminal; Management method of medical record information database comprising a. The method of claim 1, The addition request of the item is directly input through the user terminal, The medical record information database management method according to claim 1, wherein any one of the items is selected and input. The method of claim 1, In the medical record information registered in the database, additional information defining characteristics of a value for the item is stored corresponding to each item, And the additional information is selectively input through the user terminal. The method of claim 1, And receiving and storing a value for each item in the medical record information registered in the database through the user terminal. The method of claim 1, The medical record information database management method further comprising the step of selecting and storing any one of a plurality of values guided by code through the user terminal in the medical record information registered in the database. . The method according to claim 1 or 3, And said item, said value and said additional information are copied, cut, deleted and pasted through said user terminal. In the medical record information database, A database having an attribute value structure in which different items are provided for each medical record information and corresponding values are stored correspondingly. The method of claim 7, wherein And additional information defining characteristics of a value for each of a plurality of items included in the medical record information is stored corresponding to each item.

Images