JP3667953B2 - Database reorganization apparatus and computer-readable recording medium - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
  The present invention describes a database reorganization apparatus used in a database for storing records overflowing from the prime area in the overflow area, and a program used for realizing the database reorganization apparatus.RecordBe doneComputer readable recordsIn particular, a database reorganization apparatus that enables efficient reorganization processing of a database according to simple control and a program used to realize the medium are described.RecordBe doneComputer readable recordsWith media.
[0002]
In a database used for insurance business or the like, a large number of records may be generated at a specific business establishment or the like when a larger number of insured persons than the initial assumption are subscribed to the specific business establishment or the like. On the other hand, in the database, a piece of free space is generated by deleting and adding records.
[0003]
From now on, in the database, it is necessary to execute the reorganization process of rearranging records. This reorganization process must be performed without interfering with the performance of the business process, and the access performance is improved. It is necessary to execute it in the form to realize.
[0004]
[Prior art]
In the database, when a record is added to the prime page, the record is stored in the overflow page when there is no free space. Therefore, when a record is added after the record is deleted, a fragmentary free area is generated on the prime page or the overflow page due to the record length. Therefore, a record rearrangement process for organizing the empty area is necessary.
[0005]
Since this record rearrangement process prohibits access to the database required for the business process, conventionally, the record rearrangement process is configured to be executed with the database operation stopped.
[0006]
However, there is a problem that the business process cannot be performed while the record rearrangement process is being performed.
In view of this, the present inventor disclosed in Japanese Patent Laid-Open No. 6-110743, temporarily saved prime page and overflow page records in parallel with business processing, deleted those records, and then saved them. Disclosed an invention of a record rearrangement process in which new records are sequentially packed from a prime page to an overflow page and rearranged.
[0007]
According to the present invention, when the access frequency of the business process to the database is low, the prime page and the overflow page that are not exclusively acquired by the business process are acquired in order from the beginning, and the exclusive page is acquired. By executing the record rearrangement process, a parallel processing of the record rearrangement process and the business process is realized.
[0008]
[Problems to be solved by the invention]
However, the invention disclosed in Japanese Patent Application Laid-Open No. 6-110743 employs a configuration in which the record relocation process is executed by detecting when the access frequency of the business process to the database decreases, so that complicated control is performed. There was a problem that it was necessary.
[0009]
That is, there is a problem that complicated control is required to detect when the access frequency of the business process decreases.
Furthermore, in the invention disclosed in Japanese Patent Laid-Open No. 6-110743, since the prime page is filled with records and the record remains on the overflow page, it is left as it is on the overflow page. There was a problem that the degradation of access performance could not be resolved.
[0010]
That is, the access performance of the overflow page is inferior to the access performance of the prime page, and there is a problem in that the deterioration of the access performance cannot be eliminated by leaving a record on the overflow page.
[0011]
  The present invention has been made in view of such circumstances, and provides a new database reorganization apparatus that allows efficient database reorganization processing to be executed according to simple control, and a program used for realizing the same. RecordRecordBe doneComputer readable recordsThe purpose is to provide a medium.
