IP Library Granted Patent US 8,214,383
Granted Patent B2
US 8,214,383 · App. 11/266,739 · Granted Jul 3, 2012

Mixed mode (mechanical process and english text) query building support for improving the process of building queries correctly

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,214,383
App. No.
11/266,739
Granted
Jul 3, 2012
Kind
B2
Abstract

Embodiments of the present invention allow verification of query language by providing a natural language description for the query language. A natural language description is generated for each query component along with selectable text representing the query component. Upon selection of the selectable text, the query component is rendered for editing.

Claims (19)

1. A computer-implemented method for verifying query logic, comprising:

receiving a first user input corresponding to a query language, the first input defining a plurality of query components for a query being composed by a user;

for each query component, generating a natural language description for the query component, wherein each respective natural language description provides a statement of an action performed by the query component when the query is executed;

receiving a second user input, wherein the second user input modifies a portion of the natural language description; and

in response to the modified portion of the natural language description, modifying the query component corresponding to the modified portion to provide a modified query, which when executed, performs an action specified by the modified natural language statement.

2. The method of claim 1 , further comprising:

receiving a drop down selection upon receiving a selection of a particular portion of the natural language description, the drop down selection containing alternative natural language descriptions for the particular portion; and

selecting an alternative natural language description from the drop down selection, the selection being configured to modify the corresponding query component corresponding to the particular portion to reflect the selection.

3. The method of claim 1 , wherein the natural language description contains hyperlinks connecting the portions of the natural language description to respective associated query components and wherein receiving selections of portions of the natural language description comprises receiving selections of the hyperlinks and further comprising:

responsive to receiving a selection of a given hyperlink for a given portion of the natural language description, navigating the user to the respective associated query component of the given portion.

4. The method of claim 1 , wherein the plurality of query components are selected from one of a conditional statement and an output statement.

5. The method of claim 1 , wherein the natural language description for each component is generated in real time as each corresponding query component is defined.

6. The method of claim 1 , further comprising:

displaying the plurality of query components of the query in a first panel of a graphical user interface; and

simultaneously displaying the natural language description in a second panel of the graphical user interface.

7. The method of claim 6 , wherein both the first and second panels are editable and making edits to either panel results in corresponding changes to be automatically reflected in the other panel.

8. The method of claim 1 , wherein receiving user input comprises:

receiving selections in one or more screens of a graphical user interface, the screens comprising one or more query components, wherein the selections define the one or more query components; and

in response to the selections, generating the query language.

Assignments (2)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 15, 2021
From: INTERNATIONAL BUSINESS MACHINES CORPORATION
To: AIRBNB, INC.
Reel/Frame 056427/0193 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 4, 2006
From: DETTINGER, RICHARD D.; KOLZ, DANIEL P.; STEVENS, RICHARD J.
To: INTERNATIONAL BUSINESS MACHINES CORPORATION
Reel/Frame 017162/0171 →