[MonetDB-users] Syntax for column tables
Hi, is there a "CREATE COLUMN TABLE xyz" like statement in MonetDB or will every "CREATE TABLE" create a column table? Can I create "normal" row store tables in MonetDB at all? I have read http://monetdb.cwi.nl/SQL/Documentation/Table-Definition.htmlbut did not found the information I was looking for. Kind regards. michael
Michael, in user space, MonetDB/SQL completely follows the SQL standard, i.e., the conceptual data model are n-ary (multi-column) relational tables, just as with any other RDBMS. Physically, MonetDB "automatically" (and hence always) stores relational tables column-wise. That why it is also refered to as column-store. MonetDB does not come with any option to physically store relational tables row-wise. Stefan On Wed, May 25, 2011 at 09:33:17AM +0200, Michael K wrote:
Hi,
is there a "CREATE COLUMN TABLE xyz" like statement in MonetDB or will every "CREATE TABLE" create a column table? Can I create "normal" row store tables in MonetDB at all? I have read http://monetdb.cwi.nl/SQL/Documentation/Table-Definition.htmlbut did not found the information I was looking for.
Kind regards. michael
------------------------------------------------------------------------------ vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1
_______________________________________________ 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) |
Michael Yes, you can use the column definition construct CREATE TABLE <tablename> ( LIKE <tablename> , <column def> ) for example: create table tmp( i int); create table t2( like tmp); create table t3 (like tmp, d int); regards, Martin On 5/25/11 9:46 AM, Stefan Manegold wrote:
Michael,
in user space, MonetDB/SQL completely follows the SQL standard, i.e., the conceptual data model are n-ary (multi-column) relational tables, just as with any other RDBMS. Physically, MonetDB "automatically" (and hence always) stores relational tables column-wise. That why it is also refered to as column-store. MonetDB does not come with any option to physically store relational tables row-wise.
Stefan
On Wed, May 25, 2011 at 09:33:17AM +0200, Michael K wrote:
Hi,
is there a "CREATE COLUMN TABLE xyz" like statement in MonetDB or will every "CREATE TABLE" create a column table? Can I create "normal" row store tables in MonetDB at all? I have read http://monetdb.cwi.nl/SQL/Documentation/Table-Definition.htmlbut did not found the information I was looking for.
Kind regards. michael
------------------------------------------------------------------------------ vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (3)
-
Martin Kersten -
Michael K -
Stefan Manegold