Analisis de bases de datos hecho por wisdomforce

Features, strengths and weaknesses comparison between MS SQL 2005 (Yukon) and Oracle 10g databases

A Technical White Paper By David Gornshtein Boris Tamarkin WisdomForce Technologies, Inc http://www.wisdomforce.com Revision 1.2

©2004 WisdomForce Technologies, Inc. All rights reserved.

1

Note*: The latest copy of the document is available athttp://www.wisdomforce.com/dweb/resources/docs/MSSQL2005_ORACLE10g_compare.pdf This topic contains alternative comparison between latest versions of Oracle 10g and Microsoft SQL Server 2005 databases.

Table of Contents Preface............................................................................................................................................. 4 Major limitations of MSSQL prior to Yukon (such as MSSQL2000)........................................... 5 Locking strategy.......................................................................................................................... 5 Online space reorganization and table/index partitioning .......................................................... 6 Statistics...................................................................................................................................... 7 Clustering and high availability .................................................................................................. 7 Administration ................................................................................................................................ 9 Locking......................................................................................................................................... 10 Online data reorganization............................................................................................................ 13 Partitioning.................................................................................................................................... 14Indexes .......................................................................................................................................... 15 Clustering...................................................................................................................................... 16 Tuning........................................................................................................................................... 17 Function based indexes via indexed computed column............................................................ 17 MSSQL 2005 Indexed View vs. Oracle Materialized Views ................................................... 17 See our future whitepapers for MSSQL 2005 vs. Oracle 10g dynamic performance views comparison.Data export/import.................................................................................................... 17 Data export/import ........................................................................................................................ 18 WisdomForce FastReader......................................................................................................... 18 Replication.................................................................................................................................... 19 Peer-to-Peer Transactional Replication .................................................................................... 19 Database Mirroring (Extend log shipping, automatic failover to a standby server)................. 19 Backup and Recovery................................................................................................................... 20 Attach/restore database ............................................................................................................. 20 Hot Backup ............................................................................................................................... 21 Fast...