datawarehouse

[Cen Mei]

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
hku...@elixir.com.au

no flame mail, please.

Thanks in advance
- Haris -

[Breno de Avellar Gomes]

I recommend Oracle8. Major reasons include:
1) long time experience with large databases.
2) proven performance and reliability
3) Oracle8 specifics, such as table partitioning, tables and indexes spam
over several physical disks and operating systems.
4) not limited to Windows.
5) Oracle Discoverer 3.0 offers powerful features to build extraction
tables and very flexible navigation tools, freeing developers to deal
with back end.
6) Discoverer is Relational OLAP. If you need multidimensional databases
you can use Oracle Express Server and Oracle Express
Objects.

I am currently involving in data warehousing projects using Oracle. If you
need more details, links, white papers and first impressions feel
free to contact me.

Best regards

Breno Gomes

[Mick Horne]

To balance this argument, check out the SQL Server 7 White Paper in the
Services..Data Warehousing section of out site at www.os-integration.com.

Mick Horne
OS Integration (IIS) Ltd

Breno de Avellar Gomes <breno...@ieee.org> wrote in message
news:375DA80F...@ieee.org...

[Simon Riggs]

The first four of your points are also true of DB2 and Teradata.
Your remaining points apply to other products which would also work with
Oracle, SQLServer, DB2 or Teradata.

Why are you limiting your search?

Simon Riggs
Managing Consultant
Info Management Practice Group
OpenMIND Consulting
Voice: +44-1869 238080
http://www.open-mind.co.uk

[Jason Bryant]

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...@elixir.com.au>...