JP5419590B2 - Medical information system and control program thereof - Google Patents

Description

  The present invention relates to a medical information system and a control program thereof, and more particularly to a medical information system and a control program thereof that suitably determine performance degradation.

  Conventionally, a medical diagnostic apparatus as disclosed in Patent Document 1 has been proposed. This medical diagnostic device records the adjustment date and time of each function of the medical diagnostic device and the use date and time of a predetermined operation (such as calibration), and displays a message indicating that no adjustment has been made when the predetermined time has elapsed. is there.

  Also, an image management system as disclosed in Patent Document 2 has been proposed. This image management system recognizes deterioration of image quality at an early stage by using a database that continuously stores the operating status of medical image equipment and a failure cause analysis database, and issues a response to investigate the cause of image quality deterioration in a short time. That's it.

JP 2008-220396 A JP 2005-205193 A

  By the way, in a medical information system such as a medical diagnostic device, there is a problem that a long-term use causes a deviation between the originally designed data model and the actual data, so that proper performance cannot be maintained. there were.

  Therefore, in order to find aged deterioration, the test patient's data conditions are the same as the actual data and a test is performed to determine whether there is an abnormality (performance deterioration). I can't.

  In addition, if the test is performed only under suitable conditions, there will be no time restriction, but the actual data is often different from the pre-designed data model. Absent.

  This invention is made | formed in view of such a condition, The objective is to provide the medical information system which can determine performance degradation suitably, and its control program.

The medical data system having a database for storing and managing medical data in the first aspect of the present invention is characterized in that the medical data affecting the speed of data access among the medical data managed in the database. Data model storage means for storing characteristic values related to the data model, data distribution calculation means for calculating the characteristic values of medical data corresponding to the data model as data distributions, data model characteristic values, and data distribution calculation means A data distribution difference calculating unit that calculates a difference in characteristic values of the medical data that has been obtained, and a performance determining unit that determines performance based on the difference calculated by the data distribution difference calculating unit.

According to a fourth aspect of the present invention, there is provided a database for storing and managing medical data, and a characteristic value relating to the medical data that affects a data access speed among the medical data managed in the database. A data distribution calculating step of calculating a characteristic value of medical data corresponding to the data model as a data distribution in a computer included in a medical information system having a data model storage means for storing as a model, a characteristic value of the data model, and a data distribution Performing a data distribution difference calculating step for calculating a difference between the characteristic values of the medical data calculated in the calculating step, and a performance determining step for determining performance based on the difference calculated in the data distribution difference calculating step. It is.

  According to the present invention, it is possible to suitably determine performance degradation by calculating the difference between the data model and the actual data.

