Re: data-mining

Antoine,

> Hello all, I was woundering  if postgresql would be able to handle
> data-mining and data-warehousing concepts.  I have a project for class
> in which I have to get at least two rules of data-mining working.  If
> anyone has done this with postgresql, please point me in the right
> direction.   Would I need additional software or just use the features
> of postgresql?  Also could anyone point me in the right direction so I a
> large data set to use with data-mining?

Given that "data-mining" and "data-warehousing" are just branding names for
"big databases with lots of relational historical information", this should
be no problem on PostgreSQL.  Whether or not you need 3rd-party tools depends
on what kind of data mining you want to do.   Of particular interest should
be Joe Conway's PL/R project, which adds some sophisticated statistical and
graphical capabilities to PostgreSQL.

For your data, someone on the PGSQL-PERFORMANCE list posted a link to the
TigerUSA database derived from the last US Census.   This should provide you
plenty of material.   Search the online list archives for the link, or google
for it.

--
Josh Berkus
Aglio Database Solutions
San Francisco