Chart engine
Systems and methods for processing queries are described herein. As an example, a query may comprise an expression. Based on the expression, one or more indexlets may be determined. Using the one or more indexlets, a result of the expression may be determined.
1. An apparatus comprising:
one or more processors; and
memory storing processor-executable instructions that, when executed by the one or more processors, cause the apparatus to:
receive an expression comprising a plurality of attributes, wherein the plurality of attributes are associated with a plurality of dimensions of data records stored in a plurality of tables;
determine, based on the expression and an attribute-to-attribute (A2A) index, a plurality of indexlets associated with the expression, wherein the A2A index maps the plurality of attributes to the plurality of indexlets, wherein the plurality of indexlets are associated with at least one bidirectional global attribute list, and wherein an entry in the at least one bidirectional global attribute list associated with a particular attribute, of the plurality of attributes, comprises a reference to an indexlet, of the plurality of indexlets, corresponding to that attribute; and
generate, based on the plurality of indexlets and the expression, at least one graphical object, wherein each indexlet, of the plurality of indexlets, indicates whether a particular attribute value associated with one of the plurality of attributes of the expression is present or not present in each row of a block of rows within a table, of the plurality of tables, corresponding to that indexlet.
2. The apparatus of claim 1 , wherein the processor-executable instructions that cause the apparatus to generate the at least one graphical object further cause the apparatus to:
query each of the plurality of indexlets with the plurality of attributes of the expression;
receive a result from each of the plurality of indexlets; and
generate, based on the result of the expression, the at least one graphical object.
3. The apparatus of claim 1 , wherein the processor-executable instructions that cause the apparatus to generate the at least one graphical object further cause the apparatus to:
determine, based on the plurality of indexlets, a result of the expression; and
generate, based on the result of the expression, the at least one graphical object.
4. The apparatus of claim 1 , wherein the at least one bidirectional global attribute list, for each of the plurality of attributes, comprises a reference to at least one of the plurality of indexlets that corresponds to that attribute.
5. The apparatus of claim 1 , wherein the plurality of indexlets bidirectionally index blocks of rows of each of the plurality of tables to the A2A index based on the plurality of dimensions.
6. The apparatus of claim 1 , wherein the plurality of indexlets bidirectionally index blocks of rows of each of the plurality of tables to the A2A index based on the plurality of attributes.
7. The apparatus of claim 1 , wherein the plurality of indexlets bidirectionally index blocks of rows of each of the plurality of tables to the A2A index based the plurality of attributes and the plurality of dimensions.
8. One or more non-transitory computer-readable media storing processor-executable instructions that, when executed by one or more processors of at least one computing device, cause the at least one computing device to:
receive an expression comprising a plurality of attributes, wherein the plurality of attributes are associated with a plurality of dimensions of data records stored in a plurality of tables;
determine, based on the expression and an attribute-to-attribute (A2A) index, a plurality of indexlets associated with the expression, wherein the A2A index maps the plurality of attributes to the plurality of indexlets, wherein the plurality of indexlets are associated with at least one bidirectional global attribute list, and wherein an entry in the at least one bidirectional global attribute list associated with a particular attribute, of the plurality of attributes, comprises a reference to an indexlet, of the plurality of indexlets, corresponding to that attribute; and
generate, based on the plurality of indexlets and the expression, at least one graphical object, wherein each indexlet, of the plurality of indexlets, indicates whether a particular attribute value associated with one of the plurality of attributes of the expression is present or not present in each row of a block of rows within a table, of the plurality of tables, corresponding to that indexlet.
9. The one or more non-transitory computer-readable media of claim 8 , wherein the processor-executable instructions that cause the at least one computing device to generate the at least one graphical object further cause the at least one computing device to:
query each of the plurality of indexlets with the plurality of attributes of the expression;
receive a result from each of the plurality of indexlets; and
generate, based on the result of the expression, the at least one graphical object.
10. The one or more non-transitory computer-readable media of claim 8 , wherein the processor-executable instructions that cause the at least one computing device to generate the at least one graphical object further cause the at least one computing device to:
determine, based on the plurality of indexlets, a result of the expression; and
generate, based on the result of the expression, the at least one graphical object.
11. The one or more non-transitory computer-readable media of claim 8 , wherein the at least one bidirectional global attribute list, for each of the plurality of attributes, comprises a reference to at least one of the plurality of indexlets that corresponds to that attribute.
12. The one or more non-transitory computer-readable media of claim 8 , wherein the plurality of indexlets bidirectionally index blocks of rows of each of the plurality of tables to the A2A index based on the plurality of dimensions.
13. The one or more non-transitory computer-readable media of claim 8 , wherein the plurality of indexlets bidirectionally index blocks of rows of each of the plurality of tables to the A2A index based on the plurality of attributes.
14. The one or more non-transitory computer-readable media of claim 8 , wherein the plurality of indexlets bidirectionally index blocks of rows of each of the plurality of tables to the A2A index based the plurality of attributes and the plurality of dimensions.
15. One or more non-transitory computer-readable media storing processor-executable instructions that, when executed by one or more processors of at least one computing device, cause the at least one computing device to:
receive an expression comprising a plurality of attributes, wherein the plurality of attributes are associated with a plurality of dimensions of data records stored in a plurality of tables;
determine, based on the expression and an attribute-to-attribute (A2A) index, a plurality of indexlets associated with the expression, wherein the A2A index maps the plurality of attributes to the plurality of indexlets, wherein the plurality of indexlets are associated with at least one bidirectional global attribute list, and wherein an entry in the at least one bidirectional global attribute list associated with a particular attribute, of the plurality of attributes, comprises a reference to an indexlet, of the plurality of indexlets, corresponding to that attribute; and
determine, based on the plurality of indexlets, a result of the expression, wherein each indexlet, of the plurality of indexlets, indicates whether a particular attribute value associated with one of the plurality of attributes of the expression is present or not present in each row of a block of rows within a table, of the plurality of tables, corresponding to that indexlet.
16. The one or more non-transitory computer-readable media of claim 15 , wherein the plurality of indexlets bidirectionally index blocks of rows of each of the plurality of tables to the A2A index based on the plurality of attributes.
17. The one or more non-transitory computer-readable media of claim 15 , wherein the plurality of indexlets bidirectionally index blocks of rows of each of the plurality of tables to the A2A index based on the plurality of dimensions.
18. The one or more non-transitory computer-readable media of claim 15 , wherein the processor-executable instructions that cause the at least one computing device to determine the result of the expression further cause the at least one computing device to query each of the plurality of indexlets with the plurality of attributes of the expression.
19. The one or more non-transitory computer-readable media of claim 18 , wherein the processor-executable instructions further cause the at least one computing device to receive a result from each of the plurality of indexlets.
20. The one or more non-transitory computer-readable media of claim 19 , wherein the processor-executable further cause the at least one computing device to generate, based on the results, at least one graphical object.