JP7304916B2 - Auxiliary control device, control device and database system - Google Patents

Description

The present invention relates to an auxiliary management device, management device and database system.

2. Description of the Related Art In recent years, the amount of data accumulated in a database system tends to increase as the use of data in corporate activities becomes more active. For example, as a technique for improving the efficiency of storage areas in a database system, a technology has been proposed in which each node shares information about storage areas in which data is no longer needed in each database node through inter-node communication (for example, Patent Document 1: and Non-Patent Document 1).

JP-A-2005-339236

Sohan DeMel, "Oracle9i real Application Clusters-Cache Fusion Delivers Scalability, An Oracle White Paper," Oracle Corporation, May 2001, pp. 7-9, 12-13.

However, in the conventional technology, for example, communication between nodes may occur frequently, and other processes may be delayed due to communication between nodes.

SUMMARY OF THE INVENTION It is an object of the present invention to provide an auxiliary management device, a management device, and a database system capable of suppressing delays in other processes while effectively utilizing the storage area of the database system. With the goal.

In order to solve the above-described problems and achieve the object, an auxiliary management device according to the present invention includes a specifying section and a transmitting section. The identifying unit scans a predetermined storage area in the database and identifies an unnecessary area. The transmission unit transmits unnecessary area information, which is a collection of information related to the unnecessary area, to the database management device when the transmission condition related to the unnecessary area specified by the specifying unit is satisfied.

According to the present invention, delays in other processes can be suppressed while effectively using the storage area of the database system.

FIG. 1 is a diagram illustrating an example of information processing according to an embodiment. FIG. 2 is a block diagram illustrating a configuration example of a management device according to the embodiment; FIG. 3 is a block diagram illustrating a configuration example of an auxiliary management device according to the embodiment; FIG. 4 is a schematic diagram illustrating an example of an exclusive area according to the embodiment; FIG. 5 is a flowchart illustrating a processing procedure executed by the management device according to the embodiment; FIG. 6 is a flowchart illustrating a processing procedure executed by an auxiliary management device according to the embodiment; FIG. 7 is a flowchart illustrating a processing procedure executed by an auxiliary management device according to the embodiment; FIG. 8 is a hardware configuration diagram showing an example of a computer that implements the functions of the management device according to the embodiment.

Embodiments for implementing the auxiliary management device, management device, and database system according to the present application (hereinafter referred to as "embodiments") will be described in detail below with reference to the drawings. The auxiliary management device, management device, and database system according to the present application are not limited to this embodiment.

[Embodiment]
[1. information processing]
First, an example of information processing according to the embodiment will be described with reference to FIG. FIG. 1 is a diagram illustrating an example of information processing according to an embodiment.

As shown in FIG. 1, the database system 1 according to the embodiment includes a management device 10, a plurality of auxiliary management devices 50, and a storage 100. FIG. The management device 10 corresponds to the master node in the database, and the auxiliary management device 50 corresponds to the slave node in the database. For example, the management device 10 and the auxiliary management device 50 are connected via a predetermined network.

Each database node determines which database node is to be the master node or which is to be the slave node based on predetermined definition information, for example. That is, the management device 10 can also function as the auxiliary management device 50 , and the auxiliary management device 50 can function as the management device 10 . Further, for example, database nodes serving as the management device 10 or the auxiliary management device 50 are added as appropriate as their processing loads increase.

The management device 10 is a management device that collectively manages information that requires synchronization in the entire database system 1 . Further, the auxiliary management device 50 synchronizes the information aggregated by the management device 10 at a predetermined timing.

In addition, the management device 10 and the auxiliary management device 50 each perform I/O (Input/Output) processing to the storage 100 in response to the user's inquiry request, thereby performing inquiry processing corresponding to the inquiry request. Execute.

Note that, for example, the management device 10 can read/write the storage 100 , and the auxiliary management device 50 can only read the storage 100 .

The storage 100 is a shared disk type storage that shares a storage area with a plurality of database nodes. That is, the management device 10 and the auxiliary management device 50 can independently access the storage.

The storage 100 is a so-called write-once type storage, and when data is updated, the updated data area is added to the unupdated data area, and the unupdated data is invalidated with a deletion flag.

