1 / 46

Oracle Database 11g for Windows and .NET

Oracle Database 11g for Windows and .NET. Alex Keh Principal Product Manager, Server Technologies. Agenda. Oracle Database 11g on Windows Oracle Database – Best Performance Windows OS Integration Oracle for .NET Developers Ease of Development Performance Manageability and Installation

topaz
Télécharger la présentation

Oracle Database 11g for Windows and .NET

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle Database 11g for Windows and .NET Alex Keh Principal Product Manager, Server Technologies

  2. Agenda • Oracle Database 11g on Windows • Oracle Database – Best Performance • Windows OS Integration • Oracle for .NET Developers • Ease of Development • Performance • Manageability and Installation • Unified Oracle and Microsoft Server Management • Oracle Fusion Middleware • Next Steps

  3. <Insert Picture Here> Oracle Database 11g on Windows

  4. Oracle Database 11g Value Proposition • Easiest to Manage • Highest Quality of Service • Highest Performance and Scalability • Fault Tolerant • Most Secure • Best Information • Lowest Cost • Lowest Risk of Change

  5. Oracle Database 11g - Performance Client SideCaching Database ResidentConnection Pool Java Just-In-TimeCompiler Query ResultCaching Up to22% Faster Up to 20 x connections Up to11 x Faster Up to25% Faster Optimizer StatsCollection Oracle SecureBackup Oracle StreamsEnhancements RAC PerformanceEnhancements Up to 10 x Faster Up to25% Faster Up to 2 x Faster Up to70% Faster

  6. Secure Files Secure Files Linux Files Linux Files Oracle Secure FilesBreaking the Performance Barrier… Read Performance Write Performance Mb/Sec Mb/Sec File Size (Mb) File Size (Mb)

  7. Performant Schema-based XML - Binary XML - Object Relational Structured Unstructured XML - LOB Flexible Schema-less New in Oracle Database 11gExtended XML Support with Binary XML Up to15Xover XML LOBs

  8. Best Price/Performance on Windows • #1 TPC-C Price/Performance amongst all platforms • Oracle Database 11g on Windows • …And Oracle has the #1 TPC-C Performance also TPC-C by Price/Performance 11g SQL 2005 Highest Ranking Benchmark 1st 3rd Price/tpmC $0.73 $0.84 tpmC 102,454 82,774 Publication Date 9/12/07 3/27/07 As of 9/12/07: HP ProLiant ML350G5, 102,454 tpmC, $.73/tpmC available 12/31/07. HP Integrity Superdome Server, 4,092,799 tpmC, $2.93 tpmC, available 8/6/07 (#1 TPC-C performance). Source: Transaction Processing Performance Council (TPC) www.tpc.org

  9. Windows Integration - Active Directory and Windows Security • Database Registration and Name Resolution • Support authenticated connection to Active Directory using OS authentication • Kerberos Authentication • Stronger encryption algorithms (DES3, AES, RC4) • Support default encryption type supported by MS KDC • Use DNS Domain Name as Kerberos REALM name by default • Kerberos authentication to Oracle database in a MS cross-domain setup • Removal of 30 character limit on the Kerberos user name

  10. Direct NFS Client on Windows • Network Attached Storage (NAS) use Network File System (NFS) • Oracle Database 11g allows direct Windows NFS v3 access • Part of DB kernel in Oracle Disk Manager library • Benefits: easier manageability, simplified tuning, and better diagnostics • Common Oracle NFS interface for potentially all host platforms and NFS servers

  11. <Insert Picture Here> Pricing and Packaging

  12. Oracle Database Express Edition • Small-footprint starter database • Free to download, develop, deploy, distribute • Installs in about 10 minutes • Uses native Windows installer • Standard silent install method • Download size • Server (includes client) - 157 MB • Client - 30 MB • Quick start tutorials for DB and developer novices

  13. 10,000 1,000 Average Connected Users 400 Standard Edition One (2 sockets max) Enterprise Edition (Unlimited processors) Standard Edition (4 sockets max) Oracle DatabaseSolutions That Grow with You

  14. Where to Buy*…. * LIST PRICES SHOWN WHERE AVAILABLE

  15. <Insert Picture Here> .NET Development with Oracle Database

  16. .NET Development Environment Oracle Providers for ASP.NET Oracle Developer Tools for VS IIS (ASPASP.NET) MTS/COM+ C++, C#, VB .NET Application Develop Deploy Visual Studio Environment Application IIS Deploy Database Development ODP.NET Oracle DB Extensions For .NET Oracle Services for MTS

  17. Oracle Developer Tools for Visual Studio • Free • “Add-in” for Visual Studio 2005 and VS .NET 2003 • Easy to use and intuitive • Powerful features that enhance productivity • Fully integrated with Visual Studio • Easy ASP.NET web application development • Designers and wizards • Automatic .NET code generation • PL/SQL editor/debugger • Source Control Integration • Much more • Stay in Visual Studio for project lifecycle

  18. Oracle Data Provider for .NET • Free • Easy to learn, even if new to Oracle • Compliant with ADO.NET 1.x, 2.0, and higher • No learning curve • Complete access to .NET functionality • Native access to Oracle Database • Utilize advanced Oracle Database features • RAC, performance, security, data types, XML, etc. • Oracle Providers for ASP.NET use ODP.NET

  19. Oracle Database Extensions for .NET(AKA .NET Stored Procedures) • Write Microsoft Visual C# or Visual Basic .NET procedures/functions • Oracle Database 10g Release 2 or higher on Windows option • Build assembly in Visual Studio .NET • Deploy from Visual Studio .NET into Oracle using .NET Deployment Wizard

  20. Develop on Windows, Database on any Platform Windows ODT and ODP.NET Linux Visual Studio Environment Unix Windows Other Oracle 11g,10g, 9i, or 8i

  21. Oracle on .NET Customers “ “ “ “ “ We’re taking the best of both worlds – .NET and Oracle – to give us the best platform possible. ODP.NET is vital to the success of our next-generation application Since we use a Microsoft .NET middle tier, Oracle Data Provider for .NET provided the high throughput, high performance, and bulletproof connectivity to the database Integrating ODP.NET was easy and straightforward.. we were able to take advantage of… the power and high availability of  the grid ” ” ” Bill Evjen, Technical Architect Jim Lombardi, Principal Database Engineer Jason Lin, Assistant Vice President, Application Integration and Architecture

  22. New .NET Feature Themes • Ease of Development • Tight integration with Visual Studio 2005 • Web Application Development (ASP.NET) • Objects • Performance • Expose new tuning features • Improve performance out of the box • Manageability and Installation • Deployment: smaller client and easier packaging

  23. <Insert Picture Here> Ease of Development

  24. Visual Studio Integration – Oracle Developer Tools • Fully integrated with Visual Studio 2005 • Server Explorer • Data Sources Window • Data Source Configuration Wizard • Dataset Designer • TableAdapter Configuration Wizard • Query Builder/Query Designer • More • Automatic code generation – Winform and ASP.NET • Data Sources Window • Integration with SQLDataSource control • Makes ASP.NET web application development very easy

  25. Visual Studio Integration • New Oracle Database Project • Manage, Edit and Run SQL scripts • SQL*Plus is built in • Source control integration – SourceSafe and Team Foundation Server • Oracle Query Window • New UI • Explain Plan • Auto-commit toggle • ODT Options page • Customize how you use ODT

  26. D E M O N S T R A T I O N New ODT Features

  27. Web Application Development (ASP.NET) • ASP.NET Providers • Pre-built services to store website state into databases • Easy to learn • Based on standard ASP.NET provider APIs and schema • Installation • Run PL/SQL scripts to create provider schemas • Namespace • Oracle.Web

  28. Web Application Development (ASP.NET) • Oracle Providers for ASP.NET Components • Cache Dependency Provider • Membership Provider • Profile Provider • Role Provider • Site Map Provider • Session State Provider • Web Parts Personalization Provider • Web Event Provider • Administrators can pick and choose which providers to use

  29. D E M O N S T R A T I O N ASP.NET Providers

  30. <Insert Picture Here> Performance

  31. Performance – Data Retrieval • Data retrieval performance improvements (11g) • Client Result Cache • Caches results sets either on client or server • Shared across sessions in the same process • Cache remains consistent via DB Change Notification • Better LOB performance • LOB prefetching – fewer roundtrips • Improved statement caching • Cache ODP.NET parameter contexts

  32. Performance – 64-bit • Allow ODP.NET and .NET stored procedures to use more scalable 64-bit hardware (10.2.0.3) • Windows x64 • 64-bit ODP.NET • 64-bit .NET Stored Procedures • Windows Itanium • 64-bit ODP.NET • 64-bit .NET Stored Procedures • Available for download on OTN from .NET Center

  33. <Insert Picture Here> Manageability and Installation

  34. Installation – Simpler Deployment • Easier to package ODP.NET for large scale deployments • Xcopy – administrators script to specific requirements, generally large deployments • OUI – for small scale deployments • Smaller ODP.NET footprint • OUI install – small footprint • Xcopy install – smallest footprint • Faster ODP.NET deployment • Xcopy • No difference in ODP.NET functionality

  35. Installation – Simpler Deployment • IC xcopy components • ODP.NET • Oracle Providers for ASP.NET • Oracle Provider for OLE DB • OO4O • Oracle Services for MTS • IC deployment • Via OUI - Use the installer as you normally would • Via xcopy • Step 1: Copy IC files to disk • Step 2: Run install.bat • Step 3: Add installation directories to Windows PATH • Step 4: Modify NLS_LANG to desired locale

  36. <Insert Picture Here> Unified Oracle and Microsoft Server Management

  37. Grid Control for Microsoft Servers Systematic way to extend system coverage • Key Benefit: Centralize Management • Enable GC to monitor and manage new components • Windows Host Management • MOM Connector • Microsoft plug-ins: • Exchange • SQL Server • Active Directory • .NET Framework • IIS

  38. <Insert Picture Here> Oracle Fusion Middleware on .NET

  39. Apps – Oracle, Psft,JDE, SAP, Siebel, Legacy, etc. IDE App/Services Msft Outlook Msft Excel Msft InfoPath Msft .Net UI Service, Event Registry BI BPM Portal Sys. Mgmt BI – Business Objects, Cognos, etc. Security & ID Mgmt HA Oracle Fusion Middleware Msft Word Sys Mgmt – HP, CA, IBM, BMC, etc. Enterprise Service Bus Msft Servers i.e. BizTalk J2EE – BEA, IBM, JBoss, etc. ID Mgmt – Sun, Novell OpenLDAP, etc. Msft SQL Server DBMS – Oracle, DB2, Informix, etc. Msft Active Directory TP Monitors, Messaging – Tuxedo MQ, Sonic, CICS, IMS Tibco Msft MSMQ Oracle Fusion Middleware and .NETBridging MS and non-MS Infrastructure with Enterprise Capabilities M i c r o s o f t

  40. <Insert Picture Here> Next Steps

  41. More Information • OTN Windows Technology Center • http://otn.oracle.com/windows • OTN .NET Developer Center • http://otn.oracle.com/dotnet • .NET Blog • http://cshay.blogspot.com/ • For more questions • alex.keh@oracle.com

  42. More Information • OTN Fusion Middleware and Microsoft • http://www.oracle.com/technology/products/middleware/fusion-middleware-microsoft-interoperability.html • OTN Grid Control Plug-ins and Connectors • http://www.oracle.com/technology/products/oem/extensions

  43. The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

More Related