← Back to Patent Explorer
US5568638A Expired / Lapsed US ⏱️ 0.0 years remaining

Split control system for a page/page group in a data processing system a pre-split process using a temporary overflow area

Assignee: Fujitsu Ltd
•
Filing: 1993-02-18
•
Granted: 1996-10-22
•
Expires: 2013-02-18
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

Abstract

Abstract A split control system for a page/page group in a data processing system having a storage structure employing a non-dense B-tree cluster structure, includes: a data base including an index portion and a data portion; the index portion being formed by three layers consisting of the B-tree structure, and the data portion formed by a plurality of upper page groups, and an upper page group used as an overflow area; a record insertion unit for inserting records into the page/page group by using the overflow area in a transaction process, and performing a pre-split process for the page/page group into further pages/page groups by also using the overflow area when there is no vacant space for insertion into the page/page group; and a Demon processing unit operated asynchronously with the transaction process for retrieving a state of use of the overflow area, performing a normal split process for the page/page group when the overflow area is in use, and moving a split page/page group from the overflow area to the page/page group, wherein a timing of a normal split process in the B-tree structure is temporarily delayed by using the overflow area so that it is possible to effectively balance an overhead time of the split process and to improve a response time in the transaction process.

Inventors

  • 👤 Katzumi Hayashi
  • 👤 Masaaki Mitani
  • 👤 Shinzi Kitao

Bibliographic Details

Application Number —
Jurisdiction US
Data Source google_patents
Last Synchronized 2026-11-03 20:00
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/22; G06F16/2228; G06F16/2246; Y; Y10; Y10S; Y10S707/00; Y10S707/99931

Claims Analysis

Total Claims: 5
Claim 1
Independent Claim 288 words
A split control system for a page/page group in a data processing system which manages records of the page/page group based on a storage structure employing a non-dense B-tree cluster structure, comprising: a data base including an index portion and a data portion, the index portion formed by layers consisting of the B-tree structure having at least one upper page group index, a plurality of page group indexes each operatively connected to the upper page group index, and a plurality of page indexes each operatively connected to a corresponding page group index for managing key values of the records, and the data portion formed by a plurality of upper page groups each operatively connected to a corresponding page group index and having an overflow area; record insertion means operatively connected to the data base for inserting records into the page/page group by using the overflow area in a transaction process, and performing a pre-split process for the page/page group into further page/page groups by also using the overflow area when there are sufficient vacant pages for insertion into the page/page group; and Demon processing means operatively connected to the data base and operated asynchronously with the transaction process for retrieving a state of the use of the overflow area, performing a normal split process for the page/page group when the overflow area is in use, and a moving split page/page group from the overflow area to the page/page group, wherein a timing of a normal split process in the B-tree structure is temporarily delayed by using the overflow area so that it is possible to effectively balance an overhead time of the split process and to improve a response time returned by pre-split process to the transaction process.
Claim 2
Dependent Claim 288 words
A split control system for a page/page group in a data processing system which manages records of the page/page group based on a storage structure employing a non-dense B-tree cluster structure, comprising: a data base including an index portion and a data portion, the index portion formed by layers consisting of the B-tree structure having at least one upper page group index, a plurality of page group indexes each operatively connected to the upper page group index, and a plurality of page indexes each operatively connected to a corresponding page group index for managing key values of the records, and the data portion formed by a plurality of upper page groups each operatively connected to a corresponding page group index and having an overflow area; record insertion means operatively connected to the data base for inserting records into the page/page group by using the overflow area in a transaction process, and performing a pre-split process for the page/page group into further page/page groups by also using the overflow area when there are sufficient vacant pages for insertion into the page/page group; and Demon processing means operatively connected to the data base and operated asynchronously with the transaction process for retrieving a state of the use of the overflow area, performing a normal split process for the page/page group when the overflow area is in use, and a moving split page/page group from the overflow area to the page/page group, wherein a timing of a normal split process in the B-tree structure is temporarily delayed by using the overflow area so that it is possible to effectively balance an overhead time of the split process and to improve a response time returned by pre-split process to the transaction process.
Claim 3
Dependent Claim 147 words
A split control system as claimed in claim 1, further comprising: a page split unit splitting a page when the page is filled with records; a page group split unit splitting a page group when the page group is filled with records; an upper page group split unit splitting an upper page group when the upper page group is filled with the records; an index unit accessing the index portion; and a split timing decision unit determining the timing of the normal split process, the page split unit, the page group split unit, the upper page group split unit, the index unit, and the split timing decision unit being operatively connected to the record insertion means and the Demon processing means, and the split timing decision unit being operatively connected to the page split unit, the page group split unit, and the upper page group split unit.
Claim 4
Dependent Claim 71 words
A split control system as claimed in claim 1, wherein the three layers of the B-tree structure correspond to a cylinder, a track and a record area of the magnetic disk apparatus, the upper page group corresponds to the cylinder, the page group corresponds to the track, and page corresponds to the record area, so that the key values also correspond to the cylinder, the track and the record area, respectively.
Claim 5
Dependent Claim 53 words
A split control system as claimed in claim 1, wherein the Demon processing means performs a previous split for a page/page group when the page/page group is filled with records in a range of a predetermined utilization rate of the page/page group to eliminate an undesirable normal split process in the transaction process.

References Cited (Backward Citations)

US4677550A Cited
JPH01237854A Cited
US4993030A Cited
US5307486A Cited
US5208899A Cited
JPH04155547A Cited
US5430869A Cited
US5475837A Cited

USPTO Annuity & Maintenance Windows

Annuity Stage Window Opens Payment Deadline Surcharge Period Until Estimated Fee Status
3.5 Years (Year 4) 1999-10-22 2000-04-22 2000-10-22 $2000.00 Window Closed / Lapsed
7.5 Years (Year 8) 2003-10-22 2004-04-22 2004-10-22 $3760.00 Window Closed / Lapsed
11.5 Years (Year 12) 2007-10-22 2008-04-22 2008-10-22 $7700.00 Window Closed / Lapsed

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag