Forum Discussion

DoctorYSG's avatar
DoctorYSG
Helper III
2 years ago
Solved

Modeling: Advanced OODB style modeling

We have a number of telemetry sources which have overlap (network traffic at layers 2, 4, and 7) If PowerBI was a OODB (object oriented DB) I would create a class hierarchy for the common Fact Table,...
Need Help
  • TomMartens's avatar
    TomMartens
    2 years ago

    Hey DoctorYSG ,

     

    I recommend reading the "(The Complete Reference) Star Schema" by Christorpher Adamson. There are fact tables with different dimensionality and dfferent granularity. Different fact tables can share the same dimension.

    It is not a good idea to have fact and dimension tables with empty columns if different types of events are measured or different types of business objects are "modeled."

     

    Hopefully, this adds some additional information.

     

    Regards,

    Tom

    Regards,

    Tom

DoctorYSG's avatar
DoctorYSG
Helper III
2 years ago

TomMartens Jah, and that might be the best that we can do. But don't you see that this results in combinatorial explosion in both the Fact and Dimension tables, as one pre-computes all possible powersets for each one?

Sounds expensive in storage, and it is also hard to a-priori decide what combinations of "classes" are going to be interesting. 

Is there nothing closer to a true OODB (object-oriented DB) approach?


Dr. Y. Gutfreund