Abstract: Methods, systems, and apparatuses for processing function calls using a hooking routines to perform pre-execution tasks are disclosed. A server computer receives a function call including a hooking routine and a request to run a particular function from a client computer. Based on a function group identifier and the credentials of the user or client computer, the server computer can perform various pre-execution tasks. The tasks can be common to all functions in the function group or be customized Both pre-execution tasks can be stored remotely from the client computer, so that updates to the pre-execution task can be made without the need to update computer readable code stored on the client computer. If the pre-execution tasks, such as an authorization, passes, then the server computer can execute the requested function, the server computer can reject or abort the requested function.

Abstract: Methods, systems, and apparatuses for processing function calls using a hooking routines to perform pre-execution tasks are disclosed. A server computer receives a function call including a hooking routine and a request to run a particular function from a client computer. Based on a function group identifier and the credentials of the user or client computer, the server computer can perform various pre-execution tasks. The tasks can be common to all functions in the function group or be customized Both pre-execution tasks can be stored remotely from the client computer, so that updates to the pre-execution task can be made without the need to update computer readable code stored on the client computer. If the pre-execution tasks, such as an authorization, passes, then the server computer can execute the requested function, the server computer can reject or abort the requested function.

Abstract: A computer readable storage medium includes executable instructions to support the definition of an Extract Transform and Load (ETL) task. An evaluation of source table structures, source data change indicators, and target table structures is performed. The ETL task is converted to a delta load task in accordance with the evaluation.

Abstract: A computer readable storage medium includes executable instructions to analyze sort options associated with an input table and a comparison table. It is determined whether a consistent sort can be performed by a first database associated with the input table and a second database associated with the comparison table. A first sort operation is performed on the input table at the first database and a second sort operation is performed on the comparison table at the second database when a consistent sort can be achieved. Sort operations on the input table and the comparison table are executed at a common sort engine when a consistent sort cannot be performed by the first database and the second database.

Abstract: A computer readable storage medium includes executable instructions to support the definition of an Extract Transform and Load (ETL) task. An evaluation of source table structures, source data change indicators, and target table structures is performed. The ETL task is converted to a delta load task in accordance with the evaluation.

Abstract: A computer readable storage medium includes executable instructions to analyze sort options associated with an input table and a comparison table. It is determined whether a consistent sort can be performed by a first database associated with the input table and a second database associated with the comparison table. A first sort operation is performed on the input table at the first database and a second sort operation is performed on the comparison table at the second database when a consistent sort can be achieved. Sort operations on the input table and the comparison table are executed at a common sort engine when a consistent sort cannot be performed by the first database and the second database.