[0012]
[Means for Solving the Problems]
  In order to achieve this object, the database reorganization apparatus according to the present invention is used in a database that stores records overflowing from the prime area in the overflow area. (1) When accessing a business process, Detection means for detecting whether or not the overflow area of the prime area is greater than or equal to a prescribed size; and (2) whether the immediate mode is selected when the detection means detects that the overflow area has a prescribed size or more. (3) When it is determined that the immediate mode is set, it is detected by the detecting means that the overflow area has a size larger than the specified size. Specified prime area and instructed execution of reorganization, on the other hand, if it is determined that the batch mode is set (4) In response to a reorganization execution instruction issued by the execution means, the detection means detects that the overflow area has a size larger than a prescribed size. Issuing means for issuing a prime area exclusive acquisition request; and (5) when it is determined that the immediate mode is set, and when the prime area is acquired exclusively in response to the issuing of the issuing means. , After evacuating and deleting the record in the overflow area that forms a pair with the prime area, and then rearranging the evacuated record in the prime area, and for the record that cannot be included at that time, newly add one or more records Is created and stored there, while it is determined that the batch mode is set, and the business process ends. The prime area in which the identifier is stored in the storage area is set as a processing target, and the record in the overflow area that forms a pair with the prime area is saved and then deleted, and then the saved record is rearranged in the prime area, and For a record that cannot be received sometimes, one or a plurality of prime areas are newly created, and reorganization means for storing the prime areas is provided.
  In adopting this configuration, the issuing means may issue a prime area exclusive acquisition request while designating a lower priority than the business process.
  The issuing means may issue an exclusive acquisition request for the next prime area on condition that the processing of the reorganization means has been completed.
  Further, when the reorganization process for the previously detected prime area is not completed, the detecting means ignores even if it is detected that the prime area has an overflow area of a predetermined size or more according to the detection process. May be processed as follows.
  Further, when the reorganization processing for the previously issued prime area is not completed, the issuing means may perform processing so as to ignore the prime area when it is detected by the detecting means.
  Here, the functions of each processing means provided to realize the present invention are specifically realized by a program, and this program is stored in a floppy disk or the like, or stored in a disk such as a server. In addition, the present invention is realized by installing from them and operating on the memory.
  In the present invention configured as described above, when the immediate mode is set, the prime area in which the overflow area becomes large is detected in synchronization with the access to the business process, and the priority is lower than the business process. While specifying the degree, execute exclusive acquisition of the prime area, relocate the record with the exclusive area and the overflow area that forms a pair, and when a record remains in the overflow area, A configuration is adopted in which a prime area is created and records are arranged there, thereby executing database reorganization.
  In the present invention, when the collective mode is set, when a prime area where the overflow area becomes large due to extension of business process access is detected, the identifier of the prime area is stored in the storage area. When the business process is completed, the prime area to be processed is relocated to the prime area to be processed and the overflow area that forms a pair and the record is rearranged. By creating prime areas and placing records there, data A configuration for performing base reorganization is adopted.
  In this way, according to the present invention, by setting the immediate mode, the local database reorganization process is executed in conjunction with the access of the business process, so that the business can be performed according to simple control. Database reorganization processing can be executed in parallel with the processing.
  At this time, since the database reorganization process is executed in a form in which no overflow area remains, the database reorganization process capable of improving the access performance can be executed.
  According to the present invention, by setting the batch mode, it is possible to identify the prime area that is the target of the reorganization process without accessing the database at the end of the business process, thereby reorganizing the database. The process can be executed.
  At this time, since the database reorganization process is executed in a form in which no overflow area remains, the database reorganization process capable of improving the access performance can be executed.
