JPH11250082A - Database system - Google Patents

Abstract

(57) [Summary] [Problem] Search different data of the same classification at once,
In addition, the configuration of the dynamically generated input screen is made flexible. SOLUTION: For each input item on an input screen dynamically generated, a screen display title, a data type representing data classification, a component type designating a data input form, an input format such as the number of steps, etc. are preset. Input display item database 16 for holding the obtained component information, screen generation processing unit 11 for dynamically generating an input screen based on the component information corresponding to the input code, and diagnostic information database 17 by adding a data type to the input data Registration processing unit 12 to be registered in
And an information search processing unit 14 for performing a search using the data type as a key, and collectively searches for data having the same classification and different names in which the same data type is set.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database system for registering and retrieving data input from an information input screen prepared for each information group in a database,
In particular, it relates to the efficiency of search and the flexibility of generating an information input screen.

[0002]

2. Description of the Related Art When constructing a database system, it is common to store strongly related data in the same category in the same database, and store and manage data with low relevance in different databases separately. It is a target.
For example, in a database of tumors in a medical system, information on tumors of cancer included in the same category is
The data structure shown in FIG. 11 can be combined into one. Data (diagnosis information) stored in this database is input from a screen provided for inputting a diagnosis result. Although the type of tumor and the location of the tumor vary, and the input items are also different, there are not only data fields common to each cancer, such as the "location" and "size" of this data structure. An extension field for storing data is provided so that it can cope to some extent.

[0003] In the pathology work, there is a rule called "handling rule" for classifying cancer tumors for each cancer, and it is necessary to describe diagnostic information according to the rule. There is no particular problem with the common data items, but the items and format of each piece of medical information slightly differ depending on the type of tumor to be treated. FIG. 12 is a diagram showing an example of each input screen for inputting a diagnosis result of a tumor of A cancer and a tumor of B cancer. The input item is not on the diagnostic input screen.
In addition, "classification" which is an input display item on the A cancer diagnosis input screen
And "tumor classification" as an input display item on the B cancer diagnosis input screen
Are the names of the information specified in the “handling rules”, but they are different input display item names (information names) even though they are actually handling the same data. As in this example, when different information groups (A cancer and B cancer) are configured according to the type of cancer tumor, even the data (classification and tumor classification) that are considered to be the same classification and can be treated as a common item are “handling rules”. In some cases, attributes such as data names, contents, and data lengths are different, which limits the use of a common data structure. In addition, forcible commonality lacks flexibility and may complicate search processing. As a result, a database is individually constructed depending on the type of cancer tumor.

[0004] When a diagnosis input screen for each cancer is displayed, information (hereinafter, referred to as an input display item (label) displayed on each diagnosis input screen or information (field) for generating data input items (fields) is displayed. , "Component information") are set in advance, and the component information is read when the screen is displayed, whereby the diagnostic input screen can be dynamically generated.
At this time, it is generally considered that component information related to the same data input in each diagnosis input screen is commonly generated.

[0005]

However, as described above, if the database is divided into a plurality of parts under the condition that restrictions such as "handling rules" are imposed, it is necessary to obtain data classified as the same classification. Has to search multiple databases, requires more processing time, and is inefficient.

In addition, the display items common to each input screen are displayed in a list format on one input screen, and in a combo format on another input screen. Even if it is desired, it cannot be realized because the component information is shared.

SUMMARY OF THE INVENTION The present invention has been made to solve the above-described problems, and an object of the present invention is to improve the efficiency of retrieving information that is registered in the database as different data with different attributes such as names but is classified into the same classification. An object of the present invention is to provide a database system capable of preventing a decrease in the number of users.

Another object of the present invention is to provide a database system capable of flexibly generating a layout of an information input screen prepared for each information group in order to input a relevant information group registered in a database.

[0009]

In order to achieve the above object, a database system according to a first aspect of the present invention comprises a single information database storing a plurality of related information groups, An information classification database that holds classification information in which the classification of each data constituting the group is set in advance, and classification information corresponding to input data is read from the information classification database, added to the data, and registered in the database. Information registration processing means, comprising an information search processing means for searching the information database,
The information retrieval processing means retrieves data included in all information groups corresponding to the specified classification information collectively irrespective of the difference in the name of the data.

