Mailinglist Archive: opensuse-factory (723 mails)

[houghi <houghi@xxxxxxxxxx>]

On Tue, Feb 28, 2006 at 11:12:13PM +0100, Azerion wrote:
> Hey,
> 
> there is an method for designing databases the best way. Maybe you should take 
> a look at that cause it causes the most efficient way of datahandling.  Check 
> this :D
> 
> Product table:
> 1 | Cookies 		| 4$
> 2 | Milk			| 50ct
> 3 | Potatoes		| 4$
> 4 | Cola			| 50ct
> 5 | Water		| 50ct
> 6 | Beer			| 50ct
> 
> As you can see, there is a lot of the same info in it (50ct). So a database 
> like the next one would be better:
> 
> Product table:
> 1 | Cookies 	
> 2 | Milk	
> 3 | Potatoes
> 4 | Cola
> 5 | Water
> 6 | Beer
> 
> ProductPrices table:
> 50ct 	| 2,4,5,6
> 4$		| 1,3
> 
> I know you do not design a database-structure but maybe it helps a hand 
> anyway. Make sure there is not much 'the same text' in the file. But dont 
> make it unreadable either :D. Maybe trying to style the xml like a 
> ftp-directory is the best way?

Again, I have no real experience with XML, so I have no idea how to get
to what you are talking about above.


houghi
-- 
Nutze die Zeit. Sie ist das Kostbarste, was wir haben, denn es 
ist unwiederbringliche Lebenszeit. Leben ist aber mehr als Werk
und Arbeit,  und das Sein wichtiger als das Tun                                        					- Johannes Müller-Elmau