JPH06161843A - Relational data base managing system - Google Patents

Abstract

PURPOSE:To reduce external storage capacity for a relational data base and to shorten processing time for storing/retrieving the relational data base concerning the relational data base managing system for constructing the relational data base by using image data. CONSTITUTION:When storing/retrieving the large capacity of image data such as images as the relational data base, it is judged by compression and extension judging means 14 and 16 whether the data to be the object of storage/retrieval processing inputted from a relational data base operating means 11 or retrieved from an image data relational data base 13 are analyzed and compressed/ extended or not and based on the judgement, compressing and extending means 15 and 17 compress and extends the data.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a relational database management system which is a data management technique for performing data storage / storage / processing / editing / searching processing using a computer. The present invention relates to a relational database management system that makes a relational database.

[0002]

2. Description of the Related Art FIG. 6 is a functional conceptual diagram showing a configuration of a conventional relational database management system that handles image data, and FIG. 6 is a flow chart for explaining the operation contents of the relational database management system shown in FIG. Is.

In FIG. 6, a conventional relational database management system includes a relational database operating means 11 described in a database language for instructing what processing is to be performed on the relational database, and a relational database operating means 11 A relational database management means 12 for storing / searching data in a relational database in response to a request from the relational database management means 12 and a relational database 13 composed of data to be processed by the relational database management means 12.

The operation of the conventional relational database management system configured as described above will be described with reference to the drawings. In FIG. 5, the processing request to the relational database according to the purpose such as storage / retrieval of data is
The relational database operating means 11 gives an instruction to the relational database managing means 12.
For example, when a data storage process is requested, the stored image data and the storage instruction are delivered to the relational database management means 12.

Relational database management means 12
Then, based on the processing request from the relational database operating means 11, the storage / search processing is performed with respect to the relational database to be processed. For example, when a search process is requested, the relational database management means 12 delivers the data retrieved from the relational database 13 to the relational database operation means 11.

The processing of the above relational database management system will be described in more detail with reference to the flowchart of FIG. First, a processing request to a relational database according to a purpose such as data storage / retrieval is described in a database language, and the request content is instructed to the relational database management means 12 by the relational database operation means 11 ( Step 41). Relational database management means 12
Then, it is determined whether the content of the request instructed by the relational database operating means 11 is a storage process or a search process (step 42). When storage processing is requested, the relational database management means 12 performs input processing of stored data from the relational database operation means 11 (step 43) and stores the stored data in the target relational database to be processed (step 43). 44). When a search process is requested, the relational database management means 12 retrieves the target data from the relational database 13 (step 45) and delivers the retrieved data to the relational database operation means 11 (step 4).
6).

[0007]

The conventional relational database management system is configured as described above. Therefore, the data that can be handled by the conventional relational database management system is compressed / compressed regardless of whether it is character data or image data. Since only normal data that is not expanded is used, when converting image data, which has a larger capacity than character data, to a relational database, the external storage capacity for the relational database increases, and the large amount of those There is a problem that the processing time for storing / retrieving a large amount of image data is increased, and the performance of the storage / retrieval processing is deteriorated due to this.

The present invention has been made to solve the above problems, and it is possible to construct a relational database using image data, and to reduce the external storage capacity for the relational database. The objective is to obtain a relational database management system that can reduce the storage / search processing time of a relational database.

[0009]

In order to achieve the above object, a relational database management system according to a first aspect of the present invention is a database language for operating a relational database composed of image data according to a processing purpose. From the relational database operating means described in, the relational database managing means for receiving and storing the data in the relational database in response to the request from the relational database operating means, and the relational database to be processed by the relational database managing means. In this relational database management system, the relational database management means analyzes data to be stored / retrieved to determine whether or not to compress / expand it. A constant section, and further comprising a compression and expansion means for performing compression and decompression of data in accordance with the determination of the compression and decompression judging means.

