settingsLogin | Registersettings
Scalefree
Show Menu

Parents relationship between links allowed?

0 votes
I have an order and some order lines with a product on each line. The normal case that have worked so far is to put order and product as hubs and order line as a link between these two. Now however the order line has a parent order line. How would you model that?

I'm equally between making order line a hub and make a link hierarchy or making a link hierarchy on the link. The second however I'm not so sure about if that is a legit solution.
asked Oct 22, 2017 in Modelling by johan-dutina (120 points)

1 Answer

0 votes
Hi johan-dutina,

Link-to-links should not be used because of high potential for refactoring multiple entities in case one relationship changes.

From what I can derive here, one possibility would be :
Hub_Order
Hub_Order_line
Hub_Product

Order lines have parent order lines (Hierarchial Link or HAL)
Order has order lines and every orderline has 1 product (1 link between order, order line and product)

Hope this helps,

Greets Jacob Siemaszko
answered Oct 24, 2017 by simco_admin (660 points)
Scalefree Scalefree

Upcoming Trainings

  • July 01 to 03 - Amsterdam (English) Data Vault 2.0 Boot Camp and Certification

  • August 05 to 07 - Berlin (German) Data Vault 2.0 Boot Camp and Certification

  • September 9 to 13 - Hanover WWDVC EU

  • September 16 to 18 - Brussels (English) Data Vault 2.0 Boot Camp and Certification

  • October 21 to 23 - Hanover (German) Data Vault 2.0 Boot Camp and Certification

  • November 18 to 20 - Amsterdam (English) Data Vault 2.0 Boot Camp and Certification

  • December 02 to 04 - Dusseldorf (German) Data Vault 2.0 Boot Camp and Certification

  • December 16 to 18 - Zurich (English) Data Vault 2.0 Boot Camp and Certification

  • Contact us for inhouse training engagements.
    Visual Data Vault: Logical Modelling for Data Vault - Free Download!
    Scalefree
    DataVault.guru is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 United States License.
    Permissions beyond the scope of this license are available in our license.

    DataVault.guru | DWH Wiki | Recent questions RSS feed | Imprint | Provided by Michael Olschimke
    ...