JP2000172712A - Database system, method for extracting data in the system and ordering system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a database system which quickly retrieves, extracts and displays desired data and to provide a method for controlling the system and an ordering system. SOLUTION: The data amount of the number of days defined by a parameter definition table is extracted from an order database 11 and a test results database 12 in a server 1, data read processing in which it is stored in an intermediate server is executed and after that, the data amount for the number of days defined by the parameter definition table is extracted from the intermediate server and is shown on a display device.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] The present invention relates to a database system, for example, a database system in a medical institution, a data extraction method in the system, and an ordering system.

[0002]

2. Description of the Related Art Information systems using databases are currently used in all occupations. These have a configuration in which a database is accessed from a terminal, and data corresponding to the content specified by the user is read and displayed.

[0003] One of the representative information systems using this database is an ordering system used in medical institutions. This system includes a database storing medical data, test result data, and the like for each patient, and a terminal connected to the database. That is, for example, when used by a doctor, the terminal issues a data display input instruction (input of a patient's chart number, etc.) from the terminal to access the database and obtains data having a predetermined attribute (for example, a period of 30 days before the present). The relevant medical data, examination data, etc.) are searched and extracted and displayed on the display unit. This medical ordering system can read past medical data, test result data, and the like of a patient from a database as needed, and can provide a large amount of information during medical treatment and the like.

[0004]

However, the conventional ordering system described above is, for example, 3
In a state in which the data of the date corresponding to the period of 0 days is displayed, the period of 30 days before, that is, 31 days to 6 days ago is displayed.
When displaying data of a date corresponding to 0 days ago, data having a date within the period is detected and extracted from a database storing an enormous amount of medical data and test result data again. . Therefore, it takes a long time to detect and extract desired data, and there is a disadvantage that a quick response from an input instruction to a display of data content is lacking.

[0005]

SUMMARY OF THE INVENTION The present invention has been made in view of the above circumstances, and provides a database system capable of quickly searching and extracting desired data, and having a quick response from a display input instruction to an actual display. , Ordering system,
And to provide a control method for the system,
It has the following features. (1) The present invention provides a database, first data extraction means for extracting first data from the database, and an intermediate server for storing the first data extracted by the first data extraction means. A second data extracting means for extracting second data from the intermediate server.

[0006] It is preferable that the database system includes a definition means capable of defining data attributes of the first data and the second data.

According to such a configuration, the first data is extracted from the database by the first data extracting means and stored in the intermediate server, and the second data is extracted from the intermediate server by the second data extracting means. Each operation such as extraction and display is performed. Therefore, in the data extraction for display, there is no need to search and extract from a database storing an enormous amount of data, and only the necessary data is detected and extracted from the intermediate server. Can be reduced.

Further, since the data attribute to be extracted can be appropriately defined, it is possible to extract with a necessary data attribute. (2) According to the present invention, in a data extracting method for extracting data from a database, a first extraction process for extracting first data from a database, and the data extracted in the first extraction process are stored in an intermediate server. And a second extraction process for extracting second data from the intermediate server.

Preferably, the data extraction method is a method of performing the first extraction processing again when the second data is not stored in the intermediate server in the second extraction processing. , The data extraction method comprises:
It is preferable that the data attributes of the first data and the second data be defined.

According to such a configuration, the first data is extracted from the database by the first data extraction process and stored in the intermediate server, and the second data is extracted from the intermediate server by the second data extraction process. Each operation such as extraction and display is performed. Therefore, data extraction for display is basically performed from the intermediate server, so that it is not necessary to search and extract from a database storing a huge amount of data as in the technology. As a result, the data extraction time can be shortened, and the speed of response from the input instruction of data display to the actual display can be improved.

Further, in the second extraction processing, if the second data is not stored in the intermediate server, the first extraction processing is performed again. Therefore, it is defined even when the intermediate server does not have the second data. Attribute data can be extracted and displayed.

Furthermore, since the data attributes to be extracted can be appropriately defined, only the necessary data attribute extraction processing can be performed, and improvement in speed can be expected. (3) The present invention provides a database, first data extracting means for extracting first data from the database by a data attribute based on a date, and a first data extracted by the first data extracting means. An ordering system comprising: an intermediate server for storing data; and second data extracting means for extracting second data from the intermediate server based on a data attribute based on a date.

According to such a configuration, the first data extracting means uses the data attribute based on the date as the first data extracting means.
Is extracted from the database and stored in the intermediate server, and the second data is extracted from the intermediate server by the data attribute based on the date by the second data extracting means, and each operation such as display is performed. Therefore, in the data extraction for display, there is no need to search and extract from a database storing an enormous amount of data, and only the necessary data is detected and extracted from the intermediate server. Can be reduced.

[0014] In the ordering system, it is preferable that the ordering system further comprises a definition means capable of defining the first data and the second data in days.

According to such a configuration, since the data attribute to be extracted can be appropriately defined, the extraction process can be performed with the required data attribute.

In the ordering system, it is desirable that the data defined by the definition means can be defined for each medical department, and that the data extracted in the first extraction processing includes medical data, examination results, It is desirable to include data.

According to such a configuration, the first and the second
The data extraction by the extracting means can be extracted and displayed by classifying the data into the own department, other departments, and the like. It is possible to classify and extract and display the result data, and it is possible to improve the convenience in medical treatment of a doctor.

[0018]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to the drawings, taking an ordering system, which is one of database systems and used in medical institutions, as an example.

FIG. 1 is a schematic configuration diagram showing an ordering system according to the embodiment.

The server 1 and each terminal 2 are connected via a cable 3. In the server 1, an order database 11 storing data called order data such as medical histories for each patient and prescriptions of medicines.
Similarly, a test result database storing test result data (test items, test dates, numerical values, etc.) for each patient is set.

The terminal 2 is installed, for example, for use by medical doctors and the like, and accesses the server 1 from this terminal.

FIG. 2 is a block diagram showing a schematic configuration of the terminal 2.

The CPU 21 reads the ordering system management application program stored in the storage medium 23 set in the storage device 22, and
The program is stored in the work memory area of the AM 25, and the ordering system management process (see FIG. 4) is executed according to the program.

That is, the CPU 21 accesses the order database 11 and the inspection result database 12 in the server 1 according to the program. Then, data is retrieved and extracted from the order database 11 and the inspection result database 12, and a data reading process for temporarily storing the data in the intermediate server 24 set in a part of the storage medium 23 is executed. In the intermediate server 24, the order intermediate database 241 and the inspection result intermediate database 242
Is stored in the intermediate server 24 by sorting the order data into the order intermediate database and the inspection result data into the inspection result intermediate database. In the data extraction in the data reading process, data attributes are limited to dates, and data corresponding to a period defined by a method described later is extracted from the server 1.

After the data reading process, a data display process of searching and extracting data from each of the order intermediate database 241 and the inspection result intermediate database 242 and displaying the data on the display device 28 is executed. In the data extraction in the data display process, data attributes are limited to dates, and data corresponding to a period defined by a method described later is extracted from the intermediate server 24.

In the storage device 22, a storage medium 23 for storing programs and data is fixedly set or detachably mounted. This storage medium 23 is magnetic,
It is composed of an optical recording medium or a semiconductor memory, and stores various application programs corresponding to the terminal 2 and data processed by each processing program.

The storage medium 23 is provided with an intermediate server 24 having an order intermediate database 241 and an inspection result intermediate database 242. The order intermediate database 241 and the inspection result intermediate database 24
Reference numeral 2 is for classifying and temporarily storing data extracted from the server 1 by the data reading process described above.

Further, the storage medium 23 stores a parameter definition table for defining a day parameter indicating a data attribute in each data extraction when executing the data reading process and the data displaying process. As described above, the data extraction in the data reading process and the data display process limits the data attribute to only the date, and extracts a predetermined number of days in units of days. The parameter definition table represents a data attribute to be extracted as a number-of-days parameter,
The user defines this number-of-days parameter with a desired number of days, and determines the amount of extraction.

FIG. 3 is a diagram showing a parameter definition table in the present embodiment. This table can be defined for each medical department, and as shown in FIG. 3, defines the amount of order data and test result data to be extracted in the data reading process [Read Order Data], [Read Test Result Data].
And "order data display" and "inspection result display" which define the amount of extraction of the order data and the inspection result data in the data display processing. Further, in these four items, the inpatients are classified into the ward own department and the ward other department, respectively, and the outpatients are classified into the outpatient own department and the outpatient department. It is assumed that the user uses the table to define a total of 16 days parameters in advance. However, in each of the above corresponding items, it is assumed that (data read processing parameter) ≧ (data display processing parameter).

It is preferable that the value of the data read processing parameter is an integer multiple of the data display processing.

The program, data, and the like stored in the storage device 22 may be received from another device connected via a communication line or the like and stored. Further, a storage device including the storage device 22 is provided on another device connected via a communication line or the like (not shown), and programs, data, and the like stored in the storage device 22 are transferred via the communication line. It is also possible to adopt a configuration for use.

The RAM 25 has a work memory area for storing designated application programs, input instructions, input data, processing results, and the like.

The input device 27 includes a keyboard having a cursor key, a numeric keypad, and various function keys, and a mouse as a pointing device. The input device 27 transmits a signal of a key pressed by the keyboard and an operation signal of the mouse to the CPU 21. Output to

The display device 28 is composed of a CRT, a liquid crystal display device and the like, and displays data input from the CPU 21.

The printing device 29 prints data and the like created by various application programs corresponding to the terminal 2.

Next, the operation of the ordering system configured as described above will be described with reference to FIGS.

FIG. 4 is a flowchart showing the operation of the ordering system according to the present embodiment from when the user inputs a data display instruction through the input device 27 to when predetermined data is displayed on the display device 28. It is.

In the following, for the sake of simplicity, it is assumed that the surgeon uses the system during medical treatment. The number of days parameter in the data reading process and the data displaying process is defined below as the number of days shown in FIG. Give an explanation.

When a user inputs a data display instruction (such as a patient chart number) from the input device 27,
The CPU 21 accesses the order database 11 and the test result database 12 of the server 1, and executes a data reading process of the order data of the patient's chart number for 90 days and the test result data as defined in FIG. That is, data from the current date up to 90 days before the date is detected, data having a date within the period is extracted, and the extracted data is stored in the order intermediate database 241 in the intermediate server 24. And stored in the inspection result intermediate database 242 (step S
1).

