WO2008123718A1

WO2008123718A1 - Method of managing database for electronic medical record and database thereof

Info

Publication number: WO2008123718A1
Application number: PCT/KR2008/001939
Authority: WO
Inventors: Yoon-Nyun Kim; Jin-Sang Kim; Do-Hyoung Kim
Original assignee: Md Ware Co., Ltd.
Priority date: 2007-04-06
Filing date: 2008-04-04
Publication date: 2008-10-16
Also published as: KR100928401B1; KR20080090792A

Abstract

The present invention relates to a method for managing a medical record information database comprising steps of: displaying a medical record information registered in a database through a user terminal, the database including different item s according to the medical record information and having an attribute value structure having stored therein a value for each of the item s to correspond thereto; when an item addition is requested to the medical record information displayed through the user terminal, adding the requested item to a corresponding medical record information; and when an item deletion is requested to the medical record information displayed through the user terminal, deleting the requested item to a corresponding medical record information.

Description

[DESCRIPTION]

[Invention Title]

METHOD OF MANAGING DATABASE FOR ELECTRONIC MEDICAL RECORD AND DATABASE THEREOF

[Technical Field]

The present invention relates to an electronic medical record system, and in particular to a medical record information database and a method for managing the same in the electronic medical record system.

[Background Art]

The number of types of a document form in an EMR (Electronic Medical Record) system ranges from 1500 to 4000, and the number of item s of a medical record information constituting the document form ranges up to tens of thousands. As for a database for the medical record information, a method is employed wherein a table including a plurality of item s is configured in an RDBMS (Relational Database Management System) and the medical record information is recorded to correspond to the item .

Referring to Fig. 1 exemplifying an embodiment of a conventional patient information database, a patient information table includes a plurality of item s such as a key item KEY, a name item of a patient FT_NAME, a gender item PT_SEX, an age item PT_AGE and a registration number item PTJREGISTRYNO for distinguishing patients, and a data for each of the patients is recorded for each of the item s of the patient information table. That is, in a patient information of the patient named John Doe, 1 is inputted for the key item KEY, John Doe is inputted for the name item of the patient PT_NAME, male is inputted for the gender item PT_SEX, 21 is inputted for the age item PT_AGE, and 970105-1234567 is inputted for the registration number item PT_REGISTRYNO. In accordance with conventional database, since the data is recorded and stored in the table having the predetermined item s, changing or deleting the item of the table is not facile.

That is, when an additional item is required for a certain patient according to a characteristic of the patient, the additional item is added for an entirety of the patients. Therefore, an efficiency of the patient information table is degraded.

Moreover, since changing and deleting of the table should be carried out by an expert having an expert knowledge of the database, a facile management of the database in an environment of the EMR system changing frequently due to a request of a user and a development of a medical knowledge is required.

[Disclosure]

[Technical Problem]

It is an object of the present invention to provide a medical record information database and a method for managing the same wherein a user may directly manage the medical record information database based on a raw base data structure having an attribute value structure applied thereto.

[Technical Solution]

In order to achieve above-described object of the present invention, there is provided a method for managing medical record information database, the method comprising steps of: displaying a medical record information registered in a database through a user terminal, the database including different item s according to the medical record information and having an attribute value structure having stored therein a value for each of the item s to correspond thereto! when an item addition is requested to the medical record information displayed through the user terminal, adding the requested item to a corresponding medical record information! and when an item deletion is requested to the medical record information displayed through the user terminal, deleting the requested item to a corresponding medical record information.

There is also provided a medical record information database including different item s according to a medical record information and having an attribute value structure having stored therein a value for each of the item s to correspond thereto.

The present invention provides a medical record information database based on a raw base data structure having an attribute value structure applied thereto.

[Advantageous Effects]

The present invention is advantageous in that the management of the database in the environment of the EMR system changing frequently due to the request of the user and the development of a medical knowledge is facilitated by allowing the user to manage the medical record information database based on the raw base data structure.

The present invention is also advantageous in that the addition and the deletion of the item according to the medical information are possible to enable an efficient management of the database.

[Description of Drawings]

Fig. 1 is a diagram illustrating a structure of a conventional medical record information database.

Fig. 2 is a diagram illustrating a structure of a medical record information database in accordance with the present invention.

Figs. 3 through 5 are diagrams illustrating an additional information in accordance with preferred embodiment of the present invention. Fig. 6 is a diagram illustrating a configuration of a medical record information database management system in accordance with a preferred embodiment of the present invention.

Fig. 7 is a flow diagram illustrating a method for managing a medical record information database in accordance with a preferred embodiment of the present invention.

Figs.8 through 13 are diagrams illustrating examples of screen display in a user terminal in accordance with a preferred embodiment of the present invention. [Best Mode]

