Ca, Inc.

Computer Associates Think, Inc.

Kevin P Shuma

Joseph B Lynn

Robert Florian

Kenneth W Eaton

Gopinath Suryadevara

Vit Gottwald

Michael Hogan

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 for determining a sequential access efficiency for a database table includes determining a number of data block changes that occur during a sequential access of a plurality of rows in a database table. The sequential access efficiency is determined based on the determined number of data block changes.

System and method for analyzing sequential data access efficiency

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 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

A system and method determines sequential access efficiency for a database table. A number of data block changes that occur during a sequential access of a plurality of rows in a database table are determined. The sequential access efficiency is calculated based on the determined number of data block changes.

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 determining an available space in one or more data blocks. A physical data storage area associated with one or more portions of a database may be determined. An available space in each data block of one or more data blocks in the physical data storage area may be determined. A number of new data rows that can be added to each data block may also be determined.

System and method for analyzing available space in data blocks

A system and computer implemented method includes receiving an input file containing a mark-up language based description of a syntax diagram having multiple elements and variations for multiple elements describing a set of test case queries, checking and validating the syntax diagram via a parser running on a processor, and generating and storing, on a computer readable medium, the set of test case queries by calculating permutations of the elements in the syntax diagram.

Rule based syntax software test case generator

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

Celina, TX, United States of America

Kevin P Shuma