Subject | Re: Workflow for OLTP + Datawarehouse using Firebird |
---|---|
Author | javaguru_uk |
Post date | 2008-01-23T05:49:29Z |
--- 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.
<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.