System and method for enhancing system reliability using multiple channels and multicast

A method of processing a query, comprising:

• identifying a location of at least one key part by accessing a top level key associated with a pre-compiled query;
• mapping the location of the at least one key part to a first of a plurality of communication channels accessible by a master node, the first communication channel coupled to a plurality of slave nodes;
• communicating a multicast signal from the master node over the first communication channel, the multicast signal comprising a request to perform an action associated with the pre-compiled query;
• receiving the multicast signal at the plurality of slave nodes from the first communication channel;
• and
• accessing, the at least one key part, which comprises a portion of a database table, to resolve at least a portion of the action associated with the pre-compiled query, wherein the at least one key part is accessible by the plurality of slave nodes.

A computer-implemented system for processing a query on a database system, comprising one or more computer processors that:

• identify a request to perform an action associated with a pre-compiled query;
• identify at least one key part associated with the identified request, the at least one key part comprising one or more portions of a database table;
• store a top level key associated with the pre-compiled query, the top level key identifying a first communication channel from a plurality of communication channels accessible by a master node, the first communication channel coupled to a plurality of slave nodes;
• communicate a multicast signal from the master node over the first communication channel, the multicast signal comprising the request to perform an action associated with the pre-compiled query,
• receive the multicast signal at the plurality of slave nodes from the first communication channel;
• and
• access the at least one key part to resolve at least a portion of the action associated with the pre-compiled query, wherein the at least one key part is accessible by the plurality of slave nodes.