Abstract: A system and method uses a set of processors that each perform a logic function to identify portions of a data source meeting a criteria. Each logic function is performed against a row of a column of the data source, and a value that is derived from the criteria for that logic function, which is also derived from the criteria. The output of each of the logic functions is applied as an address to a table that has been configured to read true at the addresses corresponding to the criteria being met, and false otherwise. Data from the row of the database table having a table value of true are retrieved from the data source.

Abstract: A system and method processes join requests via independently running engines. A build side table to be joined is allocated among high speed memories of the engines. Each row of a probe side are allocated to the engine likely to have build side data corresponding to the row, and the engine then performs the join. Aggregation statistics may be computed by distributing the information across the engines.