Then, in step S2, the order intermediate database 241 and the inspection result intermediate database 2
It is determined whether or not there is a data amount capable of performing the data display process at 42, and if there is data, the process proceeds to the data display process of step S3.

On the other hand, in step S2, the order intermediate database 24 is defined because the parameters of the parameter data definition table are temporarily defined as (data read processing parameters) ≦ (data display processing parameters).
If there is no data in No. 1 and the inspection result intermediate database 242, the process proceeds to step S1, and the data display process is executed again. This operation is repeated until a data amount capable of performing the data display processing exists in the order intermediate database 241 and the inspection result intermediate database 242.

In step S3, data display processing for searching and extracting order data and inspection result data for 30 days from the order intermediate database 241 and the inspection result intermediate database 242 as defined in FIG. 3 is executed. That is, data is detected from the current date to a date 30 days in the past, data having a date within the period is extracted, and displayed on the display device 28 (step S3).

In step S3, the display device 28
For example, in the case of order data, the medical history of the patient is displayed, and in the case of test result data, the examination date and test result (numerical value, etc.) are displayed for each test item. ) And other medical departments are displayed separately for other medical departments (other departments).

FIG. 5 summarizes the concept of the data extraction method of the ordering system according to the present invention described in steps S1 to S3.

That is, first, a data reading process is executed, and based on the value of the number of days parameter defined in [Read Order Data] and [Read Inspection Result] of the parameter definition table shown in FIG. Data is extracted from the result database 12, and the extracted data is temporarily stored in the order intermediate database 241 and the inspection result intermediate database 242 in the intermediate server 24. Next, a data display process is executed, and based on the value of the number of days parameter defined in [order data display] and [inspection result display] of the parameter definition table shown in FIG. Data is extracted from the database 242,
This is a method of displaying on the display device 28.

