×

Computer-Implemented Systems And Methods For Extract, Transform, And Load User Interface Processing

  • US 20120324387A1
  • Filed: 06/15/2011
  • Published: 12/20/2012
  • Est. Priority Date: 06/15/2011
  • Status: Active Grant
First Claim
Patent Images

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 all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×