[0029]
DETAILED DESCRIPTION OF THE INVENTION
  Hereinafter, the present invention will be described in detail according to embodiments.
  Before describing the embodiment of the present invention, the processing of the present invention when the immediate mode is set will be described according to the principle configuration diagram shown in FIG.
  In FIG. 1, 1 is a database system comprising the present invention, and 2 is one or more business programs that execute business processing by accessing the database system 1.
  The database system 1 includes a database 10, a database management mechanism 11, a detection unit 12, an issue unit 13, a save area 14, and a reorganization unit 15.
  The database 10 is provided in association with the prime area 100, the overflow area 101 for storing records overflowing from the prime area 100, the prime area 100, and the overflow area 101 that forms a pair with the prime area 100. And a page entry type index 102 for managing the keys of the stored records.
  The database management mechanism 11 manages the database 10 and, in response to an access request issued by the business program 2, acquires the prime area 100 and the paired overflow area 101 exclusively, and obtains the exclusive prime area 100 and the overflow area 101 that forms a pair are executed.
  The detecting unit 12 detects whether or not the overflow area 101 of the prime area 100 to be accessed is equal to or larger than a predetermined size when accessing the business process.
  Issuing means 13 obtains exclusive acquisition of prime area 100 that is detected as having overflow area 101 of a prescribed size or larger by detection means 12 to database management mechanism 11 while designating a lower priority than business processing. Issue a request.
  The save area 14 is prepared as a work area for processing by the reorganization means 15 and saves the records in the prime area 100 and the overflow area 101.
  When the prime area 100 is exclusively acquired in response to the issuing process of the issuing means 13, the reorganization means 15 executes the reorganization process on the prime area 100 and the overflow area 101 that forms a pair.
  In the database system 1 having the present invention configured as described above, the detecting means 12 determines whether or not the overflow area 101 of the prime area 100 of the access destination is larger than a prescribed size when accessing the business process. When the detection means detects that the overflow area 101 of the prime area 100 is larger than the prescribed size, the issuing means 13 instructs the database management mechanism 11 to perform business processing. The exclusive acquisition request for the prime region 100 is issued while designating a lower priority.
  Upon receiving this issuance, the database management mechanism 11 gives priority to the exclusive acquisition request issued by the business process, and acquires the exclusive area when the prime area 100 issued by the issuing means 13 has not been exclusively acquired by the business process. Then, the reorganization means 15 is notified.
  In response to this notification, the reorganization means 15 deletes the record in the overflow area 101 that forms a pair with the prime area 100 that has been exclusively acquired, after saving it in the save area 14, and then saves it in the save area 14. Re-arrange the recorded records in the prime area 100, and for those records that cannot be entered at that time, newly open one or a plurality of prime areas 100 and store them there. The database 10 is reorganized by reconfiguring the index 102 provided for the prime region 100.
  When this processing configuration is adopted, the issuing unit 13 sets the next prime area on the condition that the processing of the reorganization unit 15 has been completed in order to prevent the processing requests to the reorganization unit 15 from competing. It is preferable to issue 100 exclusive acquisition requests.
  Further, when adopting this processing configuration, in order to eliminate duplicate processing, the detection means 12 defines the prime region 100 according to the detection processing when the reorganization processing for the previously detected prime region 100 is not completed. If you have an overflow area 101 that is larger than Even if it is detected, it is processed so as to be ignored, or the issuing means 13 detects the prime area 100 by the detecting means 12 when the reorganization processing for the previously issued prime area 100 is not completed. Sometimes it is preferable to process it to ignore it.
  As described above, in the present invention, when the immediate mode is set, the prime area 100 in which the overflow area 101 becomes large is detected in synchronization with the business process access, and the priority is lower than the business process. The exclusive acquisition of the prime area 100 is executed while specifying the degree, and the prime area 100 and the overflow area 101 paired with the exclusive acquisition are rearranged, and the record is stored in the overflow area 101. When the data remains, a new prime area 100 is created and records are arranged there, whereby the database 10 is reorganized.
  Next, the present invention will be described in detail.
  FIG. 2 illustrates one embodiment of a data system 1 comprising the present invention.
