Loading patent…
AssigneeKeygen Data LLC
InventorJoseph Jose
Estimating the term…
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. The resultant row of each of the tables includes the batch processed data, and the remaining portion of the data in the row in each of the tables that was not read out from the row.
A method of batch processing data that is stored in multiple tables and is organized in each of the tables as (i) a plurality of rows of data, each row being identified by a key, and (ii) a plurality of columns, each column representing a field having a unique field name,
Dependencies are inferred from the claim text.
Drawings are temporarily unavailable. Open the PDF at USPTO
From the US filing history. Foreign family members aren’t listed.
Updates performed during online database operations; commit processing: bulk updating operations
Indexing; Data structures therefor; Storage structures: tablespace storage structures; Management thereof
Computing and data processing
About 14 years 9 months of term left · ends 2 Aug 2041 (estimated)
This application is related to U.S. application Ser. No. 17/391,401 filed Aug. 2, 2021 entitled “Method of processing data in a database by simultaneously processing row data of key pairs which include a key of a first table in the database, and a matching key and a unique row of a second table in the database.”
Batch processing is the processing of transactions in a group or batch. While batch processing can be carried out at any time, it is ideally suited to end-of-cycle processing, such as for updating bank accounts at the end of a day. However, as the size of databases continue to grow, the time and computer resources required to perform batch processing on tables of the databases have reached an unacceptable level for efficient operation of the businesses that rely on the databases. Accordingly, there is a need for processes that can dramatically reduce the time and computer resources to perform batch processing. The present invention fulfills such a need.
One preferred embodiment of the present invention, also referred to herein as “Detached Field Batch Process” (DFBP), addresses the following problem and provides the following solution.
Preferred embodiments of the present invention will now be described by way of example with reference to the accompanying drawings:
FIG. 1 is a flowchart of the DFBP method in accordance with one preferred embodiment of the present invention.
FIGS. 2A-2C show sample tables for use with the DFBP method in accordance with one preferred embodiment of the present invention.
Certain terminology is used herein for convenience only and is not to be taken as a limitation on the present invention. The words “a” and “an”, as used in the claims and in the corresponding portions of the specification, mean “at least one.”
I. DFBP Method
FIG. 1 is a flowchart 100 of one preferred embodiment of the DFBP method. More specifically, the DFBP method is a method of 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 operates as follows: