Method for reserving pages of database
AssigneeHitachi, Ltd.
InventorsYukio Nakano, Yuki Sugimoto
Life of this patent
Estimating the term…
Abstract
To store data in an insertion process, a process 1 that inserts data into a new block and a process 2 that inserts, within the block reserved, data into areas that became free when data was deleted are prepared. A switching event to switch from the process 1 to the process 2 is designated in advance. The occurrence of the designated event is checked while executing the process 1 in an insertion process, and if the designated event occurs, the insertion process executes the process 2. If during the execution of the process 2, areas that can be reused become depleted, the execution of the insertion process reverts back to the process 1. As a result, free areas resulting from deletions can be reused according to the switching event designated.
Claims20
A page reserving method for a database system that accepts and analyzes an inquiry request, executes a required process and stores data in a memory, the page reserving processing method comprising the steps of:
- designating at least one event to switch a data storage processing, upon executing data insertion when storing data, between a first process, in which data is stored in a new area that is allocated in a memory area of the memory, and a second process, in which data is stored in a free area created by deleting data from a group of memory areas already allocated;
- storing data through the first process upon inserting the data;
- and
- switching the data storage processing when the designated event occurs to thereby store the data in the second process.
A computer readable recording medium that stores a program for executing a page reserving method for a database system that accepts and analyzes an inquiry request, executes a required process and stores data in a memory, the page reserving processing method comprising the steps of:
- designating at least one event to switch a data storage processing, upon executing data insertion when storing data, between a first process, in which data is stored in a new area that is allocated in a memory area of the memory, and a second process, in which data is stored in a free area created by deleting data from a group of memory areas already allocated;
- storing data through the first process upon inserting the data;
- and
- switching the data storage processing when the designated event occurs to thereby store the data in the second process.
A page reserving apparatus for a database system that accepts and analyzes an inquiry request, executes a required process and stores data in a memory, the page reserving processing apparatus comprising:
- a first processing unit that stores data in a new area that is allocated in a memory area of the memory;
- a second processing unit that stores data in a free area created by deleting data from a group of memory areas already allocated;
- and
- a switching unit that switches based on a designated event, upon executing data insertion when storing data, between the first processing unit and the second processing unit to perform a data storage processing,
- wherein data is stored by the first processing unit upon initially inserting the data by the first processing unit, and the data storage processing is switched when the designated event occurs such that data is stored by the second processing unit.
Dependencies are inferred from the claim text.