JPH11149516A - Database system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To improve processing efficiency in a database system by storing information with a comparatively high usage frequency in a storage device with a high speed access time and storing information with a comparatively low usage frequency in a storage device with a low speed access time. SOLUTION: Information with a comparatively high usage frequency is stored in a storage device with a high speed access time and information with a comparatively low usage frequency is stored in a storage device with a low speed access time. That is, in the system, recording is normally executed in temporary file devices 100 and 101 concerning information with the comparatively high usage frequency of a hospitalized patient or an outpatient and information with the usage frequency being lower than that of the file devices 100 and 101 is stored in an active file device 102. Moreover, patient information with the usage frequency being lower than that of the file device 102 is stored in an inactive file 103. Thus, the access time from a terminal equipment is shortened.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to a database system for storing information, and more particularly to a database system capable of filing image information from a network system.

[0002]

2. Description of the Related Art In a database system using a network system, an information generating device, a database for filing the information, and one or more terminals for retrieving the information of the database are provided at a plurality of nodes connected to the network system. It is connected.

FIG. 8 shows an example of a database system using the conventional and the network systems of the present invention.

FIG. 8 shows a link type network system in which a plurality of nodes 401, 402, 403, 404, 405 are connected to a common data transmission line 400. Image information and additional information of the image information and a procedure signal for exchanging the information are transferred between the nodes 401 to 405 via the common data transmission path 400.

In such a network system, an image generation device 406 is connected to the node 401,
The image information from the device 406 is placed on the common transmission path 400. This information is filed in the database system 407 connected to the node 402. The database system 407 serves as an image database and accumulates image information from the image generator 406. On the other hand, the information stored in the database system 407 is
3 is searched by the terminal 408 connected to
Is forwarded to

[0006]

However, in such a conventional system, the database system 407 is
A device for storing the information is, for example, a semiconductor memory,
Either a rewritable so-called erasable storage device such as a magnetic tape or a magnetic disk or a non-rewritable so-called non-erasable storage device such as an optical disk device is used. In particular, a database system for storing image information requires a large-capacity storage device of several gigabytes or more. As a result, a non-erasable storage device (for example, an optical disk device) having a high storage density must be used. However, the optical disk device has a storage density of, for example, 3.6.
Although it is as high as GB / sheet, there is a disadvantage that the access time of the stored image is as long as 800 mS. In general, in a current storage device, the average access time of information read from the device tends to increase as the storage capacity of the device itself increases. Therefore, the search time becomes longer in proportion to the access time.

In addition, since a non-erasable storage device is used in a large-capacity storage device such as an image, other information cannot be written again in a place where data has been recorded once. .

Therefore, if an image is edited, the image before editing remains without being erased, and the storage capacity further increases. Thus, in the conventional database system, the processing efficiency is low.

The present invention has been made in view of such circumstances, and has as its object to provide a database system capable of improving the processing efficiency of the database system.

[0010]

In order to achieve this object, the present invention provides a first file means for storing medical image information and a use frequency of the medical image information stored in the first file means. A use frequency judging means for judging, a second file means for storing medical image information, which access time is slower than the first file means, and a use frequency judgment means for storing the medical image information in the first file means. The medical image information whose use frequency determined for the medical image information determined is less than or equal to a predetermined frequency is controlled not to be stored in the first file means and to be stored in the second file means. Storage control means, and in searching for medical image information, desired medical image information is not stored in the first file means but is stored in the second file means The desired medical image information stored in the second file means is transferred to a search request destination and stored in the first file means, and further stored in the second file means. A database system comprising a search control unit for storing medical image information related to the desired medical image information in the first file unit.

[0011]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A first embodiment of the present invention will be described with reference to FIG. FIG. 1 is a configuration diagram of a database system (for example, 407 in FIG. 8). Node 5 in FIG.
Is connected to a common data transmission path 4, and image information from the image generation apparatus connected to a node or a computer (not shown) via the transmission path 4, and information and commands added to the image information are transmitted. . The image generating device is a device that sends image information to the transmission line 4 such as a video device, a copying device, a micro camera, and a diagnostic device that generates an image (for example, a magnetic resonance diagnostic device). The node 5 also sends out image information and information added thereto to a node (not shown) connected to a terminal (not shown) via the transmission line 4.

The information exchange between the node 5 and the temporary file device 1 is performed via a junction. That is, the junction corresponds to an information transmission unit between the network system and the data system. Therefore, information may be exchanged between two distant points by light or radio waves.

