Parallel task execution by a store and compute sub-system of a database system

A store and compute sub-system of a database system, the store and compute sub-system comprises:

• a plurality of computing clusters, wherein a computing cluster of the plurality of computing clusters includes a plurality of computing devices, wherein a computing device of the plurality of computing devices includes a plurality of computing nodes, and wherein a computing node of the plurality of computing nodes includes a plurality of processing core resources, wherein the computing cluster is operable to:
• receive a plurality of tasks, wherein a task of the plurality of tasks includes:
• store data of a dataset in a long-term storage format;
• execute a level three query operation of a query to produce a level three query response;
• and
• execute a level two query operation of a query to produce a level two query response;
• execute, in a concurrent manner, the plurality of tasks by:
• for a first task of the plurality of tasks, a first lead computing device of the computing cluster is operable to:
• generate a plurality of first partial tasks based on the first task;
• and
• allocate the plurality of first partial tasks to the plurality of computing devices of the computing cluster, wherein the plurality of computing devices executes the plurality of first partial tasks;
• for a second task of the plurality of tasks, a second lead computing device of the computing cluster is operable to:
• generate a plurality of second partial tasks based on the second task;
• and
• allocate the plurality of second partial tasks to the plurality of computing devices of the computing cluster, wherein the plurality of computing device executes the plurality of second partial tasks.