RE: RedBrick vs Oracle

I worked on a Redbrick data warehouse a few years ago. It was very satisfactory as a DW. Now that Informix has purchased it I don't know where it has gone, but it seems to me that it is still a DW dbms. I wouldn't try to do OLTP on it.

Redbrick is SQL-compliant now, but wasn't when they first designed it. It had partitioning and star schemas long before Oracle thought of them (I still think RB's partitioning was easier to use than Oracle's is now).

You can (or at least used to be able to) run other people's DSS tools (query tools) against an RB data warehouse. Redbrick itself is pretty fast at loading and retrieval, as long as the queries are designed correctly (still never seen a query tool that could generate efficient SQL consistently).

HTH,
Sara Wasserman

> -----Original Message-----
> From: Michael Netrusov [SMTP:mn_at_g-fax.com]
> Sent: Thursday, June 15, 2000 3:25 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RedBrick vs Oracle
>
>
> Hello,
>
> Has anyone heard of Redbrick RDBMS ( http://www.redbrick.com
> <http://www.redbrick.com> )? I am particularly interested in the
> comparison with Oracle.
> As far as I can see from their website, this product is architectured
> specifically for data warehousing.. what about OLTP?
>
>
> TIA,
> Michael Netrusov,
> Data Architect
> www.atelo.com <http://www.atelo.com>
> (202) 262 8469
Received on Fri Jun 16 2000 - 16:32:59 CDT