[0013] The temporary file device 1
, An I / O control unit 6 connected to the control unit 6, a buffer / store unit 7, a memory search unit 9 and an address addition unit 8 which can store a plurality of information and a memory search unit 9 and an address addition unit 8 connected to the memory module 10.

The memory module 10 is connected to the active file device 2 and exchanges information with the file device 2.

The active file device 2 has a memory interface 11 connected to an active file management unit 22 provided in the memory module 10 and the database system management device 3 described later, and an image connected to the interface 11. A storage editing process unit 12 and an image search unit 14; an image editing unit 16 connected to the image search unit 14 and the image storage process unit 12; an image restoration unit 15 connected to the image search unit 14; , An optical disk control unit 18 in the optical disk drive 17 connected to the compression unit 13 and the decompression unit 15, and an image compression unit 13 connected to the control unit 18.
And an optical disc autochanger 19. The optical disk autochanger 19 stores a plurality of optical disks.

Further, there is a database system management device 3 for managing the temporary file device 1 and the active file device 2. The database system management device 3 assists the operation of the file devices 1 and 2 and
Facilitate data transfer between the two.

The database system management device 3 includes a temporary file management unit 20 connected to the I / O control unit 6 and the memory search unit 9 in the future, the management unit 20, the address addition unit 8, the image search unit 14, There is an index file unit 21 connected to the image editing unit 16, and an active file management unit 22 connected to the index file unit 21, the temporary file management unit 20, and the image editing unit 16.

The temporary file management unit 20
Is an external schema for describing a view of a data structure suitable for a specific application for information in an image database (not shown), an internal schema for describing a physical organization method and a data internal representation in the database,
A description scheme divided between three layers of a conceptual schema that can be mapped between the internal schema and the external schema is used. It operates in the data description language (DDL) of each layer. In this case, an interface between the terminal and the memory module 10 is realized by using a data dictionary (not shown) and using information from each schema by using a data dictionary function.

In such a configuration, (1) image information is transmitted from the common data transmission line 4 to the memory module 1
0, (2) retrieval of information stored in the memory module 10, (3) transmission of information of the memory module 10 to the optical disk device 17 for storage, (4) optical disk device 17 The case where the information stored in the terminal is read and transferred to the terminal will be described below. (1) A case where image information from the common data transmission path 4 is stored in a memory module.

Image information to be recorded in the I / O control unit 6 is sent from an image generator (not shown) via the common data transmission line 4 and the node 5. If the temporary file device 1 is processing another command when the information is sent from the node 5, the information is immediately stored in the buffer file.
Stored temporarily in the store unit 7. When the processing of other instructions is completed, the previous information is read from the buffer store unit 7 and sent to the address addition unit 8. However, when there is no other instruction processing, information is directly transferred from the node to the address addition unit 8. The buffer store unit 7 is an erasable storage device such as a RAM or a hard disk device.

The address adding unit 8 adds the address sent from the index file unit 21 to the sent information and transfers the information to the memory module 10 for storage.

By doing so, the stored information can correspond to the address, so that the stored information can be read out by the address and the stored information can be identified.

The memory module 10 stores a plurality of images (for example, 1000 images, the storage capacity required for this is 60 MB if the memory required for one image is 60 KB). Therefore, each image has its own address. FIG. 2A shows the contents stored in the memory module 10.

FIG. 2A is an example of a database file of images showing the contents stored in the memory module 10, and is divided into an address section 40 and an information section 41. An address is assigned to each piece of information. For example, the information 42 of the image 1 which is one image and the information 43 of the additional 1 are provided with an address “001” in a corresponding manner. The additional information 43 includes, for example, the date and place where the image 1 was photographed or created, the name of the owner of the image 1, and error detection information. At the address “002”, two images 23 are continuously stored. The information 44 of the message 1 of “003” stores information that is not an image, for example, text information or a program by a word processor. No information is stored in the address “005”. As the memory module 10 stored in this manner, a rewritable (eraseable) storage device such as a magnetic bubble, a CCD, a magnetic disk device, and a magnetic tape device is used.

By using such an erasable storage device 10 and always writing relatively frequently used information in the storage device 10, the access time of the information can be shortened.

On the other hand, the index file unit 21
Has an index file indicating the address, type, length, number and key of the information stored in the memory module 10.

