Ca, Inc.

Robert Florian

Kevin P Shuma

Joseph B Lynn

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

Growing community of inventors

Dallas, TX, United States of America

Robert Florian