External Control for Structured Query Language (SQL) Statement Execution

A database system includes:

• at least one processor;
• and
• at least one memory storing operational instructions that, when executed by the at least one processor, causes the database system to:
• create a synchronization database object indicating a set of conditions for suspension of execution of at least one executing query expression;
• establish a first session configured to apply the synchronization database object to suspend execution of the at least one executing query expression when a condition of the set of conditions for suspension of execution is detected;
• establish a second session configured to:
• monitor the synchronization database object via accessing of monitoring data in at least one relational database table;
• and
• resume execution of any suspended query expressions when the condition is detected;
• initiate, via the first session, execution of a first query expression via a plurality of parallelized nodes of the database system based on processing an execute query command to execute the first query expression issued via the first session;
• suspend, via the first session based on the first session being configured to apply the synchronization database object, the execution of the first query expression via the synchronization database object in response to detecting the condition of the set of conditions being met during the execution of the first query expression;
• update, via the first session, the at least one relational database table to include the monitoring data indicating suspension of the first query expression in response to detecting the condition of the set of conditions for suspension being met of the first query expression via the synchronization database object;
• access, via the second session based on the second session being configured to monitor the synchronization database object, the monitoring data in the at least one relational database table to verify, based on the monitoring data, that suspension of the first query expression was in accordance with the condition;
• and
• resume the execution of the first query expression, via the first session and based on the second session being configured to instruct the synchronization data object to resume execution of the first query expression, until another condition of the set of conditions is met or the first query expression execution is finished.

A non-transitory computer readable storage medium comprises:

• at least one memory section that stores operational instructions that, when executed by at least one processing module that includes a processor and a memory, causes the at least one processing module to:
• create a synchronization database object indicating a set of conditions for suspension of execution of at least one executing query expression;
• establish a first session configured to apply the synchronization database object to suspend execution of the at least one executing query expression when a condition of the set of conditions for suspension of execution is detected;
• establish a second session configured to:
• monitor the synchronization database object via accessing of monitoring data in at least one relational database table;
• and
• resume execution of any suspended query expressions when the condition is detected;
• initiate, via the first session, execution of a first query expression via a plurality of parallelized nodes of the database system based on processing an execute query command to execute the first query expression issued via the first session;
• suspend, via the first session based on the first session being configured to apply the synchronization database object, the execution of the first query expression via the synchronization database object in response to detecting the condition of the set of conditions being met during the execution of the first query expression;
• update, via the first session, the at least one relational database table to include the monitoring data indicating suspension of the first query expression in response to detecting the condition of the set of conditions for suspension being met of the first query expression via the synchronization database object;
• access, via the second session based on the second session being configured to monitor the synchronization database object, the monitoring data in the at least one relational database table to verify, based on the monitoring data, that suspension of the first query expression was in accordance with the condition;
• and
• resume the execution of the first query expression, via the first session and based on the second session being configured to instruct the synchronization data object to resume execution of the first query expression, until another condition of the set of conditions is met or the first query expression execution is finished.