In the write-once type storage, since the data history is held together with the deletion flag, there is an advantage that the data update history management is facilitated. On the other hand, in the write-once type storage, since data is updated and unnecessary data is permanently stored in the storage, there is a problem in efficient use of the storage area.

Therefore, in the database system 1 according to the embodiment, an unnecessary area for storing unnecessary data is collected and reused to achieve efficient use of the storage area. Further, in the database system 1 according to the embodiment, by minimizing the number of inter-node communications regarding unnecessary areas, delays in other processes executed in each node (management device 10 and auxiliary management device 50) can be suppressed. I decided to plan.

For example, as shown in FIG. 1, in the database system 1 according to the embodiment, the auxiliary management device 50 identifies unnecessary areas in the storage 100 by scanning storage areas in the storage 100 (step S01).

For example, the example shown in FIG. 1 shows a case where auxiliary management device 50 scans the storage area for data #1 to data #4 and identifies the area in which data #1 is stored as an unnecessary area.

For example, the auxiliary management device 50 scans storage areas in the storage 100 and identifies storage areas with deletion flags as unnecessary areas. For example, the auxiliary management device 50 writes information about the specified unnecessary area into its own unnecessary area information storage unit.

Subsequently, the auxiliary management device 50 determines whether or not the transmission condition regarding the unnecessary area is satisfied (step S02). When the auxiliary management device 50 determines that the transmission condition is met, the auxiliary management device 50 transmits unnecessary area information, which is a collection of information about unnecessary areas, to the management device 10 (step S03). Then, the management apparatus 10 stores the unnecessary area information received from each auxiliary management apparatus 50 in the aggregated information storage unit, thereby collectively managing the unnecessary area information.

Here, for example, the transmission condition is that the number of specified unnecessary areas exceeds a predetermined determination threshold as a result of scanning. That is, the auxiliary management device 50 does not transmit information about unnecessary areas to the management apparatus 10 each time an unnecessary area is specified, but transmits information about a certain number of unnecessary areas to the management apparatus 10 as unnecessary area information.

As a result, unnecessary area information can be centrally managed by the management device 10 while suppressing the number of inter-node communications between the management device 10 and the auxiliary management device 50 . For example, the management device 10 can effectively use the storage 100 by reusing (for example, updating) the unnecessary area based on the collected unnecessary area information.

As described above, in the database system 1 according to the embodiment, the auxiliary management device 50 identifies an unnecessary area in the storage 100 and transmits information about the identified unnecessary area to the management device 10 after the transmission condition is established.

Therefore, in the database system 1 according to the embodiment, it is possible to effectively utilize the storage area of the storage 100 while suppressing delays in other processes.

[2.1. Configuration example of management device]
Next, a configuration example of the management device 10 according to the embodiment will be described with reference to FIG. 2 . FIG. 2 is a block diagram showing a configuration example of the management device 10 according to the embodiment. As shown in FIG. 2 , the management device 10 has a control section 20 and a storage section 30 .

The storage unit 30 is realized by, for example, a semiconductor memory device such as a RAM or a flash memory, or a storage device such as a hard disk or an optical disk. The storage unit 30 also has an integrated information storage unit 31 and a transmission condition storage unit 32 .

The integrated information storage unit 31 is a storage area that stores integrated information obtained by integrating unnecessary area information transmitted from each auxiliary management device 50 . For example, the integrated information stored in the integrated information storage unit 31 is used by the management device 10 to identify unnecessary areas.

The transmission condition storage unit 32 is a storage area that stores transmission conditions for transmitting integrated information stored in the integrated information storage unit 31 . For example, in the management device 10, when such a transmission condition is established, the integrated information is synchronized with each auxiliary management device.

The control unit 20 is, for example, a controller, and various programs stored in a storage device inside the management device 10 are executed by a CPU (Central Processing Unit), an MPU (Micro Processing Unit), etc., using the RAM as a work area. It is realized by being executed.

As shown in FIG. 2 , the control unit 20 has a request reception unit 21 , a request execution unit 22 , an unnecessary area information reception unit 23 , an integrated information transmission unit 24 and an input/output processing unit 25 .

The request accepting unit 21 receives an inquiry request from a user to the database system 1 and passes information on the inquiry request to the request execution unit 22 . The request execution unit 22 executes processing related to inquiry requests received by the request execution unit 22 .