A database system according to a second aspect of the present invention provides a single information database for registering data input from each information input screen prepared for each information group, and different display item names in each of the information input screens. An information classification database that holds classification information in which the same value is set in advance to the data classified as the same classification, and classification information corresponding to the input data is read from the information classification database, and added to the data. An information registration processing unit for registering the information in the information database; and an information search processing unit for searching the information database based on the specified classification information, wherein the information search processing unit includes data corresponding to the specified classification information. From the information database regardless of the information group containing the data and the name of the data. It is intended to search Te.

A database system according to a third invention is the database system according to the second invention, wherein an input display item database for holding component information including a display item name and an input form of each data on the information input screen; Screen generation processing means for reading out component information corresponding to data constituting an information group registered by the registration processing means from the input display item database and generating the information input screen based on the component information; The information input screen to be displayed for registering information into the information is dynamically generated.

[0012]

Preferred embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of a medical system to which a database system according to the present invention is applied. This medical system registers, in a database, a medical treatment result of a patient (particularly, diagnostic information on a cancer tumor) input from an input screen under a name or the like according to a “handling rule” for classifying a cancer tumor, In addition, it is a system for searching for the registered data.
An outline of a process such as information registration in the medical care system will be described along a transition of a screen for inputting diagnostic information shown in FIG.

The diagnostic input screen 1 corresponds to a main screen for inputting diagnostic information. When a code for discriminating the patient number and the type of tumor is input from the diagnosis input screen 1 into the code input field 1b of the code input area 1a and the input button 1c is pressed, a corresponding cancer is prepared according to the input code. The displayed diagnostic input screens 2 and 3 are displayed. When the OK buttons 2a and 3a are pressed after the diagnosis information is input on the cancer diagnosis input screens 2 and 3, the input diagnosis information is registered in the diagnosis information database. At the same time, after erasing the diagnosis input screens 2 and 3 for each cancer, they are displayed in the data display area 1d of the diagnosis input screen 1. Here, when the edit button 1e is pressed to change the input contents after the data registration in the diagnostic information database, the diagnostic information registered in the diagnostic information database is displayed after displaying the diagnostic input screens 2 and 3 for each cancer. It takes out and displays it on the screen, and accepts information change on the screen.

In the medical system according to the present embodiment,
In this way, each of the diagnostic information on the tumors such as A cancer and B cancer is constituted as one information group, and the diagnosis input screens 2 and 3 are provided corresponding to each information group, and the next screen is displayed by the input code. It is determined. Next, the configuration of the present embodiment provided for dynamically generating and displaying the diagnosis input screens 2 and 3 of each cancer shown in FIG. 2 and registering them in the diagnosis information database will be described.

As shown in FIG. 1, the system includes a screen generation processing section 11, an information registration processing section 12, an information change processing section 13, an information search processing section 14, an input / output control section 15, an input display item database 16 And diagnostic information database 17
have.

The screen generation processing section 11 dynamically generates the above-mentioned diagnosis input screens 2 and 3 for each cancer according to input codes. At this time, a screen is generated based on the component information registered in the input display item database 16 in advance. The information registration processing unit 12 registers the diagnostic information input from the diagnostic input screens 2 and 3 for each cancer in the diagnostic information database 17.
At this time, the information registration processing section 12 according to the present embodiment is characterized in that the classification information corresponding to each diagnosis information is read from the input display item database 16 and added. The information change processing unit 13 is a unit for changing the diagnostic information registered in the diagnostic information database 17 as described above. The input / output control unit 15 controls the display of the screen generated by the screen generation processing unit 11, receives the input diagnostic information, and passes it to each of the components 11 to 14.
And input / output control with input / output devices such as the mouse 19 and the like.

FIG. 3 is a diagram showing an example of a data configuration of each component information registered in the input display item database 16 in the present embodiment, and FIG. 4 is a diagram showing each data included in the component information shown in FIG. FIG. 4 is a diagram showing a table in which field contents are described. The input display item database 16
According to the definition contents of each field shown in FIG. 4, it is necessary to prepare beforehand the execution of this system. Hereinafter, each field will be described.

