Oracle Database 10g Best for Windows - PowerPoint - PowerPoint

							 The following 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 decision. The development, release, and timing
   of any features or functionality described for Oracle’s products
               remains at the sole discretion of Oracle.
Deploying
Oracle Database 10g
on the Windows Platform

Mark Townsend
Senior Director, Database Product Management
Oracle Corporation
Agenda

   Today’s IT Infrastructure
   Oracle Database 10g Solutions on Windows
   Product Demonstrations
   Commitment to Windows and .NET
   Windows and .NET Customers
   Q&A
    Today’s IT Infrastructure
   Configured for peak loads
   Limited scalability
   Availability < 99.x%
   Fragmented security
Oracle Grid Computing
Standardize, Consolidate, Automate

 Storage
 Database Servers
 Application Servers
 Management Tools
Automatic Storage Management
                  Improved ease-of-use
                   and configuration
                  Enhanced data
                   provisioning
                    –   Support transportable
                        tablespaces
                  Enhanced storage
                   virtualization
                    –   Support multiple
                        databases in a cluster
                    –   Support databases at
                        multiple release levels
  Highest Data Protection
  at Lowest Cost


                                             Data Guard
                                             Site Failure
                                             Protection
                               Flashback
                               Human Error
                                Protection
                   Flash
                  Recovery
                    Area
ASM Mirroring     Corruption
Storage Failure   Protection
  Protection
Oracle Real Application Clusters
 Improved Robustness
    –   Cluster Verification
        Utility
    –   Improved OCR,            ERP   CRM   DW
        Voting Disk resilience
 Clusterware API for
  integrated application
  availability
 Run-time load
  balancing
 Certified to 100 nodes
 Improved performance
Self-Managing Database
          Automatic Performance Diagnostics & Tuning




 Automatic Space &
                                                       Self-Managing
Memory Management
                                                         Backups
                          Oracle
                       Database 10g



             Enterprise Configuration Management
Service and System Management
                         Service
                            –   Any end-user business function
                         System
                            –   Key components responsible
  Service Topology
                                for supporting a service
                         Topological Views
                            –   Visual modeling
                            –   Relationships
                            –   Component level status
                         Dashboards
    Service Dashboard
                            –   At-a-glance monitoring of all
                                critical indicators
 Oracle Enterprise Manager 10g
 Plug-Ins for Windows
 .NET Framework
 SQL Server
 ISA Server
 BizTalk Server
 Commerce Server
 Active Directory
 Internet Information Server
Christian Shay
Principal Product Manager
.NET and Windows
Oracle Corporation
Windows Development
Environment Support
 Oracle Developer
 Tools for VS.NET
                                                        IIS
                                                              MTS/
                  Develop    C++, C#,      Deploy      (ASP
                                                              COM+
  Visual Studio              VB .NET                 ASP.NET)
  Environment               Application
                                                        Application
                                                            IIS
                                  Deploy
         Database
         Development


                                                      ODP.NET
                            Oracle DB
                            Extensions
                             For .NET          Oracle Services for MTS
Oracle on .NET

   Easy to use
   Fully compliant with ADO.NET
   Tightly integrated with Visual Studio
   High performance
     –   Fast out-of-the-box ADO.NET provider
     –   Lots of tuning options
 Advanced functionality
     –   Oracle DB features exposed in .NET
           RAC, XML DB, advanced security, etc.
ODP.NET

 Available today in production for free
    –   http://otn.oracle.com/dotnet
 Can be used with Oracle8, Oracle8i, Oracle9i,
  and Oracle10g database servers
    –   DB server can be on Unix, Linux, Windows, etc.
 Supports VS.NET 2002 and 2003
    –   VS 2005 (beta)
 Supports .NET Framework 1.0 and 1.1
    –   .NET 2.0 (beta)
ODP.NET Feature Highlights

   Conforms to ADO.NET 2.0 spec
    –   e.g. Factory Classes
   Objects/UDTs
   Database Change Notification
   XML DB
   Ref Cursors
   LOBs
   RAC/Grid
    –   Works transparently with NO application
        changes