For example, the request executing unit 22 executes processing related to the inquiry request by calling the input/output processing unit 26 that issues I/O processing to the storage 100 based on the inquiry request acquired from the request accepting unit 21. . Note that the request executing unit 22 corresponds to an example of an updating unit that updates data stored in the unnecessary area based on the unnecessary area information received by the unnecessary area information receiving unit 23 .

For example, when the inquiry request is an update request to update "data #1" with "data #2", the request execution unit 22 attaches a deletion flag to data #1 and treats data #2 as new data. The input/output processing unit 26 is instructed to add.

In this case, the request execution unit 22 refers to the integrated information storage unit 31 and instructs the input/output processing unit 26 to add “data #2” to the unnecessary area. As a result, the data in the unnecessary area is overwritten with the new data, and the unnecessary area can be reused, so that the storage 100 can be used effectively. Since an unnecessary area overwritten with new data is excluded from unnecessary areas, the request executing unit 22 deletes the unnecessary area to which new data is added from the integrated information storage unit 31 .

The unnecessary area information receiving unit 23 receives unnecessary area information about unnecessary areas from each auxiliary management device 50 . For example, the unnecessary area information receiving unit 23 writes to the integrated information storage unit 31 each time unnecessary area information is received. That is, the unnecessary area information receiving unit 23 generates integrated information by integrating the unnecessary area information received from each auxiliary management device 50 .

The integrated information transmitting unit 24 transmits integrated information obtained by integrating unnecessary area information to each auxiliary management device 50 . For example, when the transmission condition stored in the transmission condition storage unit 32 is satisfied, the integrated information transmission unit 24 reads the integrated information from the integrated information storage unit 31 and transmits it to each auxiliary management device 50 .

The transmission condition here is, for example, whether or not the number of unnecessary areas integrated as integrated information exceeds a threshold. That is, the integrated information transmitting unit 24 compares the number of unnecessary areas with a threshold value, determines that the transmission condition is satisfied when the number of unnecessary areas exceeds the threshold value, and transmits the integrated information to all the auxiliary management devices 50. Send to

The transmission condition is not limited to the above example, and may be, for example, the case where the data volume of the unnecessary area exceeds a predetermined threshold, or the case where a predetermined transmission cycle has been reached. Further, for example, when the transmission condition is satisfied, the unnecessary area information is reacquired from all the auxiliary management devices 50, the integrated information is newly generated, and the generated integrated information is transmitted to the auxiliary management device 50. can be

[2.2. Configuration example of auxiliary management device]
Next, a configuration example of the auxiliary management device 50 will be described with reference to FIG. FIG. 3 is a block diagram showing a configuration example of the auxiliary management device 50 according to the embodiment. In the example shown in FIG. 3 , the auxiliary management device 50 includes a control section 60 and a storage section 70 .

The storage unit 70 is realized by, for example, a semiconductor memory device such as a RAM or flash memory, or a storage device such as a hard disk or an optical disk. The storage unit 70 has a scan area information storage unit 71 , an unnecessary area information storage unit 72 , an integrated information storage unit 73 and a transmission condition storage unit 74 .

The scan area information storage unit 71 is a storage unit that stores information about scan areas for specifying unnecessary areas in the auxiliary management device 50 . For example, an exclusive area, which is a storage area different from the storage areas scanned by other auxiliary management devices 50, is stored in the scan area information storage unit 71 as a scan area.

That is, in the database system 1 , the processing load of each of the auxiliary management devices 50 is distributed by sharing the scanning of the storage 100 among the plurality of auxiliary management devices 50 . Note that the scan area is not limited to the exclusive area, and may overlap partially or entirely. Alternatively, the scan area may be set by excluding part of the storage 100 .

Also, the scan area set in each auxiliary management device 50 may be changed according to a predetermined condition. For example, in this case, the scan area may be determined by the auxiliary management device 50, and in this case, the other auxiliary management devices 50 may be notified of the scan area set by itself.

Further, for example, the auxiliary management device 50 may scan more scan areas when there are more processing resources, such as when there are few accesses within a predetermined period. Also, the scan area may be set according to other predetermined rules.

The unnecessary area information storage unit 72 is a storage area that stores information about unnecessary areas. For example, the unnecessary area information storage unit 72 stores information about unnecessary areas specified by the specifying unit 63, which will be described later.

