JP2000293599A - Medical information filing system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To realize a medical information filing system capable of storing/ managing much data so as to easily retrieve them without requiring enormous cost and reducing performance. SOLUTION: Data for classifying medical information in details and setting tags are restricted to basic data such as patient attribute consisting of the name, sex, age, etc., of a patient, disease history having a time base such as an examination date and insurance information from a prescribed period lowering importance as data for medical action and detailed data of a prescription, diagnosis/observation, treatment, injection, inspection, operation, anesthesia, nursing, rehabilitation, the progress of hospitalization, the recording of a temperature board or the like, guide books, medical information, accounting information, etc., except the basic data are recorded in a recorder of a computer as text data to which tags are not set in a file of each patient. In the case of retrieving the detailed data, the whole text data in the file are retrieved by text retrieving software.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a medical information filing system for converting medical information relating to medical treatment into electronic information using a computer, and storing and managing the medical information in a searchable state.

[0002]

2. Description of the Related Art In recent years, a so-called electronic medical record system, in which various medical information is converted into electronic information using a computer, has been receiving attention. Data such as medical information that has been accumulated over a long period of time has been attracting attention. 2. Description of the Related Art A database system is used to store and manage systematically excellent searchability. In this medical information database system, a method is adopted in which the structure of data to be used is finely classified and a tag as an identification code is set for each type of data.

[0003]

In order to structure medical information into a database that is easy to use and excellent in searchability, it is necessary to subdivide the items for setting tags. It is not easy to simply subdivide the items because the medical records are enormous and the medical records also have free descriptions such as memos and diagrams.

Further, since such medical information is continuously accumulated and stored for a long period of time, the amount of information increases linearly with the accumulation of new data. It is possible to cope with such an increase in the amount of information by sequentially increasing the storage capacity of the system. However, in practice, not only the increase in the amount of information but also the items for which tags need to be set are gradually reduced. It is increasing. Since the combination of searches between tags with the increase in the number of items becomes a power and increases exponentially, the performance of the search system is inevitably reduced.

[0005] That is, when the values of all data are almost equal, although the performance of the system can be satisfied even if the performance is reduced to some extent, most of the data relating to medical treatments involve time-series changes. As shown in FIG. 4, there is a gradient in the value of data in which the value of the latest data is always high (the frequency of use is high) and the old data is low in the value (frequency of use is low). In view of this, it can be said that the performance of the retrieval system is reduced due to the presence of a large amount of infrequently used data, which lacks validity as a system.

In order to avoid the situation where the database system reaches the saturation point in this way, it is actually necessary to replace the entire hardware system before that, but all the data accumulated so far is continued to the new system. This is difficult in terms of system performance and the cost and effort of data conversion, and if the database system itself is renewed, data conversion may be difficult in terms of data compatibility. Was.

Therefore, it has been considered as a practical method to divide the entire database every several years and to manage each of them independently as a practical method. This is performed in accordance with the above-mentioned system update / replacement timing. is there. However, in this method, as shown in FIG. 5, the data of each partitioned database system is independent and discontinuous, that is, the currently operating database system is used to replace the past data in other systems. There was a problem that it could not be searched. Further, the conventional medical information search / management system functions as the entire database as shown in FIG. 6, so that even if only a small part of the database is damaged, the entire system is controlled as shown in FIG. There was a possibility that it would be impossible.

In order to solve these problems, the present invention provides a medical information filing system that stores and manages a large amount of data for a long period of time without causing significant cost and reducing performance. It is an object of the present invention to realize a medical information filing system capable of storing and managing a large amount of data with excellent searchability.

[0009]

In order to achieve the above object, a medical information filing system according to the present invention is a medical information filing system which stores and manages medical information relating to medical treatment as computerized electronic data using a computer. In the system, the data managed by the database system by classifying medical information finely and setting a tag as a control code, the patient's name, gender and birth date from a predetermined time when the importance is reduced as data in medical practice. Patient attributes such as date and allergy history, patient consultation such as past visits of past departments and hospitalization of sickness, patient disease name and disease name such as main disease name, secondary disease name and insurance disease name, patient insurance information and insurance information, etc. Restriction to basic data and prescriptions, findings, treatments, injections, examinations, surgery, anesthesia, nursing, rehabilitation, Elapsed, the temperature plate such as a recording and guidance document,
Detailed data such as medical information, accounting information, etc. are recorded as text data without setting the tag in a recording device of a computer as a file for each patient. It is characterized by performing full-text search on data.

