Back to results
US 8,285,736 B2Granted
Disabling query conditions in an abstract query environment
AssigneeInternational Business Machines Corporation
InventorsRichard D. Dettinger, Frederick A. Kulack
Life of this patent
Estimating the term…
Abstract
Embodiments of the invention provide techniques for temporarily disabling conditions in abstract queries. In one embodiment, a query interface is configured to present an abstract query, and to allow a user to select conditions of the abstract query to be temporarily disabled. By executing an abstract query having disabled conditions, the user may be able to determine the effect of individual changes to the abstract query without having to re-compose the abstract query after each change. The conditions to be disabled may be selected individually, by field, or by value. Each disabled element may be displayed with a visual indicator communicating that it is disabled. The user may then select specific disabled conditions to be re-enabled.
Claims18
A computer-implemented method, comprising:
- presenting, in a query interface, an abstract query comprising a plurality of conditional expressions arranged within multiple nested logical levels separated by one or more logical operators, wherein the plurality of conditional expressions is defined in an abstraction model that defines logical fields that model underlying physical data, wherein each of the defined logical fields is associated with a respective access method specifying a manner of mapping the logical field to a corresponding one or more physical fields of the underlying physical data, and wherein the respective access method is selected from two or more different types of access methods;
- receiving a selection, from the plurality of conditional expressions, of one or more conditional expressions to be disabled in the abstract query;
- presenting the abstract query in the query interface, wherein each of the selected one or more conditional expressions is presented with an indication communicating that the respective conditional expression is disabled, such that each of the selected one or more conditional expressions is maintained in a respective original location within the multiple nested logical levels of the abstract query;
- executing the abstract query excluding the selected one or more conditional expressions, comprising:
- generating a temporary abstract query based on the abstract query and the selected one or more conditional expressions, wherein the temporary abstract query excludes the selected one or more conditional expressions;
- transforming the generated temporary abstract query into an executable query;
- and
- executing the executable query against the underlying physical data to produce a set of query results;
- and
- returning the set of query results of executing the abstract query to the query interface.
7 more elements
A non-transitory computer readable medium containing a program for processing an abstract rule, when executed, performs an operation, comprising:
- presenting, in a query interface, an abstract query comprising a plurality of conditional expressions arranged within multiple nested logical levels separated by one or more logical operators, wherein the plurality of conditional expressions is defined in an abstraction model that defines logical fields that model underlying physical data, wherein each of the defined logical fields is associated with a respective access method specifying a manner of mapping the logical field to a corresponding one or more physical fields of the underlying physical data, and wherein the respective access method is selected from two or more different types of access methods;
- receiving a selection, from the plurality of conditional expressions, of one or more conditional expressions to be disabled in the abstract query;
- presenting the abstract query in the query interface, wherein each of the selected one or more conditional expressions is presented with an indication communicating that the respective conditional expression is disabled, such that each of the selected one or more conditional expressions is maintained in a respective original location within the multiple nested logical levels of the abstract query;
- executing the abstract query excluding the selected one or more conditional expressions, comprising:
- generating a temporary abstract query based on the abstract query and the selected one or more conditional expressions, wherein the temporary abstract query excludes the selected one or more conditional expressions;
- transforming the generated temporary abstract query into an executable query;
- and
- executing the executable query against the underlying physical data to produce a set of query results;
- and
- returning a set of results of executing the abstract query to the query interface.
7 more elements
A system, comprising:
- a processor;
- and
- a memory containing a program, which when executed on the processor, performs an operation, comprising:
- presenting, in a query interface, an abstract query comprising a plurality of conditional expressions arranged within multiple nested logical levels separated by one or more logical operators, wherein the plurality of conditional expressions is defined in an abstraction model that defines logical fields, wherein each of the defined logical fields is associated with a respective access method specifying a manner of mapping the logical field to a corresponding one or more physical fields of the underlying physical data, and wherein the respective access method is selected from two or more different types of access methods;
- receiving a selection, from the plurality of conditional expressions, of one or more conditional expressions to be disabled in the abstract query;
- presenting the abstract query in the query interface, wherein each of the selected one or more conditional expressions is presented with an indication communicating that the respective conditional expression is disabled, such that each of the selected one or more conditional expressions is maintained in a respective original location within the multiple nested logical levels of the abstract query, wherein the indication comprises at least one of:
- (i) a font color, (ii) a struck-out font, (iii) a background color, and (iv) a symbol;
- executing the abstract query excluding the selected one or more conditional expressions, comprising:
- generating a temporary abstract query based on the abstract query and the selected one or more conditional expressions, wherein the temporary abstract query excludes the selected one or more conditional expressions;
- transforming the generated temporary abstract query into an executable query;
- and
- executing the executable query against the underlying physical data to produce a set of query results;
- and
- returning a set of results of executing the abstract query to the query interface.
11 more elements
Dependencies are inferred from the claim text.