After the display in step S3 of FIG. 4, the process proceeds to step S4, and it is determined whether or not the user has issued an instruction for data display processing for another 30 days through the input device 27 (step S4).

In step S4, if there is an input instruction for the data display processing for the next 30 days, the operation shifts to step S2 again, and the order intermediate database 241 and the inspection result intermediate database 242 store the data for the next 30 days. It is determined whether data exists. If the data exists, the process proceeds to step S3, and a data display process is performed.

On the other hand, in step S2, the order intermediate database 241 and the inspection result intermediate database 242
(For example, since the ordering system is configured to display data for 30 days in one data display process, if the data display process is executed three times in total, , The data in the order intermediate database 241 and the data in the inspection result intermediate database 242 are completely displayed.), The process proceeds to step S1, the data reading process is executed again, and the operation according to FIG.

If there is no input instruction for the data display processing in step S4, the display in step S3 is continued.

According to the configuration described above, the following effects can be obtained.

First, data extraction for display is basically performed from the intermediate server, and it is not necessary to search and extract data from a server storing a huge amount of data as in the related art. As a result, the data extraction time can be shortened, and the speed of response from the input instruction of data display to the actual display can be improved.

Second, since the attribute of the data to be extracted can be appropriately defined by the parameter definition table, the data can be extracted with necessary data attributes.