A relational database management system according to a second aspect of the present invention comprises a relational database operating means written in a database language for operating a relational database consisting of image data according to a processing purpose, and a relational database operating means. Is a relational database management means for storing / searching data in a relational database in response to the request, and a relational database to be processed by the relational database management means. Compress data according to a predetermined mode during storage / retrieval processing
It is characterized by comprising a compression / expansion determining means for determining whether or not to perform expansion, and a compression / expansion means for performing compression / expansion processing in accordance with an instruction from the compression / expansion determining means.

[0011]

Therefore, according to the relational database management system of the first aspect of the present invention, the compression / expansion determination means of the relational database management means is input from the relational database operation means or stored in the relational database retrieved. -A large amount of image data is compressed because the data subject to search processing is analyzed to determine whether to compress or decompress, and the compression / decompression means performs data compression / decompression processing based on that determination. -By expanding, the external storage capacity for the relational database can be reduced and the storage / search processing time of the relational database can be shortened.

Further, according to the relational database management system of the second invention, in the case where the type of data input from the outside is fixed in advance, when the input data is character data, the mode in which compression / decompression is not performed is performed. In the case of image data, a mode for performing compression / expansion is selected and preset in the compression / expansion determining means of the relational database management means, so that the compression / expansion determining means can perform compression / expansion based on the mode held by the compression / expansion determining means. The decompression means compresses / decompresses the data to be stored / retrieved that is input from the outside, so the external storage capacity for the relational database is reduced by compressing / decompressing a large amount of image data. The processing time for storing / searching relational databases can be shortened.

[0013]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENT A preferred embodiment of the present invention will be described below with reference to the drawings. FIG. 1 is a functional conceptual diagram showing the configuration of a relational database management system that handles image data according to this embodiment, and FIG. 2 is a diagram for explaining the operation contents of the relational database management system of this embodiment shown in FIG. It is a flowchart. In the figure,
The same or corresponding parts as those of the conventional relational database management system are designated by the same reference numerals and the description thereof will be omitted.

Example 1. In FIG. 1, the relational database management system according to the present embodiment includes a relational database operating means 11 described in a database language for instructing what processing is to be performed on the relational database and a relational database operating means 11. The relational database management means 18 for storing / searching data in the relational database in response to the request of (1) and the relational database 13 composed of data to be processed by the relational database management means 18 are comprised.

Relational database management means 18
From the relational database operating means 11 according to the judgment of the compression judgment means 14 and the judgment of the compression judgment means 14 for judging whether or not the data stored in the relational database 13 is to be compressed. Compressing means 15 for compressing stored data
And a decompression determination means 16 for analyzing the search data obtained by searching the relational database 13 and determining whether or not to decompress, and a decompression means 17 for decompressing the search data according to the determination of the decompression determination means 16. The relational database management means 12 has a storage / search means similar to the relational database management means described in the prior art.

The operation of the relational database management system of the present embodiment configured as described above will be described with reference to the drawings. In FIG. 1, a processing request to a relational database such as data storage / retrieval is instructed by the relational database operating means 11 to the relational database managing means 18. The relational database management means 18 stores / searches the relational database to be processed based on the processing request from the relational database operation means 11.

For example, when a data storage process is requested by the relational database operation means 11, the compression determination means 14 of the relational database management means 18 analyzes the stored data received from the relational database operation means 11 and compresses it. If it is determined that the compression is necessary, the compression unit 15 compresses the stored data. When a search process is requested, the relational database management means 18 retrieves the corresponding data from the relational database 13, and the decompression determination means 16 analyzes the retrieved data to determine whether or not to decompress. When the decompression determining unit 16 determines that decompression is necessary, the decompressing unit 17 decompresses the search data.

The storage / retrieval process of the above relational database management system will be described in more detail with reference to the flowchart of FIG. First, a processing request to a relational database according to a purpose such as storage / retrieval of data is described in a database language, and the request content is instructed to the relational database management means 18 by the relational database operation means 11 ( Step 51). The relational database management means 18 determines whether the content of the request instructed by the relational database operation means 11 is a storage process or a search process (step 52).

When it is determined that the storage processing is requested, the relational database management means 18 performs the input processing of the stored data from the relational database operating means 11 (step 53), and the compression determination means 14 analyzes the stored data. It is determined whether compression is required (step 54). That is, the compression determination means 1
4 indicates that when the stored data is data such as image data that needs to be compressed due to data analysis, or more simply, when the stored data has an identifier that indicates that the stored data needs to be compressed, the stored data It is determined that compression of is necessary. When the compression determination unit 14 determines that the compression is necessary, the stored data is output to the compression unit 15, and the compression unit 15 compresses the stored data (step 55). Compression means 15
The stored data that has been compressed by is stored and stored in the same way as the relational database management means described in the prior art.
It is stored in the relational database 13 via the relational database management means 12 having a retrieval means (step 56).

When the retrieval process is requested, the relational database management means 18 retrieves the target data from the relational database 13 (step 57), and the decompression determination means 16 analyzes the retrieved data and decompresses it. Is determined (step 58). That is, the decompression determination means 16 determines whether or not the search data is data that has been compressed and stored, such as image data, by analyzing the data based on an identifier or the like added to the stored data. When the decompression determining unit 16 determines that the decompression is necessary, the search data is output to the decompressing unit 17, and the decompressing unit 17 decompresses the search data (step 59).
The search data expanded by the expanding means 17 is delivered to the relational database operating means 11 (step 60).

Next, the relational database management means 18 of this embodiment described above will be further described with reference to FIG. FIG. 3 is a functional conceptual diagram for explaining the configuration of the relational database management means 18 and the flow of data to be stored / retrieved. As shown in the figure, the stored data 21 to be stored is first input to the compression determination means 14, and the compression determination means 14 analyzes the received stored data 21 to determine whether or not compression is required. To do. When the compression determination unit 14 determines that the compression is necessary, the stored data 21 is output to the compression unit 15, but when it is determined that the compression is not necessary, the compression unit 15 is bypassed and directly stored in the storage unit 19. Is output. The stored data 21 input to the compression unit 15 is compressed by the compression unit 15 and stored as compressed data 22 in the storage unit 1.
9 and stored in the relational database 13 by the storage means 19.

Further, the target search data 23 retrieved from the relational database 13 by the retrieval means 20 is inputted to the expansion determination means 16. The decompression determination means 16 analyzes the search data 23 and determines whether or not decompression is necessary based on the identifier or the like added to the stored data 23. When the decompression determining unit 16 determines that the decompression is necessary, the search data 23 is output to the decompressing unit 17, and the decompressing unit 17 decompresses the search data 23. The decompressed data 24 decompressed by the decompressing means 17 is delivered to the relational database operating means 11. On the other hand, when the decompression determining unit 16 determines that the decompression is unnecessary, the search data 23 bypasses the decompressing unit 17 and is directly output to the relational database operating unit 11.

Example 2. The relational database management system according to the first embodiment determines whether to analyze and compress or decompress the data that is input from the relational database operating means or retrieved from the relational database and that is the target of the storage / retrieval process. Although it has been described that the determination is made and the compression / decompression means performs the data compression / decompression processing based on the determination, the necessity of compression / decompression may be determined using another means. For example, if the type of data that is input from the outside is fixed in advance, select a mode that does not perform compression / expansion if the input data is character data and a mode that performs compression / expansion if it is image data. By presetting in the compression / expansion determining means of the relational database management means, the compression / expansion processing of the data to be stored / retrieved is performed based on the mode held by the compression / expansion determining means, It is also possible to compress and decompress a large amount of image data.

FIG. 4 is a functional conceptual diagram showing the configuration of the second relational database management system of this embodiment which is used in the case where the type of data input from the outside in advance is fixed.

