Patent US6671691B1 successfully refreshed from Google Patents.
← Back to Patent Explorer
US6671691B1 Expired / Lapsed US ⏱️ 0.0 years remaining

Method and apparatus for expression building editors

Assignee: International Business Machines Corp
•
Filing: 1998-06-04
•
Granted: 2003-12-30
•
Expires: 2018-06-04
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

Abstract

Abstract According to a preferred embodiment of the present invention, a method and an apparatus for a user-friendly expression builder GUI is disclosed. The preferred embodiment GUI design enables users to construct syntactically valid expressions, without any knowledge of expression syntax. The preferred embodiment provides generic expressions, which serve as starting points in expression building. Each generic expression is a syntactically correct expression containing generic parameters. The GUI user customizes the syntactically correct generic expression, by replacing the generic parameters with parameters specific to the database task at hand. The preferred embodiment provides lists of such specific parameters, including lists of field names and constants, which are selected to build the expression.

Inventors

  • 👤 Joseph Phillip Bigus

Bibliographic Details

Application Number —
Jurisdiction US
Data Source google_patents
Last Synchronized 2026-11-07 09:16
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/242; G06F16/2428; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99942; Y10S707/99943; Y10S715/00; Y10S715/961

Claims Analysis

Total Claims: 60
Claim 1
Independent Claim 133 words
A method for building syntactically correct expressions, said method comprising executing the following steps by a computer processor in the indicated sequential order: providing a plurality of generic expressions, each of said plurality of genetic expressions including at least one genetic argument, allowing user selection of a generic expression of said plurality of generic expressions; providing a plurality of specific arguments relating to said selected generic expression; allowing user selection of a specific argument of said plurality of specific arguments relating to said selected generic expression; allowing user selection of a generic argument of said at least one generic argument, for subsequent replacement of said generic argument in said selected generic expression with said selected specific argument, and replacing said selected generic argument in said selected generic expression with said selected specific argument.
Claim 2
Independent Claim 133 words
A method for building syntactically correct expressions, said method comprising executing the following steps by a computer processor in the indicated sequential order: providing a plurality of generic expressions, each of said plurality of genetic expressions including at least one genetic argument, allowing user selection of a generic expression of said plurality of generic expressions; providing a plurality of specific arguments relating to said selected generic expression; allowing user selection of a specific argument of said plurality of specific arguments relating to said selected generic expression; allowing user selection of a generic argument of said at least one generic argument, for subsequent replacement of said generic argument in said selected generic expression with said selected specific argument, and replacing said selected generic argument in said selected generic expression with said selected specific argument.
Claim 3
Dependent Claim 23 words
The method of claim 1 , further comprising the step of allowing user replacement of a relational operator in said selected generic expression.
Claim 4
Dependent Claim 23 words
The method of claim 1 , further comprising the step of allowing the user to add generic arguments to said selected generic expression.
Claim 5
Dependent Claim 27 words
The method of claim 1 , further comprising the step of allowing one of said plurality of generic expressions to be deleted from said selected generic expression.
Claim 6
Dependent Claim 64 words
The method of claim 1 , further comprising the step of indicating completion of expression building by activating an OK selector, said OK selector activated only when all of said at least one generic arguments in said selected generic expression have been replaced by said selected specific arguments, wherein selection of said OK selector passes said selected generic expression to a data query tool.
Claim 7
Dependent Claim 34 words
The method of claim 1 , wherein said step of allowing user selection of a specific argument of said plurality of specific arguments comprises the step of allowing user definition of a new constant.
Claim 8
Dependent Claim 28 words
The method of claim 1 , wherein the step of allowing user selection of generic argument comprises activating a selector associated with said at least one generic argument.
Claim 9
Dependent Claim 27 words
The method of claim 1 , further comprising the step of allowing one of said plurality of generic expressions to be appended to said selected generic expression.
Claim 10
Dependent Claim 19 words
The method of claim 8 , wherein said generic expressions can be appended to said selected generic expression conjunctively.
Claim 11
Dependent Claim 26 words
The method of claim 1 , wherein said step of providing a plurality of specific arguments includes the step of providing a category of specific arguments.
Claim 12
Dependent Claim 20 words
The method of claim 10 , wherein said category of specific arguments comprises identifiers of fields in a data source.
Claim 13
Dependent Claim 14 words
The method of claim 10 , wherein said category of specific arguments includes constants.
Claim 14
Dependent Claim 34 words
The method of claim 1 , wherein each of said at least one generic argument has an associated data type, and wherein each of said plurality or specific arguments have an associated data type.
Claim 15
Dependent Claim 37 words
The method of claim 13 , wherein said step of allowing user selection of a generic argument includes requiring that said data type associated with said generic argument matches said data type associated with said specific argument.
Claim 16
Dependent Claim 27 words
The method of claim 1 , wherein the step of allowing user selection of a generic argument further comprises activating a selector that selects said generic argument.
Claim 17
Independent Claim 201 words
A method for building syntactically correct processing specifications, said method comprising executing the following steps by a computer processor in the indicated sequential order: providing a plurality of computed functions, each of said plurality of computed functions including at least one generic argument, each of said at least one generic arguments having an associated data type; allowing user selection of a computed function of said plurality of computed functions; allowing user selection of a specific argument category of a plurality of specific argument categories; providing a plurality of specific arguments in said selected specific argument category, each of said plurality of specific arguments having an associated data type; allowing user selection of a specific argument of said plurality of specific arguments; conditionally allowing user selection of a generic argument of said at least one generic argument, for subsequent replacement of said at least one generic argument in said user-selected computed function with said selected specific argument, said user selection of said generic argument being allowed only if said data type associated with said selected specific argument matches said data type associated with said generic argument, and replacing said selected generic argument in said selected computed function with said user-selected specific argument.
Claim 18
Independent Claim 201 words
A method for building syntactically correct processing specifications, said method comprising executing the following steps by a computer processor in the indicated sequential order: providing a plurality of computed functions, each of said plurality of computed functions including at least one generic argument, each of said at least one generic arguments having an associated data type; allowing user selection of a computed function of said plurality of computed functions; allowing user selection of a specific argument category of a plurality of specific argument categories; providing a plurality of specific arguments in said selected specific argument category, each of said plurality of specific arguments having an associated data type; allowing user selection of a specific argument of said plurality of specific arguments; conditionally allowing user selection of a generic argument of said at least one generic argument, for subsequent replacement of said at least one generic argument in said user-selected computed function with said selected specific argument, said user selection of said generic argument being allowed only if said data type associated with said selected specific argument matches said data type associated with said generic argument, and replacing said selected generic argument in said selected computed function with said user-selected specific argument.
Claim 19
Dependent Claim 23 words
The method of claim 16 , further comprising the step of allowing user definition of new generic arguments in said user-selected computed function.
Claim 20
Dependent Claim 25 words
The method of claim 16 , further comprising the step of allowing user definition of a new specific argument in said plurality of specific arguments.
Claim 21
Dependent Claim 31 words
The method of claim 16 , wherein the step of providing a plurality of computed functions comprises selecting a category of computed functions, which displays a list of available computed functions.
Claim 22
Dependent Claim 65 words
The method of claim 16 , further comprising the step of indicating completion of expression building by activating an OK selector, said OK selector activated only when all of said at least one generic arguments in said user-selected computed function have been replaced by said selected specific arguments, and wherein selection of said OK selector passes said user-selected computed function to a data query tool.
Claim 23
Dependent Claim 58 words
The method of claim 16 , wherein the step of allowing user selection of a generic argument comprises the steps of displaying at least one argument selector corresponding to said at least one generic argument, and activating said argument selector when said data type of said generic argument matches said data type associated with said selected specific argument.
Claim 24
Independent Claim 178 words
A method for building syntactically correct queries, said method comprising executing the following steps by a computer processor in the indicated sequential order: providing a plurality of generic clause selectors, each of said generic clause selectors corresponding to a generic clause consisting of two generic arguments and a relational operator, each of said generic clause selectors facilitating user selection of at least one of said corresponding generic clauses; displaying a selected generic clause in a text area; providing a plurality of relational operator selectors, each of said relational operator selector facilitating user replacement of said relational operator in said selected generic clause in said text area; displaying a plurality of specific arguments; allowing user selection of a specific argument of said plurality of specific arguments; allowing user selection of a generic argument of said two generic arguments, for subsequent replacement of said selected generic argument in said generic clause in said text area with said selected specific argument, and replacing said selected generic argument in said generic clause in said text area with a said selected specific argument.
Claim 25
Independent Claim 178 words
A method for building syntactically correct queries, said method comprising executing the following steps by a computer processor in the indicated sequential order: providing a plurality of generic clause selectors, each of said generic clause selectors corresponding to a generic clause consisting of two generic arguments and a relational operator, each of said generic clause selectors facilitating user selection of at least one of said corresponding generic clauses; displaying a selected generic clause in a text area; providing a plurality of relational operator selectors, each of said relational operator selector facilitating user replacement of said relational operator in said selected generic clause in said text area; displaying a plurality of specific arguments; allowing user selection of a specific argument of said plurality of specific arguments; allowing user selection of a generic argument of said two generic arguments, for subsequent replacement of said selected generic argument in said generic clause in said text area with said selected specific argument, and replacing said selected generic argument in said generic clause in said text area with a said selected specific argument.
Claim 26
Dependent Claim 25 words
The method of claim 22 , further comprising the step of allowing user definition of new specific arguments in said plurality of displayed specific arguments.
Claim 27
Dependent Claim 24 words
The method of claim 22 , wherein the step of displaying a plurality of specific arguments comprises displaying a plurality of specific argument categories.
Claim 28
Dependent Claim 42 words
The method of claim 22 , wherein the step of allowing user selection of a specific argument comprises allowing user activation of one of two argument selectors, said argument selectors activatable when one of said plurality of specific arguments has been selected.
Claim 29
Dependent Claim 23 words
The method of claim 22 , further comprising the step of allowing said selected generic clause to be deleted from said text area.
Claim 30
Dependent Claim 80 words
The method of claim 22 , further comprising the step of indicating completion of expression building by activating an OK selector, said OK selector activated only when each of said two generic arguments in all of said at least one selected generic clause in said text area have been replaced by said selected specific arguments, and wherein selection of said OK selector passes said at least one selected genetic clauses clause in said text area to a data query tool.
Claim 31
Dependent Claim 148 words
A computer program product comprising a computer usable medium having a computer readable program code embodied therein for building syntactically correct expressions, said computer code adapted to have the followings steps executed in the indicated sequential order: providing a plurality of generic expressions, each of said plurality of generic expressions including at least one generic argument; allowing user selection of a generic expression of said plurality of generic expressions; providing a plurality of specific arguments relating to said selected generic expression; allowing user selection of a specific argument of said plurality of specific arguments relating to said selected generic expression; allowing user selection of a generic argument of said at least one generic argument, for subsequent replacement of said selected generic argument in said selected generic expression with said selected specific argument, and replacing said selected generic argument in said selected generic expression with said selected specific argument.
Claim 32
Dependent Claim 148 words
A computer program product comprising a computer usable medium having a computer readable program code embodied therein for building syntactically correct expressions, said computer code adapted to have the followings steps executed in the indicated sequential order: providing a plurality of generic expressions, each of said plurality of generic expressions including at least one generic argument; allowing user selection of a generic expression of said plurality of generic expressions; providing a plurality of specific arguments relating to said selected generic expression; allowing user selection of a specific argument of said plurality of specific arguments relating to said selected generic expression; allowing user selection of a generic argument of said at least one generic argument, for subsequent replacement of said selected generic argument in said selected generic expression with said selected specific argument, and replacing said selected generic argument in said selected generic expression with said selected specific argument.
Claim 33
Dependent Claim 23 words
The method of claim 28 , further comprising the step of allowing user replacement of a relational operator in said selected generic expression.
Claim 34
Dependent Claim 23 words
The method of claim 28 , further comprising the step of allowing the user to add generic arguments to said selected generic expression.
Claim 35
Dependent Claim 27 words
The method of claim 28 , further comprising the step of allowing one of said plurality of generic expressions to be deleted from said selected generic expression.
Claim 36
Dependent Claim 64 words
The method of claim 28 , further comprising the step of indicating completion of expression building by activating an OK selector, said OK selector activated only when all of said at least one generic arguments in said selected generic expression have been replaced by said selected specific arguments, wherein selection of said OK selector passes said selected generic expression to a data query tool.
Claim 37
Dependent Claim 34 words
The method of claim 28 , wherein said step of allowing user selection or a specific argument of said plurality of specific arguments comprises the step of allowing user definition of a new constant.
Claim 38
Dependent Claim 29 words
The method of claim 28 , wherein the step of allowing user selection of a generic argument comprises activating a selector associated with said at least one generic argument.
Claim 39
Dependent Claim 27 words
The method of claim 28 , further comprising the step of allowing one of said plurality of generic expressions to be appended to said selected generic expression.
Claim 40
Dependent Claim 19 words
The method of claim 35 , wherein said generic expressions can be appended to said selected generic expression conjunctively.
Claim 41
Dependent Claim 26 words
The method of claim 28 , wherein said step of providing a plurality of specific arguments includes the step of providing a category of specific arguments.
Claim 42
Dependent Claim 20 words
The method of claim 37 , wherein said category of specific arguments comprises identifiers of fields in a data source.
Claim 43
Dependent Claim 14 words
The method of claim 37 , wherein said category of specific arguments includes constants.
Claim 44
Dependent Claim 34 words
The method of claim 28 , wherein each of said at least one generic argument has an associated data type, and wherein each of said plurality or specific arguments have an associated data type.
Claim 45
Dependent Claim 37 words
The method of claim 40 , wherein said step of allowing user selection of a generic argument includes requiring that said data type associated with said generic argument matches said data type associated with said specific argument.
Claim 46
Dependent Claim 27 words
The method of claim 28 , wherein the step or allowing user selection of a generic argument further comprises activating a selector that selects said generic argument.
Claim 47
Dependent Claim 215 words
A computer program product comprising a computer usable medium having a computer readable program code embodied therein for building syntactically correct processing specifications, said computer code adapted to have the followings steps executed in the indicated sequential order: providing a plurality of computed functions, each of said plurality of computed functions including at least one generic argument, each of said at least one generic arguments having an associated data type; allowing user selection of a computed function of said plurality of computed functions; allowing user selection of a specific argument category of a plurality of specific argument categories; providing a plurality of specific arguments in said selected specific argument category, each of said plurality of specific arguments having an associated data type; allowing user selection of a specific argument of said plurality of specific arguments; conditionally allowing user selection of a generic argument of said at least one generic argument, for subsequent replacement of said at least one generic argument in said user-selected computed function with said selected specific argument, said user selection of said generic argument being allowed only if said data type associated with said selected specific argument matches said data type associated with said generic argument, and replacing said selected generic argument in said selected computed function with said user-selected specific argument.
Claim 48
Dependent Claim 215 words
A computer program product comprising a computer usable medium having a computer readable program code embodied therein for building syntactically correct processing specifications, said computer code adapted to have the followings steps executed in the indicated sequential order: providing a plurality of computed functions, each of said plurality of computed functions including at least one generic argument, each of said at least one generic arguments having an associated data type; allowing user selection of a computed function of said plurality of computed functions; allowing user selection of a specific argument category of a plurality of specific argument categories; providing a plurality of specific arguments in said selected specific argument category, each of said plurality of specific arguments having an associated data type; allowing user selection of a specific argument of said plurality of specific arguments; conditionally allowing user selection of a generic argument of said at least one generic argument, for subsequent replacement of said at least one generic argument in said user-selected computed function with said selected specific argument, said user selection of said generic argument being allowed only if said data type associated with said selected specific argument matches said data type associated with said generic argument, and replacing said selected generic argument in said selected computed function with said user-selected specific argument.
Claim 49
Dependent Claim 23 words
The method of claim 43 , further comprising the step of allowing user definition of new generic arguments in said user-selected computed function.
Claim 50
Dependent Claim 25 words
The method of claim 43 , further comprising the step of allowing user definition of a new specific argument in said plurality, of specific arguments.
Claim 51
Dependent Claim 31 words
The method of claim 43 , wherein the step of providing a plurality or computed functions comprises selecting a category of computed functions, which displays a list of available computed functions.
Claim 52
Dependent Claim 65 words
The method of claim 43 , further comprising the step of indicating completion of expression building by activating an OK selector, said OK selector activated only when all of said at least one generic arguments in said user-selected computed function have been replaced by selected specific arguments, and wherein selection of said OK selector passes said user selected computed function to a data query tool.
Claim 53
Dependent Claim 58 words
The method of claim 43 , wherein the step of allowing user selection of a generic argument comprises the steps of displaying at least one argument selector corresponding to said at least one generic argument, and activating said argument selector when said data type of said generic argument matches said data type associated with said selected specific argument.
Claim 54
Dependent Claim 192 words
A computer program product comprising a computer usable medium having a computer readable program code embodied therein for building syntactically correct queries, said computer code adapted to leave the followings steps executed in the indicated sequential order; providing a plurality of generic clause selectors, each of said generic clause selectors corresponding to a generic clause consisting of two generic arguments and a relational operator, each of said generic clause selectors facilitating user selection of at least one of said corresponding generic clauses; displaying a selected generic clause in a text area; providing a plurality of relational operator selectors, each said relational operator selector facilitating user replacement of said relational operator in said selected generic gauzes clause in said text area; displaying a plurality or specific arguments; allowing user selection of a specific argument of said plurality of specific arguments; and allowing user selection of a generic argument of said two generic arguments, for subsequent replacement of said selected generic argument in said generic clause in said text area with said selected specific argument, and replacing said selected generic argument in said generic clause in said text area with said selected specific argument.
Claim 55
Dependent Claim 192 words
A computer program product comprising a computer usable medium having a computer readable program code embodied therein for building syntactically correct queries, said computer code adapted to leave the followings steps executed in the indicated sequential order; providing a plurality of generic clause selectors, each of said generic clause selectors corresponding to a generic clause consisting of two generic arguments and a relational operator, each of said generic clause selectors facilitating user selection of at least one of said corresponding generic clauses; displaying a selected generic clause in a text area; providing a plurality of relational operator selectors, each said relational operator selector facilitating user replacement of said relational operator in said selected generic gauzes clause in said text area; displaying a plurality or specific arguments; allowing user selection of a specific argument of said plurality of specific arguments; and allowing user selection of a generic argument of said two generic arguments, for subsequent replacement of said selected generic argument in said generic clause in said text area with said selected specific argument, and replacing said selected generic argument in said generic clause in said text area with said selected specific argument.
Claim 56
Dependent Claim 25 words
The method of claim 49 , further comprising the step of allowing user definition of new specific arguments in said plurality of displayed specific arguments.
Claim 57
Dependent Claim 24 words
The method of claim 49 , wherein the step of displaying a plurality of specific arguments comprises displaying a plurality of specific argument categories.
Claim 58
Dependent Claim 65 words
The method of claim 49 , wherein the step of facilitating user replacement of said at least one generic argument in said generic clause in said text area with a selected specific argument allowing user selection of a specific argument comprises allowing user activation of one of two argument selectors, said argument selectors activatable when one of said plurality of specific arguments has been selected.
Claim 59
Dependent Claim 24 words
The method of claim 49 , further comprising the step of allowing said selected generic clauses clause to be deleted from said text area.
Claim 60
Dependent Claim 79 words
The method of claim 49 , further comprising tile step of indicating completion of expression building by activating an OK selector, said OK selector activated only when each of said two generic arguments in all of said at least one selected generic clause in said text area have been replaced by said selected specific arguments, and wherein selection of said OK selector passes said at least one selected generic clause in said text area to a data query tool.

References Cited (Backward Citations)

US5485618A Cited
US5798757A Cited
US5701400A Cited

USPTO Annuity & Maintenance Windows

Annuity Stage Window Opens Payment Deadline Surcharge Period Until Estimated Fee Status
3.5 Years (Year 4) 2006-12-29 2007-06-30 2007-12-30 $2000.00 Window Closed / Lapsed
7.5 Years (Year 8) 2010-12-29 2011-06-30 2011-12-30 $3760.00 Window Closed / Lapsed
11.5 Years (Year 12) 2014-12-29 2015-06-30 2015-12-30 $7700.00 Window Closed / Lapsed

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag