Hardware acceleration for query operators

A method comprising:

• receiving a hardware template corresponding to a query operator at a hardware device;
• receiving data associated with the query operator at the hardware device;
• in a partition mode, processing the received data and storing the received data in a plurality of partitions according to the hardware template by the hardware device;
• in a hash table mode, processing the stored data in the plurality of partitions according to the hardware template by the hardware device;
• and
• providing the processed stored data by the hardware device as results of the query operator.

A system comprising:

• a hardware device;
• and
• a software module adapted to:
• receive a computer program, wherein the computer program comprises a plurality of query operators;
• generate a query plan from the computer program, wherein the query plan comprises a plurality of computational nodes and each computational node corresponds to a query operator of the plurality of query operators;
• generate a mapping of the query operators corresponding to one or more of the computational nodes to one or more components of a hardware device using hardware templates associated with each query operator of the plurality of query operators;
• generate a memory configuration for one or more memory components of the hardware device using the hardware templates associated with each query operator of the plurality of query operators;
• and
• configure the hardware device to execute one or more of the query operators according to the mapping and the memory configuration.