FIG. 2 shows an example of this index file.
b. According to FIG. 2b, the index file is:
An address part 50 having the same number as the address of the information stored in the database file;
, A type part 52 indicating the type of the information part 41, an information part 53 indicating the length of the image and the length of the message, and a number part 54
And each is stored in a direct organization by a hash function. A hash function is a logical structure of data that can search a large table at high speed. If the data amount is small, a sequential arrangement or a storage structure using an index or a pointer is used.

The key 51 and the number 54 are sent from the terminal, and the remaining address 50, the number 54, the type 52 and the length 53 are stored in the memory module 10 in the temporary file management unit 20. Is calculated so as to be stored efficiently, and is automatically added. The information stored in the key 51 may be a symbol such as an alphanumeric character, a kana, a hiragana, or a special symbol, and is represented by three alphanumeric characters in FIG. 2B. In addition, a proper noun such as a nomination, a company name, an affiliation, a date of birth, a time such as a joining year may be used as a key, or a plurality of types of keys may be attached. The same key 51 can be attached to a plurality of addresses. For example, the key “WHO” has the address “00”
1 ”,“ 004 ”, and“ 008. ”In this way, when“ WHO ”is searched, the“ WHO ”
All addresses, types, and lengths can be output.

The type 52 is a type of information stored in the database file, and is, for example, "1" of the type 52.
Indicates that the image is stored in the form of image + addition.

The number 54 is assigned one type of symbol so as not to overlap with another address. With this number 54, information at one address can be extracted from the terminal.

The distribution of the database file and the index file is not limited to the above, and may be all stored in the memory module 10 or distributed to a database system connected to another node. Also, since the index file is created by using an erasable storage device, unnecessary information is erased like "005" at address 50, and new information is inserted afterwards. (2) Searching information stored in the memory module 10.

A number 54 or a key 51 is sent from a terminal (not shown) to the I / O control unit 6 via the common data transmission line 4 and the node 5. When these instructions are sent, if the memory module 10 is used, the data is temporarily stored in the buffer store unit 7, and even if the processing is completed, if the use of the memory module 10 is completed, the buffer store unit is used. 7 and processed.
The buffer / store unit 7 can assign a priority to each stored instruction. In the case of an urgent instruction, the priority is increased and the processing is performed.

When the instruction is decoded as a search, I
An instruction is sent from the / O control unit 6 to the memory search unit 9. Upon receiving this command, the search unit 9 checks whether the information to be searched is stored in the index file unit 21 from the memory search unit 9 via the temporary file management unit 20, and if there is such information, the search unit 9 Number 54 or address 5 of key 51
0, type 52 and length 53 are transferred to the memory search unit 9. When the key 51 corresponds to a plurality of addresses, the transfer is performed for all the addresses 50. Based on the address, the memory search unit 9
An information search is performed on the module 10. The searched image and message information are transmitted to the I / O control unit 6 and the node 5
And transmitted to the terminal via the common data transmission path 4. (3) When the information stored in the memory module 10 is transferred to the optical disk device 17 and stored.

A “data transfer command from the memory module 10 to the optical disk device 17” is sent from the terminal device (not shown) to the node 5 via the common data transmission line 4 as key information. Then, the node 5 transmits the instruction to the I / O control unit 6. When this command is received, a search key for reading information from the memory module 10 is sent from the control unit 6 to the memory search unit 9 and the temporary file management unit 20. The temporary file management unit 20 reads the address containing the key from the index file in the index file unit 21 using the search key. Then, the image, addition, and message information retrieved from the memory module 10 based on the read address and the additional information are read. At that time, if there are a plurality of addresses for one key, information at all the addresses is read. The read information is sent to the image storage processing unit 12 via the memory interface 11 in the active file device 2. In the case of information sent from a plurality of addresses, the image storage process unit 12 is sent once to the image editing unit 16 and edited there. Editing can be done, for example, by collecting only images and then adding messages, rearranging them in order from the earliest time stored in the memory module, and further editing based on type, number and key Is also good. Unnecessary information and redundant information are deleted in the unit 16. The information edited by the editing unit 16 in this way is returned to the image storage processing unit 12 again and sent to the image compression unit 13. If only one address is found for one key, it is sent directly to the compression unit 13 without going through the editing unit 16.

The image compression unit 13 outputs the information of the transmitted original image with a reduced amount, so that the storage capacity can be reduced. As the compression method of the image compression unit 13, for example, lossless compression such as run-length coding or Huffman coding or lossy compression such as KL conversion or cosine conversion is used.

