Re: datawarehouse

We have spent the last 6 months evaluating the pro's and cons of Microsft SQL Server 7, Oracle 8, Informix, ... for our datawarehousing project.

When it boils down to it Oracle is probably the best product (taking into account experience CURRENT market share and scalability on Unix).

However if cost is an issue (as it was for us) then SQL 7 is a very strong contender. If you look at the http://www.tpc.org/ they have some excellent bechmarking data, including cost per unit performance (MS SQL7 is far cheaper per unit performance than Oracle).

Also with SQL7 you get a number of bundled data warehousing tools, such as data Extraction Transformation and Load (ETL) or DTS, OLAP Server (DSS) and a metadata repository. Unless you are a big or highly complex organisation (e.g. we are not and we have 450 employees, 11 offices and 400GB of data) these tools will probably do the job and you will not have to buy additional tools as you may have to with Oracle/Informix/... (e.g. a ETL tool could cost £50,000).

When it boils down to it, it will come down to what fits in with your current infrostructre, personal preferrence and how much money you have to spend.

But that is only my view...

Hope it helps.

Jason.

Cen Mei wrote in message <375D326A.AF32DCEE_at_elixir.com.au>...
>Hi,
>
>I am trying to setup datawarehouse, current I am planning to evaluate
>oracle and sql server.
>
>I would like to hear about the pro and con of oracle and sqlserver to
>implement dataware house. the inital database approx about 100 GB and
>will grow.
>
>I belive oracle dataware house product has a utility to extract data
>from different data source and schedule it to run automatically, does
>sql server has a similar facility?
>I need to do data extraction from AS/400.
>
>I am quite new to sql server that I have not try to create 100 GB
>database in sql server before, I'd like to hear what is the performance
>like for sql server on reasonable big database compare to oracle.
>
>I appreciated if you could e-mail me the feedback at
>hkusumo_at_elixir.com.au
>
>no flame mail, please.
>
>Thanks in advance
>- Haris -
>
Received on Fri Jun 18 1999 - 09:11:55 CDT