Systems And Methods For Automatically Creating An SQL Join Expression
AssigneeSAS Institute Inc.
InventorsDonna Evelyn Zeringue, Russell Edward Robison, Nancy Anne Rausch
Life of this patent
Estimating the term…
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.
Claims16
A computer implemented method for automatically creating an SQL join expression, comprising:
- receiving a first user input that identifies a first table to be included in the SQL join expression;
- receiving a second user input that identifies a second table to be included in the SQL join expression;
- automatically creating a first SQL join for the SQL join expression and adding the first table to a left side of the first SQL join and adding the second table to a right side of the first SQL join;
- automatically matching one or more keys or indices in the first table with one or more keys or indices in the second table to define a where clause for the SQL join expression;
- and
- storing the SQL join expression in a memory device.
A system for generating a database query, comprising:
- a computer-implemented graphical user interface configured to receive a first user input that identifies a first table to be included in the SQL join expression and to receive a second user input that identifies a second table to be included in the SQL join expression;
- and
- software instructions stored in a computer-readable medium and configured to 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.
A computer implemented method for automatically creating an SQL join expression, comprising:
- receiving a first user input that identifies a first table to be included in the SQL join expression;
- receiving a second user input that identifies a second table to be included in the SQL join expression;
- automatically displaying a first graphical icon that represents a join operation in the SQL join expression;
- automatically associating the first table with a first input to the first graphical icon and associating the second table with a second input to the first graphical icon;
- and
- automatically generating the SQL join expression based on the associations between the first and second tables and the first graphical icon.
Dependencies are inferred from the claim text.