International Business Machines Corporation

Solid Information Technology Oy

Petri Uolevi Soini

Jarmo Parkkinen

Antoni Wolski

Jarmo K Ruuth

Antti-Pekka Liedes

Vilho T Raatikka

Timo Hotti

Embodiments relate to a method, system, and computer program product for data management. An aspect includes a search index that is created for a database. The search index has a reference value of a first or a second type associating data to a storage location in a first memory or a second memory respectively. Responsive to a data retrieval request, data is accessed using the reference value from the first or the second memory. If there is a data migration between the first and second memory storage, the reference values are then recalculated and altered in the search index accordingly.

Hybrid table implementation by using buffer pool as permanent in-memory storage for memory-resident data

Providing an index for a database table that includes a first portion of rows stored in a memory device and a second portion of rows stored in a disk device. A request is received relating to a specific row of the database table. An index that includes entries for each row of the database table stored in the memory device and entries for a subset of the rows of the database table stored in the disk device is accessed. A connection is made to the memory device if the specific row is stored in the memory device, and a connection is made to the disk device if the specific row is stored in the disk device. An action related to the specific row is performed based on the received request.

Index for hybrid database

A method, system and computer readable media for optimistic access of data objects in a processing system. The method, system and computer readable media comprise providing a list of position objects. Each of the position objects can be associated with a data object. The method, system and computer readable medium include utilizing a thread to mutex a position object of the list of position objects and to associate the position object with a data object, and accessing the data object by the thread. The method, system and computer readable medium record a free level of a memory allocator as a read level of the position object and record a version number of the data object as the version number of the position object after the access has been determined to be safe.

Memory allocator for optimistic data access

Method for making a consistent checkpoint of a page including at least one data object in a computer system having a primary and secondary storage, and a programmable software. The primary storage has at least one page which includes at least one original data object on the page. The computer system allows at least one write operation to modify at least one data object, and the page is written into the secondary storage during checkpointing. The method includes beginning the checkpointing, including at least one page in the primary storage into a group of pages to be checkpointed, altering at least one data object with at least one data write operation, marking at least one data object resulting from the data write operation, writing at least one of the data objects into the secondary storage, and altering the state of the pending data object to be the original data object.

Method for checkpointing a main-memory database

An apparatus for synchronizing data between DBMSs has a first DBMS and a second DBMS. The second DBMS has a storage for persistently storing data items in a form of a storage structure, i.e. database. The second DBMS has also a second data storage for persistently storing data in a form of a sequential order, i.e. a transaction log. The data to be synchronized from the first DBMS to the second DBMS is analysed and based on the analyzing, it is decided how to persistently store the data between the first and the second data storage in the second DBMS. There can be decided how to store the data between the first and the second data storage. The characteristics of the data to be stored may influence on the storage between the first and the second data storage. Thus, the storage depends on the actual data to be stored.

Apparatus, system and method for persistently storing data in a data synchronization process

This invention relates generally to database servers and computer systems and, more particularly, describes the mechanism to run transaction operations originating from a primary server used to replicate data in parallel in a secondary server. Especially the invention relates to running concurrent or parallel operations in a secondary server for redundancy, recovery and propagated transactions. This invention describes how parallel operation in a secondary server improves performance and availability and how it maintains transaction order and output congruent with the primary server where transaction operations are originated.

Growing community of inventors

Vantaa, Finland

Petri Uolevi Soini