The compressed information is sent to the optical disk control unit 18 of the optical disk device 17. The optical disk autochanger 19 of the optical disk device 17
Has a plurality of non-erasable optical disks,
The compressed information is written in this. Since an optical disc is non-erasable, when information that has been written is rewritten, the written information must be invalidated and newly written in a different location.

The optical disk control unit 18 is connected to four autochangers. The optical disk control unit 18 manages the addresses where the information is stored. Optical disk device 1
The storage capacity of the memory module 7 is larger than the storage capacity of the memory module 10.

As a result, all the information stored in the temporary file 1 can be transferred to the active file 2. That is, since the information stored in the active file 2 is information once stored in the temporary file 1, an active file having at least a storage capacity larger than the storage capacity of the temporary file is required. Of course, as the amount of information stored in the temporary file increases, the storage capacity of the active file needs to be increased in proportion thereto.

As described above, the address is read from the index file based on the key specified by the terminal, and the information of the memory module 10 at that address is transferred to the optical disk device 18 and stored. Such an implementation is not limited to this method and many other variations are possible. For example, only one key specified from the terminal is described, but a plurality of keys may be attached, each of which may be a key-based type of a related type,
The keys may be derived from algebraic expressions. Furthermore, the index file may be provided anywhere as long as the database file can be read. The data of the index file may be physically, geographically and functionally distributed.

From the memory module 10 to the optical disk
A second embodiment will be described for the case of transferring information to the control unit 18. According to the second embodiment, the memory
A place where the module 10 can be read (for example,
The time management means 60 of FIG. 3 is provided in the index file unit 21). The time management means 60 stores each time when each information is stored in the memory module 10 in the time counter 62 in key units. That is, the time counter 62 has a numerical value, and the numerical value changes with time. Then, when a predetermined time has elapsed and the numerical value has reached the predetermined value, information transfer is performed for the key of the time counter 62. In this case, the transfer is also performed for the address including the key to be transferred. The time control 61 in the time management means 60 includes addresses “001” to “9”.
It works to manage time counters up to 99 ".
Although the time management unit 60 performs the above-described operation on the address, the time management unit 60 may also manage the address degree key, the number, and a combination thereof. This time management means 60
Thereby, information can be automatically transferred without the trouble of inputting to the terminal.

The time management means 60 exchanges information with the index file unit 21 to
The information transfer to the optical disk device 17 is performed only when information related to a predetermined key is not input or output at all from the memory module 10 during a predetermined period. The memory module 1 for a predetermined key within a predetermined period
When the value is stored or read out to 0, the time counter of the address having the predetermined key is cleared, and the time is counted from the beginning. Thus, the information stored in the temporary file device can always be frequently used.

When the information transfer from the memory module 10 to the optical disk control unit 18 is completed as described above, the information stored in the memory module 10 and the index file unit 21 and transferred is cleared. (4) A case where information stored in the optical disk device 17 is read and transferred to a terminal.

From a terminal (not shown), the I / O control unit 6
A search command is sent to the management device 3 of the database system through. And the database system management device 3
The storage location of the information searched by the temporary file management unit 20, the active file management unit 22, and the index file unit 21 is found. Next, if the storage location is in the optical disk device 17, the image storage unit 14 and the optical disk control unit 18 are used to find a detailed storage position of the search information. The found information is sent from the optical disc control unit 18 to the image restoring unit 15 to restore the compression. Then, the restored information is transferred to the image search unit 14. At this time, if there is an image editing request from the terminal, the image information is sent once to the image editing unit 16 to be edited, and returned to the search unit 14 again. Next, the information of the search unit 14 is transferred to the terminal via the memory interface 11.

The information transfer from the non-erasable storage device such as the optical disk device 17 to the terminal is not limited to the above example, but may be modified in other ways. For example, information from the optical disk device is directly transferred to the common data transmission path 4 and the contents are transferred to the memory module 10.
May be stored. At that time, information having the same key as the information is also read from the optical disk device 17 and stored in the memory module 10. By doing so, the access time from the memory module 10 can be reduced.
7, the search time can be reduced when the same information is read from the terminal again. In other words, the erasable storage device is placed at the input / output port side of the non-erasable storage device, and the relatively frequently used information from the common data transmission line 4 is always stored in the erasable storage device. Can get information faster.

According to the first embodiment, in addition to the above effects,
The buffer store unit 7 can cope with a situation where the database system is congested. In addition, it is possible to increase the storage capacity by removing duplicate data by the image editing unit 16 and to combine even if the image data is divided and stored in the optical disk device 17. You can also send it.

