September 03, 2007, 07:45 AM
IngasXFocus/FOCUS DB - when it's better than RDBMS source?
Hello
I'm relatively new to WebFOCUS.
At first I've thought that FOCUS-files are just historical (for tutorials) and for real implementations only DBMS as Oracle, MSSQL, DB2 etc - are viable.
Now I begin to look on XFOCUS datasources.
Did I correctly understand that XFOCUS is hierarchical DB?
I suppose it must be faster than relational DBMSs in some scenarios.
I do not found any official considerations about XFOCUS - when it worth using as main source for reporting platform.
And I suspect that somebody uses it even for large amounts of data.
Do you have any suggestions in which cases XFOCUS is better than RDBMS source.
September 03, 2007, 08:15 AM
hammo1j Have a Look at ThisYes, XFOCUS is pointer based HDB. Make sure all your databases all XFOCUS.
You could also try and get IBI's brilliant datawarehouse concept which did not catch on - FUSION to work.
It's now bundled with wf and look at the multi dimensional indexes which I could not get to work under 7.1.3 although they may have been fixed by now.
Will take another look
September 03, 2007, 08:33 AM
IngasHallo!
You wrote:
If you want quicker x10 to x20 results than Oracle dataware housing try putting it into XFOCUS files. Honest, that's what we do.Can you get details:
1. Source data size approximately? (rows, GBs)
2. How do you fill it? Data Migrator? What about Change Data Capture - is this possible?
3. Supporting XFOCUS : defragmenting, reindexing - how this comparable with DBMS administration.
September 04, 2007, 04:29 AM
hammo1j1. 2GB
2. MODIFYs scheduled by CASTER
3. We dont do incremental load but create afresh every night.
September 04, 2007, 05:56 AM
IngasThanks
I think I must try myself XFOCUS-configuration.
I'm interested in volumes near 30-50 GBs.
Maybe I'll send my results here
A question:
What's the beast "multidimensional index"?
Does it make wonders with queries?