Migrating federated data to multi-source universe database environment

Embodiments relate to reporting data of project artifacts in a multi-source universe database environment. In embodiments, an analytics module is configured to receive as input, data in target tables of a data federator. With reference to a file, the analytics module creates a federated table in a f...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Balasubramanian Makesh, Sonwane Tejram Jagannath
Format: Patent
Sprache:eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:Embodiments relate to reporting data of project artifacts in a multi-source universe database environment. In embodiments, an analytics module is configured to receive as input, data in target tables of a data federator. With reference to a file, the analytics module creates a federated table in a federator layer of an Information Design Tool (IDT) in a multi-source universe database environment. The federator layer may also include data source references, objects, and mapping rules. This migration process allows the IDT to preserve with the federated tables, previously created mapping rules defining the complex logical relationship between the target tables and the underlying database data. These mapping rules are used in creating project-based reports of the federated table data in the multi-source database universe environment. In this manner, data can be migrated to a multi-source database universe, while conserving previous effort to define logical relationships between federated data and the database.