JD Edwards Summit Transform JD Edwards Applications with

Safe Harbor Statement The following is intended to outline our general product direction. It

Program Agenda 1 Oracle Database In-Memory: What’s the big deal? 2 What’s the big

Oracle Database In-Memory Option Powering the Real-Time Enterprise Available in Release 12. 1. 0.

Oracle Database In-Memory Goals Real Time Analytics 100 x Accelerate Mixed Workload OLTP No

Row Format Databases vs. Column Format Databases SALES Row § Query a single sales

Breakthrough: Dual Format Database Normal Buffer Cache New In-Memory Format SALES Row Format Column

Complex OLTP is Slowed by Analytic Indexes Table 1– 3 OLTP Indexes 10 –

Oracle In-Memory: Simple to Implement 1. Configure Memory Capacity • inmemory_size = XXX GB

Oracle In-Memory Requires Zero Application Changes Full Functionality Easy to Implement Fully Compatible Fully

Oracle Database In-Memory Goals Certified with Real Time Analytics JD Edwards Enterprise. One 9.

Oracle Database In-Memory Goals JD Edwards “Day. Real Time Analytics Enterprise. One Accelerate Mixed

Oracle Database In-Memory Goals Accelerate Mixed Workload OLTP 2 x Copyright © 2015, Oracle

Planned Oracle Database In-Memory Goals Accelerate Mixed Workload OLTP Node 1 HTML Avail Node

Ad-Hoc Queries § How do I find answers to unanticipated questions § What sales

Operational Analysis ‘Ad-Hoc Query’ with Oracle Database In-Memory From Batch to Real-Time § Query

Financial Close § Limited batch window results in false choices § Manual processes increase

Tools 9. 1. 5 and Apps ESU Real Time Financial Reconciliation with Oracle Database

Tools 9. 1. 5 and Apps ESU Real-Time Financial Reconciliation • Watch lists for

Tools 9. 1. 5 and Apps ESU Real-Time Financial Reconciliation Performance Old New X

Go-To-End § You need quick access to totals § Total supplier open amount §

Tools 9. 1. 5 and Apps ESU Real-Time Summarization with Oracle Database In-Memory From

Tools 9. 1. 5 and Apps ESU Real-Time Summarization Enabled in Key Applications §

Real-Time Summarization Performance Application X-Times Faster Supplier Ledger Inquiry 23. 1 Work with Forecasts

Frequently Asked Questions Q: What’s the difference between JD Edwards Enterprise. One In-Memory Applications

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Slides: 36

Download presentation

JD Edwards Summit Transform JD Edwards Applications with the Oracle Database 12 C In-Memory Option AJ Schifano JD Edwards Product Management Keith Sholes JD Edwards Product Management February 4, 2015 Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Safe Harbor Statement 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 decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle. Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Oracle Database In-Memory Option Powering the Real-Time Enterprise Available in Release 12. 1. 0. 2 Now

Oracle Database In-Memory Goals Real Time Analytics 100 x Accelerate Mixed Workload OLTP No Changes to Applications Trivial to Implement 2 x Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 7

Row Format Databases vs. Column Format Databases SALES Row § Query a single sales order in row format – One contiguous row accessed = FAST Query SALES Stores § Query a sales order in Column Format – Many column accessed = S L O W Column Query Until Now Must Choose One Format and Suffer Tradeoffs Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 8

Breakthrough: Dual Format Database Normal Buffer Cache New In-Memory Format SALES Row Format Column Format • BOTH row and column formats for same table • Simultaneously active and transactionally consistent • Analytics & reporting use new in-memory Column format • OLTP uses proven row format SALES Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 9

Complex OLTP is Slowed by Analytic Indexes Table 1– 3 OLTP Indexes 10 – 20 Analytic Indexes • Most Indexes in complex OLTP (e. g. ERP) databases are only used for analytic queries • Inserting one row into a table requires updating 10 -20 analytic indexes: Slow! • Indexes only speed up predictable queries & reports Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 10

Oracle In-Memory: Simple to Implement 1. Configure Memory Capacity • inmemory_size = XXX GB 2. Configure tables or partitions to be in memory • alter table | partition … inmemory; 3. Later drop analytic indexes to speed up OLTP Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 11

Oracle In-Memory Requires Zero Application Changes Full Functionality Easy to Implement Fully Compatible Fully Multitenant - ZERO restrictions on SQL - No migration of data - All existing applications run unchanged - Oracle In-Memory is Cloud Ready Uniquely Achieves All In-Memory Benefits With No Application Changes Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 12

Oracle Database In-Memory Goals Certified with Real Time Analytics JD Edwards Enterprise. One 9. 1. 4+ No. Tools Changes to Applications Linux and Solaris (other platforms planned) Trivial to Implement 1. Install Oracle Database 12. 1. 0. 2 2. Configure the Database In-Memory Option –inmemory_size = XXX GB –alter table | partition … inmemory; ALTER TABLE CRPDTA. F 0006 INMEMORY MEMCOMPRESS FOR QUERY DUPLICATE; ALTER TABLE CRPDTA. F 0911 INMEMORY MEMCOMPRESS FOR QUERY DUPLICATE; ALTER TABLE CRPDTA. F 4211 INMEMORY MEMCOMPRESS FOR QUERY DUPLICATE; … Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 15

Oracle Database In-Memory Goals JD Edwards “Day. Real Time Analytics Enterprise. One Accelerate Mixed in-the-Life” Benchmark kit run Workload OLTP with Applications 9. 1 / Tools 9. 1. 4. 4 with ZERO application changes. No Changes to Applications Trivial to Implement 1. Install JD Edwards Enterprise. One Applications 9. 1+ 2. Update to Tools 9. 1. 4. + Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 17

Planned Oracle Database In-Memory Goals Accelerate Mixed Workload OLTP Node 1 HTML Avail Node 2 Logic Avail JDE E 1 Apps 9. 1. 2 JDE E 1 IM-SA IM-PA JDE E 1 IM-PPA Prerelease JDE E 1 Tools Prerelease 2 x Node 1 JDE E 1 Data RAC Node 2 JDE E 1 Data JD Edwards Enterprise. One Logic and Web Tiers Exalogic X 3 -2 ¼ Rack Exadata X 3 -2 ¼ Rack Oracle Database 12. 1. 0. 2 with Database In-Memory Test Configuration Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 20

