PROCESSING QUERY CONDITIONS HAVING FILTERED FIELDS WITHIN A DATA ABSTRACTION ENVIRONMENT
First Claim
Patent Images
1. A computer-implemented method for composing abstract queries, comprising:
- receiving a selection, from a plurality of filtered fields, of a first field to be included in an abstract query, the plurality of filtered fields defined in an abstraction model that models underlying physical data in a manner making a schema of the physical data transparent to a user of the abstraction model;
determining one or more physical columns storing at least one value defining the first field;
identifying, from the plurality of filtered fields, one or more filtered fields defined by one or more values stored in the one or more physical columns;
presenting the one or more filtered fields to a user;
receiving a user selection, from the one or more filtered fields, of at least one filtered field to be included in the abstract query; and
composing the abstract query using the first field together with the at least one filtered field.
2 Assignments
0 Petitions
Accused Products
Abstract
Embodiments of the invention provide techniques for composing and executing queries using filtered fields. In one embodiment, a query may be composed with compatible fields, meaning filtered fields that store related data of a particular data type. Such compatible fields may be combined into a single query condition, thus simplifying the composition and execution of the query. In one embodiment, fields may be identified as compatible based on metadata included in a database abstraction model.
-
Citations
21 Claims
-
1. A computer-implemented method for composing abstract queries, comprising:
-
receiving a selection, from a plurality of filtered fields, of a first field to be included in an abstract query, the plurality of filtered fields defined in an abstraction model that models underlying physical data in a manner making a schema of the physical data transparent to a user of the abstraction model; determining one or more physical columns storing at least one value defining the first field; identifying, from the plurality of filtered fields, one or more filtered fields defined by one or more values stored in the one or more physical columns; presenting the one or more filtered fields to a user; receiving a user selection, from the one or more filtered fields, of at least one filtered field to be included in the abstract query; and composing the abstract query using the first field together with the at least one filtered field. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A computer-readable storage medium including a program, which when executed on a processor performs an operation, the operation comprising:
-
receiving a selection, from a plurality of filtered fields, of a first field to be included in an abstract query, the plurality of filtered fields defined in an abstraction model that models underlying physical data in a manner making a schema of the physical data transparent to a user of the abstraction model; determining one or more physical columns storing at least one value defining the first field; identifying, from the plurality of filtered fields, one or more filtered fields defined by one or more values stored in the one or more physical columns; presenting the one or more filtered fields to a user; receiving a user selection, from the one or more filtered fields, of at least one filtered field to be included in the abstract query; and composing the abstract query using the first field together with the at least one filtered field. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17, 18)
-
-
19. A computer-implemented method for composing abstract queries, comprising:
-
receiving a selection, from a plurality of logical fields, of a first field to be included in an abstract query, the plurality of logical fields defined in an abstraction model that models underlying physical data in a manner making a schema of the physical data transparent to a user of the abstraction model; identifying, from the plurality of logical fields, one or more logical fields selected from;
(i) filtered fields defined with a name column and a value column used to define the first field, and (ii) logical fields generated by a field template used to generate the first field, the field template being configured to generate multiple logical fields based on received parameters values;presenting the one or more logical fields to a user; receiving a user selection, from the one or more logical fields, of at least one logical field to be included in the abstract query; and composing the abstract query using the first field together with the at least one logical field. - View Dependent Claims (20, 21)
-
Specification