1 / 53

Breakthrough Efficiency for Enterprises with In-Memory Computing for Database, Middleware, Apps(CON9020)

Breakthrough Efficiency for Enterprises with In-Memory Computing for Database, Middleware, Apps(CON9020). Uday Shetty Senior Principal Software Engineer Ashish Pathak Director, Product Management Hsianglung Wu Principal Software Engineer. Program Agenda. Business/IT Challenges

virote
Télécharger la présentation

Breakthrough Efficiency for Enterprises with In-Memory Computing for Database, Middleware, Apps(CON9020)

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. Breakthrough Efficiency for Enterprises with In-Memory Computing for Database, Middleware, Apps(CON9020) UdayShetty Senior Principal Software Engineer AshishPathak Director, Product Management Hsianglung Wu Principal Software Engineer

  2. Program Agenda • Business/IT Challenges • Oracle Engineered Systems • In-Memory Applications • E-Business Suite In-Memory Cost Management • TimesTen In-Memory Database

  3. Business/IT Challenges

  4. Business Challenges How Do We… • Increased Capacity Demand • Managing large compute, storage, network resources • Support & Maintenance of older version Software and hardware • Drive Business Strategic Objectives • Demand volatility and uncertainity as a result of fluctuating economic condition • Lack of responsiveness to sudden Supply Chain problems Data Center • Isolate Actionable Information • Analyze existing product performance • Complete multidimensional analyses and what-if cost simulations on big data • Handle Exploding Volumes of Data • Managing high volumes of daily transactions • Get the needed information in time to be useful

  5. Engineered to Work Together A P P L I C A T I O N Hardware & SoftwareEngineered to Work Together Applications Middleware OS and Virtualization Database Servers Storage

  6. Optimizations Across the Development Cycle Engineered, Tested, and Proven from Apps-to-Disk • Faultinjectiontests • Identify • integration opportunities • Interoperability • tests • End to end functional • validation • Early • development • tests • Full Stack Optimizations One Engineering Team • Sizing and configuration optimizations • Performance and scalability tests • Real world workload tests • Patch regression tests • Load/stress tests 1,000s of hours of testing across the stack to reduce risk

  7. Oracle Engineered Systems

  8. Oracle Exalytics In-Memory Machine New Analytics at Speed of Thought • In-Memory Database(s) • Parallelized TimesTenand Essbase • Advanced Columnar Compression • Heuristic Adaptive In-Memory Cache • Decides what gets stored in-memory • Adapts to changes in analytic workload • In-Memory Analytic Functions • Oracle Business Intelligence (OBI) • Hyperion Planning, Budgeting, and Forecasting • High density Visualizations & Interactivity 4 TB RAM 2 TB RAM

  9. Oracle Exalytics In-Memory Machine • Flexible Configuration and Deployment Domain 1 E1-1 Default 8P/128C 4TRAM 7.2TB HDD 3.2TB Flash Domain 2 Domain 1 E2-1 Default 4P/64C 2TB RAM 3.6TB HDD 1.6TB Flash 4P/64C 2TB RAM 3.6TB HDD 1.6TB Flash • Solaris 11 • Built in zero-overhead virtualization for fast and flexible resource management • 5 optimized domain configurations • Up to 16 zones per system to run multiple applications concurrently • Configuration can be changed by users as needed • Built in backup/recovery with ZFS • Optimized for Consolidation F F F F F F F F F E2-2 Domain 2 Domain 1 5P/80C 2.5TB RAM 3.6TB HDD 2TB Flash 3P/48C 1.5TB RAM 3.6TB HDD 1.2TB Flash E2-3 Domain 1 Domain 2 5P/80C 2.5TB RAM 3.6TB HDD 2.4TB Flash 3P/48C 1.5 TB RAM 3.6TB HDD 0.8TB Flash E2-4 Domain 1 Domain 2 6P/96C 3TB RAM 3.6TB HDD 2.4TB Flash 2P/32C 1TB RAM 3.6B HDD 0.8TB Flash

  10. Oracle Exalytics T5-8 Performance • Breakthrough Performance • 25k concurrent Business Intelligence users and 2k Planning Public Sector Budgeting users running simultaneously on a single system • Enterprise wide central analytics • Leveraging TimesTen In-Memory Database combined with large memory and processor resources • Consolidate BI, Essbase and EPM apps and get superior performance. Dramatically simplify infrastructure. • Using Layered Optimized Virtualization with optimized Exalytics stack • Consolidate multiple Essbase applications on a single system • Multi-instance tests with 20 PSB applications • Leveraging built-in large memory and flash with optimized Exalytics stack

  11. What is Oracle SuperCluster? Best of Breed Technology Engineered to Work Together • SPARC servers • Better performance than IBM Power solutions • Exadata and ZFS Storage • Flash Cache • Executes Oracle Database and I/O operations • Low Latency Network Fabric • Massive bandwidth enabling the fastest network • Management Software • Cloud ready, zero overhead virtualization

  12. Oracle SuperCluster Oracle’s Fastest and Most Scalable Engineered Systems • The best system for running databases and applications in memory • Ideal for consolidation and cloud • Best for IBM/HP and SPARC refreshes and new deployments Software + Compute COMPLETE + Storage Networking

  13. Oracle SuperCluster M6-32 The Ultimate Engineered System • Highest performance • Most scalable engineered system • Most flexible • Grow compute and storage independently • Best for In-Memory computing • Oracle Database12c and applications optimized • Highest consolidation ratios • Highest availability and serviceability

  14. Oracle SuperCluster M6-32 Building Block Design Offers Modularity and Flexibility Compute Server Storage Turn the dial independently on Compute and Storage Flexibility within Compute and Storage

  15. Oracle SuperCluster M6-32 Compute Server Flexibility Summarized

  16. Oracle SuperCluster M6-32 VirtualizationLayered Optimized Virtualization M6-32 Dynamic Domain M6-32 Dynamic Domain • Layer 1: PDoms • Dynamic Domains (PDoms) with zero performance overhead • Layer 2: LDoms • Logical Domains (Oracle VM Server for SPARC) with zero performance overhead • Any mix of Database Domains and Application Domains • Oracle Solaris 11 or 10 for Application Domains • Layer 3: Oracle Solaris Zones • Both Database Domains and Application Domains support Oracle Solaris Zones Application Domain 2 Database Domain 1 Database Domain 2 Application Domain 1 Database Domain 1 Database Domain 2 Application Domain 1 Zone DB Zone DB Zone Zone DB Zone DB Zone Zone Zone DB Zone Zone Clusterware Solaris Cluster

  17. Oracle In-Memory Applications

  18. Oracle In-Memory Applications for SuperCluster M6-32 Real-time Ad-hoc Analytics on Live Transactional Data Hardware • Oracle In-Memory Application modules are highly optimized for engineered systems • Key modules providing real-time insights • Leveraging Exadata Storage for accelerated queries • Leveraging Exalogic optimizations • Big memory capacity of SuperCluster M6-32 combined with in-memory application modules to provide real-time performance to batch jobs • Changes business dynamics • Quickly discover growth opportunities • Make smarter decisions • Reduce corporate costs • Accelerate time-consuming workflows

  19. Fastest Architecture for In-Memory Applications No Need to Copy Data Across Servers

  20. Oracle In-Memory Cost Management

  21. REDIFINING STRATEGIC COST MANAGEMENT WITH A new solution that leverages Oracle technologies like In-Memory Database, Flash Cache, Hybrid Columnar Storage and Data Compression to provide Cost, margin and Profitability Analysis IN REAL TIME.

  22. Cost Management At-a-Glance Absorb Acquisition Costs Optimize Manufacturing Costs Maximize Margins Plan, Forecast and Setup Costs Manage Margins and Gross Profits Maintain Costs • Allocate expenses • Setup accurate cost components • Perform what-if analyses through simulations • Optimize assembly cost structures • Track, maintain, optimize margins • Feedback into cost planning and pricing

  23. Cost Management Transformation Strategic Cost Management • Optimize product cost structures by minimizing component costs • Create profitable product mixes across global operations • Maximize gross margins & profits • Increase penetration in existing markets & enter new markets Analytical Cost Management Strategic Value • Perform reconciliations & identify deviations • Identify cost drivers • Analyze margins, measure profitability Cost Maintenance • Setup costs, accounts & cost controls • Develop & simulate product costs • Manage transaction accounting Maturity

  24. Challenges in Cost Management

  25. Supply Chain Management has Changed Requirement to meet rapidly changing market conditions quickly More what-if scenarios across increasingly complex supply infrastructures Targeted product reconfigurations for separate markets Multiple supply chains running in parallel for different regions yet also feeding each other Exploding Data Volumes Global operations with micro-targeted location-specific data Rapidly increasing number of daily transactions Increasingly complex, large bills-of-materials structures to accommodate Pressure for Quick Financial Decision-Making Optimize product cost structures by minimizing component costs Create profitable product mixes across global operations Maximize gross margins & profits Increase penetration in existing markets & enter new markets • Cost Management on Engineered Systems • Need a Step Change to Tackle the Complexity of the Task

  26. Cost Management on Engineered Systems • Reduce Waiting, Increase Productivity, Distill Actionable Information Today What We Need.... Define & Rollup Costs Perform What-if Analyses Less Time Waiting Refine Product Costs Cost Transactions Process Revenue, Margins, Value Summarizations Long Wait Times for Completion of Batch Processes More Time Working Analyze Accounts, Margins and Variances Channel Analytical Insights Improve Cost Controls and Product Mixes • Near real-time interactive simulations and analyses • Not just large global businesses with multiple BUs

  27. Oracle In-Memory Cost Mgmt Applications • Providing the Performance to Transform Business Processes High Performance In-Memory Cost Management Applications • Transformational Change • Fundamental limitations of current solutions • No pre-built integrations between cost simulations and margin analysis • Linear and textual analytics Solution • A single business process flow from cost configuration and simulation through profit & margin analysis • One system, optimized for high-performance and delivered via Oracle's pre-configured Verification Methodology • Specifically engineered to exploit unique capabilities of Oracle Engineered Systems and deliver performance and functionality not possible on other platforms

  28. Spread sheet based solution In-Memory Cost Management Cost Simulator Gross Profit Analyzer Cost Compare

  29. In-Memory Cost Management SmartView – Run Simulation Directly from SS

  30. In-Memory Cost Management Where-Used and Supply Chain Cost Rollup Where-used and cost rollup result

  31. In-Memory Cost Management Visibility Into All Valuations • All Valuations • Inventory On-hand • Shop floor • In bound Pipeline

  32. In-Memory Cost Management Drilldown into Complete BOM and Routing Drilldown into complete BOM and Routing

  33. In-Memory Cost Management Cost Details in Current and Simulated Costs Cost details in Current and Simulated costs

  34. How Did We Do That ? • Powered by Oracle’s Engineered Systems • Flash Cache and Flash Cache Write-Back • In-Memory DB • Smart Scans • HCC and Data Compression • New spreadsheet based UI • OBIEE-based analytics for near real-time analyses • Unified information architecture of Oracle’s E-Business Suite • Speed and performance of our In-Memory architecture • New applications added to the strong legacy of Cost Management within the E-Business Suite at Oracle

  35. Value Proposition

  36. Oracle In-Memory Cost Management Enables You To… 1 2 Maximize Revenue and Increase Profits Optimize Operational Costs and Working Capital

  37. Oracle's Cost Impact Simulator and Gross Profit Analyzer ( page 1 of 2 ) Make Decisions in Time to Capture Highest Possible Profits • Obtain the Most Profitable Product Mix • Near real-time results from big data across Supply Chain, Manufacturing, Financials • Complex multidimensional analyses and detailed what-if cost simulations • Timely analyses of cost variations, inventory valuations, and the impact to margins and profits • View the Impact of Cost Changes • Assess the impact to margins now and downstream on unshipped orders and forecasted demand • Investigate the impact of granular cost changes and visualize the impact of the change

  38. Oracle's Cost Impact Simulator and Gross Profit Analyzer ( page 2 of 2 ) Make Decisions in Time to Capture Highest Possible Profits • Identify Optimal Pricing for Finished Goods • Comprehensive what-if analyses on complex multi-level bills of material, routing data • Access even targeted changes to supplier costs on • Purchased components • Landed costs from transportation • Delivery-related expenses • Customs & Duty • Manufacturing costs on the shop floor • Accurately Simulate Future Costs • Plan target costs and predict margins based on historical data and the influence of outside parameters • Run scenarios including the influence of inflation, competitive pricing, discounts, potential tax increases

  39. Oracle In-Memory Cost Management Enables You To… 1 2 Maximize Revenue and Increase Profits Optimize Operational Costs and Working Capital

  40. Oracle's Cost Comparison Tool ( page 1 of 2 ) Discover Hidden Opportunities to Further Shrink Operations Costs • Process and Visualize Large Volumes of Data In Near Real-Time • Identify, view, analyze details of complex cost structures across multiple locations to drive timely corrective decisions • Fast data retrieval and processing driven by Exadata’s hierarchical data storage with Smart Scan, Smart Flash Cache, and Flash Write-Back • Visualization and near real-time data analyses driven by Exalytics’s in-memory solution optimized specifically to leverage components networked via a high-bandwidth, low-latency InfiniBand network

  41. Oracle's Cost Comparison Tool ( page 2 of 2 ) Discover Hidden Opportunities to Further Shrink Operations Costs • Identify the Most Profitable Cost Structures • Aggregate complete cost structure information from across extended business operations • Easily compare complex cost structures from multiple operating units • Propagate Savings Across the Enterprise • Easily identify best-profit options to drive cost efficiencies out to all operating units • Simulate Enterprise-wide Impact of Cost Changes • Simulate the business-wide impact of a cost change and its impact across all product lines

  42. TimesTen In-Memory

  43. TimesTen - In-Memory DB for Analytics & OLTP Full-featured relational database Stored all data in memory Optimized for both OLTP & OLAP Enterprise class reliability & availability Full SQL support Can directly link with application For microsecond query resp time

  44. M6-32 for TimesTen and Application in a box

  45. Persistent Store for TB TimesTen In-Mem DB nTB M6-32 Internal storage: 32 X 1.2TB SSDs M6-32 ZS3 storage: • 80TB, 768TB, 3456TB Raw Capacities 64 PCIeX8 slots for additional external storage Log Checkpoint nTB Log Log Checkpoint nTB

  46. High Performing for In-Memory DB Applications Local Group TimesTen network latency NUMA TimesTen TimesTen TimesTen TimesTen TimesTen TimesTen network Multi - Instance Scaling TT Direct Link TT Direct Link TT Direct Link TT Direct Link TT Direct Link TT Direct Link App App App App App App App TT Client LDOMs, Zones

  47. M6-32 – TimesTen App Flexible Scaling Scaling Up TimesTen TimesTen TT Direct Link TT Direct Link App App Scaling Out

  48. High Availability – Dual half-populated M6-32s ZS3 (RAIDZ1, RAIDZ-5 etc.) ZS3 (RAIDZ1, RAIDZ-5 etc.) Available for read Tx Logs Active TimesTen Hot Standby TimesTen Tx Logs Tx Logs Tx Logs Chkpt Chkpt Chkpt Chkpt Chkpt Chkpt Chkpt Chkpt TT Direct Link TT Direct Link IB IB App App IB IB Active or Standby App Active App Active TimesTen Active or Standby TimesTen replicate Oracle Clusterware Oracle Clusterware M6-32 half populated M6-32 half populated

  49. M6-32 Engineered for Enterprise Large DB with microsecond Resp Time

More Related