The integrated information storage unit 73 is a storage unit that stores integrated information generated by the management device 10 . That is, the integrated information generated by the management device 10 holds the same data in each auxiliary management device 50 . The transmission condition storage unit 74 is a storage unit that stores information regarding the transmission conditions of the unnecessary area information.

The control unit 60 is, for example, a controller, and various programs stored in a storage device inside the auxiliary management device 50 are stored in the RAM as a work area by means of a CPU (Central Processing Unit), MPU (Micro Processing Unit), or the like. It is realized by executing as

As shown in FIG. 3, for example, the control unit 60 includes a request receiving unit 61, a request executing unit 62, a specifying unit 63, an unnecessary area information transmitting unit 64, an integrated information receiving unit 65, an input/output processing unit 66.

The request reception unit 61, the request execution unit 62, and the input/output processing unit 66 have the same functions as the request reception unit 21, the request execution unit 22, and the input/output processing unit 25 shown in FIG. By accessing the storage 100 based on the integrated information stored in the integrated information storage unit 73, the request executing unit 62 can, for example, suppress access to unnecessary areas.

The identifying unit 63 scans a predetermined storage area in the storage 100 and identifies unnecessary areas. For example, the identifying unit 63 identifies the unnecessary area by scanning the storage area at a predetermined timing and detecting an unnecessary flag associated with the data.

For example, the specifying unit 63 refers to the scan area information storage unit 71, reads out its own scan area, and scans the scan area. FIG. 4 is a schematic diagram illustrating an example of an exclusive area according to the embodiment;

For example, as shown in FIG. 4, by dividing the storage area of the storage 100 into a plurality of areas and allocating them to the respective auxiliary management apparatuses 50, the scan areas Sa1 to San of the auxiliary management apparatus 50 are determined.

Further, as shown in FIG. 4, each of the scan areas Sa1 to San is an exclusive area that exists independently, so each auxiliary management device 50 scans a different scan area. Thereby, the unnecessary area can be specified efficiently.

The identifying unit 63 writes information about the identified unnecessary area as a result of scanning the scan area into the unnecessary area information storage unit 72 (see FIG. 3). Note that, for example, the specifying unit 63 may determine the frequency of scanning according to the update frequency of the scan area.

For example, the identifying unit 63 may shorten the cycle of unnecessary area identifying processing when a request for an update query such as an update occurs in the scan area. That is, for example, when an update is performed, the frequency of data update increases, and accordingly the frequency of generation of unnecessary areas also increases.

Therefore, the specifying unit 63 can specify the unnecessary area in a relatively short time after the occurrence of the unnecessary area by specifying the unnecessary area at a frequency determined according to the update frequency of the scan area. Note that the information about the update frequency can be transmitted from the management device 10 to the auxiliary management device 50 as appropriate, for example.

Returning to the description of FIG. 3, the unnecessary area information transmitting section 64 will be described. The unnecessary area information transmitting unit 64 transmits unnecessary area information, which is a collection of information related to unnecessary areas, to the management device 10 when the transmission conditions related to the unnecessary areas specified by the specifying unit 63 are satisfied.

For example, the unnecessary area information transmitting unit 64 transmits the unnecessary area information stored in the unnecessary area information storing unit 72 to the management device 10 when the transmission condition stored in the transmitting condition storing unit 74 is satisfied.

The transmission conditions here include, for example, the case where the number of unnecessary areas reaches a threshold value, the case where the unnecessary area information transmission cycle is reached, and the like. That is, when the number of unnecessary areas specified by the specifying unit 63 reaches a predetermined number, the unnecessary area information transmitting unit 64 transmits unnecessary area information including information on the unnecessary areas to the management device 10 .

Further, for example, the unnecessary area information transmitting unit 64 transmits the unnecessary area information to the management device 10 when the unnecessary area information transmission period is reached. In this case, for example, the unnecessary area information transmitting section 64 may cause the specifying section 63 to perform unnecessary area specifying processing at the timing when the transmission cycle is reached.

In this manner, the unnecessary area information transmitting unit 64 does not transmit information each time an unnecessary area is specified, but waits until the transmission condition is satisfied before transmitting. As a result, it is possible to reduce the communication frequency of inter-node communication, thereby reducing the delay of tasks being executed by the management device 10 due to inter-node communication.