In FIG. 4, the second relational database management system of the present embodiment is a relational database operating means 11 written in a database language for operating a relational database consisting of image data according to a processing purpose, and a relational database operating means 11. The relational database management unit 25 is configured to receive a request from the database operation unit to store / search data in the relational database and the relational database 13 to be processed by the relational database management unit. Follows the instructions of the compression / expansion decision means 26 for deciding whether to compress / expand data according to a predetermined mode at the time of storage / retrieval processing and the instruction of the compression / expansion decision means 26. The compressing means 15 for compressing the received data, the decompressing means 17 for decompressing the search data retrieved from the relational database 13 according to the instruction of the compression / expansion determining means 26, and the relational database management described in the prior art. Storage similar to the means
It comprises a relational database management means 12 having a search means.

The operation of the second relational database management system of the present embodiment configured as described above will be described. First, the relational database management system shown in FIG. 4 exchanges data with a terminal application program via, for example, a communication network, and processing data input / output between the relational database management system and the terminal application program. Whether is image data that requires compression or character data that does not require compression depends on the type of application program running on the terminal. That is, the data type of the data to be stored / retrieved by the second relational database management system is fixed depending on which application program is operating on the terminal.

In such a communication system, prior to a processing request to the relational database 13 such as storage / retrieval of data from the terminal application program, the application program on the terminal first sends processing data to the relational database management means 25. Set the type of. That is, if the data to be processed is image data that requires compression, the compression mode is instructed, and if the data to be processed is character data that does not require compression, the non-compression mode is instructed. To do. Then, the compression / expansion determination means 26 of the relational database management means 25 stores the mode set by the terminal application program.

After the compression mode / non-compression mode of the processing data is set in the compression / expansion determining means 26, a processing request for the relational database 13 from the terminal application program to the relational database management means 25 is sent via the communication network. The relational database operating means 11 receives and the request content is instructed to the relational database managing means 25 by the relational database operating means 11. The relational database management unit 25 determines whether the content of the request instructed by the relational database operation unit 11 is a storage process or a search process.

When it is determined that the storage processing is requested, the relational database management means 25 receives the stored data transferred from the terminal application program and requires compression according to the processing mode stored in the compression / expansion determination means 26. It is determined whether to do. When the compression / expansion determining unit 26 determines that the compression is necessary, the stored data is output to the compression unit 15, and the compression unit 1
5, the stored data is compressed. Compression means 1
The stored data compressed by 5 is stored in the relational database 13 via the relational database management means 12 having a storage / search means.

When the retrieval process is requested, the relational database management means 25 retrieves the target data from the relational database 13 and decompression is required based on the processing mode stored by the compression / decompression determination means 26. Or not. When the compression / expansion determining unit 26 determines that the expansion is necessary, the search data is output to the expansion unit 17, and the expansion unit 1
7, the search data expansion process is performed. Extension means 1
The search data expanded by 7 is delivered to the terminal application program through the relational database operating means 11 and the communication network.

FIG. 5 is a block diagram of a communication system using the above-mentioned second relational database management system. In the figure, the communication system of the present embodiment is
The second relational database management system 3
0, a communication line network 33 connecting the computer system 30, and communication terminals 34, 3 connected to the communication line network 33.
5, the computer system 30 includes a relational database management system 32 having a communication control means for communicating with the communication network 33 and a relational database management means, and an image data storage / search processing target by the relational database management system 32. And a relational database 31 that becomes The communication terminal 34 includes a relational database operating means 36 and a decompressing means 37, and the communication terminal 35 includes a relational database operating means 36 and a compressing means 38.

The operation of the communication system of this embodiment configured as described above is almost the same as that described in the second relational database management system. That is, the application programs operating on the communication terminals 34 and 35 firstly perform the relational database management system 3 prior to processing requests to the relational database 13 such as storage / retrieval of image data.
The type of processing data is set for 2. In particular,
The image data compression processing is performed by the compression means 3 of the communication terminal 35.
Since the processing is performed by the CPU 8, even if the data to be processed is image data that requires compression, the non-compression mode is instructed. Next, the communication terminal 35 transfers the command and the compressed image data to the relational database management system 32 via the compression unit 38, the relational database operation unit 36, and the communication network 33 in order to request the image data storage process. The relational database management system 32 receives the compressed data transferred from the terminal application program, and stores it in the relational database 31 via the relational database management means having a storage / search means.

