Teradata Us, Inc.

Choung Kim

Hoa Thu Tran

Douglas Paul Brown

Anita Richards

Techniques are presented for skew exception detection within a parallel processing environment. A potential exception is detected when a highest load of a processor within the parallel processing environment exceeds an average load within the parallel processing environment by a given threshold. The potential exception can become a legitimate exception when it exists for a qualified period or time or when it exists and no qualified period of time is noted. In an embodiment, checks for the potential exception occur and are wholly contained within a given configurable interval.

Skew exception detection

In a database system, a database request is received, and database software dispatches steps associated with the database request to plural access modules of a database system for execution. Statistics are collected regarding execution of each step by a respective access module in response to receiving an indication of completion by the respective access module. It is determined whether statistics relating to execution of the database request violate one or more predefined rules, and in response to determining that the statistics relating to execution of the database request violate one or more predefined thresholds, one or more actions are performed by the database software.

Growing community of inventors

Torrance, CA, United States of America

Choung Kim