Ca, Inc.

Computer Associates Think, Inc.

Joseph B Lynn

Kevin P Shuma

Robert Florian

Kenneth W Eaton

Vit Gottwald

An embodiment includes initiating a migration of data rows in a source dataset in a source storage device to a target dataset in a target storage device. A block size defined for the target dataset equals a block size defined for the source dataset, and the migration is to be performed according to a native sequence of the data rows. The embodiment includes receiving, during the migration, a user request for access to a first data row in the source dataset, determining that the first data row was migrated to a first target block in the target dataset, and responding to the user request using the first data row in the first target block. In specific embodiments, a capacity of the target dataset is greater than a capacity of the source dataset. In other embodiments, a capacity of the target dataset is less than a capacity of the source dataset.

Dynamically reorganizing a dataset using online migration while allowing concurrent user access to data in the dataset

A system and method are described for change data capture wherein a source database is replicated to a remote database. In one embodiment, a data storage device contains source log blocks containing information regarding database transactions processed for a source database, wherein the data storage device and source database are located in a first location, and at least some of the source log blocks include a plurality of database transactions in the same order as processed in the source database. Messages containing source log blocks are sent from the first location to a second location geographically remote from the first location. One or more components at the second location receive source log blocks from the messages, extract the source transaction data from the source log blocks, and use the source transaction data to write database transaction information to a second database based on the extracted source transaction data.

Systems and methods for high speed remote change data capture

A system for logging database transactions comprises a memory (comprising a direct access storage device) operable to store a database, a database log, and a plurality of log buffers associated with the database log. Each log buffer is operable to store at least one log record associated with a database transaction. The system further comprises a processor operable to log a first record of a first database transaction using the database log and write the database log to the storage device. The processor is further operable to log a second record of a second database transaction in a first of the plurality of log buffers substantially concurrently to the database log being written to the storage device.

System and method for variable block logging with log-ahead buffers

A network server migrates dataset blocks from a source storage device to a target storage device while continuing to service user requests for the data stored in the dataset blocks. A control driver executing at the network server tracks the location of the dataset blocks during the data migration as being at either the source storage device or the target storage device. Upon receiving a user request for the data, the control driver uses the tracking information to determine whether the dataset blocks associated with the requested data have been migrated to the target storage device or are still stored at the source storage device. The control driver then retrieves the data associated with the requested dataset blocks from the determined source or target storage device.

Performing online data migration with concurrent active user access to the data

Various systems, non-transitory computer readable media, and methods reorganize data records of a database in response to an efficiency parameter. A system may use an efficiency parameter that indicates a satisfactory level of organizational efficiency of at least a portion of a database table having a group of rows stored using a plurality of data blocks. The system may determine an efficiency of the group of rows based on a number of data block changes that occur during a sequential access of the group of rows. When the determined efficiency is less than the efficiency indicated by the efficiency parameter, the server may generate a control card to reorganize the group of rows when the efficiency is not satisfactory. The control card is used by an online reorganization process that reorganizes the group of rows.

System and method for automated online reorganization of sequential access databases

A system and method is provided for partitioning a global index into multiple index datasets to house indexes and their index values. The index datasets may be stored in initialized physical index areas that are distinct from a standard physical index area.

Multi-dataset global index

A system and method is provided for locating one or more compressed data rows in a data block. A 16 byte 'row map' may be added at the end of each compressed data block. The row map may provide seven binary address points in the compressed data block (i.e., by dividing the compressed data block into 8ths).

Binary method for locating data rows in a compressed data block

A method and system presents an online reorganization of at least a portion of a database. The database includes a plurality of rows stored in a plurality of physical blocks and the rows are categorized by a plurality of reference groups. The database manager is operable to identify a target subset of physical blocks based, at least in part, on one of the reference groups and to identify a source subset of physical blocks associated with the particular reference group. The database manager is further operable to dynamically move the rows stored in a first physical block in the source subset to a second physical block in the target subset while the database is online.

System and method for reorganizing a database

In one embodiment, a Database Management System (DBMS) providing increased fault tolerance includes a first DBMS instance communicably coupled with a data store. The DBMS further includes a second DBMS instance communicably coupled with the data store, with the second DBMS instance including a shadow instance operable to monitor data processing of the first DBMS instance using a communication facility.

Growing community of inventors

Plano, TX, United States of America

Joseph B Lynn