0

I want to create and implement a Data Vault Model. In the presentation layer, I want to create a View based on a star schema. Now I would like to know if there is a certain order in creating the models in practice? (Is is a commonplace to create first a Data Vault model and then the star schema, or vice versa?) I noticed that I think very "dimensional" when start to make a concept of the requirements.

Improve this question

2 Answers 2

Reset to default
2

Seeing as you are asking about models, I assume you are in the requirements and design phase. If you know what your target dimensional model looks like then you can start there, assuming this is the result of business analysis of the SME requirements. This can inform the scope of your DV modelling. The combination of these two perspectives will inform your business concept model which will inform you HUB/LINK decisions. Do follow the DV2.0 methodology and principles. Once you've built your DV schema, then revisit the dimensional model as it may need refactoring with the newfound clarity.

Improve this answer
1

Data Vault is an architecture and methodology to store data historically, sometimes holding hundreds of entities which can, but don't need to be interconnected.

Star Schema is an architecture to provide fast querying performance for specific questions, usually holding a few entities which are interconnected.

Without getting any more specific in both methods, I think you might have misunderstood Data Vault. It might be wise to inform yourself more about Data Vault, especially where it might lie in a typical Data Warehouse. Since this is not concerning the original question, I will not go into detail.

I have seen it like this:

  • Data Vault is being used as a core storage system. All the data at all the time. No transformation is being made.
  • Star Schema is build upon Data Vault Raw / Business Vault. Can be views, can be persistent tables. All calculations / transformations will be done here.
Improve this answer
2
  • No I havent misunderstood DV. Since DV is getting more popular, I would like to try to design and implement a DV Model and based on this, i would like to create a star schema view for doing analysis. But I realized I create first the star schema, and based on this I create the DV. And I would like to know if this is a typical way to create models (frist star then dv)
    – Nika
    Mar 6, 2018 at 14:37
  • 2
    As stated in my answer, I have never seen a Star Model as a source for a Data Vault, since in my experience Star can never be as complex as Data Vault. Because of that I would like to challenge that you have fully understood the Data Vault methodology - both methods are being used for a different purpose.
    – tobi6
    Mar 6, 2018 at 14:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.