Next, a third embodiment of the present invention will be described with reference to FIG.

The network system shown in FIG. 4 has a link-like common data transmission line 4-a to which a plurality of nodes are connected.
4-b, which are connected by a gate way 73 between them.
This is a system for performing private communication using a file 1 and an active file 2. As a modified example of the network system of this embodiment, a bus shape, a tree shape, a star shape, or a combination thereof may be used. As a transmission medium, optical fiber communication for communicating with light of a semiconductor laser or a light emitting diode, wireless communication using a two-core cable, a coaxial cable, or satellite communication is used. In addition, the network system is not limited to local communication, and may be performed using a global network system (for example, public communication, submarine communication, international communication, satellite communication).

The common data transmission lines 4-a and 4-b in FIG. 4 are provided with nodes 5-a to 5-n. The nodes 5-a, 5-m, and 5-g are respectively connected to the terminal device 70-.
a to 70-c are provided. Nodes 5-b and 5
−n and 5-j are image generators 71-a to 71-71, respectively.
-C connected to nodes 5-d, 5-e, 5-h,
Temporary files 1-a to 1-c are respectively connected to 5-i, but two temporary files 1-a and 1-b are connected to a node 5-d.
The node 5-k has the active file 2-f, the node 5-c has the network management device 72, and the node 5-k.
A database system management device 74 is connected to l.

The active file 2-a has a large-capacity (for example, several hundred gigabytes or more) storage device, is connected to the temporary files 1-a to 1-c and the node 5-e, and reads from the file 2. The output information is transmitted to the common transmission line 4-
a or direct via file 1 can be selected. The temporary file 1-d is replaced with the active files 2-c and 2-c.
d is connected.

In such a configuration, the gateway 73
Appropriately exchanges different protocols for transmitting the networks 4-a and 4-b. Network management device 7
2 manages the common data transmission path 4-a via the node 5-c so that information exchange between the nodes 5 can be performed smoothly.

The temporary file 1 is distributed on the common data transmission path 4 and stores information from the transmission path 4. As a result, the amount of information managed by one temporary file 1 can be reduced.
File 1 access time can be shortened and
Even if one of the files 1 fails, all the files 1 cannot be read out. For the same reason, a distributed system is used for the active file 2 as well, and information from the temporary file 1 is distributed and stored.
The active file 2-a has a large-capacity storage device and is connected to a plurality of temporary files 1-a to 1-c. At this time, the storage capacity of the active file 2-a is larger than the total storage capacity of the temporary files 1-a to 1-c.

The operation in the above configuration is as follows. First, the image information output from the image generating device 71 is sent to an erasable storage device (not shown) in the temporary file 1 via the node 5 and the common data transmission path 4. It is memorized. Keywords related to the image information output together with the image information from the device 71 are stored in an index file (not shown) in the database system management device 74. Next, the keyword is sent from the terminal 70 to the database system management device 74. Based on this keyword, it is collated with the information in the index file to find out in which temporary file 1 the image information related to the keyword is stored. The found image information is stored in one of the active files 2. The image information stored and found in the temporary file 2 is deleted from the temporary file 2. The third embodiment using the file distribution of the present invention is not limited to the above, but can be applied to other applications. For example, the database system management device 74 may be distributed on the common data transmission path 4 or in the temporary file 1 and the active file 2. Therefore, the index file units 20 are also distributed, and the system can be made larger.

Further, the temporary file 1 and the activating file 2 may be dispersedly used according to a predetermined classification. For example, the images may be classified and distributed according to the characteristics of the stored image, such as the stored age, the classification based on the keyword of the index file, and the classification of the information type or number.

FIG. 5 shows a fourth embodiment of the present invention. The database system in FIG. 5 includes the temporary file device 1 and the active file device 2 shown in FIG. A transaction file is stored between the temporary file device 1 and the active file device 2.
A file device 80 is provided. Also active
The file device 2 has an inactive file device 90
Is connected. In the database system management device 88 in such a case, the file devices 1, 2, 8
0 and 90 are managed.

The transaction file device 80
A transaction file control unit 81 connected to the temporary file device 1, the active file device 2, and the database system management device 88 for controlling the transaction file device 80; an image storage unit 82 connected to the unit 81; A memory device 83 connected to the storage unit 82 and the control unit 81 for storing information, and an image search unit 84 connected to the memory device 83 and the control unit 81 and reading information stored in the memory device. Have been.

