【IT168 技术】MonetDB是一个超高效率的列存储数据库，在单机1亿条记录下的查询效率是MySQL的10倍以上。
MonetDB系列日志
1. 导出
shell> mclient -lsql --database=voc --dump >/tmp/voc.sql
或 msqldump -umonetdb -Pmonetdb > dump.sql
或 msqldump -umonetdb -Pmonetdb > dump.sql
2. 导入
shell> mclient -lsql --database=voc /tmp/voc.sql
mclient -lsql -umonetdb -Pmonetdb < dump.sql
mclient -lsql -umonetdb -Pmonetdb < dump.sql
导入的sql例子
START TRANSACTION;
CREATE TABLE "sys"."my_data" (
"data_id" int NOT NULL,
"start_date" date,
"start_time" time(1),
"end_date" date,
"end_time" time(1)
);
COPY 2 RECORDS INTO "my_data" FROM stdin USING DELIMITERS '\t';
1 2008-09-08 01:22:22 2009-09-01 02:33:55
2 2004-01-30 09:32:32 2005-12-01 14:27:30
COMMIT;
CREATE TABLE "sys"."my_data" (
"data_id" int NOT NULL,
"start_date" date,
"start_time" time(1),
"end_date" date,
"end_time" time(1)
);
COPY 2 RECORDS INTO "my_data" FROM stdin USING DELIMITERS '\t';
1 2008-09-08 01:22:22 2009-09-01 02:33:55
2 2004-01-30 09:32:32 2005-12-01 14:27:30
COMMIT;
