Datenanalyse mit Oracle R Enterprise (ORE) for Beginners Dr. Nadine Schöne Systemberaterin DOAG2015 19. November 2015 Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Steckbrief OD Presales bei Oracle in Potsdam seit 2,5 Jahren Middleware, insbesondere: • Mobile • Cloud • Java Datenbank: Oracle R Enterprise (Datenanalysen) Hintergrund Naturwissenschaftlerin (Biologie, Mathematik, Bioinformatik) @schoenenadine Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 3 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. | 4 Was ist ORE? 5 Analytics Tools Analytics OOB Applications Industry Analytic Data Models Industry Analytic Applications Many Industry Data Models (Retail, Telecom, Airlines, etc.) Many Industry Applications (DataRaker, Tekelec, etc.) Oracle Business Activity Monitoring Oracle Stream Explorer Business Process Analytic Applications Information Access and Analysis Tools Oracle Big Data Discovery Oracle Advanced Analytics Many Business Applications (Eloqua, Taleo, Responsys, etc.) Oracle Business Intelligence Oracle Spatial and Graph Batch Data Processing Fast Data Processing Oracle Big Data SQL Data Warehouse Data Repository Continuous Real-Time Analytics Oracle Exadata Oracle Big Data Appliance Data Integration and Governance Oracle Data Integration and Governance Data Performance Data Transactional Data Attitudinal Data Oracle SaaS (ERP, CRM, HCM) Descriptive Data Behavioral Data Oracle BlueKai Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Interactional Data Oracle Datalogix 6 Analytics Tools Analytics OOB Applications Industry Analytic Data Models Industry Analytic Applications Business Process Analytic Applications Information Access and Analysis Tools Oracle Advanced Analytics Batch Data Processing Fast Data Processing Data Warehouse Data Repository Continuous Real-Time Analytics Data Integration and Governance Data Performance Data Transactional Data Attitudinal Data Descriptive Data Behavioral Data Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Interactional Data 7 Datenbankoption: Advanced Analytics Oracle Data Miner Oracle R Enterprise Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | „Collaborative Execution“-Modell 1 User R Engine (Dektop) 3 R Engine(s) verwaltet durch Oracle DB 2 Datenbank Compute Engine Oracle DB SQL R Engine andere R-Packages Oracle R Enterprise Packages Post-Processing der Ergebnisse Ergebnisse User-Tabellen R Engine R Ergebnisse Ausführung in Collaboration mit der Oracle DB andere R-Packages Oracle R Enterprise Packages Analysen, die in der Oracle DB nicht verfügbar sind Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Demo 12 Weitere Informationen 13 Sensordaten-Analyse I 200.000 Haushalte 5.256 Mrd. Messwerte (2.628 Messwerte/Kunde) 1 Messung/Stunde 3 Jahre Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 14 Sensordaten-Analyse II 200.000 Haushalte ➔ 200.000 Modelle Oracle R Enterprise 10 s/Modell 23 Tage + 4 Stunden 4,3 Stunden Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 15 “R is a powerful and interesting tool for data analysis! ORE brings R into a scalable DB engine (solving problems of data management, analysis and scalability). We actually can obtain information and added value from not so actively used data.” – Stefano Alberto Russo, Researcher at CERN Openlab Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 16 Für R Community frei verfügbar! Beta Version noch in 2015: FastR => Beta Tester gesucht! Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | https://www.r-consortium.org/ Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal 18 DB EE Option: Advanced Analytics http://www.oracle.com/technetwork/database/options/advanced-analytics/index.html Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – 19 https://cloud.oracle.com/bigdatapreparation Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | 20 Kontakt Dr. Nadine Schöne| Systemberaterin Email: [email protected] Tel: +49 331 200 7190 ORACLE Deutschland B.V. & Co. KG Schiffbauergasse 14 14467 Potsdam Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |