PERFORMING BATCHES OF SELECTIVE ASSIGNMENTS IN A VECTOR FRIENDLY MANNER

摘要

Embodiments of the invention relate to processing queries. A query operation to be performed on a table of data is translated into a series of bit level logical operations using expansion and/or saturation operations. A mask is created from the series of bit level logical operations. This mask is then simultaneously applied to multiple rows from the table of data.

主权项

1. A method comprising:
receiving a table of input data, and receiving an operation to be performed on the table of input data, at least one of columns of the input data being a Boolean column of input data representation of a condition, and at least one of column of the input data being a non-Boolean column of input data representation of condition values; performing a function on a subset of a plurality of columns in the table of input data, including:
saturating the Boolean column of input data into a mask in order to perform a logic operation, including transforming the Boolean input column into the mask by replicating each bit in the Boolean column to be a binary width of an input value;translating the function into a series of bit level logic operations on both the non-Boolean column input data and saturated values of Boolean input; andperforming the translated function across the table of input data; and producing a non-Boolean results column as a result of the operation.