[0030]
In the figure, 10 is a database, 20 is a DBMS, 21 is a reorganization program, 22 is a save area, 23 is a startup program, and 24 is a save file.
The database 10 is provided in association with a plurality of prime pages 200 for storing records, an overflow page 201 for storing records overflowing from the prime page 200, and the prime page 200, and a pair of overflows. A page entry type index 202 for managing keys of records stored in the page 201. Here, the index 202 may be provided in an index file different from the database 10.
[0031]
In response to the exclusive acquisition request of the business program 2, the DBMS 20 acquires the prime page 200 and the paired overflow page 201 exclusively, and performs an access process to the prime page 200 and the paired overflow page 201 acquired exclusively. Execute.
[0032]
When storing records in the prime page 200, the DBMS 20 stores records in the overflow page 201 when records cannot be stored in the prime page 200. When deleting records, the DBMS 20 records records by dropping the valid bit. Is deleted. Therefore, as shown in FIG. 3, fragmentary empty areas are generated in the prime page 200 and the overflow page 201.
[0033]
The reorganization program 21 executes reorganization processing on the prime page 200 and the overflow page 201 that forms a pair while saving the record in the save area 22. The activation program 23 controls activation of the reorganization program 21, and is activated immediately or after the end of business processing. The save file 24 stacks the page numbers of the prime pages 200 in response to the storage request from the activation program 23.
[0034]
FIG. 4 shows an example of a processing flow executed by the DBMS 20, FIG. 5 shows an example of a processing flow executed by the activation program 23, and FIGS. 6 to 9 show an example of a processing flow executed by the reorganization program 21. An example is illustrated. Next, according to these processing flows, the present invention will be described in detail.
[0035]
First, a process that the DBMS 20 newly executes for realizing the present invention will be described.
In response to the access request from the business program 2, the DBMS 20 executes access to the prime page 200 and the overflow page 201 that forms a pair, and when the access is completed, the DBMS 20 newly executes the processing flow in FIG. During processing, the prime page 200 having a large number of overflow pages 201 is detected.
[0036]
That is, when the access to the business process is completed, the DBMS 20 first detects the number of overflow pages 201 of the prime page 200 to be accessed in step 1 as shown in the process flow of FIG.
[0037]
Subsequently, in step 2, it is determined whether or not the detected number of overflow pages 201 exceeds a preset specified value, and when it is determined that the number does not exceed, the process is terminated and exceeded. Is determined, it is determined whether or not “reorganization required” is recorded in a flag area (not shown) for the prime page 200.
[0038]
If it is determined in this step 3 that “reorganization required” is recorded in the flag area, the process is terminated, and if it is determined that it is not recorded, the process proceeds to step 4 where “ After recording “reorganization required”, in the following step 5, the prime page 200 is notified to the activation program 23, and the process ends.
[0039]
Here, as described later, the record of “reorganization required” recorded in the flag area is deleted when the reorganization program 21 executes the reorganization processing. Therefore, “reorganization required” is recorded in the flag area means that the reorganization processing for the prime page 200 has not been executed yet.
[0040]
In this way, when the prime page 200 accessed by the business process has an overflow page 201 that exceeds the specified value, the DBMS 20 sets the start program 23 on the condition that the reorganization process for the prime page 200 has not ended. On the other hand, the prime page 200 is notified.
[0041]
Next, processing executed by the activation program 23 will be described.
When the startup program 23 receives the notification of the prime page 200 from the DBMS 20, as shown in the processing flow of FIG. 5A, first, in step 1, the operation mode set by the user (immediately in the reorganization process). Determine whether the immediate mode is in the immediate mode (there is an immediate mode instructing to enter and a collective mode instructing to enter the reorganization process after the completion of the business process). Sometimes, the process proceeds to step 2 to check whether or not the reorganization program 21 is vacant, and when it is not vacant, it waits for it to be vacant.
[0042]
Here, the processing of step 2 is executed because the reorganization program 21 is not available, but when the processing proceeds to the following processing, the reorganization processing cannot be executed, but the prime page 200 and the overflow page 201 are exclusive. This is because it is acquired and the execution of business processing is hindered.
[0043]
When it is detected in this step 2 that the reorganization program 21 is free, the reorganization program 21 is started by specifying the prime page 200 notified from the DBMS 20 while notifying the immediate mode in step 3. The process is terminated.
[0044]
On the other hand, when it is determined in step 1 that the mode is not the immediate mode, that is, when it is determined that the operation mode set by the user is the batch mode, the process proceeds to step 4 to save the prime page 200 notified from the DBMS 20. The file 24 is stacked and the process is terminated.
[0045]
Further, when the business process by the business program 2 is completed, the activation program 23 executes a process for starting the reorganization program 21 while notifying the batch mode as shown in the process flow of FIG.
[0046]
In this way, when the activation program 23 receives the notification of the prime page 200 from the DBMS 20, when the immediate mode is set, the activation program 23 designates the prime page 200 and activates the reorganization program 21, thereby reorganizing. Request processing. When the batch mode is set, the prime page 200 is stacked on the storage file 24, and when the business process is completed, the reorganization program 21 is started to request the reorganization process.
[0047]
In addition, while waiting for the reorganization program 21 to become free, the prime page 200 may be notified from the DBMS 20 one after another. At this time, the activation program 23 takes a configuration of queuing them and requests the reorganization program 21 to perform reorganization processing in order while waiting for the reorganization program 21 to be free. .
[0048]
Next, processing executed by the reorganization program 21 will be described.
When the reorganization program 21 is activated from the activation program 23, the reorganization process is performed on the prime page 201 detected by the DBMS 20 by executing the processing flow of FIGS. 6 to 9.
[0049]
That is, when the reorganization program 21 is activated from the activation program 23, as shown in the processing flow of FIGS. 6 to 9, first, in step 1, the operation mode notified from the activation program 23 is the immediate mode. When determining whether the current mode or the batch mode and determining that the current mode is the immediate mode, the process proceeds to step 2 and designates a lower priority than the business process, while the DBMS 20 is instructed from the startup program 23. An exclusive acquisition request for the notified prime page 200 and the paired overflow page 201 is issued, and in step 3, it waits for this exclusion to be acquired.
[0050]
When the exclusive acquisition is detected in step 3, subsequently, in step 4, as shown in FIG. 10, the records of the prime page 200 and overflow page 201 acquired exclusively are saved in the save area 22. As shown in FIG. 11, the records of the prime page 200 and the overflow page 201 are deleted.
[0051]
Subsequently, in step 6, as shown in FIG. 12, the record saved in the save area 22 is rearranged on the prime page 200 acquired exclusively. That is, the records saved in the save area 22 are rearranged in the key order so that no empty area is generated in the prime page 200.
[0052]
Subsequently, when it is determined in step 7 whether or not the overflow page 201 is required in the rearrangement process in step 6 and it is determined that the overflow page 201 is not required, that is, all the prime pages 200 are included. When it is determined that the record can be rearranged, the process proceeds to step 8 where the index 202 provided in association with the prime page 200 is optimized, and in the subsequent step 9, the overflow page 201 that has been used is changed. At the same time, the record of the above “reorganization necessary” recorded in the flag area by the DBMS 20 is deleted, and the process is terminated.
[0053]
On the other hand, when it is determined in step 7 that the overflow page 201 is required in the relocation processing in step 6, that is, it is determined that all the records saved in the save area 22 in the prime page 200 cannot be relocated. To proceed to step 10 (processing flow in FIG. 7), one or a plurality of new prime pages 200 that can be stored are created, and in step 11 the record that could not be stored is added to the new page. Are arranged in the key order on the created prime page 200.
[0054]
Subsequently, in step 12, the index 202 is reconfigured in accordance with the increase of the prime page 200, and in the subsequent step 13, the overflow page 201 used so far is returned, and the DBMS 20 records in the flag area. The “reorganization required” record is deleted, and the process is terminated.
[0055]
In this way, when the user has set the immediate mode, the reorganization program 21 detects a prime page 200 having an overflow page 201 that exceeds the specified value by extension of business process access. The priority page 200 and the overflow page 201 are exclusively acquired while giving priority to the business process, the prime page 200 is created as necessary, and the reorganization process is executed while returning the overflow page 201.
[0056]
In accordance with the reorganization processing of the reorganization program 21, for example, as shown in FIG. 13, the database 10 uses a prime page 200 to manage records such as insured persons for each sales office such as an insurance company. When there are a large number of records at sales office C, a reorganization process is performed during the business process. As a result, the prime pages 200 of sales office C increase, and the records are re-recorded on those prime pages 200. Since the index 202 of the sales office C is reconfigured in accordance with the arrangement, high-speed access performance is realized. Here, P shown in the figure represents a prime page 200, and O represents an overflow page 201.
[0057]
On the other hand, the reorganization program 21 proceeds to step 14 (process flow of FIG. 8) when determining that the operation mode of the collective mode is notified from the activation program 23 in step 1 of the process flow of FIG. The page number of the prime page 200 on which the activation program 23 is stacked is read from the saved file 24. Here, as described in the processing flow of FIG. 5B, this batch mode is notified in synchronization with the end of the business process.
[0058]
Subsequently, in step 15, one page number is selected from the page numbers of the prime page 200 read from the save file 24. In step 16, it is determined whether or not all page numbers have been selected. When it is determined that all the page numbers have been selected, the process ends.
[0059]
On the other hand, when it is determined in step 16 that selection of all page numbers has not been completed, that is, when it is determined that one unprocessed prime page 200 has been selected, the process proceeds to step 17 to select the DBMS 20. The exclusive acquisition request of the prime page page 200 and the overflow page 201 to be paired is issued, and in the subsequent step 18, it waits for this exclusion to be acquired. Here, since the business process has been completed, this exclusive acquisition may be performed by specifying any priority.
[0060]
When the exclusive acquisition is detected in step 18, subsequently, in step 19, as shown in FIG. 10, the records of the prime page 200 and overflow page 201 acquired exclusively are saved in the save area 22. As shown in FIG. 11, the records of the prime page 200 and the overflow page 201 are deleted.
[0061]
Subsequently, in step 21, as shown in FIG. 12, the records saved in the save area 22 are rearranged on the prime page 200 that has been exclusively acquired. That is, the records saved in the save area 22 are rearranged in the key order so that no empty area is generated in the prime page 200.
[0062]
Subsequently, in step 22, when it is determined whether or not the overflow page 201 is required in the rearrangement process in step 20, it is determined that the overflow page 201 is not required, that is, all the prime pages 200 are included. When it is determined that the next record can be rearranged, the process proceeds to step 23 where the index 202 provided in association with the prime page 200 is optimized, and in the subsequent step 24, the overflow page 201 that has been used so far is changed. After returning, the process returns to step 15 to proceed to the next prime page 200 process.
[0063]
On the other hand, when it is determined in step 22 that the overflow page 201 is required in the relocation processing in step 21, that is, it is determined that all records saved in the save area 22 in the prime page 200 cannot be relocated. When proceeding to step 25 (processing flow in FIG. 9), one or more new prime pages 200 that can be stored are created, and in step 26, the record that could not be stored Are arranged in the key order on the created prime page 200.
[0064]
Subsequently, in step 27, the index 202 is reconfigured in accordance with the increase in the number of prime pages 200, and in the subsequent step 28, the overflow page 201 used so far is returned, and then processing of the next prime page 200 is performed. Return to Step 15 to proceed to.
[0065]
In this way, when the user is set to the collective mode, the reorganization program 21 detects the prime page 200 having the overflow page 201 exceeding the specified value by extension of the business process access, and those prime pages 200 are detected. When the business processing is completed, the prime page 200 and the paired overflow page 201 are selected in order, and the prime page 200 is created as necessary. Meanwhile, the reorganization process is executed while returning the overflow page 201.
[0066]
According to this configuration, whether or not there is a prime page 200 to be reorganized even if the database 10 is not accessed at the end of the business process, and which prime page 200 is present when it exists. Therefore, the reorganization processing of the database 10 can be executed efficiently.
[0067]
The DBMS 20 employs a configuration for detecting a prime page 200 having an overflow page 201 that is greater than or equal to a specified value by extension of business process access. From now on, when the business processes accessing the prime page 200 are concentrated, the prime page 200 is detected by the DBMS 20 many times before the reorganization process for the prime page 200 is executed. Become.
[0068]
Therefore, as shown in the processing flow of FIG. 4, the DBMS 20 once again detects the prime page 200 that has been detected as having the overflow page 201 exceeding the specified value until the reorganization processing by the reorganization program 21 is completed. A configuration is adopted to prevent detection. With this function, it is possible to control so that reorganization processing requests for the same prime page 200 do not continue when operating in the immediate mode.
[0069]
This function can be provided not only in the DBMS 20 but also in the startup program 23.
In other words, when the DBMS 20 detects a prime page 200 having an overflow page 201 that exceeds the prescribed number as a result of the extension of business process access, the DBMS 20 displays the prime page 200 regardless of whether or not the reorganization process for the prime page 200 has ended. A configuration in which the activation program 23 is designated and activated is adopted.
[0070]
Then, in accordance with this configuration, the startup program 23 adopts a configuration for recording the prime page 200 that has issued a reorganization processing request to the reorganization program 21, and executes the reorganization processing. While the record is not erased, the same prime page 200 notified from the DBMS 20 is ignored.
[0071]
As a result, it is possible to control so that reorganization processing requests for the same prime page 200 do not continue.
In the above-described embodiment, according to the operation mode (immediate mode and batch mode) set by the user, the reorganization process is executed during the business process or the reorganization process is executed after the business process is completed. Although the configuration is adopted, it is also possible to adopt a configuration in which this is dynamically controlled due to the reason that the overflow pages 201 increase.
[0072]
For example, when the cause of the increase in the overflow page 201 is due to the increase in the number of records, for example, control is performed so that the reorganization process is executed after the end of the business process. For example, the cause is due to the increase in the record length. In such a case, for example, it is possible to adopt a configuration in which control is performed so that reorganization processing is executed during business processing.
[0073]
【The invention's effect】
  As described above, in the present invention,By setting the immediate mode,When the business process is accessed, synchronize with it, detect the prime area where the overflow area becomes large, specify the priority lower than the business process, execute exclusive acquisition of the prime area, and acquire the exclusive area The records are rearranged for the prime area and the overflow area that forms a pair, and when a record remains in the overflow area, a new prime area is created and the record is placed there. The composition which performs organization is taken.
