Re: Predictive or scoring solution for PostgreSQL ? - Mailing list pgsql-general

Hmmmm, it's been a while since I did this but...

This was with Sybase (it should be configurable with ODBC by now) but we used a
tool called ModelMAX (Advanced Software Appliactions or A.S.A) which could
select a sample of records and score them on the basis of fields (you need some
NO's as well). It produced 'C' code that would score non-flagged records on the
basis of the new results.

Our process was to select a sample of YES/NO records and split it into to two
samples. (The Yes records are actually coded as '1' and the No records as '0').
The No records give the system something to differentiate.

The first and larger sample was used to generate or train the neural net. Then
the second sample (with known values) was scored using the new model, and the
known result compared with the score.

Generally the score was a probability - of response or credit card application
approval or the like.

If the model is valid, the formula can be rolled out to the database.

The trick is that the tool needs to understand something about the fields
available for scoring. Domain and type, ranges and codings - if these are fixed
they are a one time setup.

Other tools do similar things - another was Knowledge Seeker from Angoss
Software - which built turnkey decision trees (this was fairly cheap depending
on the system it is running on). SAS also produced a turnkey modeling solution
(not cheap $$$$).  You could also try SPSS (cheaper than SAS). Group 1 Software
also marketed an all-in-one Modeling Sol'n - Model 1 (I think) but I never
actually used it.

I'll dig around and see if I can find an article I wrote about this...

Marc A. Leith
President
redboxdata inc.

E-mail:mleith@redboxdata.com

Quoting Hervé Piedvache <footcow@noos.fr>:

> Hi,
>
> Does anyone know a predictive or a database scoring solution for PostgreSQL
> ?
>
> I'm looking for a system able to take a database with for example 100 000
> records in total, inside them we have got 1000 records with one field set to
>
> YES ... with about 100 fields in the table ...
> The system should be able to set a score to the 100 fields to determine the
> most importants fields to this 1000 records who's got the YES value ...
> Then set a formula ... to calculate and to apply to the rest of the database
>
> the same score ... and then estimate (predictive thing) in the 90 000 rest of
>
> records which one may have the famous field set to YES ...
>
> I hope I'm clear in my demand ... ;o)
>
> Hope also someone have already heard about this ... and may be could help
> me ;o)
>
> best regards,
> --
> Hervé
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>