Home
Top.Mail.Ru Yandeks.Metrika
Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];

Down

Connection many to many;) Find similar branches


MVova   (2001-12-04 10:41) [0]

Who knows which way is better organized many people to many for large bases ???



Val   (2001-12-04 10:46) [1]

who organized? ;)
in essence, the question is, in general, do a table of junction between tables with a many-to-many relationship, so that there are one-to-many connections



MVova   (2001-12-04 13:24) [2]

And without the third table?
I have a few ideas, but how will be faster?
1. Duplicate entries in the detailed table but show the client one.
2. In the communication field, write a comma-separated ID of the masters and look for an entry when selecting.
My ID field is VarChar (16).



Val   (2001-12-04 13:33) [3]

In principle, you can, of course ..
1 option - what about normalization?
2 option - in theory, disappears completely, because it is not known in advance how many of them will be
and in connection with many-to-many you have a table and a master and ditale, depending on which side to watch :)



Yuvich   (2001-12-04 13:35) [4]

> MVova
Everything is allowed. But this is a violation of all the rules of the relational model. In this way, you will "tie" yourself to the system because no one wants to work with these, they will not be able to. Use the third table.



MVova   (2001-12-04 14:11) [5]

> Val
2 option - in theory, disappears completely, because it is not known in advance how many of them will be
Connection field of type Char and there 8000 imposes restrictions, but basically enough;)
> Yuvich
But this is a violation of all the rules of the relational model.
And the speed. How to quickly climb two tables or three?



Desdechado   (2001-12-04 15:42) [6]

2 MVova
is it about sampling speed? so the number of tables does not play a special role, but the volume of data retrieved in this case plays a role. If everything is normalized and indexes are built, this is fast; if it is not normalized, it is slow (duplicates are processed).
it is also necessary to take into account the amount of extracted data, since This affects the speed of transmission, especially on modem channels.

so, I recommend the classics - 3-th cross-reference table.



Pages: 1 whole branch

Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];

Top









Memory: 0.83 MB
Time: 0.043 c
6-22280
rg
2001-10-06 13:26
2002.01.08
How to accept a message from Winpopup (chat for lokalki)?


1-22091
Mikhalyov Dmitry
2001-12-19 16:02
2002.01.08
question from pascal


3-21967
SklifF
2001-12-05 11:32
2002.01.08
about SQL


3-21971
Venus
2001-12-06 10:23
2002.01.08
Ibdatabase


1-22259
Rats
2001-12-12 17:55
2002.01.08
Curve finish (2 double)





afrikaans albanian Arabic armenian azerbaijani basque belarusian bulgarian catalan Chinese (Simplified) Chinese (Traditional) croatian Czech danish Dutch English estonian filipino finnish French
galician georgian German greek haitian Creole hebrew Hindi hungarian icelandic indonesian Irish italian japanese Korean latvian lithuanian macedonian malay maltese norwegian
persian polish portuguese Romanian russian serbian slovak Slovenian Español swahili Swedish thai turkish Ukrainian urdu vietnamese welsh yiddish bengali bosnian
cebuano Esperanto gujarati hausa hmong igbo javanese kannada khmer lao latin maori marathi mongolian nepali punjabi somali tamil telugu yoruba
zulu
English French German Italian Portuguese Russian Spanish