[0074]
  Thus, according to the present invention,By setting the immediate mode,A local database that is linked to business process access.OfBy executing the reorganization process, the database is executed in parallel with the business process according to simple control.OfThe reorganization process can be executed.
[0075]
  According to the present invention, when the database reorganization process is executed in parallel with the business process, the database reorganization process is executed in a form that does not leave an overflow area. Database reorganization processing that can realize improvement can be executed.
  Further, in the present invention, when the prime area where the overflow area becomes large due to the extension of the business process access is detected by setting the collective mode, the prime area identifier is stored in the storage area, and the business process is taken. Is completed, the prime area to be processed and the overflow area paired with the prime area to be processed are rearranged, and when a record remains in the overflow area, a new prime area is set. By creating and placing records there, we adopt a configuration to reorganize the database.
  In this way, according to the present invention, by setting the batch mode, it is possible to identify the prime area that is the target of the reorganization process without accessing the database at the end of the business process. The organization process can be executed.
  According to the present invention, when adopting a configuration in which the database reorganization process is executed at the end of the business process, the database reorganization process is executed in a form that does not leave an overflow area, thereby improving access performance. Database reorganization processing can be executed.
[Brief description of the drawings]
FIG. 1 is a principle configuration diagram of the present invention.
FIG. 2 is an example of the present invention.
FIG. 3 is an explanatory diagram of DBMS processing;
FIG. 4 is an example of a processing flow executed by a DBMS.
FIG. 5 is an example of a processing flow executed by a startup program.
FIG. 6 is an example of a processing flow executed by a reorganization program.
FIG. 7 is an example of a processing flow executed by a reorganization program.
FIG. 8 is an example of a processing flow executed by a reorganization program.
FIG. 9 is an example of a processing flow executed by the reorganization program.
FIG. 10 is an explanatory diagram of processing executed by the reorganization program.
FIG. 11 is an explanatory diagram of processing executed by the reorganization program.
FIG. 12 is an explanatory diagram of processing executed by the reorganization program.
FIG. 13 is an explanatory diagram of a reorganization process.
[Explanation of symbols]
1 Database system
2 business programs
10 Database
11 Database management mechanism
12 Detection means
13 Issuing means
14 Evacuation area
15 Reorganization means

