[Resolved] Datawarehousing Datamining ?

[xgab]

We have a Unix server running an Administration software that uses an Informix Database. There is no way to add new features to this boxed software.

On the other hand I have a general purpose (Linux-Apache-MySql-PHP) server.

We would need to offer to our end-users a way to make complex queries to the information located in the Administration system.

I could export the entire Database to the LAMP server.

My question is:
Is there any freeware interface software to install on the LAMP server to do something like Datawarehousing in order our non-technical-users to get the information they need ???

Hope I am clear, thank you!

[Sxooter]

Considering how complex most data warehousing queries tend to be, you might be better off with pgsql...

As for data warehousing output for non-technical users, you could likely just write some simple php interface that fires off pre-made queries for users. It's hard to let newbies get what they want without making them write at least some of the query though.

[xgab]

Thank you very much for your quick reply.

I am afraid that won't be enough.

The end-users need flexibility to buiild different combinations of queries by joining tables, adding fields, etc.

[Sxooter]

Perhaps phpmyadmin or phppgadmin would do the trick?

[xgab]

I don't think so... end-users use Windows as their workstation.

Now I am searching Windows or Java freeware interfaces to run on workstations, but I cannot find any application.

[Sxooter]

phpmyadmin (for mysql) and phppgadmin (for postgresql) run as a web interface.

If you want a nice, more powerful user interface to postgresql, look at either pgadminIII or EMS Postgresql manager.

Both are available as native windows apps. pgadmin is free, ems postgresql manager (they make a mysql manager too) is money, but not a lot of money.

ems pgsql manager pgadmin III