Does MonetDB support online schema changes? For example adding/changing a column on the fly while the tables are loaded in memory. Many in-memory databases have to restarted to get the schema changes reflected. So, I was wondering if MonetDB took care of this issue.
Asked
Active
Viewed 154 times
1 Answers
0
Yes. MonetDB supports SQL-99 which includes DDL statements (that are immediately reflected in the schema).
Holger
- 1,648
- 1
- 16
- 26
-
Thanks for confirming! I have also tested this. The online updates are seamless – Rahul Dec 13 '13 at 16:39