JPS584437A - Expanding system of prime region - Google Patents

Abstract

PURPOSE:To ensure the effective use of an overflow region, by using the overflow region as an expanded region of a prime region. CONSTITUTION:When an applied program 3 issues a storage instruction, a storage macro 4 is called out. The macro 4 requests the acquisition of a writing space to a writing space acquiring part 5 for prime. The writing space acquiring part for prime 5 reads out the contents of a prime region control block. A writing space acquiring part 6 for expanded prime secures an expanded region of the prime region within an overflow (OVF) region by referring to the overflow region control block and replaces a pointer. The presence or absence of an idle physical page of the prime region is checked successively for the part 5, an OVF writing space acquiring part 7 under use and an OVF writing space acquiring part 8 respectively. When an idle page exists, the record stored in a user interface is written into the acquired writing region.

Description

DETAILED DESCRIPTION OF THE INVENTION The present invention provides an extension of the overflow area that can be used as an extension area of the prime area in a database system having a range or subrange having a prime area and an overflow area. Regarding the system, the range or subrange of the database is divided into a prime area and an over 70-area, and for example, the owner record is written in the gut area. When designing a database, it is generally a good idea to estimate the amount of space required for the prime area, but in reality, there are cases where the prime area is all used.Normally, in such cases, etiliity is used. However, it is desirable to be able to continue operations while the expansion work is being carried out. Therefore, as a database, over 7a is used as a spare storage area.
- An area is provided. However, in the prior art, this overflow area was only used as a temporary extension of the logical page, and was not used to extend the grime area.

The present invention is based on the above considerations.

In a database where the range or subrange has a prime region and an over 4 region,
The present invention relates to a prime area O expansion method that can be used as an expansion area of the area T and time areas. Therefore, the expansion method of the Gutsim area of the present invention has a plurality of pages, and the pa
In the over 7 area, which has an over 7a area control block on the first page that manages the yso area, and the over 7 area control block that contains multiple pages and manages the ASDF area in the prime area, and the above 70 area Expanded prime area control block that points to the page meeting most recently acquired for the prime area $2 for writing the above data to the above prime area with reference! A prime write space acquisition unit that checks whether or not the own area exists and acquires a write space for writing the above data if a free space exists, and a prime write space acquisition unit that writes the above data to the above prime area When the write space cannot be obtained, it is checked whether or not the data can be written in the extended area of one prime area in the overflow area, and if it can be written, the data is written in the extended area of the prime area. Obtain a writing space for writing, and if you cannot write, use the above oats (
an extended prime write space acquisition unit that refers to a flow area control block meeting and allocates a new page as an extended area of the above-mentioned short time area, and updates the contents of the extended prime area control block and the contents of the overflow area control block; This will be explained with reference to the following one wing sound chart mt, which is the characteristic of the tIIl/l characteristic.

FIG. 1 is a diagram showing the structure of the range or sub-range and the relationship between the range or sub-range and the slave master in the present invention. In FIG. 1, 1 is a storage section assigned to a range or subrange, 2 is a key-rt-
Each of the O storage units 1 shown has a prime area and an oat (flow area).The prime area is provided with an extended prime area control program, a prime area control program, and the like. The expansion region control block points to the latest physical page acquired as a region within the overflow region, and the region control block indicates how far the prime region is used. The overflow control button indicates how far the flow area has been used.The overflow control button indicates how far the flow area has been used. The prime area controller indicates from where to where the prime area is.

Rattan 2m11 is a functional block diagram showing one embodiment of the present invention. In Figure 2, 3 is an application program.

4 indicates the store macro, S indicates the prime write space acquisition section, 6 indicates the expanded prime write space acquisition section, 7 indicates the used OVF write space acquisition section, and 8 indicates the 0VF write space acquisition section. Note that the same reference numerals as in FIG. 1 indicate the same items. OVF means overflow.

゛) When the application preprogram 3 issues a store command, the store macro 4 is called. Store iri 4t! ,
Perform the following treatment tube.

U) Determining the size of the record to be stored (B) Examine the attributes of the record to be stored from schema 2 and find the storage means.

After the above processing is performed, the 0 prime write space acquisition unit 5, which requests the prime write space acquisition 1!5 to acquire a write space, retrieves specific data from the store ψ macro.・When asked to obtain an area for writing to a type (for example, owner record), the prime area controller is referenced to find the position of the prime area control block, and the contents of the prime area control block are read out.0 prime area If there is free space, the entire ninth area for writing the owner record in the free space is secured. If there is no space in the prime area to write the owner's code, the prime write space acquisition unit 5 requests the extended prime write space acquisition unit 116 to acquire the write space.◎For extended grime The writing space acquisition section 6 obtains the positions of the expansion area control pre-loader and the over-70-area controller from the prime area controller and the over 70-area controller. -Refer to the area control block and allocate it in the overflow area of the prime area's expansion area, and change the pointer. 〇The prime write space is obtained and the logical page PK, e.g. member record group, is written. If a request is made to collect an area for a page, it is checked whether there is a physical page p/K free space (corresponding to a logical page P) in the prime area. If there is space, so*yii page P
Obtain the ninth area to write the member record to .

