DBMS choise

[Guest_imported]

I'm currently looking at various DBMS's but it's hard to find a system that matches the specs I need.
The kind of system is a data acquisition system acquirering a large amount of data each second (hundreds of records). This also means the the size of the database often is thousand of records per acq. The DBMS needs to have a SQL-interface or a similar type of interface, because it should be possible to put it on the web easily and connect to it from other systems using XML.
It's important that it is a small engine (dll or exe) because it must be distributed as a part of a bigger system.
The database management must be done with minimal CPU-load, because it will only be a small part of af bigger system that needs to work concurrently utilizing the same CPU.

Keywords:
Small
Fast (inserting records)
Cheap (at least the redistributing of the db-engine)
Support of SQL, JDBC

I'm currently using Btrieve v.6.15 but it is too slow and utilizes too much of the system resources.

I hope someone can tell me which DBMS to use, or tell me where I can find further informations

regards,
/*Klaus Hagen*/

 

[culshaja]

Have a look at MSDE. Microsoft provides it with Visual Basic. It is a kind of cut down SQL Server. From the amount of data you are talking about why don't you have a cebtralised database that uses Oracle or SQL Server. They are really what you need by the looks of it but of course they aint cheap.

james James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[2ffat]

You might also want to look at MySQL (mSQL) and PostgreSQL. These are open source DB. I don't have any experience with them but they come highly recommended to me.


James P. Cottingham

http://www.ivcusa.com

All opinions are mine alone and do not necessarily reflect those of my employer.