Abstract: Methods and system are presented for monitoring database processes to generate machine learning predictions. A plurality of database processes executed on database implementations can be monitored, wherein the monitoring includes determining a start time, an end time, and a number of rows impacted by portions of the database processes, and the monitored database processes generate instances of machine learning data including at least the number of rows impacted and an associated duration of time. Using a machine learning component and the machine learning data, a duration of time can be predicted for a candidate database process for execution on a database implementation.

Abstract: Methods and system are presented for monitoring database processes to generate machine learning predictions. A plurality of database processes executed on database implementations can be monitored, wherein the monitoring includes determining a start time, an end time, and a number of rows impacted by portions of the database processes, and the monitored database processes generate instances of machine learning data including at least the number of rows impacted and an associated duration of time. Using a machine learning component and the machine learning data, a duration of time can be predicted for a candidate database process for execution on a database implementation.

Abstract: A method of replacing information governing transactions between computer systems may include storing a first data structure comprising first information that governs an active process of transactions between the computer systems, and cloning the first data structure to generate a second data structure. The method may also include receiving changes to the second information. The method may additionally include processing the first and second data structures using a simulation process to generate a first and second result set including simulation results of transactions between the computer systems over a future time interval as governed by the first and second information. The method may also include causing the first result set and the second result set to be comparatively displayed together, receiving a selection associated with the second result set, and replacing the first data structure with the second data structure to govern the active process.

Abstract: A method of replacing information governing transactions between computer systems may include storing a first data structure comprising first information that governs an active process of transactions between the computer systems, and cloning the first data structure to generate a second data structure. The method may also include receiving changes to the second information. The method may additionally include processing the first and second data structures using a simulation process to generate a first and second result set including simulation results of transactions between the computer systems over a future time interval as governed by the first and second information. The method may also include causing the first result set and the second result set to be comparatively displayed together, receiving a selection associated with the second result set, and replacing the first data structure with the second data structure to govern the active process.

Abstract: An aspect of the present disclosure provides for handling of errors in data transferred from a source system to a target system. In an embodiment, the data is first transferred (from a source system) to a staging table as staging data. A user is enabled to configure rules to identify a respective portion of interest in the staging data, an error condition to be checked in the respective portion, and an action to be performed upon detection of the error in the respective portion. Accordingly, the staging data stored in the staging table is examined according to the rules to identify a first error associated with a first portion of the staging data, and an action associated with the combination of first portion and the first error is performed, as specified in the rules.

Abstract: An aspect of the present disclosure provides for handling of errors in data transferred from a source system to a target system. In an embodiment, the data is first transferred (from a source system) to a staging table as staging data. A user is enabled to configure rules to identify a respective portion of interest in the staging data, an error condition to be checked in the respective portion, and an action to be performed upon detection of the error in the respective portion. Accordingly, the staging data stored in the staging table is examined according to the rules to identify a first error associated with a first portion of the staging data, and an action associated with the combination of first portion and the first error is performed, as specified in the rules.