It is a figure which shows the structural example of the medical information system to which this invention is applied. It is a block diagram which shows the function structural example of HIS. A configuration example of the database managed by DBMS is shown. It is a figure which shows the example of information of the characteristic value of the data model memorize | stored in a data model memory | storage part. It is a figure which shows the example of information of the data distribution calculated in a data distribution calculation part. It is a figure which shows the example of information of the data distribution difference calculated in a data distribution difference calculation part. It is a flowchart explaining aged deterioration determination processing.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.

  FIG. 1 is a diagram showing a configuration example of a medical information system to which the present invention is applied. In this medical information system, HIS (Hospital Information System) 1, RIS (Radiology Information System) 2, DICOM (Digital Imaging and Communication in Medicine) server 3, medical image photographing device 4, and medical image observing device 5 are connected to a network. 6 are connected to each other.

  The medical information system referred to in this embodiment is a computer used in a medical institution such as HIS1, RIS2, DICOM server 3, medical image photographing device 4, and medical image observation device 5 as shown in FIG. Here, in particular, it means a device in which a database management system (DBMS) is mounted.

  The HIS 1 is a hospital information management system that comprehensively manages office information in a hospital. For example, the HIS 1 manages patient consultation information, medical record information, examination result information, accounting information, and the like using a DBMS.

  RIS2 is a radiation department information management system that comprehensively manages medical information in the radiation department. For example, RIS2 manages the contents of radiation inspection orders, schedules, and inspection execution records using DBMS in cooperation with HIS1.

  The DICOM server 3 has a DBMS installed therein and stores image data in accordance with the DICOM standard.

  The medical image photographing apparatus 4 includes an X-ray apparatus, a CT (Computed Tomography) apparatus, an MRI (Magnetic Resonance Imaging) apparatus, and an ultrasonic apparatus. The medical image photographing device 4 includes a DBMS therein and stores photographed image data. The image data stored in the medical image capturing apparatus 4 is temporary, and the DICOM server 3 and the like outside the medical image capturing apparatus 4 are used for long-term storage.

  The medical image observation apparatus 5 does not have a DBMS installed therein, and displays image data received from the DICOM server 3 or the medical image photographing apparatus 4.

  The HIS 1 to the medical image observation apparatus 5 are a main storage device (for example, HDD (Hard Disc Drive)) that stores a program and data necessary for the program processing, and a CPU (Central Processing) that performs arithmetic processing based on the program and data. A computer including a unit (ROM), a read only memory (ROM), and a random access memory (RAM).

  The network 6 may be a wired network or a wireless network such as a public network, a local area network, a network such as the Internet, or a digital satellite broadcast.

  FIG. 2 is a block diagram illustrating a functional configuration example of the HIS 1. At least a part of the functional units shown in FIG. 2 is implemented by the DBMS 12, the aging detection unit 13, and the GUI (Graphical User Interface) control unit 14 by executing the aging detection application by the program control unit 11. Is done.

  The program control unit 11 issues a command for starting each functional unit of the aging deterioration detection unit 13. The program control unit 11 controls the GUI function of the GUI control unit 14.

  The DBMS 12 is medical data such as patient information, insurance information, consultation information, medical record information, medical record item information, sample order information, rehabilitation order information, prescription order information, order item master, and medical record item master according to a relational model or object model. Are stored in a database and managed.

  FIG. 3 shows a configuration example of a database managed by the DBMS 12.

  In the “patient information” data table 12a, fields of patient ID, name, date of birth, telephone number, and address are set. A primary key is defined for the patient ID. The primary key is for uniquely identifying the stored record.

  In the “insurance information” data table 12b, fields of patient ID, insurance sequence number, insurance type, insured number, insurer number, and expiration date are set. A primary key is defined for the patient ID and the insurance sequence number. When uniqueness in a single field cannot be guaranteed as in the data table 12b, two or more fields can be assigned as primary keys. The patient ID is also a foreign key (FK), and the primary key of the reference table is defined. That is, the patient ID refers to the “patient information” data table 12a.

  In the “visit information” data table 12c, fields of a patient ID, a visit number, a visit date, and a department are set. A primary key is defined for the patient ID and the consultation number. An external key (FK) is also defined in the patient ID, and the “patient information” data table 12a is referred to.

  In the data table 12d of “medical record information”, fields of a medical record number, a patient ID, a consultation number, and a confirmed status are set. A primary key is defined for the chart number. An external key is defined for the patient ID and the consultation number, and the “table information” data table 12c is referred to.

  In the data table 12e of the “medical record item master”, fields of a medical record item ID, a medical record item name, a medical record item type, and an item data type are set. A primary key is defined for the chart item ID.

  In the “table chart item information” data table 12 f, chart number, item number, chart item ID, and item data fields are defined. A primary key is defined for the chart number and the item number. A foreign key is defined in the chart number, and the data table 12d of “chart information” is referred to. Also, an external key is defined for the chart item ID, and the data table 12e of the “chart item master” is referred to.

  In the “order item master” data table 12g, fields of order item ID, order item name, order item type, and item data type are set. A primary key is defined for the order item ID.

  In the “sample order information” data table 12h, fields of a chart number, an order item number, an order item ID, a quantity, a request format, an order status, a request date, and an execution date are set. A primary key is defined for the chart number and the order item number. A foreign key is defined in the chart number, and the data table 12d of “chart information” is referred to. Also, an external key is defined for the order item ID, and the data table 12g of “order item master” is referred to.

  In the “rehabilitation order information” data table 12i, fields of a chart number, an order item number, an order item ID, an execution period start, an execution period end, an execution count, an order status, a request date, and an execution date are set. . A primary key is defined for the chart number and the order item number. A foreign key is defined in the chart number, and the data table 12d of “chart information” is referred to. Also, an external key is defined for the order item ID, and the data table 12g of “order item master” is referred to.

  In the “prescription order information” data table 12j, fields of a chart number, an order item number, an order item ID, a quantity, an order status, a request date, and an execution date are set. A primary key is defined for the chart number and the order item number. A foreign key is defined in the chart number, and the data table 12d of “chart information” is referred to. Also, an external key is defined for the order item ID, and the data table 12g of “order item master” is referred to.

  As described above, the DBMS 12 manages various data tables. Although FIG. 3 shows a configuration example of a database using a relational model, a database according to an object model may be used.

  Access to the database managed by the DBMS 12 is performed via an application program. The application program accesses the DBMS 12 by a data acquisition command such as SQL, which is a relational database language, and acquires data. Note that data acquisition may be performed not only by SQL but also by a data access method provided by each DBMS.

  Returning to the description of FIG. When the DBMS 12 receives a data acquisition command from the application program, the DBMS 12 analyzes the command and dynamically determines and executes an optimal data acquisition algorithm. The data acquisition method is determined based on, for example, the join order of the target tables, the join algorithm, the presence / absence of the used index, and the index type. As these determination methods, for example, there are a method of determining based on a SQL description method according to a predetermined rule, and a method of determining in consideration of data distribution characteristics of a search target table. In general, it is said that a method of determining in consideration of the data distribution characteristics of the search target table can acquire data at a higher speed.

  The aged deterioration detection unit 13 includes a data model storage unit 13a, a data distribution calculation unit 13b, a data distribution difference calculation unit 13c, and a performance determination unit 13d, and is activated by an instruction from the program control unit 11. This activation command is received by the data distribution difference calculation unit 13c.

  When a plurality of DBMSs are installed in the HIS 1, only specific DBMSs can be detected by including identification information for designating specific DBMSs in the startup command. Further, by specifying one or more target table names, only the specified table can be set as a detection target. As a result, it is possible to reduce the processing time and CPU load necessary for determining aging degradation.

  The data model storage unit 13a stores, as a data model, characteristic values of the data table that affects the data access speed among the data tables managed by the DBMS 12. Data access includes data retrieval, data registration, and data update.

  The data model storage unit 13a may store at least one data model assumed at the time of design. However, by storing a plurality of data models, the determination process in the performance determination unit 13d described later is performed with higher accuracy. It is preferable to store a plurality of data models.

  For example, as a plurality of data models, a data model assuming 10 specimen order items per visit, a data model assuming 100 specimen orders per visit, and the like are conceivable. As a data model, the number of data items and the cardinality of data may be used as data model characteristic values, but the data model is not limited thereto.

  FIG. 4 shows an example of information on characteristic values of the data model stored in the data model storage unit 13a.

  “10,000” is stored as the characteristic value in the “standard-type small-scale” data model in the “table chart” data table, and “10,000” is stored as the characteristic value in the “rehabilitation-type small-scale” data model. Has been.

  In the “rehabilitation order information” data table, the “standard type small” data model stores “1,000” as the characteristic value, and the “rehabilitation type small” data model has “300,000” as the characteristic value. It is remembered.

  The “standard type small” data model in the “prescription order information” data table stores “30,000” as the characteristic value, and the “rehabilitation type small” data model has “1,000” as the characteristic value. It is remembered.

  The “standard small scale” data model in the “sample order information” data table stores “500” as the characteristic value, and the “rehabilitation type small” data model has “500” as the characteristic value. It is remembered.

  The data model storage unit 13a returns the stored data model information in response to a request from the data distribution difference calculation unit 13c. The request from the data distribution difference calculation unit 13c includes at least one of a number for identifying the data model, a characteristic value of the data model, and a range of the characteristic value of the data model.

  The data distribution calculation unit 13b acquires a data table defined by the data model as an evaluation item from the data distribution difference calculation unit 13c. In response to a request from the data distribution difference calculation unit 13c, the data distribution calculation unit 13b searches actual data corresponding to the acquired evaluation item from the database of the DBMS 12, and calculates the characteristic value as a data distribution. This calculation process may be executed in advance every predetermined time (for example, every month), stored in the database of the DBMS 12, and read.

  FIG. 5 shows an example of data distribution information calculated by the data distribution calculation unit 13b.

  In the example shown in FIG. 5, “1,000” is calculated as the actual data characteristic value corresponding to the evaluation item “chart information”, and “100” is the actual data characteristic value corresponding to the evaluation item “rehabilitation order information”. Is calculated, "3,000" is calculated as the characteristic value of the actual data corresponding to the evaluation item of "prescription order information", and "50" is calculated as the characteristic value of the actual data corresponding to the evaluation item of "specimen order information" Has been.

  The data distribution difference calculation unit 13c requests to return information on the data model stored in the data model storage unit 13a. The data distribution difference calculation unit 13c requests the data distribution calculation unit 13b to calculate the characteristic value of the actual data corresponding to the evaluation item (data table) defined in the data model as the data distribution.

  The data distribution difference calculation unit 13c calculates a difference between the characteristic value included in the data model information returned from the data model storage unit 13a and the characteristic value of the actual data calculated by the data distribution calculation unit 13b.

  For example, the data distribution difference calculation unit 13c prepares to calculate differences for all evaluation items, but the value of the evaluation item of the data model stored in the data model storage unit 13a and the data distribution calculation unit 13b When the difference between the characteristic values obtained from the above becomes larger than the preset value, it is immediately determined that there is a difference in the data distribution, and the difference is not calculated for the subsequent evaluation items. .

  In the case of the difference calculation method described above, the processing time can be shortened. However, since it cannot be said that the characteristics of the entire determination target are evaluated, the accuracy of performance determination by the performance determination unit 13d described later is reduced. there's a possibility that. Therefore, as another difference calculation method, the evaluation items may be weighted in advance, the data distribution difference may be calculated for all the evaluation items, and the sum of the differences may be determined.

  FIG. 6 shows an example of data distribution difference information calculated by the data distribution difference calculation unit 13c.

  In the example shown in FIG. 6, “9,000” is calculated as the difference between the characteristic value of the “standard small scale” data model and the actual data in the evaluation item of “medical chart information”, and the evaluation of “rehabilitation order information” “900” is calculated as the difference between the characteristic value of the “standard small scale” data model and the characteristic value of the actual data in the item, and the characteristics of the “standard small scale” data model in the evaluation item of “prescription order information” “27,000” is calculated as the difference between the actual value and the actual data characteristic value, and “650” is the difference between the characteristic value of the “standard-type small-scale” data model and the actual data characteristic value in the evaluation item of “sample order information” Is calculated.

  The data distribution difference calculation unit 13c supplies a difference calculation result between the characteristic value of the data model and the characteristic value of the actual data to the performance determination unit 13d. The calculation result includes, for example, the following information, and any one of the information (1) to (5) is supplied to the performance determination unit 13d.

