Abstract: 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.

Abstract: An embodiment includes detecting a request for a change related to a first data row of a first table in a first database, identifying a unique record identifier of the first data row, and performing a first search of a change index for an index entry corresponding to the first data row. The first search is based on the unique record identifier and each index entry includes a date and time indicating a last change related to a corresponding data row. The embodiment further includes updating the index entry corresponding to the first data row with a first date and time indicating the change related to the first data row and identifying data rows that are changed subsequent to a prior date and time by performing a second search of the change index for index entries containing a date and time that is greater than the prior date and time.

Abstract: 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.

Abstract: An embodiment includes initiating a first migration of data rows in a source dataset in a source storage device to a target dataset in a target storage device, wherein a block size defined for the target dataset is different than a block size defined for the source dataset. The embodiment also includes, during the first migration, receiving 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, loading the first target block from the target dataset into a first buffer in memory, and responding to the user request using the first data row in the first target block. In specific embodiments a device type that defines the source storage device is different than a device type that defines the target storage device.

Abstract: 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.

Abstract: A computer device provides an “on-demand” technique for compressing the rows of a dataset separately from all other rows of data in the dataset. Users are presented with a list of predetermined compression techniques, and select one of the techniques. The computer then executes the selected compression technique to compress the dataset on a row-by-row basis. As each row of data is being compressed, the dataset remains on-line such that users still have access to the other rows of data in the dataset. Decompression of the rows of data in the dataset are also implemented on a row-by-row basis.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: A system and method is provided for determining a 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 may be determined. The sequential access efficiency may be determined based on the determined number of data block changes.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: Various systems, non-transitory computer readable media, and methods for reorganizing data records of a database are provided. For example, 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.

Abstract: 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.

Abstract: A system and method is provided for determining a 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 may be determined. The sequential access efficiency may be determined based on the determined number of data block changes.