"Input_id" is a field for setting a code assigned to each diagnostic input screen, and is a code input to a code input field (text box) 1b of the code input area 1a. In this example, code A is assigned to the A cancer diagnosis input screen 2 and code B is assigned to the B cancer diagnosis input screen 3. In addition,
The diagnosis input screen referred to in this description refers to the diagnosis input screens 2 and 3 for each cancer generated by the screen generation processing unit 11 according to the input code, and does not include the diagnosis input screen 1 corresponding to the main screen. Of course, the component information may be registered and displayed in order to display the diagnostic input screen 1 in the input display item database 16, but the description is omitted because it is not the gist of the present embodiment.

"Order" is a field for setting the priority order (display order) of components on each diagnostic input screen. For example, when the code A is input, the list for inputting the occurrence site is set to "1", the check box for inputting the classification is set to "2", and the text for inputting the comment is set to "3". In input screen 2,
The images are displayed in the order shown in FIG. Here, suppose that the display order of the comments is “2” and the display order of the classification is “3”.
, The display order of the classification and the comment is reversed.

"Data_type" is a field for setting a data type for classifying input data. Classification information indicating the classification of each data constituting each information group, that is, diagnosis information for each cancer. Is set in advance. According to the example shown in FIG. 4, since the same value “2” is set for the labels “classification” and “tumor classification”, they are recognized as the same classification. This data type is characteristic field data in the present embodiment.

"Label" is a field for setting an input display item, that is, a screen display title for identifying input data. This corresponds to the information name of the input data. On the A cancer diagnosis input screen 2, "occurrence site", "classification", and "comment" correspond to this.

"Input_type" is a field for setting the component type, that is, the input form of the component of the input item. In this embodiment, 1 is a text, 2 is a list,
3 is a radio button, 4 is a check box, 5 is a combo list, 6 is a size input, and each data can be input in a set input form. For example, since “2” is set in “tumor classification”, data is selected from the list displayed on the B cancer diagnosis input screen 3 in a selectable manner.

"Select_type" is the "input_typ"
This field is valid only when "e" is 2, and determines whether a plurality of items in the list can be selected. In this example, the case where only single data can be selected is "1", and the case where multiple data can be selected is "2".

"Size" is a field for setting the data input format, and its meaning slightly changes depending on the set value of the component type (input_type). Part type is 1
(Text) and 5 (Combo List) indicate the maximum input length of text, and 6 (Size Input) indicates how many dimensions to input. Otherwise, it indicates the number of display steps.

"Entry" is a field for setting a display entry, and stores a default character string in text, and each entry as a selection candidate in a list or a check box.

"Continue_flag" is line feed flag information for line feed control on the display screen. When "1" is set, the immediately preceding component information is displayed, and no line feed is performed. Is displayed side-by-side with the part information. In this example, since all are "0", the "occurrence site", "classification", and "comment" in the A cancer diagnosis input screen 2 have a screen configuration in which the line is broken at the time of display and arranged vertically. I have.

The component information registered in the input display item database 16 is information necessary for generating the diagnostic input screens 2 and 3, and each component information is set in advance on each screen so as to correspond to each data. As described above, since component information in which input data of the same classification is forcibly shared is not provided, a screen can be generated without depending on another screen. Thereby, flexibility can be given to the screen layout. In this embodiment, the component information includes the classification information, and is maintained and managed in a single database.

FIG. 5 is a diagram showing an example of the data structure of the diagnostic information database 17 in the present embodiment. "Pa
“tient_id” is a patient number, which is read from a master file (not shown) and stores data displayed on the main diagnosis input screen. "Input_id" and "orde
“r” is the same input code and priority as in FIG. 3, and stores the input code and priority set in the component information corresponding to the data set and input from each of the cancer diagnosis input screens 2 and 3. . “Data_type” is the same data type as that in FIG. 3, and stores the data type set in the component information corresponding to the data set and input from the diagnosis input screens 2 and 3 for each cancer. “Data” is the data itself set and input from the diagnosis input screens 2 and 3 for each cancer.