(1) The difference between the data model characteristic value and the actual data characteristic value and the identification information of the applied data model (2) The difference between the data model characteristic value and the actual data characteristic value is determined according to the type of the data model characteristic value Weighted value and identification information of the applied data model (3) Data obtained by classifying and pricing the difference between the data model characteristic value and the actual data characteristic value according to a predefined threshold, and applied data Model identification information (4) Real data characteristic value calculated by the data distribution calculation unit 13b, and applied data model identification information (5) Real data characteristic value calculated by the data distribution calculation unit 13b, And the data model characteristic value of the applied data model. The performance determination unit 13d performs data modeling based on the calculation result supplied from the data distribution difference calculation unit 13c. It is determined whether the data model stored in the data storage unit 13a is appropriate, and the determination result is supplied to the GUI control unit 14.

  For example, when the performance determination unit 13d acquires, as the calculation result, information as illustrated in FIG. 6 that is the difference between the data model characteristic value (1) and the actual data characteristic value described above, the applied data model Since the number of data items is smaller than that and the data distribution ratio (medical record information: rehabilitation order information: prescription order information: sample order information) is also equivalent to the applied data model, it is determined that the applied data model is appropriate.

  The data distribution ratio may be determined based on a predetermined rule.

  For example, the number of data items is divided by the number of records in the medical record information, and if the difference from the original ratio is within ± 30%, it is determined that the data distribution ratio is equivalent to the applied data model.

  Also, for example, divide the number of data by the number of records, calculate the distance of each data model, and if the distance matches the data model with the smallest distance, the data distribution ratio is equivalent to the applicable data model It is judged that. In this case, since the determination result including information about what the appropriate data model is can be supplied to the GUI control unit 14, the convenience is further improved.

  The GUI control unit 14 displays a message indicating that the applied data model is appropriate or inappropriate on a display device (not shown) based on the performance determination result supplied from the performance determination unit 13d. Let The GUI control unit 14 also displays a GUI that provides an operation method for updating the application data model together with a message that the application data model is inappropriate.

  In the functional configuration example illustrated in FIG. 2, the aging deterioration detection unit 13 is provided inside the HIS 1. However, the present invention is not limited thereto, and may be provided outside the HIS 1.

  In addition, as the data model characteristic value, the number of data registered in the data table has been described as an example. However, the data model characteristic value is not limited to this, and the data cardinality, the average value of the data size of each column, and the DBMS 12 are managed. The disk storage area information of the database may be included in the characteristic value.

  Next, the aged deterioration determination process executed by the HIS 1 will be described with reference to the flowchart of FIG.

  In step S1, the data distribution difference calculation unit 13c acquires the characteristic value of the data model from the data model storage unit 13a. Thereby, for example, a data model characteristic value as shown in FIG. 4 is acquired.

  Further, the data distribution difference calculation unit 13c requests the data distribution calculation unit 13b to calculate the characteristic value of the actual data corresponding to the evaluation item defined in the data model as the data distribution.

  In step S2, the data distribution calculation unit 13b acquires a data table defined by the data model as an evaluation item from the data distribution difference calculation unit 13c. Thereby, for example, evaluation items of “medical chart information”, “rehabilitation order information”, “prescription order information”, and “specimen order information” are acquired.

  In step S3, the data distribution calculation unit 13b searches the database of the DBMS 12 for actual data corresponding to the evaluation item acquired in the process of step S2, and calculates the characteristic value as a data distribution. Thereby, for example, a data distribution as shown in FIG. 5 is calculated.

  In step S4, the data distribution difference calculation unit 13c calculates a difference between the data model characteristic value acquired in the process of step S1 and the characteristic value of the actual data calculated by the data distribution calculation unit 13b in the process of step S3. To do. Thereby, for example, the difference as shown in FIG. 6 is calculated.

  In step S5, the performance determination unit 13d determines whether or not the applied model is appropriate from the difference between the data model characteristic value and the actual data characteristic value, which is the calculation result obtained in step S4.

  In the example illustrated in FIG. 6, the number of data is smaller than that of the applied data model and the data distribution ratio is equal to that of the applied data model. Therefore, it is determined that the applied model is appropriate.

  On the other hand, when there are more actual data than the applied data model, or when the difference between the data distribution ratio and the applied data model ratio exceeds the specified value, the applied data model Is determined to be inappropriate.

  In step S6, the performance determination unit 13d causes the display device to display a message indicating appropriateness or inappropriateness based on the determination result obtained in step S5. When it is determined that the application data model is inappropriate, a GUI that provides an operation method for updating the application data model is displayed on the display device together with a message that the application data model is inappropriate.

  As described above, in order to determine performance degradation, a data table that affects the data access speed is extracted as an evaluation item, and the difference between the data model characteristic value of the evaluation item and the actual data characteristic value is calculated. As a result, it is possible to determine the performance deterioration more suitably without time restrictions.

  Therefore, when it is determined that the actual data distribution is different from the data model assumed at the time of design, the performance is deteriorated, that is, the DBMS 12 uses an unexpected data acquisition algorithm and the data acquisition performance. Is judged to have decreased. In such a case, updating may be performed so that a new data model is applied in accordance with the GUI displayed on the display device.

  In the above description, the HIS 1 has been described as an example. Of course, the present invention can also be applied to the RIS 2, the DICOM server 3, the medical image photographing device 4, and the like.

  The present invention is not limited to the above-described embodiment as it is, and in the implementation stage, the component may be modified and embodied without departing from the spirit of the invention, or a plurality of components disclosed in the above-described embodiment. Various inventions can be formed by appropriately combining the above. For example, some components may be deleted from all the components shown in the embodiment. Furthermore, you may combine the component covering different embodiment suitably.

1 HIS
2 RIS
3 DICOM server 4 Medical imaging device 12 DBMS
13 Aging detection unit 13a Data model storage unit 13b Data distribution calculation unit 13c Data distribution difference calculation unit 13d Performance determination unit

Claims (4)

In a medical information system having a database for storing and managing medical data,
Data model storage means for storing, as a data model, characteristic values related to the medical data that affect the speed of data access among the medical data managed in the database ;
Data distribution calculating means for calculating a characteristic value of the medical data corresponding to the data model as a data distribution;
A data distribution difference calculating means for calculating a difference between the characteristic value of the data model and the characteristic value of the medical data calculated by the data distribution calculating means;
Based on the difference calculated by the data distribution difference calculating means, performance determining means for determining performance;
A medical information system comprising:   The medical information system according to claim 1, wherein the performance determination unit determines whether or not the data model stored in the data model storage unit is appropriate.   The characteristic value of the data model includes at least one of the number of data items, the cardinality of the data, the average value of the data size of each column, and the disk storage area information of the database. The medical information system according to claim 2. A database for storing and managing medical data;
A computer provided in a medical information system comprising: a data model storage unit that stores, as a data model, a characteristic value related to the medical data that affects a data access speed among the medical data managed in the database.
A data distribution calculating step of calculating a characteristic value of the medical data corresponding to the data model as a data distribution;
A data distribution difference calculating step for calculating a difference between the characteristic value of the data model and the characteristic value of the medical data calculated in the data distribution calculating step;
A performance determination step of determining performance based on the difference calculated in the data distribution difference calculation step;
A control program characterized by causing

Images