Parent/Child Vs One/Many

Question

Question

Neerav Verma · Mar 2, 2019

Hi

Just curious to know about the pros and cons of Parent/Child Vs One/Many.

We do use a bit of both.
One big reason we use Parent child is we feel if we delete one global, it gets rid of all child data too and all parent child data is stored in one global. Much easier to manage.

Discussion (4)1

Log in or sign up to continue

Robert Cemper · Mar 2, 2019

You are totally right.

With Parent-Child your data are not only logical but also physically tied to each other.

One-to-many allows you more flexible handling of Relations.

Just one out of many examples M:N Relationship

0 0

Alexander Koblov · Mar 4, 2019

For drawbacks of Parent/Child relationships see this comment by @Brendan Bannon

0 0

Joel Solon · Mar 5, 2019

Brendan's comment from the other thread summarizes it nicely. Here's a little more...you have 2 good alternatives to parent-children:

Without using either relationship option, just use a simple reference from the "many/child" class to the "one/parent" class, and add the FK constraint yourself (using "cascade"). This allows bitmap indexes in either class.
Simulate parent-children relationship using one-many. After setting up the one-many relationship, in the Relationship definition in the "many" class, add the bold items shown here: [Cardinality = one, Inverse = Orders, Required, OnDelete = cascade]. This allows bitmap indexes in either class.

0 0

score 0 · Answer 1 · 2019-03-05T11:26:32-05:00

Neerav Verma · Mar 5, 2019

Thanx Joel

Can you please elaborate point 1 a bit may be by a small example

0 0