Dear Sateesh, thank you very much for your interest in MonetDB. The distinction between "Column-store" and "Row-store" database systems refers to the physical storage of data, not to the logical data model. Physically ("under the hood"), MonetDB uses only two-column tables ("BATs") and hence is in nowadays term referred to as "Column-store". Logically, MonetDB offers next to is BAT data model also standard relational data model (SQL), i.e., "arbitrarily" wide tables, as well as XML and XQuery. The VOC example on the web site is in fact given using both the relational (SQL) data model (http://monetdb.cwi.nl/SQL/QuickTour/VOC/) and the XML data model (http://monetdb.cwi.nl/XQuery/QuickTour/VOC/). For more information on how different "logical" data models are mapped to the physical column-store like tow-column data model, please see the MonetDB web site and related articles, in particular http://monetdb.cwi.nl/Assets/monetdb_lecture.pdf http://www.cwi.nl/htbin/ins1/publications?request=abstract&key=BoKe:BIWIT:95 http://www.cwi.nl/htbin/ins1/publications?request=abstract&key=Bo:DISS:02 http://www.cwi.nl/htbin/ins1/publications?request=abstract&key=BoGrKeMaRiTe:SIGMOD:06 Please feel free to contact us again, in case you have more questions. Kind regards, Stefan On Wed, Dec 12, 2007 at 12:24:30PM -0800, sateesh wrote:
Hi All,
I am evaluating MonetDB for my project and we are planning to Store Semantic Web related info which is basically in RDF Format and wants to use a Colum Oriented DB for this purpose..
Now when i looked at the Sample DB VOC that comes with DB most of the tables have more than two columns.
So is this sample (voc) not meant for semantic storage ..
Thanks Sateesh
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |