Hello,
In my application I have several processes in a server, each one
managing different and non-related pieces of data, which I intend to
store in MonetDB databases. As these processes are not related to each
other, I would like to put their data in logically different storage
spaces, like a different catalog or a different schema inside the
database, if not in in different databases themselves.
I am just starting with MonetDB and I do not know how I can create new
databases, …
[View More]catalogs or schemas and what I should do to configure these
things on the server. Can you give me some hints about it?
FYI, my application is written in Java and I am using the JDBC interface
to connect to the database.
Cheers,
Rodrigo
[View Less]
Hi,
I'm not too familiar with the BAT concept.
Regardless, I want to know more about the SQL equivalents.
We have need for a 300 million recors DB of about 500 GB. We insert about 1000 records per
seconds.
or about 100 millions record per day, for 3 days.
We 'roll' the data by time, deleting the tail end of the tables, but the the 'deletes' are too
slow. So, we are looking at better DB or data storage patterns (one that would allow a quick
DROP-table-like or file.delete() response time).
So,…
[View More] as I look at MonetDB, I have some questions:
1-What is the insert speed relatively to other DBs?
2-What is the delete speed relatively to other DBs?
3-What is the insert speed degradation with the addition of indexes?
4-What is the delete speed degradation with the addition of indexes?
Also, in the forum, I saw some discussions about size. We may remain on a 32 bits kernel, so:
5-The 2 gigs limit on BATs, is that records count is byte size?
A performance constraint was also highlighted: "the performance degradation starts when MonetDB
has to access BATs larger then the available memory"
6-In our case, with 300 millions records, how big would be the BATs?
Last question, lucky 7:
7-Do you think MonetDB is at all a good choice for our high-thoughput highly volatile data?
Thanks!
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
[View Less]
