[MonetDB-users] New to MonetDB
Hello I am new to monetDB. I have a few questions about using MonetDB in embedded environment. I read in the embedded server page that only client is allowed to connect to the embedded server. 1. Does this mean I can not have multiple processes accessing the same database? 2. Can multiple threads with in the same process access the same database? 3. in the in-memory embedded environment, is there a way to save the data before the system shutdown? So that when the system starts, I can automatically populate the database to the previous state? Thank you for your help in advance Shankar
On 10-04-2008 10:45:01 -0700, Shankar Yoganathan wrote:
Hello
I am new to monetDB. I have a few questions about using MonetDB in embedded environment.
I read in the embedded server page that only client is allowed to connect to the embedded server.
1. Does this mean I can not have multiple processes accessing the same database?
2. Can multiple threads with in the same process access the same database?
3. in the in-memory embedded environment, is there a way to save the data before the system shutdown? So that when the system starts, I can automatically populate the database to the previous state?
Beware that "embedded" is not what it is in general. In MonetDB's case is't more like "MonetDB Light(tm)", where you still have a server running, though limited to one client at a time, such that concurrency issues are not apparent.
On Sat, Apr 12, 2008 at 03:02:35PM +0200, Fabian Groffen wrote:
On 10-04-2008 10:45:01 -0700, Shankar Yoganathan wrote:
Hello
I am new to monetDB. I have a few questions about using MonetDB in embedded environment.
I read in the embedded server page that only client is allowed to connect to the embedded server. Embedded server is like fabian says a 'server which only expects a single client'.
There is also an embedded library version, ie the server is embedded within your application then.
1. Does this mean I can not have multiple processes accessing the same database?
If you want this you shouldn't use the embedded version (flag), but the normal server.
2. Can multiple threads with in the same process access the same database?
Incase you embedded monetdb into your application you could use multiple threads to access the database. You should however take care of concurrency yourself.
3. in the in-memory embedded environment, is there a way to save the data before the system shutdown? So that when the system starts, I can automatically populate the database to the previous state?
In the sql embedded server the data should be saved (its a database system after all). If you found it didn't save the database something is wrong.
Niels -- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
participants (3)
-
Fabian Groffen -
Niels Nes -
Shankar Yoganathan