Apparatus and method for optimized application of batched data to a database
First Claim
1. A non-transitory computer readable medium having sets of instructions stored thereon which, when executed by a machine, cause the machine to:
- receive multiple database operation commands from a database transaction application, wherein the multiple database operation commands are configured to be executed in a target database;
fill, by the database transaction application, database command queues which include a portion of the multiple database operation commands;
combine the contents of two or more of the multiple database command queues of the multiple database operation commands with similar operation types into multiple submission groups, wherein the combined contents of the two or more of the multiple database commands are executed as a single command;
identify dependencies between the multiple submission groups to designate priority submission groups and to apply priority submission groups to the target database substantially synchronously with the receipt of a continuous stream of database transactions, wherein a first submission group is dependent on a second submission group if the first group can only be executed sequentially after the second submission group;
based on the identified dependencies between the multiple submission groups, designate an execution hierarchy of the multiple submission groups, wherein the execution hierarchy indicates an order of execution of the multiple submission groups based in part on predecessors and dependencies of the multiple database operations;
apply, the multiple database operation commands in order of the execution hierarchy of the submission groups, to the database target substantially synchronously with the receipt of the multiple database operation commands; and
receive the multiple database operation commands, at the same time the database command queues are filled.
2 Assignments
0 Petitions
Accused Products
Abstract
A computer readable medium storing executable instructions includes executable instructions to: receive a continuous stream of database transactions; form batches of database transactions from the continuous stream of database transactions; combine batches of database transactions with similar operations to form submission groups; identify dependencies between submission groups to designate priority submission groups; and apply priority submission groups to a database target substantially synchronously with the receipt of the continuous stream of database transactions.
-
Citations
20 Claims
-
1. A non-transitory computer readable medium having sets of instructions stored thereon which, when executed by a machine, cause the machine to:
-
receive multiple database operation commands from a database transaction application, wherein the multiple database operation commands are configured to be executed in a target database; fill, by the database transaction application, database command queues which include a portion of the multiple database operation commands; combine the contents of two or more of the multiple database command queues of the multiple database operation commands with similar operation types into multiple submission groups, wherein the combined contents of the two or more of the multiple database commands are executed as a single command; identify dependencies between the multiple submission groups to designate priority submission groups and to apply priority submission groups to the target database substantially synchronously with the receipt of a continuous stream of database transactions, wherein a first submission group is dependent on a second submission group if the first group can only be executed sequentially after the second submission group; based on the identified dependencies between the multiple submission groups, designate an execution hierarchy of the multiple submission groups, wherein the execution hierarchy indicates an order of execution of the multiple submission groups based in part on predecessors and dependencies of the multiple database operations; apply, the multiple database operation commands in order of the execution hierarchy of the submission groups, to the database target substantially synchronously with the receipt of the multiple database operation commands; and receive the multiple database operation commands, at the same time the database command queues are filled. - View Dependent Claims (3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19)
-
-
2. (canceled)
-
7. (canceled)
-
20. A method comprising:
-
receiving multiple database operation commands from a database transaction application, wherein the multiple database operation commands are configured to be executed in a target database; filling, by the database transaction application, database command queues which include a portion of the multiple database operation commands; combining the contents of two or more of the multiple database command queues of the multiple database operation commands with similar operation types into multiple submission groups, wherein the combined contents of the two or more of the multiple database commands are executed as a single command; identifying dependencies between the multiple submission groups to designate priority submission groups and to apply priority submission groups to the target database substantially synchronously with the receipt of a continuous stream of database transactions, wherein a first submission group is dependent on a second submission group if the first group can only be executed sequentially after the second submission group; based on the identified dependencies between the multiple submission groups, designating an execution hierarchy of the multiple submission groups, wherein the execution hierarchy indicates an order of execution of the multiple submission groups based in part on predecessors and dependencies of the multiple database operations; applying, the multiple database operation commands in order of the execution hierarchy of the submission groups, to the database target substantially synchronously with the receipt of the multiple database operation commands; and receiving the multiple database operation commands at the same time the database command queues are filled.
-
Specification