The hardware configuration of this system is CP
It can be realized by a general-purpose computer equipped with a U, a memory, a disk device, a display, a pointing device, and the like. FIG. 1 shows an example realized by a single computer, but it can also be constructed by a plurality of computers such as a client server system. In addition, the system requires master data related to the patient itself, such as a patient number, an address, an insurance number, and the like, and master data related to a diagnosis, but a configuration that is not the gist of the present embodiment is not illustrated.

A feature of this embodiment is that a data type is added to diagnostic information and registered in the diagnostic information database 17. As a result, the same data type is added to data of different information groups that cannot be treated as the same data despite being of the same classification due to some restrictions as in the “handling rules” of the present embodiment, and If a search is performed, different data can be searched collectively.

Also, since the component information is individually registered for the same data, and the input form and the display order can be set for each component information, each screen can be set to the input form or layout of another screen. Can be generated without depending on. Further, different display item names can be easily set for the same data.

Next, the operation in this embodiment will be described in the order of the screen generation processing, the information registration processing, the information change processing, and the information search processing along the screen transition shown in FIG. First, the screen generation processing by the screen generation processing unit 1 will be described with reference to the flowchart shown in FIG. In order to operate this system, it is necessary to generate the input display item database 16 in advance.

First, the information input user inputs diagnostic information on the patient 1 on the diagnostic input screen 1 corresponding to the main screen for registering diagnostic information. If the diagnostic result of the patient 1 is A cancer, a code input field is entered. "A" is input to 1b, and "B" is input for B cancer, and then the input button 1c is pressed. The screen generation processing unit 11 receives the code input via the input / output control unit 15 (step 10).
1) The component information corresponding to the code input from the input display item database 16 is sequentially extracted according to the respective priorities (display order) (step 102). That is, by searching the input display item database 16 with a key composed of “input_id” and “order”, each piece of component information is extracted one by one in the display order. And
The screen generation processing unit 11 generates an input field with a screen display title and a designated input form based on the extracted component information (step 104). At this time, if necessary, a line feed is performed according to the line feed flag information, and if unnecessary, a line is displayed side by side with the immediately preceding input item without line break. This is repeated until there is no more unprocessed component information corresponding to the input code (step 103).

For example, if the information input person inputs the code “A”, the screen generation processing section 11 generates the A cancer diagnosis input screen 2. Is extracted in the order of higher priority (the order of smaller numbers), that is, in the order of "occurrence site", "classification", and "comment", and input display items based on the label and input based on the component type. Generate the fields for the item. As described above, according to the present embodiment, any of the separately prepared diagnostic input screens based on the “handling rules” can be dynamically generated and displayed as the next screen according to the input code. Especially,
According to the present embodiment, since the input display item database 16 having the above-described data configuration is provided, the same value (“benign”
Alternatively, different labels (“classification”, “tumor classification”) can be set for diagnostic information of the same classification in which “malignancy” is set, and different component types can be set for each label. Features. More specifically, the input can be made in different forms, such as a radio button for "classification" and a list for "tumor classification". For this reason, the input screen provided for each related information group can be generated without depending on other input screens.

Screen generation processing unit 11 in the present embodiment
FIG. 7 shows the input display item database 16 shown in FIG.
By converting each component information corresponding to the input code based on the conversion table shown in FIG.
ext Markup Language)
The diagnostic input screen of each cancer shown in FIG. 6 is generated by the generated HTML. FIG. 8 shows a process based on HTML according to FIG. FIG. 8 shows HTs related to ruled lines and line feeds.
ML is also described.

Next, information registration processing in the present embodiment will be described with reference to the flowchart shown in FIG.

When the OK button 2a, 3a is pressed after the diagnosis information is set and input from the diagnosis input screens 2, 3 generated by the screen generation processing unit 11, the information registration processing unit 12 enters The data input through the output control unit 15 is sequentially received, and the component information corresponding to the data is acquired (step 201). Then, an input code, a priority order (display order) and a data type extracted from the component information are added to the patient number and the input data, and registered in the diagnostic information database 17 (step 203). The above process is repeated for all the displayed input data (step 202). When the input diagnostic information is registered in the diagnostic information database 17, the diagnostic input screen of each cancer is deleted and the registered contents are displayed in the data display area 1d of the diagnostic input screen 1.