The inactive file device 90
Is an optical disk management unit 91 connected to the database system management device 88 for managing the inactive file device 90, and the optical disk transport means 9 connected to the management unit 91 and the active file device 2.
2, the optical disk access means 93 connected to the transport means 92, the access means 93 and the management unit 9
1 and an optical disk storage 94 for storing optical disks.

In such a configuration, in a place where the image information from the image generating device 71 is stored in the database system, first, the temporary file device 1 is stored.
Next, when a predetermined period has elapsed, image information based on a predetermined key is transferred to the transaction file control unit 81. In the control unit 81, the image storage unit 82
The information is sent to the memory device 83. The memory device 83 is an erasable storage device whose storage capacity is larger than the storage capacity of the temporary file device 1 and smaller than the storage capacity of the active file device 80. The control of the memory device 83 is performed by the control unit 81.

After a further predetermined period, information is read from the memory device 83 by the image retrieval unit 84 and transferred to the active file device 2 via the control unit 81. Information that has passed a predetermined period in the active file device 2 is transferred to the inactive file device 90.

When the information stored in the memory device 83 is accessed from the terminal 70, the information accessed to the terminal 70 is sent and the temporary file device 1
Is also stored again.

As described above, the erasable storage device is divided into a plurality of hierarchies and stored in a predetermined file device according to the frequency of use, whereby the image reading time can be shortened.

Next, information for which a predetermined period has passed in the active file device is transferred to the inactive file device 90. The inactive file device 90 has a non-erasable storage device, and its storage capacity is larger than that of the active file device.
The file device 90 includes an optical disk storage 94 for storing a plurality of optical disks that are relatively infrequently used among the optical disks of the active file device, an optical disk access means for inserting and removing the optical disk from the storage 94, and an active file storage device. There are an optical disk transport unit 92 that transports the optical disk to the optical disk writing or reading unit of the device 2 and an optical disk management unit 91 that manages the position where the optical disk storing each information is stored.

The optical disk storage 94 stores, for example, 36 rows 1
There are 12 disc boxes arranged in two rows,
Optical disks are taken out one by one by mechanical means.
The taken out optical disk is transferred to the optical disk autochanger 17, and the less frequently used optical disk is transferred to the storage 94 by the autochanger 17.

The database system management device 88 stores file information indicating which file among the files 1, 2, 80 and 90 exists in each information.
Therefore, when information is transferred from a file device to a file device, the file information is rewritten.

The fifth embodiment of the present invention is not limited to the above description, but may be modified in various ways. For example, only either the transaction file device 80 or the inactive file device 90 may be used, or the transaction file device 80 or the inactive file device 90 may be provided in a distributed manner in the network system.

A fifth embodiment will be described with reference to FIGS. 6 and 7. FIG.

The network system of FIG. 6 comprises an optical star coupler 110, a plurality of optical fiber cables 111 connected radially therefrom, and nodes 112-119 connected to the other of the cables 111.
5 and a gateway 130, and between each node, through the optical fiber cable 111 and the star coupler 110, screen information, additional information related to the image information, search information, and those information are appropriately packetized. A procedural order for exchange is transferred.

These nodes 112 to 119 and 125
Are the imaging room 120, the reading room 121, and the imaging room 12, respectively.
2. Ward 123, ward temporary file device 10
0, an active file device 102, an outpatient temporary file device 101, a doctor's office 124, and a database system management device 104. The gateway 130 is connected to another network system (for example, a network system having a database of medical record information) to exchange information.

An electronic endoscope diagnostic apparatus, a nuclear magnetic resonance diagnostic apparatus, and 16 X-ray imaging apparatuses are provided in the imaging room 120. These apparatuses are connected to the node 112, and the image information and the image information are provided. Related additional information (eg, patient number, examination site and method, examination room number, examination device name and number)
Is output via the node 112.

An imaging room 122 is provided with an X-ray imaging diagnostic apparatus (computed radio anthrophy apparatus) using two imaging plates, a nuclear medicine diagnostic apparatus, an ultrasonic diagnostic apparatus, and an X-ray CT apparatus. These devices are connected to the node 114 and the image information and the additional information are transferred to the node 114.
Is output via.

There are 15 reading rooms in the reading room 121, and each room has a terminal device (not shown) capable of displaying images. These terminal devices are connected to the node 111, and information is exchanged via the node 111.