When a search process is requested, the communication terminal 34 uses the relational database management system 32.
The relational database management system 32 retrieves the target data from the relational database 31 and transfers it to the communication terminal 34 via the communication network 33. Relational database operating means 36 of the communication terminal 34 that receives the compressed image data
Is decompressed by the decompression means 37 and delivered to the terminal application program.

[0034]

As described above, according to the relational database management system of the present invention, when a large amount of image data such as an image is stored / retrieved as a relational database, the data to be stored / retrieved. The compression / expansion means is configured to perform data compression / expansion processing based on the judgment of whether or not to compress / expand the data, so that the external storage capacity for the relational database is reduced. There is an effect that the storage / search processing time of the relational database can be shortened.

Further, according to the relational database management system of the present invention, since the compression / expansion determining means is provided in the relational database managing means, the compression / expansion determining means is individually provided to the terminal application program of the relational database. There is an effect that it is not necessary to provide and complexity can be eliminated.

Further, according to the relational database management system of the present invention, when the type of data input from the outside is fixed in advance, in the case of character data depending on the type of input data, the non-compression mode is set and the image data is set. In this case, the compression mode is selected, preset in the compression / expansion determining means of the relational database management means, and the compression / expansion means is input from the outside based on the mode held by the compression / expansion determining means. -Since it is configured to perform compression / expansion processing of the data to be searched, if the communication terminal of the communication system has data compression / expansion means, the compressed / expanded data is used to create a relational database. This shortens the transmission time in the communication network and efficiently reduces the external storage capacity and data There is an effect that can shorten the storage and retrieval processing time to the nest.

[Brief description of drawings]

FIG. 1 is a functional conceptual diagram showing the configuration of a relational database management system that handles image data according to the present embodiment.

FIG. 2 is a flowchart for explaining the operation contents of the relational database management system of this embodiment.

FIG. 3 is a functional conceptual diagram for explaining a configuration of relational database management means of the present embodiment and a flow of data to be stored / retrieved.

FIG. 4 is a functional conceptual diagram showing a configuration of a second relational database management system of the present embodiment.

FIG. 5 is a block diagram of a communication system using a second relational database management system.

FIG. 6 is a functional conceptual diagram showing a configuration of a conventional relational database management system that handles image data.

FIG. 7 is a flowchart for explaining the operation contents of a conventional relational database management system.

[Explanation of symbols]

11, 36 Relational database operation means 12, 18, 25 Relational database management means 13, 31 Relational database 14 Compression determination means 15, 38 Compression means 16 Decompression determination means 17, 37 Decompression means 19 Storage means 20 Retrieval means 21 Stored data 22 Compression Data 23 Search data 24 Decompression data 26 Compression / decompression determining means 30 Computer system 32 Relational database management system 33 Communication network 34, 35 Communication terminal

Claims (2)

[Claims] 1. A relational database operating means written in a database language for operating a relational database consisting of image data according to a processing purpose, and storing data in the relational database in response to a request from the relational database operating means. In a relational database management system including a relational database management unit that performs a search process and a relational database that is a processing target of the relational database management unit, the relational database management unit analyzes the data that is the target of the storage / search process. A compression / decompression determining means for determining whether or not to compress / decompress, and a compression / decompression processing for performing data compression / decompression processing according to the determination of the compression / decompression determining means
A relational database management system characterized by having a decompression means. 2. A relational database operating means written in a database language for operating a relational database consisting of image data according to a processing purpose, and storing data in the relational database in response to a request from the relational database operating means. In a relational database management system including a relational database management unit that performs a retrieval process and a relational database that is a processing target of the relational database management unit, the relational database management unit stores the data according to a predetermined mode during the storage / retrieval process. compression·
A relational database management system comprising: compression / expansion determining means for determining whether or not to perform expansion; and compression / expansion means for performing compression / expansion processing according to an instruction from the compression / expansion determining means.