没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
试读
21页
SQL Server 2008 is the optimal data platform for Oracle applications that run on Microsoft. It is an enterprise-ready data management and analysis platform that provides Oracle applications with the highest levels of scalability, reliability, and security. SQL Server 2008 supports large-scale Independent Software Vendor (ISV) applications, provides enhanced performance , and takes full advantage of the latest hardware and software architectures.
资源推荐
资源详情
资源评论
Optimal and Enterprise Ready: SQL Server
2008 with JD Edwards, PeopleSoft, and Siebel
SQL Server Technical Article
Published: March, 2009
Applies to: SQL Server 2008
Introduction: This white paper describes why Microsoft
®
SQL Server
®
is the optimal data
platform to use with JD Edwards, PeopleSoft, and Siebel applications that run on the Microsoft
®
platform. The paper describes the new and enhanced features of SQL Server 2008 that enable
Oracle application customers to reduce cost, optimize performance, improve availability and
reliability, and simplify data management and security. It is assumed that the reader has a
working knowledge of these Oracle applications and Microsoft SQL Server concepts and
features.
For the latest information: See Microsoft SQL Server 2008
Copyright
The information contained in this document represents the current view of Microsoft Corporation
on the issues discussed as of the date of publication. Because Microsoft must respond to
changing market conditions, it should not be interpreted to be a commitment on the part of
Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the
date of publication.
This white paper is for informational purposes only. MICROSOFT MAKES NO WARRANTIES,
EXPRESS, IMPLIED, OR STATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT.
Complying with all applicable copyright laws is the responsibility of the user. Without limiting the
rights under copyright, no part of this document may be reproduced, stored in, or introduced into
a retrieval system, or transmitted in any form or by any means (electronic, mechanical,
photocopying, recording, or otherwise), or for any purpose, without the express written
permission of Microsoft Corporation.
Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual
property rights covering subject matter in this document. Except as expressly provided in any
written license agreement from Microsoft, the furnishing of this document does not give you any
license to these patents, trademarks, copyrights, or other intellectual property.
© 2009 Microsoft Corporation. All rights reserved.
Microsoft, SQL Server, SQL Server 2005, SQL Server 2008, Windows, and Windows Server,
Windows Server 2008 are either registered trademarks or trademarks of Microsoft Corporation
in the United States and/or other countries.
The names of actual companies and products mentioned herein may be the trademarks of their
respective owners.
Optimal and Enterprise Ready: SQL Server 2008 with Oracle Applications i
Contents
..................................................................................................................................................... i
Executive Summary...................................................................................................................1
What is New in SQL Server 2008..............................................................................................3
Microsoft and Oracle Applications Partnership......................................................................4
SQL Server 2008 and Oracle Applications...............................................................................4
Enterprise-Ready and Scalable for Oracle Applications........................................................5
Ease of Use and Self-Tuning Features.....................................................................................6
Advanced Database Features...................................................................................................7
Data Compression.................................................................................................................... 7
Backup Compression............................................................................................................... 8
Transparent Data Encryption....................................................................................................9
Data Collector and Management Data Warehouse..................................................................9
Plan Freezing......................................................................................................................... 10
Resource Governor................................................................................................................11
Other Advanced Database Features......................................................................................11
High Availability Features.......................................................................................................12
Database Mirroring.................................................................................................................12
Failover Clustering.................................................................................................................13
Lower Total Cost of Ownership..............................................................................................13
Conclusion............................................................................................................................... 15
Links and References..............................................................................................................17
Optimal and Enterprise Ready: SQL Server 2008 with Oracle Applications ii
Executive Summary
As Oracle has released new versions of the JD Edwards, PeopleSoft, and Siebel business
applications, many Oracle customers are evaluating their strategy for upgrading to these
applications, and the future investment in maintaining their enabling technologies. Customers
want to ensure that Oracle applications will enable their company to achieve a competitive
advantage, improve business agility, and enable innovation.
For Oracle applications that run on the Microsoft
®
platform, customers want assurance that
Microsoft Application Platform enabling technologies including Microsoft
®
SQL Server
®
are
reliable, secure, manageable, economical, and fully integrate with Oracle applications.
1
In this regard, Microsoft is working with Oracle Corporation through its Applications Unlimited
plan
2
to ensure that SQL Server 2008 and Microsoft
®
Windows Server
®
2008 are certified and
fully compatible with the latest versions of the JD Edwards, PeopleSoft, and Siebel
applications.
3
In particular, this certification ensures that earlier versions of SQL Server can be
easily upgraded to SQL Server 2008.
Table 1 shows the Oracle application versions that are certified with Microsoft SQL Server
2008.
4
Oracle application SQL Server 2008 Oracle application versions
JD Edwards EnterpriseOne EnterpriseOne Tools version 8.98.1
PeopleSoft Enterprise PeopleSoft Enterprise applications versions 8.9, 9.0, and
above
PeopleTools versions 8.49.13, 8.50, and above
Siebel Siebel versions 7.8, 8.0, and 8.1
Table 1 SQL Server 2008 Supported Oracle Applications
SQL Server 2008 is the optimal data platform for Oracle applications that run on Microsoft. It is
an enterprise-ready data management and analysis platform that provides Oracle applications
with the highest levels of scalability, reliability, and security. SQL Server 2008 supports large-
scale Independent Software Vendor (ISV) applications, provides enhanced performance
5
, and
takes full advantage of the latest hardware and software architectures.
SQL Server 2008 contains a compelling set of new features and capabilities that make it ideal
for an enterprise environment. By upgrading from SQL Server 2000 or 2005 to SQL Server
2008, Oracle applications customers can receive many immediate business and technical
benefits, without the need to make application changes.
1
http://www.microsoft.com/sqlserver/2008/en/us/application-platform.aspx
2
http://www.oracle.com/applications/applications-unlimited.html
3
The latest versions of all Oracle applications (JD Edwards, PeopleSoft, Siebel) are, or shortly will be,
certified on SQL Server 2008 (JD Edwards by early 2009).
4
PeopleTools 8.49.13 requires SQL Server 2008 cumulative update 1 (CU1 ).
5
http://www.microsoft.com/isv/oracle/
Optimal and Enterprise Ready: SQL Server 2008 with Oracle Applications 1
SQL Server 2008 advanced features such as data compression and backup compression
enable it to provide a strong, economical data platform for Oracle’s applications. For example,
Table 2 below shows recent Microsoft data compression testing results.
6
Compression type Oracle application Disk savings
row Siebel CRM application 45 percent
row JDE customer workload 69 percent
row Siebel Analytics 48 percent
page Siebel Analytics 66 percent
Table 2 Data Compression with Oracle Applications
Table 3 shows recent Microsoft backup compression testing results.
7
Oracle application Compression ratio Backup time
reduction
Restore time
improvement
PeopleSoft applications 1:10 50 percent 20 to 30 percent
Table 3 Backup Compression with Oracle Applications
SQL Server 2008 has excellent value and a lower total cost of ownership (TCO) as compared to
competitor platforms. Many of the features that are simply included within SQL Server 2008
must be purchased as separate third-party products, or as add-ons in competitor platforms.
6
Actual customer results will vary according to the Oracle application, the hardware being tested, and the
application’s specific data and workload requirements.
7
See footnote 5.
Optimal and Enterprise Ready: SQL Server 2008 with Oracle Applications 2
剩余20页未读,继续阅读
资源评论
wwwach
- 粉丝: 1
- 资源: 3
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功