If there is no free space on the physical page P'.

Prime writing space acquisition@sFi requests the OvF writing space acquisition unit 7 for a-drug OvF writing space acquisition. The used OVF write space acquisition unit 7 finds a physical page in the over 70 area linked to the logical page P', and if the physical page PIK is free, writes a member record in that physical page. If there is no free space in the zero object ring page Pl to be acquired, the in-use OVF writing space accumulation unit 7 stores the OVF
A request is made to the writing space acquisition 118 to acquire a writing space. The OvF write space SS refers to the over 70-area control block and obtains a new physical page P# for the logical page P. notifies store macro 4. Store macro 4 writes the RAID tube that has been acquired and stored in the user interface area into the good write area.

FIG. 3 Fi shows the processing flow of the extended prime write space acquisition unit 6.

■ Store in free space in the record tube expansion prime area.

■ Check whether storage has been completed. If it is ONo, perform the processing in ■.

■ , t-/<70- Check whether there is a free page in the over 70- area by controlling 9F E1 ◎Y-
If so, proceed with ■, and if N・, proceed with ■.
I do.

■ First empty page P1 and over 7m = link 1 disconnected from control plant, next empty page I and over 7m
0-Control block tube link! Yes ■ Report the occurrence of an error as there is no storage space O ■ Register the page number of the empty page P in the extended prime control block 〇■ Store the record in the empty page P (extended prime area).

Figure 4 shows the page structure. Figure 4 (a)
is the first page of the prime area, Figure 4 ←) is over 7G
"-The first page of the area, Figure 4 shows the configuration of other normal pages. The first page of the prime area is
Extended prime control block.

It has a prime area control block and an OVF page pointer. The first page of over 70-region control blocks has a %OVF control block, an extended prime region pointer, and an OVF page pointer of 1. A normal page has an extended prime area pointer and an OVF page pointer of 1, 0 and 1 (not shown), but 9 within each page! It has a page control block that manages its own area. 0 IIs is a diagram specifically explaining the expansion of the prime area. 0 In Fig. Program C indicates the extended prime area pointer of the first page of the over 7o area, and D indicates the extended prime area pointer of the normal page.0 Also, the first page of the prime area is page 0, the beginning of the over 74 area It is assumed that there are 11,100 pages.

Figure 5 6) shows a state in which the prime area has not been expanded and the over 7o area is all empty.
In this state, A is the Oth page and B is the 100th page.
The page diagram (b) shows the state in which the 100th page is used as an expansion area of the prime area.
B indicates the 101st page, C indicates the 0th page. 〇 5Ee1 indicates a state where the g1oo page and the 101st page are used as an extension area of the prime area. ◎ In this state, A is the 101st page, B is the all (l page, and C is the 0th page.) A variant example of the expansion of page 0 is as follows.

Igloo page and 1st page as extension area of 0th page.
When using page 01, l! ! for.

0th page 0OVF page pointer is JIIIIOI
page, the 101st page 00VF The page pointer indicates the tooth page slll0ooovy The page pointer indicates the go page.
In a database system where the area and Kfi are low, over 7W area can be used effectively.

[Brief explanation of the drawing]

Figure 1 shows the configuration of the range or subrange in the present invention, the range or subrange, the spacer, and the IC).
II% Presentation Water Containing A1 A1 2nd Headquarters Functional diagram showing the embodiment of the present invention, Figure 3 is a diagram showing the geographical flow of the writing space acquisition section for extended putzim, and Figure 4 shows the page structure. Figure * I'I Figure 5 is a diagram that explains the expansion of the prime area in a different way Ol...Storage unit allocated to range or subrange, 2...Schema, 3...Application program, 5 ...Writing space acquisition unit for prime, 6...Writing space acquisition unit for expanded prime, 7...
- OVF writing space acquisition unit in use, 8...OVF writing space acquisition 11A. Special Savings Applicant Fujitsu Gold Co., Ltd. Representative Patent Attorney Kyotani

Claims (1)

[Claims] An over-puff p-area that has a plurality of pages and manages free space in the over-70-area; an over-70-area that has a region control block in the first page; and a prime area that has a plurality of pages and manages free space in the prime area. A control block and a prime area whose first page has an extended prime area control block pointing to the page most recently acquired for the prime area in the over 70-area, and a store request to write data to the prime area. When this occurs, refer to the prime area control block and check whether there is free space for writing the data in the prime area. If there is free space, write to the data pipe. The space meeting was unable to acquire the writing space for the prime and the writing space for writing the above data in the above prime area.
Check whether the above data can be written in the extended area of the prime area in the 0- area. If it can be written, obtain a write space for writing the data in the extended area of the prime area. If it cannot be written, then Refers to the above overflow area control block and allocates a new page as an extension area of the above prime area, and updates the contents of the above extended prime area control block and the contents of the above overflow area control block for extended prime use. Expansion method of prime area with writing space acquisition unit and T4I mold.