Oracle Advanced Analytics 概要

  • Published on
    14-Apr-2017

  • View
    66

  • Download
    1

Transcript

Oracle Advanced Analytics 2017330

Copyright 2017 Oracle and/or its affiliates. All rights reserved.

Copyright 2017 Oracle and/or its affiliates. All rights reserved.

OracleJavaOracle Corporation

2

Copyright 2017 Oracle and/or its affiliates. All rights reserved.3

Copyright 2017 Oracle and/or its affiliates. All rights reserved. BI Business Analytics 4VALUEDIFFICULTINFORMATIONOPTIMIZATIONDescriptive AnalyticsDiagnostic AnalyticsPredictive AnalyticsPrescriptive Analytics BIBusiness Analytics

Copyright 2017 Oracle and/or its affiliates. All rights reserved.- - -(Web)- - -What-If- - -

5DiscoveryBI(OLAP)Oracle BIEnterprise Edition (BIEE)Oracle EndecaOracle Advanced Analytics

Copyright 2017 Oracle and/or its affiliates. All rights reserved.6

AI

https://ja.wikipedia.org/wiki/

Copyright 2017 Oracle and/or its affiliates. All rights reserved.Python

6

7

Copyright 2017 Oracle and/or its affiliates. All rights reserved.

7

8

SVM

Copyright 2017 Oracle and/or its affiliates. All rights reserved.

8

9

=5,000

X=No

X=No

IF ( >= 5000 AND = ) THEN X = Yes

Prob = 0.77Support = 0.250

ID1013110,000No102425,000Yes10336200No104433,000No105227,000Yes

ID314404,000No315265,500Yes

X=Yes

Copyright 2017 Oracle and/or its affiliates. All rights reserved.10

One-to-one

Copyright 2017 Oracle and/or its affiliates. All rights reserved.

10

11

100%

0%

20%

50%

20%

70%

50%

ROI100%

Copyright 2017 Oracle and/or its affiliates. All rights reserved.

100%0%

20

75

250

POSetc.100%8

Copyright 2017 Oracle and/or its affiliates. All rights reserved.

12

PDCACRISP-DM13

CRISP-DM (Cross-Industry Standard Process for Data Mining)

Copyright 2017 Oracle and/or its affiliates. All rights reserved.CRoss-Industry Standard Process for Data Mining13

PDCACRISP-DM14CRISP-DM (Cross-Industry Standard Process for Data Mining)

Copyright 2017 Oracle and/or its affiliates. All rights reserved.15

Copyright 2017 Oracle and/or its affiliates. All rights reserved.

Oracle Database Enterprise Edition Advanced Analytics Oracle Data Mining

12Oracle Data Miner (SQL Developer) GUIPL/SQL API Java API ExadataOracle Advanced Analytics

Oracle R Enterprise

ROBIEER (CRAN)

16

Copyright 2017 Oracle and/or its affiliates. All rights reserved.2DB

DBIn-Database Analytics

16

Oracle SQL1719981999200220052008

200420112015

Darwin+SQL, 7, GUIGUI Oracle Data Miner Classic3(EM, PCA, SVD)SQLDEV/Oracle Data Miner 4.0 SQL+SQLROAA/ORE 1.3 + 1.4 RHadoopOracle R Advanced Analytics for Hadoop (NB, AR) Java API (ADP),SQL DeveloperOracle Data Miner 3.2 Oracle R EnterpriseOracle DatabaseR Oracle Advanced Analytics (ODM + ORE)

Copyright 2017 Oracle and/or its affiliates. All rights reserved.Over the years, Oracle has increasingly invested in making the database and SQL more powerful.17

BIEEBICSOracle Database Enterprise EditionOracle Advanced Analytics 18Advanced Analytics SQLRSQL Developer

HCMCRM

R Client

R

Copyright 2017 Oracle and/or its affiliates. All rights reserved.OAA, as I have stated, IS the Oracle Database. Separately licensed as the OAA Database Option, but OAA provides native SQL and PL/SQL data mining and advanced analytics functions plus integration with R to provide scalable in-database execution.

Users can access OAA via four main access points. First, the Oracle Data Miner GUI provides simple drag and drop access for business analysts. R developers can use the R console or RStudio to write R scripts that get trapped, transparently converted by OAA to SQL and then executed inside the Database.

Business users and application users can access OAAs insights and predictions via OBIEE and Applications. More detail in the coming slides.

18

19Advanced Analytics

Data Mining

Copyright 2017 Oracle and/or its affiliates. All rights reserved.Oracle Data Mining20

DBPL/SQL APIJava API

Oracle Data Miner (GUI)

Copyright 2017 Oracle and/or its affiliates. All rights reserved.

20

Oracle Data Mining 21

ODMRSYS Data Miner USERS /

Data Mining XML DB Scheduler Text

SQL DeveloperData Miner SQL, PL/SQL

Copyright 2017 Oracle and/or its affiliates. All rights reserved.

Oracle Data Miner GUIGUI SQL ETL

&

Copyright 2017 Oracle and/or its affiliates. All rights reserved.In-Database Data Mining 23Logistic Regression (GLM)Decision TreesNave Bayes Support Vector Machines (SVM)Linear Regression (GLM)Support Vector Machine (SVM)One Class SVMMinimum Description Length (MDL)Principal Components Analysis (PCA)Apriori / NBO(Next Best Offer)Hierarchical k-MeansHierarchical O-ClusterExpectation-Maximization Clustering (EM)/ -Nonnegative Matrix Factorization (NMF)Singular Value Decomposition (SVD) /

A1 A2 A3 A4 A5 A6 A7

F1 F2 F3 F4

Copyright 2017 Oracle and/or its affiliates. All rights reserved.

23

24Advanced Analytics

R Enterprise

Copyright 2017 Oracle and/or its affiliates. All rights reserved.R25

Copyright 2017 Oracle and/or its affiliates. All rights reserved.Oracle R Enterprise26ROracle/ViewRR

RR

DB

R

Copyright 2017 Oracle and/or its affiliates. All rights reserved.

27R Oracle Database Oracle R Enterprise ROracle DatabaseDBDBRR EngineR Engine R Engine

Other R packagesRDBOracle R Enterprise packagesDBRR

ROracle Database

RR

RSQLPL/SQLR

Oracle Database

RSQLOracle DatabaseOracle Database

DB R Engine

Other R packagesOracle R Enterprise packages

Copyright 2017 Oracle and/or its affiliates. All rights reserved.

DBDBR

DBR

27

OREOSS R401

28

Copyright 2017 Oracle and/or its affiliates. All rights reserved.ORE 29library(ORE)ORE ore.connect( user="ore_user", sid="orcl", host="192.168.56.101", password="oracle", port=1521, all=TRUE)ore.ls() R

Copyright 2017 Oracle and/or its affiliates. All rights reserved.30model

Recommended

View more >