Re: RCubes

> Bjorn Bentzen Wrote:
> You can expect performance increases in the range 3-20 times for most
> DSS-type of queries. IQ uses a "snapshot versioning" approach for
> changes to data - an update of 10 million rows will be almost as fast
> as an insert, with no special rollback/log-area to consider.

How often do you run your ETL's, sounds like they run quick will little overhead?

> There is no maintenance of indexes in IQ - you do not have to run
> "update statistics" in order for the index to be useful. IQ allows
> many types of indexes, depending on what the column is used for, e.g.
> low-cardinality, medium-cardinality, summarised columns, join columns.
> This means that you have to have a good grasp for what the data is
> used for up front, but later on you do not need to maintain these
> indexes in any way. IQ compresses data before it is written to
> disk-with only the default index in place - the compression is 40-60%.
> Even with specialised indexes on some columns, you can be sure that IQ
> will only use a fraction of what a traditional RDBMS would use.

This sounds great, I have been exploring solutions with Oracle 9i, but the maintence overhead seems huge. Dropping indexes for every ETL, recalculating statistics, partioning tables and indexes properly. And after all that stuff, one unanticipated ad-hoc query could still take hours to run.

> IQ Multiplex is an architecure which allows IQ to scale almost 100%
> linearly by putting in a new SMP_server box. This architecture is
> dependent on a SAN-type of storage solution.

What kind of hardware are you running?
How big is your warehouse?
What is pricing and licensing like for IQ?

Thanks for the outstanding feedback!

Cheers,
Adam Received on Thu Dec 19 2002 - 03:36:17 CET