Query model tool and method for visually grouping and ungrouping predicates
First Claim
1. A computer-implemented system for assisting a user in creating and/or editing a query statement, the computer-implemented system comprising:
- means for visually displaying a search condition of a query statement in a first display area;
means for visually selecting two or more predicates of the displayed search condition for grouping;
means for resolving column references and value expression datatypes in the query statement comprising;
syntactic parsing of an input into an internal model form,semantic resolving of SQL expression tables and columns by associating the SQL expression tables and columns with table and column entities provided in an information catalog, andresolving remaining value expression datatypes; and
means responsive to selection of the two or more predicates for visually indicating the grouping in the first display area.
1 Assignment
0 Petitions
Accused Products
Abstract
A user-friendly query modeling tool and method, for representing, creating, modifying and modeling a query language statement for use in retrieving data from a database. In accordance with the present invention, the tool includes a user interface for receiving or building and manipulating a query, a query model definition for use in populating instances of one or more query models, and a model content provider for receiving query elements from the user interface and providing them to the query model, and conversely, for retrieving query elements from the query model and providing them to the user interface. The user interface enables the user to easily group and ungroup query elements by providing a visual tool for selecting query elements to be grouped and ungrouped.
44 Citations
48 Claims
-
1. A computer-implemented system for assisting a user in creating and/or editing a query statement, the computer-implemented system comprising:
-
means for visually displaying a search condition of a query statement in a first display area; means for visually selecting two or more predicates of the displayed search condition for grouping; means for resolving column references and value expression datatypes in the query statement comprising; syntactic parsing of an input into an internal model form, semantic resolving of SQL expression tables and columns by associating the SQL expression tables and columns with table and column entities provided in an information catalog, and resolving remaining value expression datatypes; and means responsive to selection of the two or more predicates for visually indicating the grouping in the first display area. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16)
-
-
17. A computer-implemented method for assisting a user in creating and/or editing a query statement, wherein the computer performs the following functions comprising:
-
visually displaying a search condition of a query statement in a first display area of the user interface; visually selecting two or more predicates of the displayed search condition for grouping; visually resolving column references and value expression datatypes in the query statement comprising; syntactic parsing of an input into an internal model form, semantic resolving of SQL expression tables and columns by associating the SQL expression tables and columns with table and column entities provided in an information catalog, and resolving remaining value expression datatypes; and visually indicating the grouping in the first display area in response to selection of the two or more predicates. - View Dependent Claims (18, 19, 20, 21, 22, 23, 25, 26, 27, 28, 29, 30, 31, 32)
-
-
24. The method of claim computer-implemented 21, where confirmation causes a model instance to be updated with the selected ungrouping.
-
33. A non-transitory computer storage medium readable by a computer and embodying one or more instructions executable by the computer, the computer program providing a query assist tool for assisting a user in creating and/or editing a query statement and further comprising:
-
program instructions for visually displaying a search condition of a query statement in a first display area of the user interface; and program instructions for visually selecting two or more predicates of the displayed search condition for grouping; program instructions for visually resolving column references and value expression datatypes in the query statement comprising; syntactic parsing of an input into an internal model form, semantic resolving of SQL expression tables and columns by associating the SQL expression tables and columns with table and column entities provided in an information catalog, and resolving remaining value expression datatypes; and program instructions for visually indicating the grouping in the first display area in response to selection of the two or more predicates. - View Dependent Claims (34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48)
-
Specification