COMPUTER-IMPLEMENTED METHODS, SYSTEMS, AND COMPUTER PROGRAM PRODUCTS FOR ENHANCED BATCH MODE PROCESSING OF A RELATIONAL DATABASE
First Claim
1. A computer-implemented method for enhanced batch mode processing of relational data files, comprising:
- creating a sequential file for a relational table in a relational database;
receiving an input file and a database query for the relational table;
sorting records in the input file and the sequential file on a primary key or a non-key;
generating a temporary file for processing the input file and the sequential file;
executing an operation for the database query on the sorted records of the input file and the sorted records of the sequential file within the temporary file;
storing output of the operation in the temporary file; and
updating the relational table with the output from the temporary file.
1 Assignment
0 Petitions
Accused Products
Abstract
Computer-implemented methods, systems, and computer program products for enhanced batch mode processing of a relational database are provided. A computer-implemented method includes creating a sequential file for a relational table in a relational database, receiving an input file and a database query for the relational table, and, if needed, sorting the input file and the sequential file on a primary key or a non-key. The computer-implemented method also includes generating a temporary file for processing the input file and the sequential file and executing an operation for the database query on the sorted input file and the sorted sequential file within the temporary file. The computer-implemented method also includes storing output of the operation in the temporary file and updating the relational table with the output of the temporary file.
36 Citations
18 Claims
-
1. A computer-implemented method for enhanced batch mode processing of relational data files, comprising:
-
creating a sequential file for a relational table in a relational database; receiving an input file and a database query for the relational table; sorting records in the input file and the sequential file on a primary key or a non-key; generating a temporary file for processing the input file and the sequential file; executing an operation for the database query on the sorted records of the input file and the sorted records of the sequential file within the temporary file; storing output of the operation in the temporary file; and updating the relational table with the output from the temporary file. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A system for enhanced batch mode processing of relational data files, comprising:
-
a computer processing device; and an application executing on the computer processing device, the application performing a method, comprising; creating a sequential file for a relational table in a relational database; receiving an input file and a database query for the relational table; sorting records in the input file and the sequential file on a primary key or a non-key; generating a temporary file for processing the input file and the sequential file; executing an operation for the database query on the sorted records of the input file and the sorted records of the sequential file within the temporary file; storing output of the operation in the temporary file; and updating the relational table with the output from the temporary file. - View Dependent Claims (8, 9, 10, 11, 12)
-
-
13. A computer program product for enhanced batch mode processing of relational data files, the computer program product including instructions for causing a computer to implement a method, the method comprising:
-
creating a sequential file for a relational table in a relational database; receiving an input file and a database query for the relational table; sorting records in the input file and the sequential file on a primary key or a non-key; executing an operation for the database query on the sorted records of the input file and the sorted records of the sequential file; generating a temporary file that includes the output of the operation; and updating the relational table with data in the temporary file. - View Dependent Claims (14, 15, 16, 17, 18)
-
Specification