Re: Database for datawarehouse

There is a technical paper with detailed comparison between Oracle and
SQL Server from wisdomforce site:

http://wisdomforce.com/dweb/resources/docs/MSSQL2005_ORACLE10g_compare.pdf

As far as I remember it contains a lot of OLAP info


Jéjé wrote:
> SQL 2005 offer a better package then the others. (at a lower price then the
> 2 others)
> In 1 product you have a database engine, OLAP engine, data mining engine,
> report engine and ETL engine.
>
> Analysis Services (7.0, 2000... and 2005...) is the most OLAP server used.
> (http://www.olapreport.com/market.htm)
>
> From a performance point of view the 3 RDBMS servers are near identical
> (www.tpc.org / TCP-H benchmark)
>
> From a 3rd party support Microsoft is better, you'll found a lot of tools &
> product compatible with AS 2000/2005 & SQL 2000/2005.
>
> But you'll found a lot of articles which push one of these vendors...
>
> You have to setup a complete list of needs & requirements of what your
> client want.
> But from my experience, this doesn't really helps you in your process.
> Today the internal expertise & knowledge of a particular database/technology
> is most important, if you know and allready use the product you are able to
> provide better & faster results.
>
> Also... get the demo versions of the tools or ask the vendors for a proof
> of concept.
> if you are really neutral, let the sales rep. to do their jobs.
>
>
> "Stella" <stellajst@xxxxxxxxxxx> wrote in message
> news:ulhZuoP5FHA.884@xxxxxxxxxxxxxxxxxxxxxxx
> > Hi,
> >
> > Does anyone have any information on comparison between different databases
> > for datawarehousing? I am working on a study to develop a datawarehousing
> > solution for my client, so I would like to get some information on
> > competitive aspects of SQL Server 2005 over DB2 and Oracle.
> >
> > Thanks all~
> >

.

Relevant Pages

  • Which SP3a for SQL 2000 Personal Edition?
    ... I need to know which EXE's of SP3 to install with SQL Server 2000 Personal ... engine. ... Database ...
    (microsoft.public.sqlserver.server)
  • Re: Database for datawarehouse
    ... > then the 2 others) In 1 product you have a database engine, ... > cut under the 'proven technology' selection criteria. ... under 1TB of disk (100GB of data for SQL Server) you can ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: VistaDB Database
    ... I just saw an ad in the latest ComponentSource newsletter for a database ... It looks very interesting as a database engine for smaller applications ... Should I use access or SQL server? ... but with SQL server you have to install the engine and check ...
    (microsoft.public.dotnet.languages.csharp)
  • LRe: newbie questions
    ... SQL Server is just that--it's a software program (what we call a database ... Microsoft sells about five different versions of SQL Server ... It's not a database or a database engine. ... JET is a client-side database program that like SQL ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: I dont know how to link VB to database (ODBC) table.
    ... The Provider/Driver -> Uses a Connection String to access a Database engine ... The Jet engine -> Uses your data store. ... Under TextBox Property ...
    (microsoft.public.vb.general.discussion)
Loading