Data vault modeling in a complex data environment - Hendrik Ruijter & Anders Lindström

Поділитися
Вставка
  • Опубліковано 4 лис 2024

КОМЕНТАРІ • 4

  • @agustinespinosa4096
    @agustinespinosa4096 4 роки тому +1

    58:19 Business analysis and SMEs - Very Interesting and important

  • @tarpara
    @tarpara 3 роки тому

    Why is “Steering_Wheel” a hub and on a satellite of Car_Hub?

    • @hendrikruijter2151
      @hendrikruijter2151 3 роки тому

      One option is to say that all cars have one steering wheel. A car will never have two or more steering wheels. You would argue that context close to key makes the steering wheel a SAT of the car HUB. This SAT would keep all attribute information of steering wheel: does it have paddles, does it have a Siri button, etc. If you believe in multi-valued satellites you can add information for a second steering wheel in the specification of the car. Another option is to handle uncertainty when you are not a car expert, maybe there are cars produced with more than one steering wheel in a car. When the link creates a relation between a car HUB and a steering wheel HUB you can say that the steering wheel is a core business concept. The business talks about steering wheels. Steering wheels with many options sell cars to customers. Now, the steering wheel SAT is related to the CBC of a steering wheel HUB and all the SAT attributes are the same as in the context close to key SAT.Adding a second steering wheel would require a linked key model choice. The basic link with one car HUB and one steering wheel HUB is like a faceless fact table. You know that one car has one steering wheel. To model the relation you must add more information.

  • @pecheur1234
    @pecheur1234 5 років тому

    Hi, I can not read the video, it stops at 8:47. In addition, English subtitles are not available. Can you do something ? thank you !!