Ad-Hoc Queries § How do I find answers to unanticipated questions § What sales orders are assigned to a carrier that just went on strike? § What sales orders contained items from a recalled lot? § What sales orders involved an unscrupulous business partner? § 1000’s of use cases across all functional areas § Time-outs, batch jobs, exports, etc. Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Operational Analysis ‘Ad-Hoc Query’ with Oracle Database In-Memory From Batch to Real-Time § Query non-indexed columns in real- Real Time Analytics time No Changes to Applications § Find immediate answers to unanticipated questions § Eliminate batch jobs, data exports, third-party systems § Requires no change to JD Edwards 1762 x applications 104 million sales order lines From 22. 5 Min to Sub-second Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Financial Close § Limited batch window results in false choices § Manual processes increase errors and decrease efficiency § Long running batch jobs make it very time consuming to validate changes § Increased pressure to close the books faster s g n i h le t t y t n li a o m s So do… to e! it m Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Tools 9. 1. 5 and Apps ESU Real Time Financial Reconciliation with Oracle Database In-Memory From Batch to Real-Time § Batch financial integrities re-imagined as Real Time Analytics interactive applications § Watch lists provide real time visibility § No more PDF! Reduce time to resolve and increase quality by working exceptions interactively § Why wait till month end. . reconcile daily! 122 x § Faster re-organizations § Significantly reduce your time to close 120 Million Ledger Lines From 12 hours to 6 minutes Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Tools 9. 1. 5 and Apps ESU Real-Time Financial Reconciliation • Watch lists for notification • Interactive UI lists exceptions • Interactively work exceptions Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Tools 9. 1. 5 and Apps ESU Real-Time Financial Reconciliation Performance Old New X Times Faster 8. 1 minutes 5. 8 seconds 83 x Transactions to Account Master 2. 7 hours 51 seconds 190 x Account Balance w/out Account Master 1. 3 hours 17. 2 seconds 272 x Transactions to Batch Header 2. 9 hours 99 seconds 104 x Companies by Batch out of Balance 2 hours 63 seconds 117 x Batches out of Balance 2 hours 69 seconds 105 x 32. 1 minutes 38 seconds 50 x 11. 6 hours 5. 7 minutes 122 x Accounts to Business Units Companies out of Balance Cumulative 120 M Transactions… 10 M Account Balances… 10 M Accounts Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Go-To-End § You need quick access to totals § Total supplier open amount § Posted and un-posted G/L totals § Forecast totals by forecast type § Total quantity shipped by item § Spend by Supplier § Many apps show totals after the last grid row…go-to-end § Millions of rows to process…. slow § Time-outs, multiple queries, batch jobs Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Tools 9. 1. 5 and Apps ESU Real-Time Summarization with Oracle Database In-Memory From Batch to Real-Time § Click on summation icon for totals Real Time Analytics § No need for go-to-end! § Incredible response time § Balances by customer, line of business, and currency over 10 million invoice lines in 4 seconds 3500 x § Eliminate multiple queries, batch jobs, data exports 10 million invoice lines From 244 Min to 4 Secs Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Tools 9. 1. 5 and Apps ESU Real-Time Summarization Enabled in Key Applications § Customer Ledger Inquiry § Account Ledger by Category Code § Account Ledger by Object § Supplier Ledger Inquiry § Forecast Inquiry § Customer Service Inquiry § Purchase Order Inquiry Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

Real-Time Summarization Performance Application X-Times Faster Supplier Ledger Inquiry 23. 1 Work with Forecasts 2. 4 Purchase Order Inquiry 202. 4 Account Ledger Inquiry 13. 6 Account Ledger by Object 78. 4 Account Ledger By Category Code 13. 8 Customer Service Inquiry 57. 2 Customer Ledger Inquiry 2994. 3 Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

e n O e is r p r e t n E s d r a w for JD Ed Oracle Database In-Memory Goals˄ Real Time Analytics Accelerate Mixed Workload OLTP 100 x No Changes to Applications Trivial to Implement 2 x Copyright © 2015, Oracle and/or its affiliates. All rights reserved. 33

Frequently Asked Questions Q: What’s the difference between JD Edwards Enterprise. One In-Memory Applications and running JD Edwards Enterprise. One Applications with Oracle Database In-Memory? A: The 3 JD Edwards Enterprise. One In-Memory Applications are designed and certified to take advantage of the extreme performance of Oracle engineered systems: Exadata/Exalogic and Super. Cluster. All JD Edwards Enterprise. One applications can run with Oracle Database In-Memory. Q: Do the JD Edwards Enterprise. One In-Memory Applications still require Oracle engineered systems? A: Yes. Q: What use cases best demonstrate the benefit of Database In-Memory? A: Ad hoc query; “needle-in-the-haystack; ” searches over nonindexed fields; Analytics, not transactions Q: Do customers have to license anything extra to use Oracle Database In-Memory? A: Yes, Database In-Memory is an option of Oracle Database 12 c Enterprise Edition. Q: With which JD Edwards Enterprise. One releases can customers run Database In-Memory? A: Certified: Tools 9. 1. 4+ (Apps 9. 0 and 9. 1); Untested: Tools 8. 98. 3+ (Apps 9. 0) Q: If the database is “in memory” do customers need to buy lots more memory (RAM)? A: Lab testing shows that compression is very good. Customers should begin testing with current systems. Q: Is JD Edwards product development innovating to take advantage of Database In-Memory? A: Yes. Be watchful. Copyright © 2015, Oracle and/or its affiliates. All rights reserved.