Systems And Methods For Generating A Database Query Using A Graphical User Interface

A computer-implemented graphical user interface system for generating a database query, comprising:

• a first interface configured to receive a first set of graphical icons, the first set of graphical icons including one or more clause-specific icons that identify database operations and one or more table icons that identify sets of data in the database,
• the first interface being further configured to create an association between the first set of graphical icons to create a database query;
• and
• a second interface that is displayed by performing a drill-down operation in connection with a join-related clause icon in the first set of graphical icons,
• the second interface being configured to receive a second set of graphical icons and to create an association between the second set of graphical icons to define a join operation in the database query.

A computer-implemented graphical user interface system for generating a database query, comprising:

• a first interface configured to receive a first set of graphical icons, the first set of graphical icons including one or more clause-specific icons that identify database operations, one or more table icons that identify sets of data in the database, and a subquery icon,
• the first interface being further configured for associating the first set of graphical icons to create a database query;
• and
• a second interface that is displayed by performing a drill-down operation in connection with the subquery icon in the first set of graphical icons,
• the second interface being configured to receive a second set of graphical icons and to associate the second set of graphical icons to define a subquery operation in the database query.

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 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 with the first graphical icon.