Dimension and fact table creation using templates

A method of creating a dimension table or a fact table for a data warehouse includes accessing an ordered sequence of activities that are arranged in a template. A first set of code associated with creating the dimension table is organized into a dimension processing class, a second set of code asso...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
1. Verfasser: Haelen, Bennie Alfons
Format: Patent
Sprache:eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:A method of creating a dimension table or a fact table for a data warehouse includes accessing an ordered sequence of activities that are arranged in a template. A first set of code associated with creating the dimension table is organized into a dimension processing class, a second set of code associated with creating the fact table is organized into a fact processing class, and a third set of code associated with creating both the dimension table and the fact table is organized into a common processing class. The method further includes executing the ordered sequence of activities and creating the dimension table when an instance of the dimension processing class is created in the ordered sequence of activities and creating the fact table when an instance of the fact processing class is created in the ordered sequence of activities.