Chart engine
In an aspect, provided is a method comprising receiving an expression involving one or more dimensions, determining one or more indexlets associated with the one or more dimensions, querying each of the one or more indexlets with the expression, receiving a result from each of the one or more indexlets, and aggregating the results.
1. A method comprising:
receiving an expression associated with one or more dimensions of data records;
determining one or more indexlets associated with the one or more dimensions of data records, wherein each of the one or more indexlets bidirectionally indexes a block of rows of at least one table comprising at least one dimension of the one or more dimensions of data records;
querying each of the one or more indexlets with the expression;
receiving a result from each of the one or more indexlets; and
aggregating the results.
2. The method of claim 1 , wherein the expression comprises a component independent operator.
3. The method of claim 1 , wherein the one or more dimensions of data records are within a single table.
4. A method comprising:
receiving an expression comprising one or more dimensions of data records, wherein the one or more dimensions of data records are within multiple tables;
determining one or more indexlets associated with the one or more dimensions of data records, wherein each of the one or more indexlets bidirectionally indexes a block of rows of at least one table of the multiple tables;
identifying a master table of the multiple tables, wherein the master table comprises a largest number of the one or more indexlets;
querying, based on the expression, the master table and at least one indexlet of the one or more indexlets associated with the one or more dimensions of data records, wherein the at least one indexlet is configured to query at least one other indexlet of the one or more indexlets to evaluate the expression;
receiving a result from the at least one indexlet; and
aggregating the results.
5. The method of claim 4 , wherein the expression comprises a component independent operator.
6. The method of claim 4 , wherein the at least one other indexlet comprises a closest neighbor indexlet to the at least one indexlet.
7. A method comprising:
receiving a user selection of data, wherein the data comprises one or more tables;
determining, based on at least one indexlet of one or more indexlets, distinct values of the data in the one or more tables that are associated with the user selection, wherein each of the one or more indexlets bidirectionally indexes a block of rows of the one or more tables;
generating, based on the distinct values of the data, a first hypercube; and
generating, based on the first hypercube, a graphical object.
8. The method of claim 7 , wherein determining distinct values of the data in the one or more tables that are associated with the user selection comprises:
receiving an expression associated with the user selection and one or more dimensions of the data; and
querying each of the one or more indexlets with the expression.
9. The method of claim 8 , wherein the expression comprises a component independent operator.
10. The method of claim 8 , wherein the one or more dimensions of the data are within a single table of the one or more tables.
11. The method of claim 7 , wherein determining distinct values of the data in the one or more tables that are associated with the user selection comprises:
receiving an expression associated with the user selection and comprising one or more dimensions of the data; and
querying, based on the expression, a master table and at least one indexlet of the one or more indexlets associated with the one or more dimensions of the data, wherein the at least one indexlet is configured to query at least one other indexlet of the one or more indexlets to evaluate the expression.
12. The method of claim 11 , wherein the expression comprises a component independent operator, a summable operator, or a recursive operator.
13. The method of claim 11 , where wherein the at least one other indexlet comprises a closest neighbor indexlet to the at least one indexlet.
14. The method of claim 1 , wherein the expression comprises a summable operator.
15. The method of claim 1 , wherein the expression comprises a recursive operator.
16. The method of claim 4 , wherein the expression comprises a summable operator.
17. The method of claim 4 , wherein the expression comprises a recursive operator.
18. The method of claim 8 , wherein the expression comprises a summable operator.
19. The method of claim 8 , wherein the expression comprises a recursive operator.
20. The method of claim 1 , wherein at least one of the one or more indexlets is configured to query at least one other indexlet of the one or more indexlets to evaluate the expression.