Oracle Database 10g Best for Windows by jianglifang

VIEWS: 13 PAGES: 34

									 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
 AN SWE RS

								
To top