MySQL Forums
Forum List  »  German

Re: Abfrage in einer Hierarchie
Posted by: Thomas Wiedmann
Date: September 17, 2010 02:13AM

Spontan würde ich die Tabelle

Einkaufswagen_Ware_assoc (einkaufswagen_id, ware_id)

denormalisieren in

Einkaufswagen_Ware_assoc (kunde_id, einkaufswagen_id, ware_id)


Da Einkaufswagen_Ware_assoc eine reine "Schlüssel-Tabelle" ist, sollten die Daten auch nicht zu sehr explodieren.

Mal so als Idee..

Grüße
Thomas

Options: ReplyQuote


Subject
Views
Written By
Posted
1943
September 14, 2010 09:24AM
Re: Abfrage in einer Hierarchie
1086
September 17, 2010 02:13AM
1019
September 17, 2010 06:27AM
946
September 17, 2010 11:11AM
1053
September 17, 2010 11:56AM
983
September 20, 2010 03:08AM
1011
September 20, 2010 03:48AM
913
September 20, 2010 04:11AM
949
September 20, 2010 04:49AM
972
September 20, 2010 05:22AM
1052
September 20, 2010 05:30AM
1039
September 20, 2010 05:54AM
1038
September 20, 2010 06:45AM
1368
September 20, 2010 07:07AM
1097
September 20, 2010 07:15AM
1031
September 20, 2010 07:24AM
1040
September 20, 2010 10:26AM
973
September 20, 2010 10:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.