General discussion

Locked

Data Warehouse

By dbose ·
We are currently evaluating data warehouse products. Our initial goal is to give clients query access to their (historical) activity related data using web based GUI. Later on we will data mine and use OLAP tools. The data will be in the terabyte range, with about 250 concurrent users. We do not expect complicated queries. The frontrunner, in our case, is turning out to be IBM UDB EEE on IBM RS 6000 (SMP) running AIX. I will appreciate any feed back about the product. I would also like to know how you think it stacks up against Oracle, SybaseIQ, and Teradata. Thanks.

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Data Warehouse

by rellips In reply to Data Warehouse

We have used SybaseIQ for a web based data warehousing solution (about 10GB) and found it to perform very well on reads. We have not had a lot of maintenace hassles either. Since we have to update a large portion of the database nightly we stage onSybase (which is much more efficient for updates) and rebuild the entire db from the Sybase database nightly nightly. We have about 20 concurrent users on a Sun Sparc 250 (solaris)

Collapse -

Data Warehouse

by dbose In reply to Data Warehouse

I was hoping to find a comparative evaluation of the various products. I am also not sure what 'perform very well' means. Thank you.

Collapse -

Data Warehouse

by YCDBSOYA In reply to Data Warehouse

Understand the following is based on information gathered in early 1998. At that time IBM's UDB was clearly the best performer at the high end. Oracle was expensive and did not scale, Sysbase is just not a mainstream player in my opinion. Teradata was too complex a solution. As far as the server goes today if you want high availability it has to be HP or IBM, don't go to Sun. I see no reason not to go with IBM as a total solution.

Collapse -

Data Warehouse

by dbose In reply to Data Warehouse

The question was auto-closed by TechRepublic

Collapse -

Data Warehouse

by Eoin.Farrell In reply to Data Warehouse

If you were considering Oracle, I'd advise using a Compaq server, as the Alpha chip outperforms all other compatition when utilising any Oracle package thus lessening licensing cost as less processors would be required to acheive the same throughputwith a competitor. i.e. An Alphaserver ES40 Model 6/667 1CPU has a Specint200 of 433 whilst the RS/6000 Model 7026-H80 1CPU has Specint2000 of 234. You can find these results at www.spec.org where those results came from. Its a great site to check out performance results by an Independent company before deciding on a server.

Best of luck with your purcase,

Eoin.
(eoin@xpert.ie)

Collapse -

Data Warehouse

by dbose In reply to Data Warehouse

The question was auto-closed by TechRepublic

Collapse -

Data Warehouse

by Eoin.Farrell In reply to Data Warehouse

If you were considering Oracle, I'd advise using a Compaq server, as the Alpha chip outperforms all other compatition when utilising any Oracle package thus lessening licensing cost as less processors would be required to acheive the same throughputwith a competitor. i.e. An Alphaserver ES40 Model 6/667 1CPU has a Specint200 of 433 whilst the RS/6000 Model 7026-H80 1CPU has Specint2000 of 234. You can find these results at www.spec.org where those results came from. Its a great site to check out performance results by an Independent company before deciding on a server.

Best of luck with your purchase,

Eoin.
(eoin@xpert.ie)

Collapse -

Data Warehouse

by dbose In reply to Data Warehouse

The question was auto-closed by TechRepublic

Collapse -

Data Warehouse

by dbose In reply to Data Warehouse

This question was auto closed due to inactivity

Back to Software Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums