Batched query processing and optimization
Disclosed are various embodiments for batched query processing and optimization in database management systems. A single algebraic expression is generated based at least in part on applying equivalence rules to algebraic expressions for a plurality of database queries of a database comprising a set of relations. The equivalence rules involve relational operators comprising Psi (ψ) operators. The database can be queried using a single database query to create a result that is equivalent to the plurality of database queries.
1. A system comprising:
a memory storing a database;
at least one computing device in communication with the database and comprising a processor, the processor being configured to execute a set of instructions to at least:
obtain a plurality of database queries;
prior to sending any query requests of the plurality of database queries to a database management system of the memory, transform the plurality of database queries using algebraic expressions and generate a single global query encompassing the algebraic expressions of all of the plurality of database queries;
send a single database query request based on the global query to the database management system of the memory storing the database; and
by querying the database using only the single database query request, to cause the database to return to the at least one computing device a result in the form of a global relation corresponding to relations for the plurality of database queries, wherein the global relation comprises response data from which results for all of the database queries can be derived.
2. The system of claim 1 , wherein the global query is generated based at least in part on applying equivalence rules to algebraic expressions for the plurality of database queries.
3. The system of claim 1 , wherein the processor of the at least one computing device is further configured to execute a set of instructions that cause the processor to at least:
modify at least one aspect of at least one table in the memory storing the database; and
generate a second global query corresponding to a second plurality of database queries by applying equivalence rules for the plurality of second database queries.
4. A method comprising:
obtaining, via at least one computing device, a plurality of database queries;
generating, via the at least one computing device, a single expression to expressions of each of the plurality of database queries and a global relation corresponding to relations for the plurality of database queries, wherein the global relation is a single relation that contains all data needed to derive results for all of the database queries; and
without transmitting any of the plurality of database queries individually, querying, via the at least one computing device, a database based at least in part on the single expression.
5. The method of claim 4 , wherein the single expression is generated based at least in part on applying equivalence rules to algebraic expressions for the plurality of database queries.
6. The method of claim 4 , further comprising:
modifying at least one aspect of at least one table in the database; and
generating a second single expression corresponding to a second plurality of database queries by applying equivalence rules for the plurality of second database queries.
7. A system comprising:
a data store comprising a set of relations;
at least one computing device in communication with the data store and comprising a processor, the processor being configured to execute a set of instructions to at least:
obtain a plurality of database queries associated with the set of relations, each of the relations comprising attributes;
prior to sending to the data store any query requests for the plurality of database queries, generate, based at least in part on applying equivalence rules using a plurality of relational operators comprising a plurality of ψ operators to algebraic expressions for the plurality of database queries and the set of relations, a single algebraic expression whose result is a global relation comprising a set of tuples,
wherein the global relation is a single relation that contains all data needed to derive results for all of the database queries;
generate a single database query based on the single algebraic expression;
query the data store using only the single database query;
in response to querying the data store using only the single database query, receiving response data from the data store from which results for all of the plurality of database queries can be derived; and
based on the response data, provide each tuple in the global relation to a plurality of filters to generate output relations corresponding to the plurality of database queries.
8. The system of claim 7 , wherein the plurality of database queries are registered in a database management system.
9. The system of claim 7 , wherein the plurality of database queries are registered to be executed concurrently.
10. The system of claim 7 , wherein at least one of the plurality of database queries is associated with an algebraic expression that returns a vector of the relations.
11. The system of claim 7 , wherein the single algebraic expression is associated with a global relation comprising data necessary for the plurality of database queries.
12. The system of claim 11 , wherein the data does not include any attributes unless the attributes have been used in the plurality of database queries.
13. The system of claim 11 , wherein there is not any row of the data that is not used by the plurality of database queries.
14. The system of claim 7 , wherein the processor of the at least one computing device is further configured to at least modify at least one aspect of at least one table in the data store.