The ward is provided with terminals on buildings A and B from the third floor to the twelfth floor of 123 and is connected to the node 115.

There are 24 clinics in the clinics 124,
A terminal device (not shown) is provided in each doctor's office and is provided at the node 119.
And information exchange is performed.

The temporary file devices are distributed to the temporary file device 100 for hospital wards and the temporary file device 101 for outpatients by type and are connected to the nodes 116 and 118, and the information is stored therein.

The active file device 102 is connected to the node 117 and has two temporary file devices 1
The information from 00 and 101 is stored.

The inactive file device has a non-erasable storage device, and is connected to the active file device 102.

The database system management device 104 is connected to the node 125 and manages the database file devices 100, 101, 102 and 103.

An example of the operation in the hospital management information system as described above will be described below, including the index file 150 shown in FIGS. 7A and 7B.

The symbols shown in the lower column of the index file 150 indicate the type of information stored for each item. All types are fixed length, "9" represents one digit, "999" is three digits, "X (1
2) "represents 12 digits of alphanumeric characters, hiragana, katakana, kanji, special characters, or a combination thereof, and the other characters are also represented in this manner.
“XX” and “X (3)” have the same meaning.

The index file is mainly composed of an image address 151 in which information indicating the position where the image information obtained by one inspection is stored is stored.
The keyword 152 is provided corresponding to the image information, and is divided into a keyword 152 in which additional information related to the image information is stored.

The image address 151 further stores information indicating whether the predetermined image information is stored in the temporary 100, 101 or active 102 or inactive 103 file device into a numeral. A type 153, a file number 154 in which information indicating whether it is a temporary file device for the ward 100 or an outpatient 101 is converted into a number and stored, and a predetermined number of images in each file device. And the address 155 indicating the block number.

The keyword 152 is further divided into a plurality of items, and the patient number (I
D) 156, the individual's name 157 and gender 158 and age 159 and date of birth 160, and an outpatient / hospital 161 that indicates numerically whether the patient is outpatient or hospitalized.
A ward 162 (for example, information input to this ward is “1”
2A07 ", indicating that the patient is at bed number 7 in Building A on the 12th floor) and image address 1
Inspection date 163 and inspection site 1 of the image stored in 51
64, the examination method 165, the conditions 166 at that time, the number of the examination room 167 in which the examination was conducted, the diagnosis name 168 diagnosed by the image, and the confidence of the diagnosis 1
69, the code 170 of the physician who made the diagnosis, the name of the test device 171 that performed the test, and the device number 172
It is made up of

Since the address 155 indicates the position of a block having image information, the detailed position in each image unit is managed by each file itself.

For example, the operation is performed first in the photographing rooms 120 and 12.
2, image information and additional information for diagnosing an outpatient or hospitalized patient from any of the devices in the temporary file device 100 via a network system.
It is transferred to 101. In this case, the outpatient temporary file device 101 is used for outpatients, and the ward temporary file device 100 is used for hospitalized patients.
Are stored separately in the management device 104. Almost simultaneously with the transfer of the image information, a part of the keyword 152 is transferred to the database system management device 104. The transferred keyword 152 is patient number 156, examination date 1
63, inspection site 164 and method 165 and condition 16
6, inspection room 167, inspection device name 171, device number 172
It is.

Items 157-1 of remaining keywords 152
With regard to 62, if the patient number 156 is known, it is retrieved from the chart information via the gateway 130 and the information is obtained, so that information is input. The image address 151 is automatically assigned in the database system management device 104.

Next, in the reading room 121, the temporary
When taking out an image stored from the file devices 100 and 101 and diagnosing the image, a terminal provided in the reading room 121 searches the system management device 104 with a keyword,
Next, a command to transfer image information is sent from the management device 104 to the location of the image address corresponding to the keyword. When the address is the ward temporary file device 100, the image information is transferred from the file device 100 to the searched terminal device in the reading room 121. Almost at the same time, each item of the keyword is sent from the database system management device 104 to the terminal. Then, the doctor looks at the transferred image and inputs the diagnosis name 168, its certainty factor 169, and the doctor code 170 from the terminal. However, there are few disease names that can be determined in current medicine even by looking at several to a dozen or so images sent, and usually, in addition to the image information, the patient's chart information and clinical Diagnosis is made in light of the findings.

Then, necessary image information is divided into unnecessary image information, and only necessary information is left. In addition, the necessary information is edited or filtered to make the best condition for diagnosis, and the image information is again stored in the ward file device 100, and the keywords are the diagnosis name 168, the certainty factor 169, and the doctor code 170. In addition, the management device 10
4 and stored.

For image information for which the image reading room 121, the ward 123, or the medical office 124 is not searched for a predetermined period (for example, three days), the image information is transferred to the active file device 102. At this time, the information of the image address 151 is also rewritten.

Further, the active file device 1
02 is within a predetermined period (for example, 40 days)
If there is no access to the inactive file device 1
Relocated to 03.

Therefore, an image that has not been accessed for a predetermined period (for example, three years) is deleted or manually moved to another storage.

If the information stored in the active file device 102 is accessed within a predetermined period, the information is transferred to either the temporary file device 100 or 101 according to the location of the patient (outpatient or hospitalized), The image information is also transferred to the terminal device accessed almost at the same time. Further, the image address 151 is changed accordingly.

When there is a change in the patient information (for example, outpatient / hospitalization, ward, name) without accessing the image information, the database system management device 1
04 and is changed to new information.

As described above, information that is relatively frequently used by patients who are hospitalized or outpatient is always recorded in the temporary file devices 100 and 101, and the active file device 102 is stored in the file devices 100 and 101. Next, information that is used most frequently is stored. Further, the inactive file 103 stores patient information that is used less frequently than the file device 102. Thus, the access time from the terminal device can be shortened.

The fifth embodiment of the present invention is not limited to FIGS. 6, 7 and the above description, but can be applied to various applications. For example, each file 100, 101, 10
2, 103 are classified according to classification (for example, thoracic surgery, neurosurgery, gastroenterology, psychiatry, ophthalmology), and devices such as X-ray CT, X-ray imaging device, endoscope, and ultrasonic diagnostic device. ). The image address 151 of the file device due to this distribution is given by the file number 154.

Further, the input of the diagnosis name 168 from the terminal is
One type of disease name is not necessarily written, and a plurality of disease names may be input. Accompanying it, the degree of certainty is input as much as the number of the disease names.

Although the first to fifth embodiments of the present invention have been described above, the present invention is not limited to the above-described embodiments, and can be appropriately modified within the scope of the present invention. Needless to say.

[0096]

As described above, according to the present invention, information having a relatively high frequency of use is stored in a storage device having a high access time, and information having a relatively low frequency of use is stored in a storage device having a low access time. The processing efficiency of the database system can be improved.

[Brief description of the drawings]

FIG. 1 is a configuration diagram of a database system showing a first embodiment according to the present invention;

FIG. 2 is a configuration diagram of an index file according to the first embodiment of the present invention;

FIG. 3 is a configuration diagram of a time counter according to a second embodiment of the present invention;

FIG. 4 is a configuration diagram of a database system and a network system according to a third embodiment of the present invention.

FIG. 5 is a configuration diagram of a database system showing a fourth embodiment according to the present invention.

FIG. 6 is a configuration diagram of a hospital database system according to a fifth embodiment of the present invention.

FIG. 7 is a configuration diagram of an index file according to a fifth embodiment of the present invention.

FIG. 8 is a schematic diagram of a network system and a database system according to the related art and the present invention.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 ... Temporary file device 2 ... Active file device 3 ... Database system management device 10 ... Memory module 17 ... Optical disk 7 ... Buffer store unit 13 ... Image compression unit 16 ... Image editing unit 23 ... Joint part 80 ... Transaction file device 90 ... Inactive file device 40,50 ... Address 51 ... Key

 ────────────────────────────────────────────────── ─── Continued on the front page (72) Inventor Seiji Fujimoto 1385-1 Shimoishigami, Otawara-shi, Tochigi Pref.

Claims (1)

[Claims] A first file unit for storing medical image information; a use frequency determining unit for determining a use frequency of the medical image information stored in the first file unit; and storing the medical image information. A second file unit whose access time is slower than the first file unit, and a usage frequency determined by the usage frequency determination unit for the medical image information stored in the first file unit is equal to or less than a predetermined frequency. The medical image information is not stored in the first file means, and is stored in the second file means. The storage control means controls the medical image information to be in the state stored in the second file means. When the image information is not stored in the first file means but is stored in the second file means, the desired information stored in the second file means is stored. And the medical image information relating to the desired medical image information stored in the second file means is also transferred to the search request destination and stored in the first file means. A database system comprising: a search control unit that stores the file in one file unit.