Insert performance on a multi-system transaction environment
AssigneeInternational Business Machines Corporation
InventorsDonald James Haderle, Akira Shibamiya, James Zu-Chia Tseng, Julie Ann Watts
Life of this patent
Estimating the term…
Abstract
A method, apparatus, and article of manufacture for a computer implemented insert system. Data is stored in a database stored on a data storage device connected to a plurality of computers. At least one look-aside space map is allocated to each of the computers. At each computer, when data is to be inserted into the database, a look-aside space map allocated to that computer is identified, and a free data page is located using the identified look-aside space map.
Claims21
A method of storing data in a database stored on a data storage device connected to a plurality of computers, the method comprising the steps of:
- allocating at least one look-aside space map to each system of a multi-system data sharing environment, wherein the look-aside space map identifies data pages associated with a corresponding system;
- and
- at each system of the multi-system data sharing environment, when data is to be inserted into the database,
- searching for a look-aside space map with one or more free data pages allocated to that system;
- when a look-aside space map with one or more free data pages is identified, inserting data into the data pages referenced by the identified look-aside space map, wherein the insertion of data into each system is isolated from the insertion of data in each of the other systems;
- and
- when a look-aside space map with one or more free data pages is not found, dynamically allocating one or more additional space maps to that system.
An apparatus for storing data, comprising:
- a computer having a data storage device connected thereto, wherein the data storage device stores a database containing the partitioned data;
- one or more computer programs, performed by the computer, for allocating at least one look-aside space map to each system of a multi-system data sharing environment, wherein the look-aside space map identifies data pages associated with a corresponding system, and at each system of the multi-system data sharing environment, when data is to be inserted into the database, searching for a look-aside space map with one or more free data pages allocated to that system;
- when a look-aside space map with one or more free data pages is identified, inserting data into the data pages referenced by the identified look-aside space map, wherein the insertion of data into each system is isolated from the insertion of data in each of the other systems;
- and when a look-aside space map with one or more free data pages is not found, dynamically allocating one or more additional space maps to that system.
An article of manufacture comprising a computer program carrier readable by a computer and embodying one or more instructions executable by the computer to perform method steps for storing data in a database stored in a data storage device connected to the computer, the method comprising the steps of:
- allocating at least one look-aside space map to each system of a multi-system data sharing environment, wherein the look-aside space map identifies data pages associated with a corresponding system;
- at each system of the multi-system data sharing environment, when data is to be inserted into the database,
- searching for a look-aside space map with one or more free data pages allocated to that system;
- when a look-aside space map with one or more free data pages is identified, inserting data into the data pages referenced by the identified look-aside space map, wherein the insertion of data into each system is isolated from the insertion of data in each of the other systems;
- and
- when a look-aside space map with one or more free data pages is not found, dynamically allocating one or more additional space maps to that system.
Dependencies are inferred from the claim text.