Patent ID: 8458200
Filing Date: 2013-06-04
Classification: G06F

Abstract:
1. A computer-implemented method for composing abstract queries, comprising: providing an abstraction model defining a plurality of filtered fields, wherein the abstraction model models underlying physical data in a manner making a schema of the physical data transparent to a user of the abstraction model, wherein the abstraction model includes a filtered field definition for each filtered field specifying a respective: (i) field name that uniquely identifies the filtered field, (ii) first column, (iii) second column and (iv) filter value, wherein the filtered field is configured to return a subset of values from the first column based on which values within the second column correspond to the filter value; receiving a first selection of a first one of the plurality of filtered fields to be included in an abstract query, the first filtered field selected using the field name associated with the first filtered field; identifying, from the plurality of filtered fields, one or more filtered fields, distinct from the selected first filtered field, and each having a respective filtered field definition that specifies a same first column and second column as the filtered field definition of the selected first filtered field; presenting the identified one or more filtered fields in a user interface; receiving a second selection of at least one of the presented filtered fields to be included in the abstract query; and composing the abstract query using the field name associated with the first filtered field to reference the first filtered field, together with the respective field name associated with each of the at least one selected filtered field, to reference the at least one selected filtered field.