Patent ID: 8374997
Filing Date: 2013-02-12
Classification: G06F,G06Q

Abstract:
1. A method of processing data in one or more computers, comprising: (a) performing, in the one or more computers, a job comprised of one or more steps in a relational database management system (RDBMS), wherein the steps include setup, generation and execution of structured query language (SQL) statements by the RDBMS; and (b) monitoring, in the one or more computers, the steps by monitoring the setup, generation and execution of the SQL statements by the RDBMS, further comprising: (1) logging of information to the RDBMS, before and after each step of the job, concerning the setup, generation and execution of the SQL statements, (2) bypassing remaining steps of the job when an error occurs in the setup, generation and execution of the SQL statements, based on the logging of information to the RDBMS before and after each step of the job, resulting in the job being aborted, (3) providing user restartability of the aborted job from where the error occurred in the setup, generation and execution of the SQL statements, based on the logging of information to the RDBMS before and after each step of the job, by skipping previously successfully executed steps of the job and executing only the bypassed remaining steps of the aborted job, and (4) providing a status of the job, concerning the setup, generation and execution of the SQL statements, based on the logging of information to the RDBMS before and after each step of the job, thereby comprising Bypass, Logging, User Restartability and Status (BLURS) functions for the job, wherein the BLURS functions allow for execution management (bypass, user restartability), execution logging, and real-time status capabilities.