International Business Machines Corporation

Lloyd E Jordan, Ii

Shaw-Ben Shi

Martin Jay Sirkin

Linda C Elliott

Paul Edwin Stephens

Frank Eliot Levine

Gary Randall Horn

James L Gaudet

Dwayne C Jacobs

Cheng-Fong Shih

Raymond Hernandez

William W Myre, Jr

Jane R Garrison

Estel P Devany

Virginia L Alexander

Howard C Nudd

A method, system and process for enhancing a database server by improving dynamic memory allocation and memory copying during the process of reconstructing a data structure from a communication buffer.

Method and apparatus for enhancing access to a remote database employing

A local application connected to a remote application over a computer network can interrupt processing of the remote application. To do so, a new communications link is opened, and an identifier of the remote process to be interrupted is passed to the remote node. The new communications link is then closed. A manager process on the remote node raises the interrupt to the desired remote application, which returns acknowledgement of the interrupt over the original connection.

Remote interrupt processing over a network

A digital computer system and method for storing and retrieving data contained in a 'relational data table' in such a way that individual items of data are readily accessible and the data itself is compressible. The items of data are arranged in the table in a plurality of rows and columns. The items of data in each given column are of the same type (fixed length character, variable length up to a prescribed maximum length, etc.). The items of data are arranged in a particular data format which comprises a plurality of 'column descriptor' or 'C' records, each of which is associated with one column of the table, followed by a plurality of 'data' or 'D' records which include the items of data in the table. The D records and C records contain the following information: Each D record includes one or more of the items of data from a particular table row. It is therefore associated with this table row and with at least one table column. Each C record, which is associated with one of the table columns, includes an identification of the associated column, an identification of a D record which includes an item of data in the associated column, and a number defining the absolute displacement of the beginning of the items of data arranged in the respective column with respect to the beginning of the D records associated with that column.

Method and apparatus for data storage and interchange using a relational

A method, system and process for enhancing a database server by improving memory allocation and memory copying during the process of reconstructing a data structure.

Apparatus and method for efficiently allocating memory to reconstruct a

A system suitable for use on a computer network provides a user interface on a local node and an application to be run on a remote node. An application for accepting input from the user and translating it to appropriate commands for the remote application is divided, and located partially on the local node and partially on the remote node. That portion located on the local node gathers any information required from the user and transmits it to the portion located on the remote node in an efficient manner. The remote location portion uses the transmitted information to interface with the remote application and obtain results. The results are collected and transmitted to the local portion, from which they are returned to the user.

System for reducing communications overhead in distributed database

Method for reducing data loss during I/O errors and power failure during non-atomic writes to media in a transaction management system using write-ahead logging protocol. A recovery log is written during forward processing. On system restart processing, the log is traversed and a REDO executed. Recovery is effected from detected incomplete log writes or log write failures and uncommitted transactions are undone. A technique is provided in which files having I/O errors are identified, whereby subsequent restart operations are prevented from accessing these files. In one embodiment index files with such error are renamed, serving to indicate that corresponding original files contain errors, and the error index files are automatically rebuilt whereby I/O error on the files causes no data loss. The index file rebuild does not invalidate access plans related to the failed index.

Growing community of inventors

Austin, TX, United States of America

Lloyd E Jordan, Ii