Eugene, in general, normalization of your database schema does avoid redundant storage of data, and thus helps reducing space consumption also in MonetDB. Make sure you do declare the appropriate primary and foreign keys. MonetDB exploits these for efficient query processing. Regards, Stefan On Thu, Jul 14, 2011 at 01:25:36PM +0400, Eugene Prokopiev wrote:

Hi,

need I use normalization for tables in colum-oriented databases or it will only decreses perfomance without reducing space usage and other advantages?

-- Thanks, Eugene Prokopiev

------------------------------------------------------------------------------ AppSumo Presents a FREE Video for the SourceForge Community by Eric Ries, the creator of the Lean Startup Methodology on "Lean Startup Secrets Revealed." This video shows you how to validate your ideas, optimize your ideas and identify your business strategy. http://p.sf.net/sfu/appsumosfdev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |