Subject Re: Workflow for OLTP + Datawarehouse using Firebird
Author javaguru_uk
--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:

Alexandre> but I think the volume of all calls in a city could be far
Alexandre> bigger than a nation wide incident report to the police
Alexandre> station. Of course I don't have those numbers, but I
Alexandre> suppose too.

Yes, if you are comparing a main call center that takes all the calls
nationwide with a call center that takes calls from a city, which is
not the case. There will be several call-centers, and one central
database. All the data from all the provinces need to be available in
near real-time to all users.

Alexandre> Don't know if tis is what are you looking for, but take a
Alexandre> look at pentaho

Alexandre> www.pentaho.org

Hey, it's been a while since I used this tool. I had forgotten about
it. Wow! Well, I think that'll do the job.

Alexandre> This one is not open source, but I had a look at it and
Alexandre> found it pretty impressive. It's not a datawarehouse tool..
Alexandre> but take a close look at it, even if it's not for your
Alexandre> project, it would be a good tool to have in your toolbox.

Alexandre> www.tableausoftware.com

Hey, that is some nice little tool. Very impressive and very useful
for analysis.

Thanks for the pointers.

All the best,

Fidel.