[0010] Alternatively, in a medical information filing system that stores and manages medical information relating to medical treatment as computerized data using a computer, the medical information is finely classified and a tag as a control code is set to set a database system. From the specified time when the data managed in the above becomes less important as data in medical practice, patient attributes such as patient's name, gender, date of birth and allergy history, patient's past visits to various departments, hospitalized bloat etc. Limited to basic data such as patient consultation, patient's disease name / disease name such as primary disease name, secondary disease name and insurance disease name, patient insurance information / insurance
In addition to the basic data, the tag is set for detailed data such as prescription, finding, treatment, injection, examination, surgery, anesthesia, nursing, rehabilitation, hospitalization progress, temperature plate etc. record and instruction book, medical information, accounting information etc. Not only as text data but also recorded in a recording device of a computer as a department file for each medical department, and when searching for the detailed data, full-text search is performed on the text data in the file using text search software. Is what you do.

[0011] Further, the present invention is characterized in that the predetermined time is set to a relatively short time, such as when the calendar year changes after more than one year from the first consultation of the patient.

[0012] Further, the present invention is characterized in that the predetermined time is a time when the hospitalized patient is discharged from the hospital.

Further, in each file in which the detailed data is recorded as text data, a page is set for each type of the detailed data.

[0014]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS The medical information filing system of the present invention has the disadvantage that a conventional database system for managing medical information processes all data as equal value data without weighting. This has been devised in order to improve the situation in which the performance of the system is degraded or the entire system has to be replaced at a great cost.

In other words, taking into account the fact that newer data has a higher weight in medical treatment as shown in the graph of FIG. 4, the medical information filing system of the present invention provides For a predetermined period limited to a relatively short period, such as one year or two years, data relating to patients is of high importance, and as shown in FIG. 1, tags are set for data relating to patients and stored using a database system. -It is in a state where it can be managed and data can be exchanged with individual files such as medical information, order information, test results, reports, medical records, etc.

[0016] Starting from the time when the patient who has been hospitalized and receiving medical treatment is discharged, one year or two years after the initial medical examination
Since the data of patients whose age has passed is judged to be of low importance, the minimum basic data such as patient attributes such as name, gender and age, illness information, insurance information, etc. in the patient data are not changed. Detailed data such as prescriptions, findings, treatments, injections, examinations, surgery, anesthesia, nursing, rehabilitation, hospitalization progress, temperature plate and other records and guidance books, medical information, accounting information, etc. 2, as shown in FIG. 2, the data is taken out of the database system, transferred to a recording device of a computer and recorded as text data without setting a tag.

When the detailed data is recorded as text data, processing the data apart from the patient attributes is limited to exceptional statistical processing. From the point of view of emphasis, rather than being bundled with the above-described detailed data, all data is recorded as belonging to the patient in a file for each patient, that is, an electronic medical record in the original sense.
For example, even in the case of medical information created for each disease name, data is all distributed to each patient and transferred to a file for each patient. Then, data is sequentially transferred from the database system with the passage of time, and these data are always added as a time series after the original data, so that the data is always maintained as a file for each single patient.

More specifically, there are records such as prescriptions, findings, treatments, injections, examinations, surgery, anesthesia, nursing, rehabilitation, hospitalization progress, and temperature plates, which are information described in individual medical records other than the basic data. Detailed data that is subordinate medical information such as instruction manuals, medical information, accounting information, clinical chemistry test data, various reports, etc. is set as pages for each type and recorded as time-series data in a file for each patient. Thereby, it is possible to refer to the information without inconvenience even if it is not structured as in a database system. This can be said to be a form similar to the current situation in which a doctor's description, a temperature plate, a nursing record, a medical certificate, and the like are bound to a medical record after discharge from the hospital and managed as a single file. However,
When extracting the detailed data from the database system and recording it as text data in a file for each patient, it is more efficient to use a method of allocating each type of detailed data to a corresponding page.

When a department ledger is required for each medical department, as shown in FIG. 3, a department-based file server for managing department-based data is provided separately from the patient-based file server. A file is created and recorded as time-series data.

The time for transferring the detailed data from the database system is limited to a relatively short period, such as when the calendar year changes more than one year from the first consultation because the calendar year is easy to manage. It is determined that storing and managing the medical information of this year and last year in the database system is sufficient. Thus, for example, if the period is limited when the calendar year changes more than one year from the first consultation, all patient data is stored in the database system.
The shortest period to be managed is one year and one day, and the longest period is one year and 365 days.
Becomes That is, a batch process for transferring data from the database system to a file for each patient is performed at the beginning of January every year.

