Re: datawarehouse

From: Breno de Avellar Gomes <brenogomes_at_ieee.org>
Date: Wed, 09 Jun 1999 00:32:31 +0100
Message-ID: <375DA80F.B97D681F@ieee.org>

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

Cen Mei wrote:

> 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 Tue Jun 08 1999 - 18:32:31 CDT