Maria Nazareno Scanlon

US Patent:

8458164, Jun 4, 2013

Filed:

Jul 15, 2003

Appl. No.:

10/620857

Inventors:

Brian G. Payton - San Jose CA, US
Stavros Polyviou - Yeri, CY
Maria N. Scanlon - Morgan Hill CA, US
Sheila I. Sholars - Morgan Hill CA, US
Andrew Speakes - San Jose CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/30

US Classification:

707713, 707722, 707736, 707758, 707781, 707791

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.

US Patent:

20050015361, Jan 20, 2005

Filed:

Jul 15, 2003

Appl. No.:

10/620538

Inventors:

Brian Payton - San Jose CA, US
Maria Scanlon - Morgan Hill CA, US
Sheila Sholars - Morgan Hill CA, US
Andrew Speakes - San Jose CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F007/00

US Classification:

707003000

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 model content provider has a hierarchical architecture including lower level API specific components for supporting a plurality of GUI API's, and higher level API-independent, reusable components. This architecture facilitates scalability in terms of adding support for new API's.

US Patent:

20050015363, Jan 20, 2005

Filed:

Jul 15, 2003

Appl. No.:

10/620856

Inventors:

Stefan Dessloch - Kaiserslautern, DE
Brian Payton - San Jose CA, US
Maria Scanlon - Morgan Hill CA, US
Sheila Sholars - Morgan Hill CA, US
Andrew Speakes - San Jose CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F007/00

US Classification:

707003000

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. A query modeling structure and method are provided for clearly representing query statements which include an atomic element, a combined element and a relationship between the two defined by a combined operator.

US Patent:

20050015368, Jan 20, 2005

Filed:

Jul 15, 2003

Appl. No.:

10/620633

Inventors:

Brian Payton - San Jose CA, US
Stavros Polyviou - Yeri, CY
Maria Scanlon - Morgan Hill CA, US
Sheila Sholars - Morgan Hill CA, US
Andrew Speakes - San Jose CA, US

International Classification:

G06F017/30

US Classification:

707004000, 707003000

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 dynamically adapts to selections by a user in creating or editing a query statement, thus providing a helpful and user-friendly visual interface.

US Patent:

20080288465, Nov 20, 2008

Filed:

Jun 18, 2008

Appl. No.:

12/141777

Inventors:

Brian G. PAYTON - San Jose CA, US
Maria N. Scanlon - Morgan Hill CA, US
Sheila I. Sholars - Morgan Hill CA, US
Andrew Speakes - San Jose CA, US

Assignee:

INTERNATIONAL BUSINESS MACHINES CORPORATION - Armonk NY

International Classification:

G06F 17/30

US Classification:

707 3, 707E17014

Abstract:

A user-friendly query modeling tool 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 model content provider has a hierarchical architecture including lower level API specific components for supporting a plurality of GUI API'S, and higher level API-independent, reusable components. This architecture facilitates scalability in terms of adding support for new API's.