Is it okay to say that monetdDB is an in-memory database. I read Here that its use array as data storage in memory to perform relational algebra operation. Is it enough to say it is an in-memory database ?
0
votes
1 Answers
-1
votes
MonetDB is not an in memory database.
You confuse "memory-mapped file array" with "in-memory array".
When using memory-mapped file, one can do direct mapping (array) structure data in memory on disk.
If some records queried with SQL, it will be mapped to a mmap file, and then loaded to memory by OS's kernel.
When that records not used any more, it's memory space will be reclaimed by the OS's kernel.
This is how virtual memory management work.