EXTENSIBLE DATA DRIVEN ETL FRAMEWORK

An extensible ETL framework can be designed with components/elements that add and manage request driven customizations to a database and that allow an ETL application to incorporate these customizations into its ETL process without code changes to the ETL application. The extensible ETL framework co...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Cosgrove, JR., David William, Reno, JR., Gerald L, Caron, Jonathan Pantier
Format: Patent
Sprache:eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:An extensible ETL framework can be designed with components/elements that add and manage request driven customizations to a database and that allow an ETL application to incorporate these customizations into its ETL process without code changes to the ETL application. The extensible ETL framework comprises a data aggregator element ("data aggregator") that processes customization requests for a database. The data aggregator executes customization requests to create, update and delete custom attributes. The ETL application dynamically detects the custom attributes and associated metadata when executing. The ETL application uses the detected custom attributes and associated metadata to determine source data tables and data values to be extracted from the source data tables to incorporate the custom attributes into the ETL process being performed by the ETL application. The ETL application may alter target data tables that are then loaded with the extracted data values.