system
December 31, 2007, 7:55am
1
Dear all,
I run into a situation where the DB designers made a database design where there is a loop.
Important to know is that in we do not need any sum in the applicable reports.
So my question to you is:
Is it always needed to resolve this loop or are there situations where you can leave it as it is?
thx in advance
peter
PeetV (BOB member since 2006-04-20)
system
December 31, 2007, 8:49am
2
Please, look here or here or here…
We have a situation in our universe that is being identified as a loop but it’s really just a case where part of the foreign key resides in one table and part resides in the other. Some strange things are happening in the generated SQL and I was wondering if a context might help but I’m not sure it’s intended for something like this.
I have attached a piece of the universe diagram but to sum it up:
We determine what “service” a patient had by looking at a combination of the facility they visit…
I know, I know I searched I promise, but I am having problem with the terminology of trying to search based on my question.
Three tables A, B, and C. I need to create objects based on table C dependent on 4 values from table A and 1 from table B. Problem is, table A and B are joined and need to be, thus I have a loop. I am familiar with context and alias but not sure they will work for this situation. A context would define the correct path, but I really need both paths A-> C and B-> C defined…
etc.
In short, a loop might be necessary to get valid data, especially in highly normalized databases.
Andreas (BOB member since 2002-06-20)
system
December 31, 2007, 9:06am
3
Thx Andreas,
I’m gonna look into these articals.
peter
PeetV (BOB member since 2006-04-20)
(BOB member since 2002-06-20)