ODP.NET – Optimized for Grid
 Works transparently with NO application changes
 When a node fails
   –   Instant failover notification
   –   Automatic connection cleanup
   –   Automatic rebalancing
 When a node is added
   –   Automatic rebalancing
 Ongoing workloads
   –   Connections are dispensed based on load metrics
  Load                            Connection Request
  Balancing
                   ODP.NET Conn. Pool




“I am very busy”                             “I am busy”

 10% idle                                     20% idle
                          “I am bored”

                                 70% idle
Oracle Developer Tools for Visual
Studio .NET

 Free download
    –   http://otn.oracle.com/dotnet
 Tightly integrated “Add-in” for Visual Studio
 Oracle is a premier-level partner in the Microsoft
  Visual Studio Industry Partner (VSIP) Program
ODT Feature Overview
   Oracle Explorer – browse and alter schema
   Wizards and Designers
   Automatic code generation
   PL/SQL Editor/Debugger with IntelliSense
   Oracle Data Window
   Oracle Query Window (ad hoc SQL)
   .NET Stored Procedure Deployment Wizard
   Integrated help system – SQL, PL/SQL keywords
ODT New Features

 PL/SQL Debugging
 Visual Studio .NET 2005 support
Write .NET Stored Procedures for
Oracle
    Oracle Developer
    Tools for VS.NET

     Visual Studio                 Client
     Environment                 Application

              Develop
                                        Invoke
     C#,VB.NET,C++
     Server Project
      (Use ODP.NET                             Invoke     Stored
       if required)                                     Procedure,
                                                          SQL ..
                Build   Deploy

       Assembly                                  Oracle DB
         foo.dll
        (proc sp)                                Extensions
                                 Stored Proc      for .NET
D E M O N S T R A T I O N


Oracle Developer
     Tools
Oracle Database 10g Express Edition
 Small-footprint
  starter database
 Free to
   –   Download
   –   Develop
   –   Deploy
   –   Distribute
 Free online
  community forum
Oracle Application Express 2.0
 Quick assembly of reporting
  and data entry applications
 No programming or scripting
 Instant deployment on the
  Web
 Use the full power of Oracle
  Database 10g
D E M O N S T R A T I O N

 Oracle Database 10g
   Express Edition
Oracle’s Commitment to Windows
                                                        Windows

7                                                      Management
                                                        Plug-Ins




1993       2000   2001        2003    2004    2005      2006




Windows   Windows Windows   Windows          Windows
  NT       2000     XP       Server            x64
                              2003
Oracle RAC on Windows Customers
        Nextel
           –   Mission-critical applications
        US Army Medical Research (MRMC)
           –   Consolidated evaluation/reporting system
        WeightWatchers.com
           –   Global web site
        First Command Financial Planning
           –   Financial services
        Lex Vehicle Leasing
           –   Global online rental application
 Oracle’s Commitment to .NET

   Oracle Data Provider
   for .NET(ODP.NET)              ODP.NET
                                  Oracle Developer Tools
                                  for VS.NET             Oracle Database
                                  Oracle Database          10g Express
                                  Extensions for .NET        Edition




  2002            2003    2004    2005                  2006


   .NET          .NET               .NET
Framework     Framework          Framework
    1.0           1.1                2.0
Oracle .NET Customers
       Thomson Financial
          –   Financial information research
       Ohio Savings Bank
          –   Customer Call Center & Mortgage
              processing
       Dell Corporation
          –   Order Management
       Credit Suisse First Boston
          –   Mission critical system spanning three
              locations
       Ziraat Bank
          –   Core banking application on grid computing
In Conclusion
 The latest Oracle technology further
  empowers .NET and Windows developers

 Oracle’s new management plug-ins deliver
  rich monitoring and management for Windows

 Oracle Database 10g delivers the highest
  quality of service on Windows at the lowest cost
Next Steps
 Visit Oracle at booth # 800
   - Hands-On Lab: Install Oracle Database XE
   - Daily Raffle: Win a pass to Oracle OpenWorld
   - Live product demonstrations
   - Oracle Windows and .NET experts

 Download Oracle for Windows and .NET
   - oracle.com/technology/dotnet
   - oracle.com/technology/windows
QUESTIONS
 ANSWERS