Announcing a newly developed database adapter for MonetDB

[Michalis P]

Hello,

I've developed an ActiveRecord adapter for MonetDB, and I would be
glad if you people give it a try and give me some feedback and
possibly join the project as developers/maintainers.

MonetDB is an open source high-performance database management system
developed at the National Research Institute for Mathematics and
Computer Science (CWI; Centrum voor Wiskunde en Informatica) in the
Netherlands. It was designed to provide high performance on complex
queries against large databases, e.g. combining tables with hundreds
of columns and multi-million rows. As such, MonetDB can be used in
application areas that because of performance issues are no-go areas
for using traditional database technology in a real-time manner.
MonetDB has been successfully applied in high-performance applications
for data mining, OLAP, GIS, XML Query, text and multimedia retrieval.

More information on MonetDB can be found at :
http://monetdb.cwi.nl/

You can get the database adapter at :
http://rubyforge.org/projects/monetdb-ror/

Thanks for your time,
Michalis Polakis

[Bill Walton]

Hi Michalis,

Michalis P wrote:
>
> I've developed an ActiveRecord adapter for MonetDB,
> and I would be glad if you people give it a try and give
> me some feedback and possibly join the project as
> developers/maintainers.

This looks very interesting. I've been looking recently for a DB that could
store XML documents 'natively' while allowing SQL queries on the data so I
could get ActiveRecord functionality. I'll definitely begin checking this
out. Hope you won't mind if I ping you off-list for some additional info.

Best regards,
Bill

[Philip Nelson]

On Monday 11 August 2008 13:17:10 Bill Walton wrote:
> This looks very interesting.  I've been looking recently for a DB that
> could store XML documents 'natively' while allowing SQL queries on the data
> so I could get ActiveRecord functionality.  I'll definitely begin checking
> this out.  Hope you won't mind if I ping you off-list for some additional
> info.

Bill,

I've been doing exactly that with DB2 Express-C and its pureXML functionality,
which is free (as in beer).

It stores the data in XML column as parsed XML documents and you can use SQL,
XQuery or combinations of these to access the data.

I'm doing a presentation (D.V.) on this at the Information on Demand
conference in Las Vegas in October.

HTH

Phil

--
Philip Nelson
ScotDB Limited
(tea...@scotdb.com)