transforming data management -...
TRANSCRIPT
![Page 1: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/1.jpg)
![Page 2: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/2.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
TransformingDataManagementwithOracleDatabase12cRelease2
![Page 3: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/3.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
SafeHarborStatementThefollowingisintendedtooutlineourgeneralproductdirecIon.ItisintendedforinformaIonpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfuncIonality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andImingofanyfeaturesorfuncIonalitydescribedforOracle’sproductsremainsatthesolediscreIonofOracle.
3
![Page 4: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/4.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
• Availablenow– ExadataExpressCloudService– EnterpriseCloudService– ExadataCloudService• AvailableDecember– ExadataCloudMachine
4
OracleDatabase12cRelease2onOracleCloud
![Page 5: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/5.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
TransformingDataManagement
Ø FromDisk-basedtoIn-MemoryDatabases
Ø FromDataWarehousetoBigDataØ FromOn-PremtoDatabaseOpImizedCloud
5
Whilepreservingcustomer’sinvestments
![Page 6: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/6.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
TransformingDataManagement
Ø FromDisk-basedtoIn-MemoryDatabases
Ø FromDataWarehousetoBigDataØ FromOn-PremtoDatabaseOpImizedCloud
6
Whilepreservingcustomer’sinvestments
![Page 7: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/7.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
In-MemoryDatabases
FromDisk-Based
• OpImizedfordiskI/O• Rowformat• BuffercacheinDRAMplusdiskstorage
ToIn-MemoryDatabases
• OpImizedformemoryaccess• Dualrow/columnformat• IntegratedDRAM,FlashandNVRAMstorage
7
![Page 8: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/8.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
CostofmemoryconInuestodecrease
8
Demandforreal-ImeanalyIcsconInuestoincrease
Non-volaIlememoryindevelopment
EvoluIonofIn-Memory
![Page 9: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/9.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.| 9
In-MemorywithOracleDatabase12cRealTimeAnaly?cs Performance SimpletoImplement
OLTP&AnalyIcsonsamedatabase Sub-secondreporIng&analyIcs NoapplicaIonchanges
![Page 10: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/10.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
• Real-ImeanalyIcswithnoimpactonproducIondatabase• MakeproducIveuseofstandbydatabaseresources• CanpopulatewithdifferentdatafromproducIondatabase
10
Newin12.2onOracleCloudIn-MemoryrunsonAcIveDataGuardstandby
MonthIn-Memory
ProducIon Standby
YearIn-Memory
![Page 11: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/11.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
• Upto3Xfasterjoins– Usingin-memoryjoingroups
• Upto10Xfastercomplexqueries– Usingin-memoryexpressions
• Upto60XfasterJSONqueries– UsingnewopImizedbinaryformat
11
Newin12.2onOracleCloudPerformanceEnhancements
{! "Theater":"AMC 15",! "Movie":”SULLY",! "Time“:2016-09-09T18:45:00",! "Tickets":{! "Adults":2! }! }!
RelaIonal Virtual JSON
In-MemoryColumnStore
![Page 12: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/12.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
• In-MemoryformatnowusedinSmartColumnarFlashCache
• Enablesin-memoryopImizaIonsondatainExadataFlashCache
• In-memoryperformanceseamlesslyextendedfromserverDRAMmemoryto10xlargerflashinstorage
12
Newin12.2onOracleCloudIn-MemoryColumnFormatinExadataFlashCache
In-MemoryColumnarscans
In-FlashColumnarscans
![Page 13: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/13.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
TheCustomer’sViewv
OracleDatabaseIn-Memory
![Page 14: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/14.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
![Page 15: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/15.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
TransformingDataManagement
Ø FromDisk-basedtoIn-MemoryDatabases
Ø FromDataWarehousetoBigDataØ FromOn-PremtoDatabaseOpImizedCloud
16
Whilepreservingcustomer’sinvestments
![Page 16: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/16.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
TransformingtoBigData
FromDataWarehouse
• RelaIonal– On-Premises
• TransacIonaldata• AnalyIcs+DataMining
ToBigData
• RelaIonal+HadoopandNoSQL– On-Premises+Cloud
• TransacIonal+Social,WebandIoT• AnalyIcs+DataMining+MachineLearning
17
![Page 17: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/17.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.| 18
DataWarehouseEvoluIon
Transac?onal
DataWarehouse
SQL
Social,Web
DataLake
IoT
FastData
![Page 18: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/18.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.| 19
OracleBigDataPlajorm
Dataofanytype
Anydatasource
AnalysisofanytypeSQL GraphSpark SpaIal MachineLearning
SQLAccesswithanylanguage
node.jsJavaREST Python ScalaR
![Page 19: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/19.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
FastSQLaccessforRelaIonal,HadoopandNoSQL
• UnifiedSQLlanguageforalldatasources– WithfullpowerofOracleSQL
• Massivelyparallel,distributedqueryprocessing– Localprocessingusing‘SmartScan’technology– Scalablejoinsbetweendatasources
• Securedataaccess– RedacIonandrow-basedsecurityonalldatasources
20
UsingOracleBigDataSQL
BigDataSQL
![Page 20: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/20.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
BigDataSQL
FastSQLaccessforRelaIonal,HadoopandNoSQL
• IntuiIveSQLsyntaxoverJSON SELECT c.json_column.address.city FROM customers c;
• UseJSONdatainanySQLquery– JoinJSONwithanyotherdatasource– ApplyanySQLanalyIcstoJSON
• NewinBigDataSQLonOracleCloud– DataGuide:AutomaIcallyunderstandJSONstructure
21
UsingOracleBigDataSQLonJSONdata
![Page 21: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/21.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
MachineLearning• Massively-scalableRprocessing
• In-DatabaseandSparkalgorithms
• EnhancesandextendsSparkML
Graph• Massively-scalableGraphDatabase
• 40+in-memoryparallelalgorithms
• Simplestandardinterfaces
22
Spa?al• Massively-scalableVectorandRasterprocessing:50+funcIons
• SpaIaldataenrichment,filtering,andcategorizaIon
Mul?-media• Massively-scalableopenframeworkforimageandvideoprocessing
• Use-cases:facerecogniIon;OCR;licenseplaterecogniIon
ComprehensiveDataScienceCapabiliIesAnyanalysisacrossrelaIonal,HadoopandNoSQL
![Page 22: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/22.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
TheCustomer’sViewv
OracleBigData
![Page 23: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/23.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
![Page 24: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/24.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
BigDataCloudService
• BigDataCloudServiceincludes:– ClouderaEnterpriseDataHub– EmbeddedanalyIcsincludingRandPropertyGraphanalyIcs– EmbeddeddataintegraIontools
• Startwith3-nodecluster,scalesto100’sofnodes• BigDataSQLCloudServicecomingsoon
26
Comprehensive,high-performanceserviceforHadoop,Spark,andNoSQL
![Page 25: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/25.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
TransformingDataManagement
Ø FromDisk-basedtoIn-MemoryDatabases
Ø FromDataWarehousetoBigDataØ FromOn-PremtoDatabaseOp?mizedCloud
27
Whilepreservingcustomer’sinvestments
![Page 26: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/26.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
Exadata SuperCluster
BigDataAppliance
RecoveryAppliance
DatabaseAppliance
EngineeredSystemsforDataManagementStartyourjourneytothecloudwithdatabase-opImizedinfrastructure
![Page 27: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/27.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
• LowerCosts– Managemanydatabasesas-one
• Agility– Rapidprovisioning,cloning,movement
• ElasIcScaling– Scale-up,scale-outandscale-down
29
TransformingtoDatabase-OpImizedCloud
![Page 28: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/28.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
LoweringCosts
FromOn-Prem
• Payup-front– forpeakcapacity
• Manualdeploymentandupgrade• HighoperaIonalcost– ManageManyDatabases
ToDatabase-Op?mizedCloud
• Payasyougo– forcapacityon-demand
• Self-servicedeploymentandupgrade• LowoperaIonalcost– ManageMany-as-One
30
![Page 29: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/29.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
• VirtualizedatabasesintoContainerDatabase– ApplicaIonsrununchanged
• LowerOperaIonalExpenses– ManagemanyPluggableDatabasesasone
• LowerCapitalExpenses– MorePluggableDatabasesperserver
• MoreAgile– Fastprovisioning,movementandcloning
31
OracleDatabase12cMulItenantArchitecture
ERP CRM
DW
ContainerDatabase
![Page 30: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/30.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
• Upto4,096PDBspercontainer• Memory,CPUandI/OresourceprioriIzaIon• ConfigurableisolaIonbetweenprivateandpublicclouds
32
Newin12.2onOracleCloudGreaterConsolidaIonandIsolaIonatScale
Retail
Pricing
ContainerDatabase
![Page 31: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/31.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
• PDBsshareapplicaIonobjects– Code,metadataanddata
• Furthersimplifiesmanagement– ManagetenantapplicaIonsasone
• SuitableformanyapplicaIons– SaaS,franchise,divisional,etc.
Newin12.2onOracleCloudConsolidaIonwithApplicaIonContainers
33
![Page 32: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/32.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
Agility
FromOn-Prem
• ManualdatabaseconfiguraIon– DesignHW/SWstackfromscratch
• Monthstodeploy,upgrade• Singletenantdatabases
ToDatabase-Op?mizedCloud
• Self-servicedatabaseprovisioning– ChoosefromlistofCloudservices
• Minutestodeploy,upgrade• MulItenantcontainerdatabases– HotcloningandrelocatePDBs
34
![Page 33: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/33.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
• PDBHotClone– FastertestmasterinstanIaIon
• PDBRefresh– SimpleoperaIonforlatestdata
• PDBRelocate– RelocatewithnodownIme
35
Newin12.2onOracleCloudOnlinePDBOperaIons
35
CRM
HR
OracleCloud
Pricing Retail
On-Premises
CRM
![Page 34: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/34.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
TheCustomer’sViewv
Mul?tenantonOracleCloud
![Page 35: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/35.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
![Page 36: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/36.jpg)
Copyright©2016Oracleand/oritsaffiliates.Allrightsreserved.
ElasIcScaling
FromOn-Prem
• Manualscale-upofsingleserversandscale-outRACclusters– WithnobursIng
• Provisionforpeak-demand• Massivescalability&reliability– Manualdatabasesharding
ToDatabase-Op?mizedCloud
• Self-servicescale-upofsingleserversandscale-outRACclusters– WithbursIng
• Provisioncapacityon-demand• Massivescalability&reliability– Automateddatabasesharding
39
![Page 37: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/37.jpg)
Copyright©2016Oracleand/oritsaffiliates.Allrightsreserved.
Uniquescale-outandfaulttolerancewithOracleRACNoapplicaIonchangesrequired
• Protectsdatabasesfromserverfailure• Scale-outdatabaseperformance– WithbursIngasrequired
• Supportstheworld’slargestOLTPandDataWarehouseworkloads• Newin12.2onOracleCloud– OpImizedformulItenantdatabases– Scale-outtohundredsofnodes
40
![Page 38: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/38.jpg)
Copyright©2016Oracleand/oritsaffiliates.Allrightsreserved.
Newin12.2onOracleCloud
41
NaIveDatabaseShardingformassivescalabilityandreliabilityforOLTPapplicaIons
OnegiantdatabaseparIIonedintomanysmalldatabases(shards)
CustomersAmericas
Customers
CustomersEurope
CustomersAsia
• RACandDataGuardmeetneedsofover99%ofapplicaIonswhilepreservingapplicaIontransparency
• SomeGlobal-ScaleOLTPapplicaIonsprefertoshardmassivedatabasesintoafarmofsmallerdatabases
• RequiresdesigningapplicaIonssothatworkloadsareautomaIcallyroutedtospecificshardsinthefarm
• SQLforshardedtablesacrossupto1000Shards
![Page 39: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/39.jpg)
Copyright©2016Oracleand/oritsaffiliates.Allrightsreserved.
OracleExadataCloudService#1databaseononlycloudinfrastructureopImizedfordatabase• OracleDatabasewithallopIons• OnfastestandmostreliableDatabaseCloudPlajorm– Scale-OutCompute,Scale-OutIntelligentStorage,ElasIcExpansion– CompleteIsolaIonoftenantswithnooverprovisioning
• AllbenefitsofPublicCloud– Fullymanagedinfrastructure– Rapid,elasIc,databaseprovisioning– NoCapExwithpay-perusesubscripIon
42
![Page 40: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/40.jpg)
Copyright©2016Oracleand/oritsaffiliates.Allrightsreserved.
Pay-as-you-goExadataCloudServiceMonthlysubscripIonratesandburstOCPUsondemand
43
Month1 Month2 Month3 Month4
Burst16OCPUsasrequired
OCP
Us
032
24
16
8
EndofQuarter
![Page 41: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/41.jpg)
Copyright©2016Oracleand/oritsaffiliates.Allrightsreserved.
100%CompaIbleHybridCloudGracefulco-existenceandmigraIonbetweenprivateandpublicclouds
45
OracleCloudSameArchitectureSameSoTwareSameSkills
SameSupport
Automatedmovementofapplica?ons&databetweenon-premises&publiccloud
On-Premises
![Page 42: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/42.jpg)
Copyright©2016Oracleand/oritsaffiliates.Allrightsreserved.
Oracle‘CloudatCustomer’Helpsconformtobusinessandgovernmentsecurityandcompliancerequirements
• SamePaaSandIaaShardwareandsoswareasOraclePublicCloud• ManagedbyOracleanddeliveredasaservicebehindyourfirewall• Samecost-effecIvesubscripIonpricingmodelasOracleCloud
46
IaaS BigData
Database
![Page 43: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/43.jpg)
Copyright©2016Oracleand/oritsaffiliates.Allrightsreserved.
CustomerDataCenter
Purchased
CustomerManaged
47
ChoiceofExadataDeploymentModels
ExadataDatabaseMachine
CustomerDataCenter
SubscripIon
OracleManaged
ExadataCloudMachine
OracleCloud
SubscripIon
OracleManaged
ExadataCloudService
![Page 44: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/44.jpg)
Copyright©2016Oracleand/oritsaffiliates.Allrightsreserved.
IntroducingExadataExpressCloudService
§ #1Database,includingopIons,onExadata§ FullymanagedbyOracle§ Lowcost,starIngat$175permonth
48
Simpletouse,lowestcostDatabaseCloudService,running12.2
![Page 45: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/45.jpg)
Copyright©2016Oracleand/oritsaffiliates.Allrightsreserved.
• ApplicaIondevelopment• TesIngandqualityassurance• Short-term,ImesensiIveprojects• AnalyIcsandsandboxes• ProducIondepartmentalworkloads
49
UseCases:ExadataExpressCloudService
![Page 46: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/46.jpg)
Copyright©2016Oracleand/oritsaffiliates.Allrightsreserved.
• Allpopularlanguagessupported• Fulldatabasesupportfor– JSON– Rest• Developmenttoolsincluded– ApplicaIonExpress– SQLDeveloper
50
DevelopmentontheOracleCloud
andmore…
![Page 47: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/47.jpg)
Copyright©2016Oracleand/oritsaffiliates.Allrightsreserved.
OracleApplicaIonExpress(APEX)CompleteApplicaIonPlajormasaService(aPaaS)
51
Develop Customize DeployProvision
IncludedwithALLOracleDatabaseediIonsandCloudServices
100%compaIbilitybetweenon-premisesandOracleCloud
• RADbrowserbasedtool• Createandmanagedatabaseobjects• RobustvisualizaIoncomponents• 300K+developers,100’sofpartners
![Page 48: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/48.jpg)
Copyright©2016Oracleand/oritsaffiliates.Allrightsreserved.
ProducIvityAppsincludedinAPEX
52
andmore…
![Page 49: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/49.jpg)
Copyright©2016Oracleand/oritsaffiliates.Allrightsreserved.
DatabaseDevelopment
SpectrumofOracleDatabaseCloudServices
53
Scalefromentry-leveltothelargestmissioncriIcaldatabaseworkloads
ExadataEnterpriseExadataExpress
Highestavailability,scalabilityandperformance
SMB&DepartmentalApplicaIons
EnterpriseApplicaIons
![Page 50: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/50.jpg)
Copyright©2016Oracleand/oritsaffiliates.Allrightsreserved.
TransformingDataManagement
Ø FromDisk-basedtoIn-MemoryDatabases
Ø FromDataWarehousetoBigData
Ø FromOn-PremtoDatabaseOpImizedCloud
54
Whilepreservingcustomer’sinvestments
![Page 51: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/51.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.|
SafeHarborStatementTheprecedingisintendedtooutlineourgeneralproductdirecIon.ItisintendedforinformaIonpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfuncIonality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andImingofanyfeaturesorfuncIonalitydescribedforOracle’sproductsremainsatthesolediscreIonofOracle.
55
![Page 52: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/52.jpg)
Copyright©2016,Oracleand/oritsaffiliates.Allrightsreserved.| 56
![Page 53: Transforming Data Management - NYOUGnyoug.org/wp-content/uploads/2016/12/TransformingDataManagem… · Machine Learning • Massively-scalable R processing ... New in 12.2 on Oracle](https://reader036.vdocuments.us/reader036/viewer/2022081522/5f01fda87e708231d4020937/html5/thumbnails/53.jpg)