Re: oracle v SS

On 11/7/19 3:13 PM, Orlando L wrote:

> Hi all
>
> Trying to decide between oracle and sql server for a query/warehousing
> type database. Can anyone share their input or point to a paper for
> the current versions. Thanks
>
> Orlando.

Hi Orlando!

SQL Server enterprise edition comes with what Oracle calls "In-Memory option" and partitioning, no further licensing required. SQL Server doesn't have multi-versioning  which makes things simpler for mostly query database. On the flip side, readers block writers and vice versa, which means that loading usually means downtime. SS has something called "always on availability groups", which allows you to maintain shared nothing "cluster" with several identical database copies, which can be queried in parallel. SQL Server supports bitmap indexes and star (snowflake) schema queries.  SQL Server EE is significantly cheaper than Oracle. I would advise going with SQL Server.

Regards

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

--
http://www.freelists.org/webpage/oracle-l