Russell E Robison

US Patent:

7908266, Mar 15, 2011

Filed:

May 6, 2008

Appl. No.:

12/115808

Inventors:

Donna Evelyn Zeringue - Cary NC, US
Russell Edward Robison - Cary NC, US
Nancy Anne Rausch - Apex NC, US

Assignee:

SAS Institute Inc. - Cary NC

International Classification:

G06F 17/30

US Classification:

707714, 707716, 707999006

Abstract:

Systems and methods are provided for automatically creating an SQL join expression. A computer-implemented graphical user interface may receive a first user input that identifies a first table to be included in the SQL join expression and a second user input that identifies a second table to be included in the SQL join expression. Software instructions stored in a computer-readable medium may automatically define the SQL join expression by matching one or more keys or indices in the first table with one or more keys or indices in the second table.

US Patent:

20090024940, Jan 22, 2009

Filed:

May 6, 2008

Appl. No.:

12/115815

Inventors:

Donna Evelyn Zeringue - Cary NC, US
Russell Edward Robison - Cary NC, US
Nancy Anne Rausch - Apex NC, US

International Classification:

G06F 3/048

US Classification:

715763

Abstract:

A computer-implemented graphical user interface system for generating a database query includes a create region, a plurality of clause-specific regions and a navigation region. The create region may be used to receive a plurality of graphical icons and to create an association between the plurality of graphical icons to define the database query. The plurality of graphical icons may include a plurality of clause-specific icons that identify clauses for the database query and a plurality of table icons that identify sets of data in the database. The plurality of clause-specific interface regions are each associated with a particular clause-specific icon and may be used to receive user input to define one or more parameters associated with the particular clause-specific icon. The navigation region may be used to receive user input to select between the create region and the plurality of clause-specific interface regions.

US Patent:

20120324387, Dec 20, 2012

Filed:

Jun 15, 2011

Appl. No.:

13/160718

Inventors:

Nancy Anne Rausch - Apex NC, US
Peter Rowland Eastwood - Cary NC, US
Andrew Shakinovsky - Apex NC, US
Russell Edward Robison - Cary NC, US

International Classification:

G06F 3/048

US Classification:

715771

Abstract:

Computer-implemented systems and methods are disclosed for specifying an Extract, Transform, Load (ETL) process. For example, systems and methods are provided for specifying the ETL process through ETL diagrams, and allowing ETL diagrams with different components to be easily traversed. Behaviors of underlying engine technology of the ETL process may be encapsulated so that users may build a job or data flow of the ETL process without knowing specific details of the underlying engine technology.