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.

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.

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.

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.

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.

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.