The integrated information receiving unit 65 receives integrated information about unnecessary areas generated by the management device 10 . For example, integrated information receiving portion 65 updates the data stored in integrated information storage portion 73 using the received integrated information.

[3. Processing flow]
Next, a processing procedure of the management device 10 according to the embodiment will be described with reference to FIG. FIG. 5 is a flow chart showing a processing procedure executed by the management device 10 according to the embodiment. Note that the processing procedure described below is executed by the control unit 20 of the management device 10 .

As shown in FIG. 5, when receiving the unnecessary area information (step S101), the management device 10 generates integrated information based on the received unnecessary area information (step S102). Subsequently, the management device 10 determines whether or not the conditions for transmitting the integrated information are satisfied (step S103). If it is determined that the conditions for transmission are satisfied (step S103: Yes), In response, the integrated information is transmitted (step S104), and the process ends.

If the management device 10 determines in step S103 that the transmission condition is not met (step S103: No), it omits the processing in step S104.

Next, a processing procedure executed by the auxiliary management device 50 according to the embodiment will be described with reference to FIGS. 6 and 7. FIG. 6 and 7 are flowcharts showing processing procedures executed by the auxiliary management device 50 according to the embodiment.

As shown in FIG. 6, the auxiliary management device 50 first identifies an unnecessary area (step S201), and then determines whether or not the transmission condition is satisfied (step S202). When the auxiliary management device 50 determines that the transmission condition is satisfied (step S202; Yes), the auxiliary management device 50 transmits the unnecessary area information to the management device 10 (step S203), and ends the process.

Further, when the auxiliary management device 50 determines that the transmission condition is not met (step S202; No), the process of step S203 is omitted.

In the example shown in FIG. 7, the auxiliary management device 50 first determines whether or not the transmission cycle of the unnecessary area information has arrived (step S211). When the auxiliary management device 50 determines that the transmission cycle has arrived (step S211; Yes), it identifies an unnecessary area (step S212).

Subsequently, the auxiliary management device 50 transmits unnecessary area information regarding the specified unnecessary area to the management device 10 (step S213), and ends the process. If the auxiliary management device 50 determines in step S211 that the transmission cycle has not arrived (step S211: No), it ends the process.

[4. Modification]
In the above-described embodiment, for example, the case where each auxiliary management device 50 scans the inside of the storage 100 at a predetermined timing has been described, but the present invention is not limited to this. For example, the timing of scanning by the auxiliary management device 50 may be determined such that the timing of scanning is different from each other. In this case, all of the auxiliary management devices 50 may perform scanning in different time zones. good too.

Further, for example, the size of the exclusive area and the timing of scanning may be specified by a predetermined operator. When the operator gives an instruction, the auxiliary management device 50 to which the instruction is directed may scan, and the management device 10 may transmit the integrated information.