A patient information table having an attribute value structure in accordance with the present invention is described with reference to Fig. 2. The patient information table includes a key item , an attribute, a value and an additional information. The key item is for distinguishing a patient, wherein a different key value is assigned to each patient. In addition, the corresponding value and the additional information for the corresponding value are stored in each attribute to correspond thereto. In accordance with the present invention, an addition and a deletion of the item is facilitated by configuring a patient information as the attribute value structure. For instance, when a address item PT_ADDRESS is to be added to a first patient information, only the address item which is the attribute of the first patient information, an address information which is the value for the corresponding attribute and the additional information of the address information are required to be added. Therefore, a modification such as a transformation of an overall structure of the database is not required. The additional information in order to apply the attribute value structure to a medical record information is shown in Figs. 3 through 5. A form item name represents a name of each form item . In addition, an item adjustment format is an element for determining in what format each form item is displayed such as a format wherein each form item is displayed in multiple lines, or each form item is displayed in a list of predetermined item s, meaning an adjustment format of the item . The item adjustment format includes MTEXT, TEXT, IMEGE, MCHECK, MRADIO, CHECK and COMBO. MTEXT represents multiple line text, TEXT represents a short text, IMEGE represents a format wherein in an image may be contained, MCHECK represents a format wherein in multiple check boxes may be contained, MRADIO represents a format wherein in a radio button may be contained, CHECK represents a format wherein in a check box may be contained, and COMBO represents a format wherein in a value may be contained in a form of a list. An item adjustment default value is default values of the item adjustment format wherein a content to be recorded in the value of the item is determined by the value of this item .

Specifically, {DIAGNOSE} of MTEXT is used to record a diagnose-related control, {OP/PROCEDURE} is used to record an operation/treatment control, {MEDICATION} is used to record an internal/external medicine control, {INJECTION} is used to record an injection control, {SYMPTON} is used to record a symptom-related control, and a blank space is used to record a free text in a multi-line format.

In addition, ##.## of TEXT is a mask for inputting a time-related information, ####-####-#### is a mask for inputting a telephone number, other input value is an input format that may be selected by a user, and the blank space is used to record a short free text .

IMAGE is used to process a content in an image format other than a text format. Here, a method for storing an image of the medical record information is carried out by displaying an image creation control that displays a human body part as a background image on a screen and stores the image when a certain human body part is displayed or inputted by a text. An entirety of the stored image is displayed as is or as a thumbnail. Moreover, the additional filed includes a data format of the item for defining a type of the data, a size of the item for defining a magnitude of a number when the data format is the number, a basic unit for defining the basic unit of the item , a reference value of the item for displaying the reference value when the item has the reference value, a degree management value of the item for managing a symptom or a progress state, an order of the item which is a value for determining an order according to which the item is displayed, a date of creation for managing a date on which the item is created, a time of creation for managing a time at which the item is created, a remark which is the item to be used for a certain notice or a warning, a form code for managing to which form the item belongs, and indents between the item s for displaying a higher order and a lower order between the item s. A configuration of a medical record information database management system wherein a user may directly manage a medical record information database based on a raw base data in accordance with the present invention is described with reference to Fig. 6.

A server 100 adds, deletes and modifies a medical information in the medical record information database stored in a database 102 according to a request from one of a plurality of user terminals 104 and 106 in accordance with a database management service of a preferred embodiment of the present invent ion.

A tool for the database management service may be installed in the server 100 in a large hospital to be provided to the plurality of user terminals 104 and 106 connected via a network as shown in Fig. 6, or may be installed in the user terminal in a small hospital to add, delete and modify the medical information, which is obvious to those skilled in the art.

A method for managing a medical record information database in accordance with a preferred embodiment of the present invention is described with reference to Fig. 7.

When one of the plurality of user terminals 104 and 106 accesses the medical record information, the server 100 displays a medical record information management window (step 200). Referring to Fig.8 illustrating an example of the medical record information management window, the medical record information exemplified in Fig, 8, which is a patient information, includes a plurality of item s such as a diagnosis of a corresponding patient and the date, value for each item and the additional information. The additional information may include an input format and a default input value.

After displaying the medical record information management window, the server

100 checks whether an addition of the item for the corresponding medical record information is requested through the user terminal (step 202).

When the addition of the item for the corresponding medical record information is requested through the user terminal, the server 100 checks which one of adding the item directly and adding the item using a medical record item tab" is selected, and carries out adding the item according to the selection (step 204).

Adding the item directly is described with reference to Fig. 9.

When a user clicks a right button on the medical record information management window through the user terminal, the server 100 displays a right button menu such as cut, copy, insert a line, insert multiple lines and delete as shown in Fig. 9(a). When insert a line or insert multiple lines is selected from the menu, the server 100 inserts one line or multiple lines in the corresponding medical record information management window, and receives the item for an input item of the inserted line and the additional information for the additional information item through the user terminal to add the item to the corresponding medical record information.

