Abstract: A global index with a repartitioning operator is provided. A method for executing a query includes receiving a query including a request to search a first table based on a first value in a first column. The method may include generating a second table by partitioning the second table based on the first column and including, in the second table, a partition identifier and a reference row identifier. The method may include pruning the second table such that a row corresponding to the first value remains in the second table. The method may include repartitioning the row to a stream based on the partition identifier. The method may include executing the query by at least searching the partition of the first table based on the stream and the row identifier of the row. Related systems and articles of manufacture are provided.

Abstract: A method for performing a multi-fragment index scan operation included in a query pipeline of a query accessing a database table may include performing an index scan on a first chunk of a first fragment of the database table and a second chunk of a second fragment of the database table. A first output of the index scan on the first chunk of the first fragment of the database table and a second output of the index scan on the second chunk of the second fragment of the database table may be merged to generate a partial result set for ingestion by a next operation in the query pipeline. The multi-fragment index scan operation may continue with index scans on subsequent chunks of the first fragment and second fragment of the database table. Related systems and computer program products are also provided.

Abstract: The present hybrid drive is especially suitable for buses and the like which must make frequent stops. The engine, clutch, and automatic transmission are arranged in series. A flywheel energy storing device is coupled to the drive train by a further clutch. The automatic transmission is a power distribution transmission including a mechanical power transmission branch and a hydraulic power transmission branch. An auxiliary power take-off connects the flywheel to the drive train. The auxiliary power take-off is arranged laterally adjacent to the transmission. The connection point between the transmission and the auxiliary drive is constructed to take up power which, in addition to the engine power, is re-circulating through the hydraulic branch and which flows into the mechanical branch.