Abstract: A method for retrieving information from a database includes identifying a cylinder. The cylinder includes a plurality of data segments. The method also includes retrieving the plurality of data segments from the cylinder during a single retrieval operation. In addition, the method includes storing the plurality of data segments in a cache.

Abstract: An arrangement for supporting a building wall, such as a foundation wall, against inward movement caused by shifting of adjacent soil or by hydrostatic forces or other forces acting on the exterior surface of the wall to push it inwardly. The support arrangement includes upper and lower jacking members that each engage respective upper and lower sections of a support beam that is placed vertically against the surface of the wall to be supported. Each jacking member includes a respective jackscrew that is rotatable for applying a wall holding or a wall restoring force to either or both of the upper and lower sections of the wall.

Abstract: Methods, computer programs, information handling systems, and state machines for performing an atomic write to a data block area are disclosed. The atomic write is an in-place write> The method includes receiving one or more data blocks to write to the data block area; and for each data block received: writing the data block to the depot slot; and writing the data block to the data block area after the data block write to the depot slot is completed.

Abstract: A method for retrieving information from a database includes identifying a cylinder. The cylinder includes a plurality of data segments. The method also includes retrieving the plurality of data segments from the cylinder during a single retrieval operation. In addition, the method includes storing the plurality of data segments in a cache.

Abstract: A method, computer program, and computer system are disclosed for indexing database table rows. A first set of one or more columns of the database table is chosen. A second set of one or more columns of the database table is chosen. An index record is generated for each unique result of applying a second function to a value corresponding to the second set for the database table rows. In each index record, only a single copy of each unique result of applying a first function to a value corresponding to the first set for the database table rows having the result of applying the second function to a value corresponding to the second set for that index record is included. The first set is not identical to the second set. At least two rows of the database table rows have the same result of applying the second function to a value corresponding to the second set and have the same result of applying the first function to the value corresponding to the first set.

Abstract: A method, computer system, and computer program are claimed for selecting rows from first and second tables each having rows containing values in columns. In at least the first table, the rows are divided into partitions at least one of which is populated by one or more rows. The method, computer system, and computer program include creating a plurality of partition contexts, each partition context corresponding to a populated partition and storing at least a first value associated with a row. The lowest first value stored by the partition context is determined. Rows with a particular first value are identified by reading the partition contexts, creating a temporary file context corresponding to one of the partition contexts, the temporary file context including location data for a data block of rows in memory, and reading rows in memory.

Abstract: A database system includes a plurality of storage modules, with a first storage module storing rows of a first table and a second storage module storing rows of a second table, and a plurality of access modules adapted to manage access of respective storage modules. A first access module corresponds to the first storage module, and a second access module corresponds to the second storage module. The first access module is adapted to distribute rows of the first table to the second access module in response to a join request, and the first access module is adapted to further distribute row identifiers with the distributed rows. The distributed rows contain one or more columns that are part of one or more join conditions of the join request, but does not contain one or more columns that are in a specified result list of the join request or that are part of a subsequent operation specified in the join request.

Abstract: A diagnosis system includes procedures to perform various operations, including diagnosis of problems, in a run-time environment recreated from dump information. The dump information is saved in response to a fault occurring in a node, which may be part of a parallel processing system. The diagnosis system may be separate from the parallel processing system or it may be one of the nodes of the parallel processing system. Setting up the run-time environment includes identifying memory sections associated with a task that caused the fault and filling the identified memory sections with data extracted from the dump information. Diagnosis procedures may then be run in the recreated run-time environment. The diagnosis may be the same diagnosis procedures used in a live run-time environment to save time and costs associated with writing such diagnosis procedures.

Abstract: A method for retrieving information from a database includes identifying a cylinder. The cylinder includes a plurality of data segments. The method also includes retrieving the plurality of data segments from the cylinder during a single retrieval operation. In addition, the method includes storing the plurality of data segments in a cache.