Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Technology Stocks : Red Brick Systems -- Ignore unavailable to you. Want to Upgrade?

To: Red Brick DBA who wrote (181)	3/15/1998 8:39:00 PM
From: Dave Yenne	Read Replies (1) \| Respond to of 304

No experience with IQ, but haven't heard good things from a DBA perspective. And it DOES cover the same territory as REDB. I haven't been following the Red Brick thread for about the last 6 months. If you look at some of my posts early on in this thread you'll see that I predicted Red Bricks fall. As for Sybase's Adaptive Server IQ (previously Sybase IQ), its a product that has been on the market about 18-20 months. In that time ASIQ has outsold Red Brick. To date there are 400+ ASIQ customers and the number of new customers is about 30-50 per quarter. Here's a quote from America Airlines about ASIQ from the Sybase web site's success stories area: The department's decision to go with Sybase IQ was approved by its director. The principal reason was performance. "We chose Sybase IQ because we like the product," says Hagen. "We didn't find anything comparable to Sybase IQ. It performs 4 to 6 times faster than any of the databases we benchmarked. Plus it was 15 times faster than our previous Teradata system." Here's a observation from Client Server Associates about ASIQ from the Sybase web site's success stories area: Based on CSA's experiences to date, there just isn't any downside to Sybase IQ. "It's very easy to install and takes very little work. In one case we were able to install IQ, get it set up, build the structures, and load a table of a million records into an IQ table, and begin to run queries on it all in half a day. Tuning is equally easy. We loaded our data in on an incremental basis and saw no effect on query performance," says Anderson. "The users are clearly big winners in this, but the other group that really loves it is the DBAs. They're not going to have to worry about continually building indexes for people and having to deal with users who have runaway queries." The quote about DBAs loving ASIQ is a constant with customer sites. Some customer have reduced their DW support staff from 5 persons to 2. That alone can save a company $200+K a year. ASIQ truely supports adhoc queries. You don't have to add a new index or summary table to place new data or to maintain performance. With a Red Brick DW the DBA will have to know what analysis is going to be performed on the data prior to building the data base. This is not the case with ASIQ you provide information related to the data's cardinality and it will build the neccessary indexes. The other great thing about ASIQ is its data compression. Unlike Red Brick and the other RDBMS databases that explode the raw source data 5 to 7 times, ASIQ will result in, on average, a DW database that is 50-70% the size of the original raw source data. For example, you take 300Gb of raw source data. With Red Brick (I have used it) after you load the data, create indexes, fact tables, dimension tables, star index you'll end up with a 1.5 or 2.0Tb DW. Conversely, with ASIQ you'll get a 200Gb DW. That's a savings of 1.3 to 1.8Tb of DASD. At $500 per Gb that's a savings of $900,000.00 just in DASD. Add to that the superior response time with ASIQ and the ROI is far greater than with Red Brick. Red Brick is still gaining a new customer here and there. But don't fool yourself into thinking that there's no competition. Sybase's ASIQ is very much a competitor that has won a number of deals over Red Brick, Oracle and Informix. Dave.