Extracting the above detailed data from a running database system and transferring it to a recording device of a computer as text data without setting a tag means recording the data in a discontinuous manner. One of the features of the present invention is to set the discontinuity point at a relatively early and appropriate time. In other words, while the database system is used during the period in which favorable searchability is required, the discharge of the patient is regarded as the discontinuous point in the hospitalization work, and the calendar year after one year from the first consultation in the outpatient work. The discontinuous point is a relatively short period of time, for example, when is changed.

When retrieving detailed data, a patient is specified, and text data recorded in a file of the patient is converted to text data using, for example, an operation system, word processing software, an editor or the like. And do a full-text search.

For example, when searching for a patient who has developed a rash during the course of the treatment using the drug A, a full-text search is performed using a search term called the drug A, and the patients are listed. At the same time, a full-text search is performed for the search term rash to list the patients. Then, a desired list can be obtained by taking the difference set between the set of patients listed by the search term A medicine and the set of patients listed by the search term rash.

[0024]

As described above in detail, according to the present invention, in a medical information filing system for storing and managing a large amount of data over a long period of time, the performance is reduced without requiring a large cost. Large amounts of data can be stored and managed with excellent searchability without the need. As a result, the performance of the system is degraded due to the waste of the conventional database system for managing medical information processing all data as equal-value data without weighting, and the cost of the system is high. Thus, the situation in which the entire system must be replaced is improved.

Further, by setting a page for each type of detailed data in each file in which detailed data is recorded as text data, it is possible to refer to the file without inconvenience even if it is not structured as in a database system.

[Brief description of the drawings]

FIG. 1 is an explanatory diagram showing a system during management by a database according to the present invention.

FIG. 2 is an explanatory diagram showing a chart system separated from management in a database according to the present invention.

FIG. 3 is an explanatory diagram showing a department register system separated from management in a database according to the present invention.

FIG. 4 is an explanatory diagram showing the correlation between the value of data in medical information and the passage of time.

FIG. 5 is an explanatory diagram showing a conventional system managed by a database.

FIG. 6 is an explanatory diagram showing a conventional system managed by a database.

FIG. 7 is an explanatory diagram showing a conventional system managed by a database.

Claims (5)

[Claims] 1. A medical information filing system for storing and managing medical information relating to medical care as computerized data using a computer, wherein the medical information is finely classified and a tag as a control code is set to set a database system. From the specified time when the data managed in the above becomes less important as data in medical practice, patient attributes such as patient's name, gender, date of birth and allergy history, patient's past visits to various departments, hospitalized bloat etc. Limited to basic data such as patient consultation, patient's disease name / disease name such as primary disease name, secondary disease name and insurance disease name, patient insurance information / insurance
In addition to the basic data, detailed tags such as prescriptions, findings, treatments, injections, examinations, surgery, anesthesia, nursing, rehabilitation, hospitalization progress, temperature plate and other records and instruction books, medical information, accounting information, etc., set the above tags. Medical information characterized in that the text data is recorded as a file for each patient in a recording device of a computer as a text data, and the text data in the file is searched by a full-text search software using text search software when searching for the detailed data Filing system. 2. A medical information filing system that stores and manages medical information related to medical care as computerized data using a computer. In a medical information filing system, the medical information is finely classified, and a tag as a control code is set. From the specified time when the data managed in the above becomes less important as data in medical practice, patient attributes such as patient's name, gender, date of birth and allergy history, patient's past visits to various departments, hospitalized bloat etc. Limited to basic data such as patient consultation, patient's disease name / disease name such as primary disease name, secondary disease name and insurance disease name, patient insurance information / insurance
In addition to the basic data, detailed tags such as prescriptions, findings, treatments, injections, examinations, surgery, anesthesia, nursing, rehabilitation, hospitalization progress, temperature plate and other records and instruction books, medical information, accounting information, etc., set the above tags. Not only as text data but also recorded in a recording device of a computer as a department file for each medical department, and when searching for the detailed data, full-text search is performed on the text data in the file using text search software. Medical information filing system. 3. The medical information filing system according to claim 1, wherein the predetermined time is set to a relatively short time, such as when the calendar year has changed after more than one year from the first consultation of the patient. 4. The medical information filing system according to claim 1, wherein the predetermined time is a time when the hospitalized patient is discharged. 5. The medical information filing system according to claim 1, wherein a page is set for each type of the detailed data in each file in which the detailed data is recorded as text data. .