Computer-Implemented Systems And Methods For Extract, Transform, And Load User Interface Processing
First Claim
1. A computer-implemented method for specifying through a computer-based graphical user interface an Extract, Transform, Load (ETL) process, wherein the ETL process is represented through a hierarchy of levels, wherein a level comprises one or more ETL diagrams having ETL components representative of one of more ETL-related entities or actions, said method comprising:
- displaying an ETL diagram on the graphical user interface;
wherein the displayed ETL diagram includes a display of parent ETL diagram information and provides an indication of which ETL components are allowable specifically for the displayed ETL diagram;
wherein determination as to which ETL components are allowable for the displayed ETL diagram is based upon the parent ETL diagram information associated with the displayed ETL diagram;
using the parent ETL diagram information on the displayed ETL diagram to navigate to a different ETL diagram within the hierarchy; and
updating the ETL process based upon allowable components that are selected with respect to the displayed ETL diagram and the different ETL diagram;
wherein the updated ETL process is used by a computer system to process data from one or more data sources for loading into one or more data targets.
1 Assignment
0 Petitions
Accused Products
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.
36 Citations
20 Claims
-
1. A computer-implemented method for specifying through a computer-based graphical user interface an Extract, Transform, Load (ETL) process, wherein the ETL process is represented through a hierarchy of levels, wherein a level comprises one or more ETL diagrams having ETL components representative of one of more ETL-related entities or actions, said method comprising:
-
displaying an ETL diagram on the graphical user interface; wherein the displayed ETL diagram includes a display of parent ETL diagram information and provides an indication of which ETL components are allowable specifically for the displayed ETL diagram; wherein determination as to which ETL components are allowable for the displayed ETL diagram is based upon the parent ETL diagram information associated with the displayed ETL diagram; using the parent ETL diagram information on the displayed ETL diagram to navigate to a different ETL diagram within the hierarchy; and updating the ETL process based upon allowable components that are selected with respect to the displayed ETL diagram and the different ETL diagram; wherein the updated ETL process is used by a computer system to process data from one or more data sources for loading into one or more data targets. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15)
-
-
16. A computer-implemented system for specifying through a computer-based graphical user interface an Extract, Transform, Load (ETL) process, wherein the ETL process is represented through a hierarchy of levels, wherein a level comprises one or more ETL diagrams having ETL components representative of one of more ETL-related entities or actions, said system comprising:
-
one or more data processors; a computer-readable storage medium encoded with instructions for commanding the one or more data processors to execute steps including; displaying an ETL diagram on the graphical user interface; wherein the displayed ETL diagram includes a display of parent ETL diagram information and provides an indication of which ETL components are allowable specifically for the displayed ETL diagram; wherein determination as to which ETL components are allowable for the displayed ETL diagram is based upon the parent ETL diagram information associated with the displayed ETL diagram; using the parent ETL diagram information on the displayed ETL diagram to navigate to a different ETL diagram within the hierarchy; and updating the ETL process based upon allowable components that are selected with respect to the displayed ETL diagram and the different ETL diagram; wherein the updated ETL process is used by a computer system to process data from one or more data sources for loading into one or more data targets. - View Dependent Claims (17, 18, 19)
-
-
20. A non-transitory computer readable medium comprising programming instructions for specifying through a computer-based graphical user interface an Extract, Transform, Load (ETL) process, wherein the ETL process is represented through a hierarchy of levels, wherein a level comprises one or more ETL diagrams having ETL components representative of one of more ETL-related entities or actions, the programming instructions adapted to cause a processing system to execute steps comprising:
-
displaying an ETL diagram on the graphical user interface; wherein the displayed ETL diagram includes a display of parent ETL diagram information and provides an indication of which ETL components are allowable specifically for the displayed ETL diagram; wherein determination as to which ETL components are allowable for the displayed ETL diagram is based upon the parent ETL diagram information associated with the displayed ETL diagram; using the parent ETL diagram information on the displayed ETL diagram to navigate to a different ETL diagram within the hierarchy; and updating the ETL process based upon allowable components that are selected with respect to the displayed ETL diagram and the different ETL diagram; wherein the updated ETL process is used by a computer system to process data from one or more data sources for loading into one or more data targets.
-
Specification