Selection query language methods and systems
Provided are methods and systems comprising receiving a plurality of data tables, wherein each data table comprises at least one row, generating a first handle for a first value in a table of the plurality of tables, wherein the first handle comprises an indication of whether a row in each of the plurality of tables is associated or not associated with the first value, and performing one or more operations on the first handle.
1 . A method comprising:
receiving, by a first computing device, a plurality of data tables, wherein each data table of the plurality of data tables comprises a plurality of rows;
generating, based on a first selection of at least one graphical object at a user interface, a first handle for a first value in a table of the plurality of data tables, wherein the first handle indicates that each row, of the plurality of rows, in each data table of the plurality of data tables is associated or not associated with the first value;
generating, based on the first handle and a further selection of at least one graphical object at the user interface, a second handle for a subset value, wherein the further selection is associated with the subset value, and wherein the subset value is associated with the first value;
retrieving, based on the first handle and the second handle, data associated with the subset value from the plurality of data tables; and
outputting, at the user interface, at least one graphical object based on the retrieved data from the plurality of data tables.
2 . The method of claim 1 , wherein the user interface comprises a plurality of graphical objects, and wherein the plurality of graphical objects comprises at least one chart, table, or graph.
3 . The method of claim 1 , wherein the second handle identifies an association or a lack of an association of each row in each data table, of the plurality of data tables, with the subset value.
4 . The method of claim 1 , wherein an intersection of a column and a row in the first handle comprises an indication of association or a lack of an association with the first value.
5 . The method of claim 1 , wherein retrieving the data associated with the subset value from the plurality of data tables comprises performing one or more operations on the first handle and the second handle, and wherein the one or more operations comprise performing one or more of SET HANDLE H, SELECT, COMPLEMENT, UNION, INTERSECT, STATE (n), UPDATE, AGGR, SORT, SESSION, or PAGE.
6 . The method of claim 1 , wherein retrieving the data associated with the subset value from the plurality of data tables comprises performing a PAGE operation to retrieve one or more data values from the plurality of data tables based on the first handle and the second handle.
7 . The method of claim 1 , wherein generating the second handle for the subset value comprises performing at least one aggregation, wherein the at least one aggregation is associated with the first value and the subset value.
8 . 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 a plurality of data tables, wherein each data table of the plurality of data tables comprises a plurality of rows;
generate, based on a first selection of at least one graphical object at a user interface, a first handle for a first value in a table of the plurality of data tables, wherein the first handle indicates that each row, of the plurality of rows, in each data table of the plurality of data tables is associated or not associated with the first value;
generate, based on the first handle and a further selection of at least one graphical object at the user interface, a second handle for a subset value, wherein the further selection is associated with the subset value, and wherein the subset value is associated with the first value;
retrieve, based on the first handle and the second handle, data associated with the subset value from the plurality of data tables; and
output, at the user interface, at least one graphical object based on the retrieved data from the plurality of data tables.
9 . The apparatus of claim 8 , wherein the user interface comprises a plurality of graphical objects, and wherein the plurality of graphical objects comprises at least one chart, table, or graph.
10 . The apparatus of claim 8 , wherein the second handle identifies an association or a lack of an association of each row in each data table, of the plurality of data tables, with the subset value.
11 . The apparatus of claim 8 , wherein an intersection of a column and a row in the first handle comprises an indication of association or a lack of an association with the first value.
12 . The apparatus of claim 8 , wherein the processor-executable instructions that cause the apparatus to retrieve the data associated with the subset value from the plurality of data tables further cause the apparatus to perform one or more operations on the first handle and the second handle, wherein the one or more operations comprise performing one or more of SET HANDLE H, SELECT, COMPLEMENT, UNION, INTERSECT, STATE(n), UPDATE, AGGR, SORT, SESSION, or PAGE.
13 . The apparatus of claim 8 , wherein the processor-executable instructions that cause the apparatus to retrieve the data associated with the subset value from the plurality of data tables further cause the apparatus to perform a PAGE operation to retrieve one or more data values from the plurality of data tables based on the first handle and the second handle.
14 . The apparatus of claim 8 , wherein the processor-executable instructions that cause the apparatus to generate the second handle for the subset value further cause the apparatus to perform at least one aggregation, wherein the at least one aggregation is associated with the first value and the subset value.
15 . One or more non-transitory computer-readable media storing processor-executable instructions that, when executed by one or more processors, cause the one or more processors to:
receive a plurality of data tables, wherein each data table of the plurality of data tables comprises a plurality of rows;
generate, based on a first selection of at least one graphical object at a user interface, a first handle for a first value in a table of the plurality of data tables, wherein the first handle indicates that each row, of the plurality of rows, in each data table of the plurality of data tables is associated or not associated with the first value;
generate, based on the first handle and a further selection of at least one graphical object at the user interface, a second handle for a subset value, wherein the further selection is associated with the subset value, and wherein the subset value is associated with the first value;
retrieve, based on the first handle and the second handle, data associated with the subset value from the plurality of data tables; and
output, at the user interface, at least one graphical object based on the retrieved data from the plurality of data tables.
16 . The one or more non-transitory computer-readable media of claim 15 , wherein the user interface comprises a plurality of graphical objects, and wherein the plurality of graphical objects comprises at least one chart, table, or graph.
17 . The one or more non-transitory computer-readable media of claim 15 , wherein the second handle identifies an association or a lack of an association of each row in each data table, of the plurality of data tables, with the subset value.
18 . The one or more non-transitory computer-readable media of claim 15 , wherein an intersection of a column and a row in the first handle comprises an indication of association or a lack of an association with the first value.
19 . The one or more non-transitory computer-readable media of claim 15 , wherein the processor-executable instructions that cause the one or more processors to retrieve the data associated with the subset value from the plurality of data tables further cause the one or more processors to perform one or more operations on the first handle and the second handle, wherein the one or more operations comprise performing one or more of SET HANDLE H, SELECT, COMPLEMENT, UNION, INTERSECT, STATE(n), UPDATE, AGGR, SORT, SESSION, or PAGE.
20 . The one or more non-transitory computer-readable media of claim 15 , wherein the processor-executable instructions that cause the one or more processors to retrieve the data associated with the subset value from the plurality of data tables further cause the one or more processors to perform a PAGE operation to retrieve one or more data values from the plurality of data tables based on the first handle and the second handle, and wherein the processor-executable instructions that cause the one or more processors to generate the second handle for the subset value further cause the one or more processors to perform at least one aggregation, wherein the at least one aggregation is associated with the first value and the subset value.