Classic to in-memory cube conversion
Conversion of a snowflake-like schema to a star-like schema includes a distribution of the snowflake-like schema across several host computer systems. Each host computer system has a fragment of the snowflake-like schema, including a fragment of constituent fact tables. Dimension keys in the fact ta...
Gespeichert in:
Hauptverfasser: | , , |
---|---|
Format: | Patent |
Sprache: | eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | Conversion of a snowflake-like schema to a star-like schema includes a distribution of the snowflake-like schema across several host computer systems. Each host computer system has a fragment of the snowflake-like schema, including a fragment of constituent fact tables. Dimension keys in the fact table fragments are mapped to data tables via the constituent dimension tables. Data table keys are identified and populate the fact table for the converted star-like schema, thus obviating the dimension tables in the converted star-like schema. |
---|