Adding the item using the medical record item tab is described with reference to Fig. 10.

When the user selects a position for inserting a new item in the medical record information management window through the user terminal as shown in

Fig. 10(a), and clicks a medical record item tab of a predetermined medical record, the server 100 displays the medical record item as shown in Fig.

10(b). Thereafter, when the user selects one of the displayed medical record item s, the server 100 inserts the corresponding item into the selected position as shown in Fig. 10(c).

After the insertion of the item , the server 100 receives the additional information for the additional information input for the corresponding item to add the item to the medical record information.

In addition, when the user commands an input of the value via a slip scheme during the display of the medical record information management window, the server 100 receives and saves the value via the slip scheme (steps 206 and

208).

The slip scheme is described with reference to Fig. 11.

When the user clicks the value of one item through the user terminal as shown in Fig. ll(a), the server 100 displays a list for various values according to the code as shown in Fig. 10(b). When the user selects one of the various values, the server 100 records and stores the selected value in the corresponding item s as shown in Fig. ll(c). In addition, when the user activates and executes the right button menu by clicking the right button during the display of the medical record information management window, the server 100 carries out an operation according to corresponding menu (steps 210 and 212). The right button menu includes cut, copy, paste, insert a line, insert multiple lines and delete. Here, copy operation or delete operation using the right button menu is carried out for an entirety of portions displayed in the medical record information management window. Copy operation and delete operation of the item are described in detail below. <Coρy operation> The copy operation of the item is described in detail with reference to Fig.

12. When the user drags or selects one of the item s in the medical record information management window and clicks the right button as shown in Fig. 12(a), the server 100 displays the right button menu such as cut, copy, paste, insert a line, insert multiple lines and delete as shown in Fig. 12(b). When the copy button of the menu is clicked, the server 100 temporarily stores the selected item . Thereafter, when the user clicks the paste menu after selecting one of the item s by clicking the right button to display the right button menu as shown in Fig. 12(c), the server 100 copies the temporarily stored item to the corresponding position as shown in Fig. 12(e).

The delete operation of the item is described in detail with reference to Fig.

13. When the user selects one of the item and clicks the right button as shown in Fig. 13(a), the server 100 displays the right button menu such as cut, copy, paste, insert a line, insert multiple lines and delete as shown in Fig. 13(b). When the delete button of the menu is clicked, the server 100 deletes the selected item as shown in Fig. 13(c). [Industrial Applicability]

As described above, in accordance with the present invention, the management of the database in the environment of the EMR system changing frequently due to the request of the user and the development of a medical knowledge is facilitated by allowing the user to manage the medical record information database based on the raw base data structure.

In addition, in accordance with the present invention, the addition and the deletion of the item according to the medical information are possible to enable an efficient management of the database.

Accordingly, the present invention provides an improved environment of the EMR system and contributes to the development of a medical industry. While the present invention has been particularly shown and described with reference to the preferred embodiment thereof and drawings, it will be understood by those skilled in the art that various changes in form and details may be effected therein without departing from the spirit and scope of the invention as defined by the appended claims.

Claims

[CLAIMS]

[Claim 1]

A method for managing medical record information database, the method comprising steps of: displaying a medical record information registered in a database through a user terminal, the database including different item s according to the medical record information and having an attribute value structure having stored therein a value for each of the item s to correspond thereto; When an item addition is requested to the medical record information displayed through the user terminal, adding the requested item to a corresponding medical record information; and

When an item deletion is requested to the medical record information displayed through the user terminal, deleting the requested item to a corresponding medical record information.

[Claim 2]

The method in accordance with claim 1, wherein the request for the item addition is inputted through user terminal directly, or is inputted by selecting one of the item s in a displayed list.

[Claim 3]

The method in accordance with claim 1, wherein an additional information defining a characteristic of the value for the item is stored in the medical record information registered in the database to correspond to each of the item s, and the additional information is selectively inputted through the user terminal

[Claim 4]

The method in accordance with claim 1, further comprising receiving and storing the value for each of the item in the medical record information registered in the database.

[Claim 5]

The method in accordance with claim 1, further comprising selecting and storing one of a plurality of values displayed according to a code through the user terminal as the value for each of the item s of the medical record information registered in the database.

[Claim 6]

The method in accordance with one of claims 1 or 3, wherein the item , the value and the additional information is copied, cut, deleted and pasted through the user terminal.

[Claim 7]

A medical record information database including different item s according to a medical record information and having an attribute value structure having stored therein a value for each of the item s to correspond thereto.

[Claim 8]

The database in accordance with claim 7, wherein an additional information defining a characteristic of the value for the item included in the medical record information is stored to correspond to each of the item s.