To: SemiBull who wrote (11015 ) 6/3/1998 12:09:00 PM From: Mark Finger Read Replies (1) | Respond to of 14631
>>''Comparing feature to feature, performance to performance . . . Red >>Brick will win, hands down,'' Craig said. ''Oracle can't touch >>them.'' Red Brick is a "one-trick" pony. That means that it can only do one thing well--data warehousing--and is incapable of competing in the broader DBMS market (OLTP, objects, ....). Even worse, they only compete well in one type of data warehouse, and do not do well in other categories. For Red Brick, they assume that the primary data will be in one table, and that all the other tables will generally be related to the primary table. They further assume that there will be lots of multi-table joins with conditions on multiple of the tables (i.e., subsets of multiple tables). They optimize this by creating "StarIndex" for these joins--an index that spans multiple tables, so that the selection conditions can work primarily in the index, instead of walking all the records of multiple tables. This is how they get their performance. The problem is that their advantage is coming to an end. Informix has "multi-table join indexes" in XPS 8.2 (not yet shipping, but stable enough to show and benchmark). I believe that Oracle also has something like that in Oracle8, but maybe not quite as well done or flexible. The reason that Red Brick had an advantage was that until recently, the data warehousing was such a small segment of the DBMS market, and these special index types did not have much use in OLTP market, which was the bulk of the warehouse. Now that hardware has improved to really be able to support data warehousing (lots of parallel machines and the price is dropping dramatically), the data warehouse market is large enough for the big boys to really be interested, and worth the R&D to bring the new features to market. Further, some of the competitors seem to be further along in some other features important to data warehousing. For example, "bit map indexes" are also very useful and can enhance performance. Sybase IQ has been shipping for sometime and looks very good where this makes a difference. Informix (in 8.2) and Oracle are both adding bit-map index capabilities (although not to the extent of Sybase IQ). As far as I can tell, Red Brick seems to have bit-map index capabilities, but only recently added, and definitely not as developed as Sybase. mark