|
I don't really expect a serious answer to this. I just found a few database tables which obviously had been designed by that Russian who's liver I already would have liked to be served (fried, with onions). Now I start to believe that he is actually from Eta Carinae and I'm doing my best to understand alien database design.
If I have two tables A and B and a relation table inbetween, that must be a many to many relation. Fine. Nothing unusual.
But what do you call it when there are two relation tables in a row between A and B? A many to even more relation? m to m^2?
And that's only the beginning! How about a relation table that has three relations to yet more relation tables , which have a relation to tables A, B and C. What's that? A multible m to n^3 relation? Or an omnidirectional star relation to the third degree? The Romulan relation nova?
I have lived with several Zen masters - all of them were cats.
modified 16-Nov-17 4:28am.
|
|
|
|
|
|
I would say your tables have a busy social life.
|
|
|
|
|
Do you know someone in Sicily who would be willing to invite this former coworker to a boat tour?
I have lived with several Zen masters - all of them were cats.
|
|
|
|
|
CodeWraith wrote: Russian who's liver I already would have liked to be served (fried, with onions).
That's a waste of Russian liver - it's already deeply marinated in vodka, frying it you will ruin the flavor. It should be let slowly simmered, to keep the alcohol fragrance.
To any russian: forgive me, I'm just playing with stereotypes for the lulz.
GCS d-- s-/++ a- C++++ U+++ P- L+@ E-- W++ N+ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t+ 5? X R+++ tv-- b+(+++) DI+++ D++ G e++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
|
|
|
|
|
I disagree. Simmering it will draw out all the vodka flavor and allow the alcohol to evaporate. It should be given a quick flambe using it's own aromats for the accelerant. Top with a sauce of your choice and viola!
|
|
|
|
|
Without really knowing what's in the tables, I could only hazard a guess that you have one of two scenarios here.
1. The database is modelling a trie.
2. Some of these relationships are optional. An example of this could be where you have a master lookup of known names - this list is inviolate; then you have a second lookup which is a taxonomy, so you would have the taxonomy relating back to the master lookup; the idea here being that you can use a term and the search will take in the taxonomy and the master list. For instance, local government taxonomies might have the person who collects your rubbish down as "refuse collection manager" but someone might want to search on "binman" or "dustman", and these should refer to the same items.
This space for rent
|
|
|
|
|
In general, I find Russians do much better code. May be you mistook a Baltic sounding eastern European name for a Russian? 
Starting to think people post kid pics in their profiles because that was the last time they were cute - Jeremy Falcon.
|
|
|
|
|
Russian programmers are usually not self taught and have benefited from a rigorous education. Baltic names don't sound Russian unless they are Russian and many are.
Peter Wasser
"The whole problem with the world is that fools and fanatics are always so certain of themselves, and wiser people so full of doubts." - Bertrand Russell
|
|
|
|
|
We already had established that he is from Eta Carinae and wants to be mistaken for a Russian. I never met him, but (great news!) he was apparently headed to the US when he left here. Here he was a sinister hack, there he may be seen as a guru. The american dream!
I have lived with several Zen masters - all of them were cats.
|
|
|
|
|
Let us hope he gets in charge of the White House security system.
... such stuff as dreams are made on
|
|
|
|
|
Seek thee the Medusa Cascade.
|
|
|
|
|
You're on a helicopter tour of the Grand Canyon when the pilot, who made the obvious
mistake of eating fish for lunch, suddenly groans and faints. Fortunately, he left you
hovering 100 feet above the ground. You rationalize that the collective pitch lever [2]
controls overall lift, so lowering it slightly will start a gentle descent to the ground.
However, when you try it, you discover that life isn't that simple. The helicopter's nose
drops, and you start to spiral down to the left. Suddenly you discover that you're flying a
system where every control input has secondary effects. Lower the left-hand lever and
you need to add compensating backward movement to the right-hand stick and push the
right pedal. But then each of these changes affects all of the other controls again.
Suddenly you're juggling an unbelievably complex system, where every change impacts
all the other inputs. Your workload is phenomenal: your hands and feet are constantly
moving, trying to balance all the interacting forces.
Everything is connected to everything else and also some other things you didn't even know existed.
|
|
|
|
|
And that was even before that butterfly in Tokyo started to flap.
... such stuff as dreams are made on
|
|
|
|
|
There are only two types of Helicopters. Those that are broken and those that are in the process of breaking...
Also, I appreciate the Dirk Gently reference 
The holistic approach never works!
|
|
|
|
|
CodeWraith wrote: Are rethorical programming questions allowed?
Yes, but only if you can demonstrate the ability to use "who's" and "whose" correctly. 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I know the answer to this one!
It's a graph database!
|
|
|
|
|
Are non-English words such as 'rethorical' allowed in questions on the discussion board, or are these allowed when the language being used is stated clearly in the question?
|
|
|
|
|
Start a study about then effects of early mornings on correct spelling. At this time I would write 'rhetorical'. 
I have lived with several Zen masters - all of them were cats.
|
|
|
|
|
Tell them you were drunk when you posted.... 
Anyone who expects affection or appreciation from a cat is delusional.
I once had a Scottish terrier that was so aloof he was almost a cat...
|
|
|
|
|
I would expect that the writer is referring to a SQL design paradigm called "thor". After all, we have "COM" and "comical." "Rethorical" suggests an attempt to normalize thor relationships. The practices guide offers the image of smashing tables under a heavy blockish object tied by leather straps to a handle. Among the side effects are static discharges.
|
|
|
|
|
Sounds like a typical Oracle EBS implementation to me. 
If you think 'goto' is evil, try writing an Assembly program without JMP.
|
|
|
|
|
"Intersection" data.
Intersection data is data that is (only) relevant in the context of a "relation"; e.g. is a "member" of x; or "has possession of" y; etc.
This can create multiple relations between the same entities; that "may" result in multiple physical tables.
They may also be used to implement "recursion" in 2 tables; again the "relation" table may have intersection data to make sense of the recursion (as per IBM's "virtual logical child").
"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal
|
|
|
|
|
CodeWraith wrote: But what do you call it when there are two relation tables in a row between A and B? A many to even more relation? m to m^2?
Nothing stops two entities from having more than one 'type' of relationship between the the two. But to be fair that can be handled by additional attribute(s) on the first table also.
That said, for the example provided, the only cases I have seen of that is where a developer added the second table because they didn't know the first existed.
CodeWraith wrote: And that's only the beginning! How about a relation table that has three relations to yet more relation tables , which have a
relation to tables A, B and C. What's that?
Can't speak to the entire world of all possibilities but normally I would deem that 'someone who didn't know how to do data modeling and certainly didn't know how to map it to a database.'
|
|
|
|
|
I have heard from the boss that they kept making changes every day, sometimes even very contradictary ones. It's very possible that the data model started out orderly, but then degenerated because nobody knew what's wrong or right anymore.
I have lived with several Zen masters - all of them were cats.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