[5. effect〕
The auxiliary management device 50 according to the above-described embodiment scans a predetermined storage area in the storage 100 (an example of a database) to identify unnecessary areas. and an unnecessary area information transmitting unit 64 (an example of a transmitting unit) that transmits unnecessary area information, which is a collection of information about unnecessary areas, to the database management device 10 when the above is established. Therefore, according to the auxiliary management device 50 according to the embodiment, it is possible to effectively utilize the storage area of the database system 1 while suppressing delays in other processes.

Further, the specifying unit 63 according to the embodiment scans an exclusive area, which is a storage area different from the storage areas scanned by other auxiliary management devices 50 . Therefore, according to the auxiliary management device 50 according to the embodiment, the unnecessary area can be specified efficiently.

Further, the unnecessary area information transmitting unit 64 according to the embodiment transmits unnecessary area information to the management device 10 when the number of unnecessary areas specified by the specifying unit 63 reaches a predetermined number. Therefore, according to the auxiliary management device 50 according to the embodiment, it is possible to reduce the number of inter-node communications associated with the transmission and reception of unnecessary space information.

Further, the unnecessary area information transmitting unit 64 according to the embodiment transmits the unnecessary area information to the management apparatus 10 when the unnecessary area information transmission period is reached. Therefore, according to the auxiliary management device 50 according to the embodiment, it is possible to reduce the number of inter-node communications associated with the transmission and reception of unnecessary space information.

Further, the identification unit 63 according to the embodiment identifies unnecessary areas with a frequency determined according to the update frequency of the scanned storage area. Therefore, according to the auxiliary management device 50 according to the embodiment, the unnecessary area can be identified at appropriate timing.

In addition, the specifying unit 63 according to the embodiment scans the storage area in the write-once database and detects an unnecessary flag associated with the data stored in the storage area, thereby specifying the unnecessary area. Therefore, according to the auxiliary management device 50 according to the embodiment, the unnecessary area can be specified with high accuracy.

Further, the auxiliary management device 50 according to the embodiment includes an integrated information reception unit 65 (an example of a reception unit) that receives integrated information obtained by integrating unnecessary area information transmitted from a plurality of auxiliary management devices in the management apparatus 10, and and an integrated information storage unit 73 for storing the integrated information received by the information receiving unit 65 . Therefore, according to the auxiliary management device 50 according to the embodiment, it is possible to synchronize integrated information.

Further, the auxiliary management device 50 according to the embodiment has a request execution unit 62 that accesses the database based on the integrated information and executes a request. Therefore, according to the auxiliary management device 50 according to the embodiment, the request can be properly executed.

Also, the request execution unit 62 according to the embodiment accesses a database that can be independently accessed by each of the plurality of auxiliary management devices 50 . Therefore, according to the auxiliary management device 50 according to the embodiment, each auxiliary management device 50 can independently execute a request.

The management device 10 according to the embodiment also includes an unnecessary area information receiving unit 23 (an example of a receiving unit) that receives unnecessary area information about an unnecessary area in which unnecessary data is stored in the database from the auxiliary management apparatus 50 of the database. , and a request execution unit 22 (an example of an update unit) that updates data stored in the unnecessary area based on the unnecessary area information received by the unnecessary area information receiving unit 23 .

Further, the database system 1 according to the embodiment scans a predetermined storage area in the database, specifies the unnecessary area, and when the transmission conditions regarding the unnecessary area specified by the specifying unit 63 are satisfied, the unnecessary An auxiliary management device 50 that includes an unnecessary area information transmission unit 64 (an example of a transmission unit) that transmits unnecessary area information, which is a collection of information about areas, to the management apparatus 10 of the database; and a management device 10 including a request execution unit 22 (an example of an update unit) that updates data stored in the unnecessary area based on the area information.

[6. Hardware configuration]
Also, the management apparatus 10 according to the above-described embodiments is implemented by a computer 1000 configured as shown in FIG. 8, for example. FIG. 8 is a hardware configuration diagram showing an example of a computer that implements the functions of the management device 10 according to the embodiment. Computer 1000 has CPU 1100 , RAM 1200 , ROM 1300 , HDD 1400 , communication interface (I/F) 1500 , input/output interface (I/F) 1600 and media interface (I/F) 1700 .

The CPU 1100 operates based on programs stored in the ROM 1300 or HDD 1400 and controls each section. The ROM 1300 stores a boot program executed by the CPU 1100 when the computer 1000 is started up, a program depending on the hardware of the computer 1000, and the like.

The HDD 1400 stores programs executed by the CPU 1100, data used by the programs, and the like. Communication interface 1500 receives data from other devices via network (communication network) N, sends the data to CPU 1100, and transmits data generated by CPU 1100 to other devices via network N. FIG.

Through an input/output interface 1600, the CPU 1100 is connected to an output device such as a display and a printer, and an input device such as a keyboard and a mouse (in FIG. 8, the output device and the input device are collectively referred to as "input/output device" ). CPU 1100 acquires data from an input device via input/output interface 1600 . CPU 1100 also outputs the generated data to an output device via input/output interface 1600 .

Media interface 1700 reads programs or data stored in recording medium 1800 and provides them to CPU 1100 via RAM 1200 . CPU 1100 loads such a program from recording medium 1800 onto RAM 1200 via media interface 1700, and executes the loaded program. The recording medium 1800 is, for example, an optical recording medium such as a DVD (Digital Versatile Disc) or a PD (Phase change rewritable disc), a magneto-optical recording medium such as an MO (Magneto-Optical disk), a tape medium, a magnetic recording medium, or a semiconductor memory. etc.

For example, when the computer 1000 functions as the management device 10 according to the embodiment, the CPU 1100 of the computer 1000 implements the functions of the control unit 130 by executing programs loaded on the RAM 1200 . The CPU 1100 of the computer 1000 reads these programs from the recording medium 1800 and executes them, but as another example, these programs may be acquired via the network N from another device.

As described above, some of the embodiments of the present application have been described in detail based on the drawings. It is possible to carry out the invention in other forms with modifications.

[7. others〕
Further, among the processes described in the above embodiments and modifications, all or part of the processes described as being performed automatically can be performed manually, or described as being performed manually. All or part of the processing can also be performed automatically by a known method. In addition, information including processing procedures, specific names, various data and parameters shown in the above documents and drawings can be arbitrarily changed unless otherwise specified. For example, the various information shown in each drawing is not limited to the illustrated information.

Also, each component of each device illustrated is functionally conceptual, and does not necessarily need to be physically configured as illustrated. In other words, the specific form of distribution and integration of each device is not limited to the one shown in the figure, and all or part of them can be functionally or physically distributed and integrated in arbitrary units according to various loads and usage conditions. Can be integrated and configured.

Also, the above-described embodiments and modifications can be appropriately combined within a range that does not contradict the processing content.

Also, the above-mentioned "section, module, unit" can be read as "means" or "circuit". For example, the request reception unit 61 can be read as request reception means or a request reception circuit.

1 Database system 10 Management device 21 Request reception unit 22 Request execution unit 23 Unnecessary area information reception unit 24 Integration information transmission unit 25 Input/output processing unit 31 Integration information storage unit 32 Transmission condition storage unit 50 Auxiliary management device 61 Request reception unit 62 Request Execution unit 63 Identification unit 64 Unnecessary area information transmission unit 65 Integration information reception unit 66 Input/output processing unit 71 Scan area information storage unit 72 Unnecessary area information storage unit 73 Integration information storage unit 74 Transmission condition storage unit

Claims (10)

an identification unit that scans a predetermined storage area in the database and identifies an unnecessary area;
a transmitting unit configured to transmit unnecessary area information, which is a collection of information related to the unnecessary area, to the database management device when a transmission condition related to the unnecessary area specified by the specifying unit is satisfied ;
The identification unit
Identifying the unnecessary area with a frequency determined according to the update frequency of the storage area to be scanned
An auxiliary management device characterized by: The identification unit
2. The auxiliary management device according to claim 1, wherein an exclusive area that is said storage area different from said storage area scanned by another said auxiliary management apparatus is scanned. The transmission unit
The auxiliary management device according to claim 1 or 2, wherein the unnecessary region information is transmitted to the management device when the number of the unnecessary regions identified by the identification unit reaches a predetermined number. The transmission unit
4. The auxiliary management device according to claim 1, 2 or 3, wherein the unnecessary area information is transmitted to the management device when a transmission cycle of the unnecessary area information is reached. The identification unit
The unnecessary area is identified by scanning the storage area in the write - once database and detecting an unnecessary flag associated with the data stored in the storage area. An auxiliary management device according to one. a receiving unit that receives integrated information obtained by integrating the unnecessary area information transmitted from the plurality of auxiliary management devices in the management device;
The auxiliary management device according to any one of claims 1 to 5 , further comprising an integrated information storage unit that stores the integrated information received by the receiving unit. 7. The auxiliary management device according to claim 6 , further comprising a request execution unit that accesses said database based on said integrated information and executes a request. The request execution unit
8. The auxiliary management device according to claim 7 , wherein a plurality of said auxiliary management devices each independently access said accessible database. a receiving unit for receiving unnecessary area information about an unnecessary area in which unnecessary data is stored in a database from an auxiliary management device of the database;
an updating unit that updates data stored in the unnecessary area based on the unnecessary area information received by the receiving unit ;
The receiving unit
receiving from the auxiliary management device the unnecessary area information about the unnecessary area identified at a frequency determined according to the update frequency of the storage area scanned by the auxiliary management device;
A management device characterized by: an identification unit that scans the storage area at a frequency determined according to the update frequency of a predetermined storage area in the database and identifies an unnecessary area;
a transmission unit configured to transmit unnecessary area information, which is a collection of information related to the unnecessary area, to the management apparatus of the database when a transmission condition related to the unnecessary area specified by the specifying unit is satisfied;
A database system, comprising: a management device comprising: an update unit that updates data stored in the unnecessary area based on the unnecessary area information received from the plurality of auxiliary management apparatuses.

Images