SYSTEM AND METHOD FOR ENABLING EXTRACT TRANSFORM AND LOAD PROCESSES IN A BUSINESS INTELLIGENCE SERVER

SYSTEM AND METHOD FOR ENABLING EXTRACT TRANSFORM AND LOAD PROCESSES IN A BUSINESS INTELLIGENCE SERVER

A business intelligence (BI) server maintains a plurality of metadata objects to support the extract, transform and load (ETL) processes. These metadata objects includes a transparent view object, which takes a joined set of source tables and represents a data shape of the joined set of source table...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: VENKATA, ANANTH, SURENDRAN, VENUGOPAL, CHOWDHURY, SAUGATA, MASCARENHAS, ALEXTAIR, BOLSIUS, ROGER, PAN, HARVARD, VENKATASUBRAMANIAN, RAGHURAM, VIGEANT, JACQUES
Format: Patent
Sprache:eng
Schlagworte:
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:A business intelligence (BI) server maintains a plurality of metadata objects to support the extract, transform and load (ETL) processes. These metadata objects includes a transparent view object, which takes a joined set of source tables and represents a data shape of the joined set of source tables using a transformation, and a ETL mapping association object that maps the transformation contained in the transparent view object to a target table. The BI server can then orchestrate the movement of data from source systems into the target data warehouses in a source and target system agnostic way.