Claims (6)

In a database reorganization apparatus used in a database that stores records overflowing from the prime area in the overflow area,
Detecting means for detecting whether or not the overflow area of the prime area of the access destination is equal to or larger than a predetermined size when accessing the business process;
A determination means for determining whether the immediate mode or the batch mode is set when the detection means detects that the overflow area has a predetermined size or more;
When it is determined that the immediate mode is set, the above-mentioned detection means designates a prime area detected as having an overflow area of a prescribed size or more and instructs execution of reorganization. Execution means for storing the identifier of the prime area in the storage area when it is determined that the mode is set;
In response to the reorganization execution instruction, issuing means for issuing an exclusive acquisition request for the prime area detected by the detecting means as having an overflow area of a prescribed size or more,
In the case where it is determined is set in the immediate mode, when the prime region in response to the issuance of the upper Symbol issuing means is exclusion acquisition, saving a record of the overflow area forming the prime region and pairs And then relocating the evacuation record to the prime area, and for records that cannot be entered at that time, newly create one or more prime areas and store them there. In the case where it is determined that the batch mode is set, when the business process ends, the prime area where the identifier is stored in the storage area is set as a processing target, and the prime area and the pair overflow The records in the area are evacuated and then deleted, and then the evacuated records are relocated to the prime area and the records that cannot be filled at that time are recorded. For creates a new one or more prime regions, further comprising a rearrangement unit that stores therein,
Feature database reorganization device. The database reorganization apparatus according to claim 1, wherein
The issuing means issues a prime area exclusive acquisition request while specifying a lower priority than the business process.
Feature database reorganization device. The database reorganization apparatus according to claim 1 or 2,
The issuing means, on condition that the process of the reorganization unit has ended, to issue exclusion acquisition request next prime area,
Feature database reorganization device. In the database reorganization apparatus according to claim 1, 2, or 3,
When the reorganization process for the previously detected prime area is not completed, the detecting means ignores even if it is detected that the prime area has an overflow area of a predetermined size or more according to the detection process. To process
Feature database reorganization device. In the database reorganization apparatus according to claim 1, 2, or 3,
The issuing means, when the reorganization process for prime areas previously issued has not been completed, to also be treated to ignore it when said prime area is detected by said detection means,
Feature database reorganization device. A computer-readable recording medium on which the program is recorded to be used to realize the database reorganization apparatus used in database storing overflow record from the prime region to the overflow area,
A detection process for detecting whether or not the overflow area of the prime area of the access destination is greater than or equal to a prescribed size when accessing the business process;
A determination process for determining whether the immediate mode or the batch mode is set when it is detected by the detection process that the overflow area has a predetermined size or more;
When it is determined that the immediate mode is set, a prime area detected as having an overflow area of a specified size or more by the above detection process is specified and execution of reorganization is instructed. An execution process for storing the identifier of the prime area in a storage area when it is determined that the mode is set;
In response to the reorganization execution instruction, an issuance process for issuing an exclusive acquisition request for a prime area that is detected as having an overflow area of a predetermined size or more by the detection process;
In the case where it is determined is set in the immediate mode, when the prime region in response to the issuance of the upper Symbol issuing process is exclusively acquired, saving a record of the overflow area forming the prime region and pairs And then relocating the evacuation record to the prime area, and for records that cannot be entered at that time, newly create one or more prime areas and store them there. In the case where it is determined that the batch mode is set, when the business process ends, the prime area where the identifier is stored in the storage area is set as a processing target, and the prime area and the pair overflow The records in the area are evacuated and then deleted, and then the evacuated records are relocated to the prime area and the records that cannot be filled at that time are recorded. For, the newly created one or more prime regions, a program for executing a reorganization process in a computer for storing therein are recorded,
A computer-readable recording medium.

Images