Abstract: A batch processor executing batch processing logic is provided for batch processing data that is stored in multiple tables and is organized in the tables as a plurality of rows of data and a plurality of columns. Each row is identified by a key, and each column represents a field having a unique field name. In operation, the batch processing is performed by reading out data from only a portion of a row from each of the tables that is to be used for the batch processing logic by specifying the key of the row from the respective table, and the unique field names in the row of the respective table to be used for the batch processing logic. The remaining portion of the data in the row of the respective table is not read out from the row. Batch processing is then performed on the read out data using the batch processing logic. The batch processed data is then written back into the same row of the respective table that the data was read out from.
Abstract: A computer program product is provided wherein a batch process operates on structured data in multiple tables, including a first and a second source table, and a first and a second processing table. An additional key is added within each natural key to at least the second source and processing table for identifying a sequence of rows for updating.
Abstract: A method is provided for processing data in a database, wherein the database includes a first table and a second table. Each of the tables have a plurality of rows of data, wherein a key identifies one or more rows of data in the tables. There is a plurality of matching key pairs among the tables. Each key pair includes a key of a first table, and a matching key and a unique row of a second table. In operation, the method involves simultaneously processing row data of key pairs associated with a first row of the second table, and then simultaneously processing row data of key pairs associated with any remaining rows of the second table in sequential row order.
Abstract: A method is provided for batch processing data that is stored in multiple tables and is organized in the tables as a plurality of rows of data and a plurality of columns. Each row is identified by a key, and each column represents a field having a unique field name. The batch processing is performed using batch processing logic. In operation, the batch processing is performed by reading out data from only a portion of a row from each of the tables that is to be used for the batch processing logic by specifying the key of the row from the respective table, and the unique field names in the row of the respective table to be used for the batch processing logic. The remaining portion of the data in the row of the respective table is not read out from the row. Batch processing is then performed on the read out data using the batch processing logic. The batch processed data is then written back into the same row of the respective table that the data was read out from.
Abstract: A batch process operates on structured data in multiple tables, including a first and a second source table, and a first and a second processing table. An additional key is added within each natural key to at least the second source and processing table for identifying a sequence of rows for updating.