Next, the information change processing in this embodiment will be described with reference to the flowchart shown in FIG.

When the information input person presses the edit button 1e in the code input area 1a, the information change processing section 13
By causing the screen generation processing unit 11 to execute the above-described screen generation processing, the diagnostic input screens 2 and 3 corresponding to the code set in the code input field 1b are generated (step 301). Thereafter, the information change processing unit 13 stores the diagnostic information of the corresponding patient (number) in the diagnostic information database 17.
And displays it in each input field of the diagnostic input screens 2 and 3 (step 302). Information change processing unit 13
After the data is reset on the diagnosis input screens 2 and 3 of each cancer, when the OK buttons 2a and 3a are pressed, the information registration processing unit 12 executes the above-described information registration processing to change the data. Diagnosis information database 1
7 (step 303).

Finally, a description will be given of an information retrieval process which is a feature of the present embodiment.

When the information searcher inputs a data type from a predetermined search screen (not shown) and issues a search request, the information search processor 14 searches the diagnostic information database 17 using the specified data type as a key. I do. For example, assuming that the data type “2” is designated, the information search processing unit 14 simultaneously searches for data having different “classification” and “tumor classification”. That is, the information search processing unit 14 is applicable only by designating a single search key, even in a case where data which can be said to be of the same classification must be registered under different names by agreement such as “handling rules”. Data can be searched at the same time regardless of its name. Originally, "Handling Rules"
However, according to the present embodiment, this data type (classification information) is added to the data. Since the information is registered, it can be acquired by one search execution even though it has a different information name, and the search efficiency can be improved.

In this embodiment, data having different names have been described as an example of data of the same classification. However, data having different attributes such as a data length and a data structure are different, so that data which is handled as different data may be used. Needless to say, this can also be applied. Further, if the data is to be searched collectively, the data type of the same value may be set depending on the operation of the system even if the data type is not the same. Further, in the present embodiment, two information groups have been described as an example, but it is needless to say that the present invention can be applied to more information groups.
Also, there is no upper limit on the number of component information items that specify the same data type. Further, in the present embodiment, the case where the present invention is applied to a medical system is described as an example, but the present invention can be applied to other systems.

[0044]

According to the present invention, equivalent classification information is added to data of a different information group which cannot be treated as the same data despite being of the same classification due to some restrictions,
Since the database is searched based on the classification information, different data of the same classification can be searched collectively.

Further, since component information in which input data of the same classification is forcibly shared is not provided, a screen can be generated without depending on other screens. Therefore, the same data can be input in different forms such as a list format and a combo format, and the screen layout can be given flexibility.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an embodiment of a medical system to which a database system according to the present invention is applied.

FIG. 2 is a diagram showing a screen for inputting diagnostic information and a transition thereof in the present embodiment.

FIG. 3 is a diagram showing a data configuration example of each component information registered in an input display item database according to the embodiment.

FIG. 4 is a diagram showing a field definition of each component information in a table format according to the embodiment;

FIG. 5 is a diagram showing an example of a data structure of a diagnostic information database according to the present embodiment.

FIG. 6 is a flowchart illustrating a screen generation process according to the present embodiment.

FIG. 7 is a diagram showing a conversion correspondence when HTML is generated from each piece of component information when an input screen is generated by HTML in the present embodiment.

FIG. 8 is a flowchart showing a screen generation process when an input screen is generated by HTML in the present embodiment.

FIG. 9 is a flowchart illustrating an information registration process according to the present embodiment.

FIG. 10 is a flowchart illustrating an information change process according to the present embodiment.

FIG. 11 is a diagram showing an example of a data structure of a conventional diagnostic information database.

FIG. 12 is a diagram showing an example of a screen for inputting a diagnosis result of tumors A and B.

[Explanation of symbols]

11 screen generation processing unit, 12 information registration processing unit, 13
Information change processing unit, 14 information search processing unit, 15 input / output control unit, 16 input display item database, 17 diagnostic information database.

────────────────────────────────────────────────── ───