Third, in the data display processing, even when the data defined in the intermediate server is not stored, the data reading processing is performed again, so that it is possible to extract and display with the defined data attributes. is there.

Fourth, the data attributes defined by the parameter definition table can be defined for each medical department, the data extracted for each medical department is classified into order data and test result data, and each data is Although the present invention has been described based on the first embodiment, it is possible to improve the convenience of medical treatment and the like by classifying and displaying the information by classifying it into own department and other departments. However, the present invention is not limited to the above embodiment, and for example, the following (1) to (1)
As in (4), various modifications can be made without changing the gist. (1) In the above description, a part of the storage medium 23 of the terminal 2 is used as the intermediate server 24. However, a configuration in which an intermediate server is separately provided separately may be employed. (2) In the above-described embodiment, a case has been described in which the doctor uses the medical treatment of a patient. It may be used for office management and the like. (3) In the above embodiment, only the order data and the inspection result data are searched, extracted, and displayed from the server 1. However, the ordering system further includes image data in addition to the two types of data. You may. (4) In the above embodiment, the ordering system used in medical institutions and the like has been described as an example.
It is not necessary to limit the data attribute to the date, and other data attributes can be applied to general database systems.

[0055]

As described in the above embodiment, the use of the parameter definition table and the intermediate server makes it possible to quickly search and extract desired data. As a result, it is possible to realize the provision of a database system, a control method of the system, and an ordering system that can respond quickly from a display input instruction to an actual display.

[Brief description of the drawings]

FIG. 1 is a schematic configuration diagram of an ordering system according to an embodiment.

FIG. 2 is a circuit block diagram of a terminal 2.

FIG. 3 is a diagram showing a parameter definition table.

FIG. 4 is a flowchart showing the procedure of an operation of data extraction.

FIG. 5 is an exemplary view for explaining the concept of a data extraction method of the ordering system according to the embodiment.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 ... Server 11 ... Order database 12 ... Test result database 2 ... Terminal 21 ... CPU 22 ... Storage device 23 ... Storage medium 24 ... Intermediate server 241 ... Order intermediate database 242 ... Test result intermediate database 25 ... RAM 27 ... Input device 28 ... Display device 29: Printing device 3: Cable

Claims (9)

[Claims] 1. a database; first data extracting means for extracting first data from the database; an intermediate server for storing the first data extracted by the first data extracting means; A second data extracting means for extracting second data from the server. 2. The database system according to claim 1, further comprising definition means capable of defining data attributes of said first data and said second data. 3. A data extraction method for extracting data from a database, comprising: a first extraction process for extracting first data from a database; and storing the data extracted in the first extraction process in an intermediate server. A second extraction process for extracting second data from the intermediate server. 4. The data extraction method according to claim 3, wherein, in the second extraction processing, if the second data is not stored in the intermediate server, the first extraction processing is performed again. 5. The data extraction method according to claim 3, wherein a data attribute of the first data and a data attribute of the second data can be defined. 6. A database, first data extracting means for extracting first data from the database based on a data attribute based on a date, and first data extracted by the first data extracting means. An ordering system comprising: an intermediate server for storing; and second data extracting means for extracting second data from the intermediate server based on a data attribute based on a date. 7. The ordering system according to claim 6, further comprising a definition unit capable of defining the first data and the second data in units of days. 8. The ordering system according to claim 7, wherein the first data and the second data defined by the definition means can be defined for each medical department. 9. The ordering system according to claim 8, wherein the data extracted in the first extraction processing includes medical treatment data and examination result data.