Optimize query based on unique attribute
Example implementations relate to optimized queries based on unique attributes. For example, a computing device may include a processor. The processor may receive a query and identify at least one unique attribute based on at least one operation specified in the query or based on an attribute property associated with at least one relational table relevant to the query, the attribute property indicating uniqueness. The processor may modify a data structure representing the query, the data structure having nodes each associated with a respective relational table and the data structure modified to specify a subset of the nodes that are associated with the at least one unique attribute. The processor may optimize the query based on the data structure modified to specify the subset.
1. A computing device, comprising:
a processor to:
receive a query;
identify at least one unique attribute based on at least one operation specified in the query or based on an attribute property associated with at least one relational table relevant to the query, the at least one unique attribute property indicating uniqueness;
annotate a data structure representing the query, the data structure having nodes each being associated with a respective relational table, the data structure modified to specify a subset of the nodes that are associated with the at least one unique attribute, wherein a portion of the nodes of the data structure are each associated with a sub-query and wherein annotating the data structure includes the processor modifying a sub-query data structure associated with each node of the portion of the nodes, each sub-query data structure being modified based on the at least one unique attribute; and
optimize the query based on the data structure modified to specify the subset.
2. The computing device of claim 1 , wherein the processor is further to process the query, based on the subset of the nodes specified in the modified data structure as associated with the at least one unique attribute, to obtain results of the query.
3. The computing device of claim 1 , wherein the query is optimized by optimizing the at least one operation specified in the query, the at least one operation specified in the query being associated with the at least one unique attribute.
4. The computing device of claim 3 , wherein the at least one operation specified in the query includes at least one of an order by clause, a group by clause, and a join clause.
5. The computing device of claim 1 , wherein the data structure represents a join graph for the query, wherein the join graph comprises edges that each connect two nodes, wherein each edge represents a distinct join in the join graph.
6. The computing device of claim 1 , wherein annotating the data structure comprises annotating each node with a set of attributes that are guaranteed to have unique values for that node.
7. A method, comprising;
receiving, by a computing device, a query;
determining, by the computing device, at least one unique attribute based on at least one operation specified in the query or based on an attribute property associated with at least one relational table relevant to the query, the attribute property indicating uniqueness;
accessing, by the computing device, a data structure representing the query, the data structure having nodes each associated with a respective relational table;
annotating, by the computing device, the data structure to specify a subset of the nodes that are associated with the at least one unique attribute, wherein a portion of the nodes of the data structure are each associated with a sub-query and wherein annotating the data structure includes annotating a sub-query data structure associated with each node of the portion of the nodes, each sub-query data structure being annotated based on the at least one unique attribute; and
generating, by the computing device, an optimization of the query based on the data structure annotated to specify the subset.
8. The method of claim 7 , further comprising:
processing, by the computing device, the optimization of the query; and
providing, by the computing device, results of the processing as a response to the query.
9. The method of claim 7 , wherein generating the optimization includes optimizing the at least one operation specified in the query, the at least one operation specified in the query being associated with the at least one unique attribute.
10. The method of claim 9 , wherein the at least one operation specified in the query includes at least one of an order by clause, a group by clause, and a join clause.
11. The method of claim 7 , wherein the data structure represents a join graph for the query, wherein the join graph comprises edges that each connect two nodes, wherein each edge represents a distinct join in the join graph.
12. The method of claim 7 , wherein annotating the data structure comprises annotating each node with a set of attributes that are guaranteed to have unique values for that node.
13. A non-transitory machine-readable storage medium storing instructions that, if executed by at least one processor of a computing device, cause the computing device to:
receive a query;
identify at least one unique attribute based on at least one operation specified in the query or based on an attribute property associated with at least one relational table relevant to the query, the at least one unique attribute property indicating uniqueness;
access a data structure representing the query, the data structure having nodes each being associated with a respective relational table;
annotate the data structure to specify a subset of the nodes that are associated with the at least one unique attribute, wherein a portion of the nodes of the data structure are each associated with a sub-query and wherein modifying the data structure includes modifying a sub-query data structure associated with each node of the portion of the nodes, each sub-query data structure being modified based on the at least one unique attribute;
determine an optimization of the query based on the data structure modified to specify the subset; and
process the optimization of the query.
14. The non-transitory machine-readable storage medium of claim 13 , wherein the instructions further cause the computing device to return results of the optimization as a response to the query.
15. The non-transitory machine-readable storage medium of claim 13 , wherein the optimization is determined by optimizing the at least one operation specified in the query, the at least one operation specified in the query being associated with the at least one unique attribute.
16. The non-transitory machine-readable storage medium of claim 15 , wherein the at least one operation specified in the query includes at least one of an order by clause, a group by clause, and a join clause.
17. The non-transitory machine-readable storage medium of claim 13 , wherein the data structure represents a join graph for the query, wherein the join graph comprises edges that each connect two nodes, wherein each edge represents a distinct join in the join graph.
18. The non-transitory machine-readable storage medium of claim 13 , wherein annotating the data structure comprises annotating each node with a set of attributes that are guaranteed to have unique values for that node.