荔园在线
荔园之美，在春之萌芽，在夏之绽放，在秋之收获，在冬之沉淀
[回到开始]
[上一篇][下一篇]
发信人: achang (阿昌), 信区: Database
标 题: Comparing SQL Server 2005 and Oracle
发信站: 荔园晨风BBS站 (2005年12月13日23:03:19 星期二), 站内信件
Security
"Oracle is years behind Microsoft and other companies on security," said
Cesar Cerrudo, CEO at information security services company Argeniss in
Argentina. "I think Oracle is an amateur when it comes to security right
now."
Microsoft believes that advanced security is functionality that should be
standard in your database infrastructure. Oracle seems to think advanced
security is an option available for only select customers. SQL Server
provides all security features in all SQL Server editions, out of the box.
Oracle provides only basic security in its all its edition. More advanced,
but essential, security features are available only as extra cost options.
Further, these options are available only with the Enterprise Edition of the
database, leaving small- and medium-sized businesses potentially vulnerable.
For equivalent security functionality, SQL Server costs less than Oracle and
is easier to manage. See the following paper for a detailed comparison of
the security features of SQL Server 2005 and Oracle 10g R2.
Compare the security features available in SQL Server 2005 and Oracle 10g R2
by reviewing the SQL Server 2005 and Oracle 10g Security Comparison.
Security features and functionality by themselves do not tell the complete
security story. Security features are of no use if a product is not well
designed and engineered. Security features must be built on a solid
foundation of a well-engineered, high-quality product. SQL Server is built
on such a foundation.
Fewer security vulnerabilities have been detected in SQL Server than in
Oracle over the same period—and Microsoft addresses vulnerabilities more
quickly than Oracle. This implies that days-of-exposure-to-risk are
substantially lower with SQL Server than with Oracle. Read comments from
knowledgeable industry insiders about Oracle security and then learn more
about the comparisons in the reports that follow.
• Flaw Hunters Pick Holes in Oracle Patches
"It seems that Microsoft has learned this lesson. Oracle has not. Oracle has
talked the talk without walking the walk, while Microsoft has spent a
fortune in time and money to improve the security of its software and has
made incredible headway." —Michael Gavin, Senior Analyst, Forrester
• Microsoft's Blue Hat Shows It's Serious About Security
"Microsoft's development process and procedures are unique, and uniquely
suited to a mammoth software development shop. However, companies that want
to make their software more secure will have to take many of the same steps
as Microsoft to turn their ship around." —Gary McGraw, CTO, Cigital Inc.
• Role Comparison Security Report: Database Server Role
Commissioned in this one-year study, Security Innovation reports SQL Server
2000 had zero vulnerabilities compared to MySQL with 7 vulnerabilities and
Oracle 10g with 30 vulnerabilities.
• The Importance of Vendor Openness on Security
Recent research conducted by a respected analyst firm on Oracle's security
patches warns that Oracle's secrecy around some "Severity 1" security
vulnerabilities leaves customers open to increased risks. The analyst firm
also notes that users of older Oracle versions should consider upgrading
immediately or switching to an alternative product.
• Get the Facts on Database Security
Find out more about key resources for securing your database and best
practices from security specialists, and learn from the insights of various
industry experts about database vendor security claims.
-----------------------------------------------------------------------------
---
High Availability
High availability does not have to mean high cost. Both SQL Server 2005 and
Oracle 10g can help provide very high levels of availability. However, SQL
Server 2005 delivers enterprise-level high-availability features to your
organization at a lower total cost of ownership (TCO) and with greater
flexibility and less complexity than does Oracle 10g.
The following white paper analyzes the high-availability features of SQL
Server 2005 and compares them with Oracle 10g:
• White Paper Shows SQL Server Provides Enterprise-Class
High-Availability
at
a Lower Cost than Oracle 10g
Comparing the high-availability features of SQL Server 2005 and Oracle 10g,
this paper shows that SQL Server high-availability features outperform and
are available in more versions, with a lower TCO, than Oracle.
-----------------------------------------------------------------------------
---
Performance and Scalability
SQL Server comes in several editions to meet the needs of businesses of all
sizes, from small- and medium-sized companies to the largest enterprises.
The following page compares the performance of SQL Server 2005 and Oracle
using standard benchmarks.
• SQL Server Benchmarks
SQL Server 2005 is designed to scale reliably to meet the needs of even the
largest enterprise in the most demanding environments.
-----------------------------------------------------------------------------
---
Developer Productivity
SQL Server 2005 means more developer tools and fewer barriers. Integration
of SQL Server 2005 with Microsoft Visual Studio, the Microsoft .NET
technologies, and the common language runtime is more comprehensive, more
seamless, more functional, and better-performing than that of Oracle 10g.
SQL Server 2005 has superior ease of use and seamlessness in developing
service-oriented architecture (SOA) applications. Additionally, SQL Server
business intelligence (BI) features are integrated with Visual Studio,
unlike Oracle BI features.
The following document examines the tools and relative levels of integration
for SQL Server 2005 and Oracle 10g:
• White Paper Compares SQL Server 2005 and Oracle as Development
Platform
for .NET Applications
This paper, intended for technology decision makers, examines whether SQL
Server 2005 or Oracle 10g provides a more productive application development
platform for the .NET platform developer. The paper includes a comparative
discussion of TCO.
-----------------------------------------------------------------------------
---
Total Cost of Ownership
Save with SQL Server. Because you do not have to purchase expensive add-ins
to obtain benefits such as security features, management tools, and
reporting and analysis services, the initial cost advantages of SQL Server
2005 over Oracle 10g carry through the entire life of the deployment.
Multicore pricing from Microsoft further increases the cost advantage of
choosing SQL Server. Unlike Microsoft, Oracle has a policy of charging per
core, which can make Oracle database licenses more than four times as
expensive as SQL Server licenses.
Oracle's maintenance and support programs are also more expensive. Customers
must purchase maintenance and support annually (at 22 percent of list
license price) to receive bug fixes and critical security patches. SQL
Server provides all fixes free and has flexible customer support programs.
• CIOview White Paper: Should You Migrate from Oracle to Microsoft SQL
Ser
ver?
Compare the costs of running SQL Server 2005 on Windows Server 2003 to
running Oracle on Unix, including costs of migration and ongoing
maintenance. Or perform your own TCO analysis online.
• Oracle Price Comparison
Compare pricing for Oracle and IBM with SQL Server pricing quickly and
easily. Download our Oracle Price Comparison calculator and see how much you
will save with SQL Server.
• White Paper Shows that SQL Server Provides Enterprise-Class High-
Availability at a Lower Cost than Oracle 10g
Comparing the high-availability features of SQL Server 2005 and Oracle 10g,
this paper shows that SQL Server high-availability features outperform
Oracle, with a lower TCO than Oracle's.
• White Paper Compares SQL Server 2005 and Oracle as Development
Platform
for .NET Applications
This paper is intended for technology decision makers and focuses on the
database management system as an application development platform for
the .NET platform developer. A comparative discussion of TCO is also
included.
-----------------------------------------------------------------------------
---
Business Intelligence
Get a competitive edge with better business intelligence (BI). SQL Server
2005 includes Analysis Services for online analytical processing (OLAP) and
data mining, Reporting Services, and other features for the equivalent of
which Oracle requires the purchase of expensive add-ins. These powerful
capabilities are included in the basic license and price with SQL Server
2005. This lets organizations deploy BI solutions widely without
significantly affecting their budgets.
Look more deeply into how SQL Server 2005 stacks up against Oracle
functionally in the following documents:
• A Comparison of Business Intelligence Strategies and Platforms
This report from Green Hill Analysis analyzes and compares the BI
components—data warehousing databases, OLAP, data mining, interfaces, and
build-and-manage capabilities—of SQL Server, Hyperion Solutions, IBM, and
Oracle.
• Study Shows SQL Server BI Solution Costs $3.2 Million Less than Oracle
The Walklett Group, a project delivery and project management company,
explores the cost differences between two comparable BI solutions: one from
Unisys and Microsoft, the other from Sun Microsystems and Oracle. This paper
details the analysis process and reveals the Walklett Group's findings.
--
看不见你的背影，于是我渐行渐远，
直到某天你的呼唤，我依然会回头。
※ 来源:·荔园晨风BBS站 bbs.szu.edu.cn·[FROM: 192.168.110.128]
[回到开始]
[上一篇][下一篇]
荔园在线首页 友情链接：深圳大学 深大招生 荔园晨风BBS S-Term软件 网络书店