[Procedure amendment]

[Submission date] May 7, 1999

[Procedure amendment 1]

[Document name to be amended] Statement

[Correction target item name] Claims

[Correction method] Change

[Correction contents]

[Claims]

1. A single information database for registering data input from each information input screen prepared for each information group, a classification of each data , and a display item name being different in each information input screen. Regardless of the data classified as the same regardless of
Is an information classification database that holds classification information in which the same value is set, and information registration processing means that reads classification information corresponding to input data from the information classification database, adds the data to the data, and registers the information in the information database. Information search processing means for searching the information database based on designated classification information ; display item names and input forms of each data on an information input screen;
Input display item database that holds part information including
And displaying the information input screen, the information registration processing means
Component information corresponding to the data that constitutes the information group to be registered
Information from the input display item database, and
Screen generation for generating the information input screen based on parts information
And a different input form for each data classified as the same classification.
A database system characterized by being configurable .

2. The information classification database and the input table.
The display item database is formed by a single database.
Classification information and parts information correspond to each display item name.
The database system according to claim 1 , wherein the database system is held.

[Procedure amendment 2]

[Document name to be amended] Statement

[Correction target item name] 0009

[Correction method] Deleted

[Procedure amendment 3]

[Document name to be amended] Statement

[Correction target item name] 0010

[Correction method] Change

[Correction contents]

[0010]

Means for Solving the Problems Achieving the above objects
To, the database system according to the present invention includes a single information database for registering data inputted from the information input screen prepared for each information group, each data
The same value is set for each data that is classified as the same regardless of the display item name on each information input screen
An information classification database for holding classification information to be read; information registration processing means for reading classification information corresponding to the input data from the information classification database, adding the data to the data, and registering the information in the information database; Information search processing means for searching the information database based on the classification information ;
An input that holds the component information including the display item name and the input form
When displaying the display item database and the information input screen
The information group registered by the information registration processing means
Part information corresponding to the input display data
From the database, and the relevant information
Screen generation processing means for generating an input screen.
A different input mode can be set for each type of data .

[Procedure amendment 4]

[Document name to be amended] Statement

[Correction target item name] 0011

[Correction method] Change

[Correction contents]

Further , the information classification database and the input
Force display item database is formed by a single database
The classification information and parts information correspond to each display item name.
It is held in response .

[Procedure amendment 5]

[Document name to be amended] Statement

[Correction target item name] 0015

[Correction method] Change

[Correction contents]

In the medical system according to the present embodiment,
Thus constitute a respective diagnostic information about tumors A cancer or B cancer such as cancer as one information group, the diagnostic input screen 2,3 provided corresponding to each information group by the entered code <br / > Next screen is determined. Next, the configuration of the present embodiment provided for dynamically generating and displaying the diagnosis input screens 2 and 3 of each cancer shown in FIG. 2 and registering them in the diagnosis information database will be described.

Claims (3)

[Claims] 1. A single information database for storing a plurality of related information groups, an information classification database for holding classification information in which the classification of each data constituting each information group is set in advance, Information registration processing means for reading classification information corresponding to data from the information classification database and adding the data to the data and registering the information in the database; and information search processing means for searching the information database. A database system, wherein the processing means searches collectively for data included in all information groups corresponding to the specified classification information regardless of the difference in the name of the data. 2. A single information database for registering data input from each information input screen prepared for each information group, and the same classification regardless of display item names on each information input screen. An information classification database that holds classification information in which the same value is set in data, and information registration that reads classification information corresponding to input data from the information classification database, adds the read information to the data, and registers the information in the information database. Processing means; and information search processing means for searching the information database based on specified classification information, wherein the information search processing means includes data corresponding to the specified classification information, including the data. Data which are collectively searched from the information database regardless of the difference between the information group and the name of the data. Over the scan system. 3. An input display item database holding part information including a display item name and an input form of each data on the information input screen, and a data constituting an information group registered by the information registration processing means. Screen generation processing means for reading out the obtained component information from the input display item database and generating the information input screen based on the component information, and displaying the information input screen displayed for registering information in the information database. 3. The database system according to claim 2, wherein the database system is dynamically generated.