R语言案例DataMiningwithRORE.pptVIP

* 1) data volume: We use SQL and existing database functionality for the most part which is proven 2) heterogeneity - because of oracle database + BDA 3) Breadth of analytics - covers what we have in the database already + R packages 4) User community supported - R developers, SQL developers, BI report developers, DBAs for productionizing R code. * * * * * * * Copyright ? 2008, Oracle and/or its affiliates. All rights reserved. Insert Picture Here Data Mining with R/OREMinming Duan  * iTech Solution ProfileAgenda R/ORE Overview 1 XML output generation using SQL 4 Integration with IBP and BIEE 3 2 5 R vs. SPSS 6 FAQ Oracle R for Hadoop Connector Why analysts use R R is a statistics language similar to Base SAS or SPSS statistics. R environment is… ? Powerful ? Extensible ? Graphical ? Extensive statistics ? OOTB functionality with many ‘knobs’ but smart defaults ? Ease of installation and use ? Free Limitations of R R is a client and server bundled together as 1 executable - like Excel Single user tool Not multi-threaded Cannot leverage CPU capacity even on a users laptop/desktop R requires data it operates on to be first loaded into memory Loading data may not be a limitation given RAM available on laptops/desktops R’s call by value semantics means as data flows into functions, for each function invocation, many copies of the data are made As a result you quickly run into memory limits Why should you be interested in R? Emerging trends It’s the next “big thing” in advanced analytics Colleges and universities use R for statistics classes(replacing more traditional software tools) Advanced Analytics as a critical differentiator of the DWH technology stack Augment Oracle deployments Enhance results with powerful graphics Integrate R results and graphics with BI Publisher documents and OBIEE dashboards A scalable R via Oracle R Enterprise Leverage Oracle-engineered solutions A viable alternative to SAS/SPSS Rexer Analytics Survey 2011 Defaul