Back to results
US 12,182,112 B2Granted
Selection query language methods and systems
AssigneeQliktech International AB
InventorsCharles M. Potter, Jose Diaz Lopez
Life of this patent
Estimating the term…
Abstract
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.
Claims20
A method comprising:
- determining, by a computing device, based on one or more operations performed on data associated with a first attribute and a handle for the first attribute, one or more changes to table data associated with the first attribute and stored in a plurality of data tables, wherein the handle comprises a row and at least one column for each data table of the plurality of data tables;
- determining, based on the one or more changes, an updated selection state for the handle, wherein the handle indicates, prior to performance of the one or more operations, an initial selection state of the table data via the row and the at least one column for each data table of the plurality of data tables, wherein the initial selection state indicates an association or a lack of an association between the first attribute and the table data stored in the plurality of data tables;
- and
- causing, based on the updated selection state, the handle to be updated by retrieving one or more data values from the table data associated with the one or more changes, wherein the updated handle comprises the updated selection state and indicates, based on the retrieved one or more data values associated with the one or more changes, an association or a lack of an association between the first attribute and the table data.
1 more element
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:
- determine, based on one or more operations performed on data associated with a first attribute and a handle for the first attribute, one or more changes to table data associated with the first attribute and stored in a plurality of data tables, wherein the handle comprises a row and at least one column for each data table of the plurality of data tables;
- determine, based on the one or more changes, an updated selection state for the handle, wherein the handle indicates, prior to performance of the one or more operations, an initial selection state of the table data via the row and the at least one column for each data table of the plurality of data tables, wherein the initial selection state indicates an association or a lack of an association between the first attribute and the table data stored in the plurality of data tables;
- and
- cause, based on the updated selection state, the handle to be updated by retrieving one or more data values from the table data associated with the one or more changes, wherein the updated handle comprises the updated selection state and indicates, based on the retrieved one or more data values associated with the one or more changes, an association or a lack of an association between the first attribute and the table data.
3 more elements
A non-transitory computer-readable storage medium comprising processor-executable instructions that, when executed by one or more processors of a computing device, cause the computing device to:
- determine, based on one or more operations performed on data associated with a first attribute and a handle for the first attribute, one or more changes to table data associated with the first attribute and stored in a plurality of data tables, wherein the handle comprises a row and at least one column for each data table of the plurality of data tables;
- determine, based on the one or more changes, an updated selection state for the handle, wherein the handle indicates, prior to performance of the one or more operations, an initial selection state of the table data via the row and the at least one column for each data table of the plurality of data tables, wherein the initial selection state indicates an association or a lack of an association between the first attribute and the table data stored in the plurality of data tables;
- and
- cause, based on the updated selection state, the handle to be updated by retrieving one or more data values from the table data associated with the one or more changes, wherein the updated handle comprises the updated selection state and indicates, based on the retrieved one or more data values associated with the one or more changes, an association or a lack of an association between the first attribute and the table data.
1 more element
Dependencies are inferred from the claim text.