Double header logging of slotted page structures
AssigneeResearch & Business Foundation Sungkyunkwan University
InventorBeom Seok Nam
Life of this patent
Estimating the term…
Abstract
Provided are a doubleheader logging methods of a slotted page and a database apparatuses. The method of doubleheader logging of a slotted page performed by a database apparatus includes determining a valid slot header among a first slot header and a second slot header of a page to select a slot header; selecting a valid slot header according to the determination result; and performing a transaction based on the selected valid slot header.
Claims20
A processor-implemented method of doubleheader logging of a slotted page performed by a database apparatus comprising a processor, a memory, and a database, the page includes a first slot header and a second slot header for storing metadata of the page, a free space, and a content area for storing data, the method comprising:
- determining, by the processor, whether the first slot header of the page or the second slot header of the page is valid by comparing a transaction ID of each of the first slot header and the second slot header with a file change counter;
- selecting, by the processor, one of the first and second slot headers determined to be valid as a valid slot header;
- performing, by the processor, a transaction based on the selected valid slot header.
A processor-implemented method of double header logging of a slotted page performed by a database apparatus comprising a processor, a memory, and a database, the page includes a first slot header and a second slot header for storing metadata of the page, a free space, and a content area for storing data, the method comprising:
- providing, by using the processor, the slotted page comprising the first slot header and the second slot header to determine whether the first slot header is valid or the second slot header is valid and select one of the first slot header and the second slot header determined to be valid as a valid slot header;
- and
- performing, by the processor, a transaction based on the selected valid slot header of the provided page,
- wherein each of the first and second slot headers comprises a transaction ID, and the transaction ID of each slot header is compared with a file change counter to determine whether the first slot header or the second slot header is valid.
A processor-implemented method of doubleheader logging of a slotted page performed by a database apparatus comprising a processor, a memory and a database, the page includes a first slot header and a second slot header for storing metadata of the page, a free space, and a content area for storing data, the method comprising:
- determining, by using the processor, whether the first slot header of the page to be recovered or the second slot header of the page to be recovered is valid by comparing a transaction ID of each of the first slot header and the second slot header with a file change counter;
- invalidating, by the processor, one of the first slot header and the second slot header determined to be invalid;
- and
- performing, by the processor, a transaction based on one of the first slot header and the second slot header determined to be valid.
A database apparatus for doubleheader logging of a slotted page, the database apparatus comprising:
- a database for storing a database file configured with a database header and a plurality of database pages;
- a memory for storing at least one instruction;
- and
- a processor connected to the database and the memory,
- wherein the processor executes the at least one instruction to:
- determine whether a first slot header of a page or a second slot header of the page is valid by comparing a transaction ID of the first slot header and a transaction ID of the second slot header with a file change counter;
- select one of the first and second slot headers determined to be valid as a valid slot header;
- and
- perform a transaction based on the selected valid slot header.
A database apparatus for doubleheader logging of a slotted page, the page includes a first slot header and a second slot header for storing metadata of the page, a free space, and a content area for storing data, the database apparatus comprising:
- a database for storing a database file configured with a database header and a plurality of database pages;
- a memory for storing at least one instruction;
- and
- a processor connected to the database and the memory,
- wherein the processor executes the at least one instruction to configure the processor to:
- obtain a file change counter for a page of the database file;
- determine whether the first slot header of the page to be recovered or the second slot header of the page to be recovered is valid by comparing a transaction ID of the first slot header and a transaction ID of the second slot header with a file change counter;
- invalidate one of the first and second slot headers determined to be invalid;
- and
- perform a transaction based on one of the first and second slot headers that is determined to be valid.
Dependencies are inferred from the claim text.