OracleDatabase12c-详细介绍

,OracleConfidentialInternal,2,OracleDatabaseUpdate,PennyAvrilVicePresidentDatabaseProductManagement,3,Gartner:Worldwide2013RDBMSVendorShare,OracleConfidentialDoNotDistribute,Source:Gartner:“MarketShare:AllSoftwareMarkets,Worldwide2013,”March28,2014,ByColleenGraham,JoanneCorreia,DavidCoyle,FabrizioBiscotti,MatthewCheung,RuggeroContu,YannaDharmasthira,TomEid,ChadEschinger,BiancaGranetto,HaiHongSwinehart,SharonMertz,ChrisPang,AsheeshRaina,DanSommer,BhavishSood,MarianneDAquila,LaurieWursterandJieZhang,ChoosingtheRightUpgradeTarget,OracleConfidentialInternal,5,SummaryofCustomerUpgradeExperience,QuotesfromReferenceCustomers,Go-livemigrationwasflawless.”BrianPawlik,technologymanager,PulteGroup“Ourexperiencewith12c.hasledustobelieveitisoneofthemoststablereleasesinthelast2decades.Havingbeenrunningaproductioncustomerfacing12csystemsinceGAwithnooutages,wecanattesttotherobustnessandreliabilityofthisrelease”JamesAnthony,TechnologyDirector,e-DBAOurexperiencewithupgradehasbeenverypositive,upgradingto12c,andwehavebeenveryimpressedwiththerobustnessof12c.-NickSalem,DistinguishedEngineer,Neustar,Inc.,6,PlaythePodcast!,ReleaseRoadmap,SustainingSupport,AUG2015,AUG2012,JAN2018,JAN2015,JUN2021,JUN2018,WaivedExtended,ExtendedSupport,PremierSupport,7,Today,OracleDatabase12cRelease2TargetedforRelease1HCY2016(MOSNote742060.1),ContinuousOracleDatabaseInnovations,PreservingcustomersinvestmentthougheachnewComputingEra,StoredProceduresPartitioningParallelQueryUnstructuredData,ResourceManagementRealApplicationClustersDataGuardXML,ExadataMultitenantIn-MemoryJSON,BigDatarecoveratpluggabledatabaseLevel,Public,21,Point-in-timerecoveryatpluggabledatabaselevel,MultitenancyimplementedbytheDatabase,nottheApplication,22,MultitenantforSoftwareasaService,Customer1,Customer2,Customer3,Customer4,Customer5,Customer6,Customer7,FastProvisioning,SnapshotClones,DatabaseasaServiceforDevelopment,23,DevelopmentContainer,OriginalPDB,CloneofPDB,SnapshotCloneofPDB,OracleMultitenantforDatabaseasaService,Differentservicelevelsfordifferentrequirements,24,RAC,DataGuard,RAC,Backups,TestandDevelopment,Production,MissionCritical,DevelopmentintheCloud,DatabaseasaServiceontheCloud,25,Developmentanddeploymentagility,DevelopmentOnPremise,DeliverDatabaseasaServiceviaaLifecycleApproach,1.PlanDatabaseOptionsSecure:Encryption-Network,Database,BackupHighlyAvailable:DataGuard,RACManaged:OracleBackups,Patches,UpgradesAllDatabaseTools:SQLLoader,DataPump,JDBC,OCI,EnterpriseManager,AnyThirdPartyToolsFullportability:On-premisetoCloud,01011011101010100101001001000010001010101101001011010011100001010010,011100001010001011011101010100101001001000010001010101101001011010101001010010010001,StorageStrategy,Usagebaseddatacompressionandtiering,1000010100100101001010110111000010,101010101110101001101011100001010001011011101010100101001001000010001010101101001011010011100001010010010100001001000010001010,101010101110101001101011100001010001011011,15XColumnarArchiveCompression,011101010100101000010001010101011100001010,101010101110101001101011100001010001011011101010100101001001000010001010101101001011010011100001010010010100001001000010001010101110011010,10100101001001000010001,1110010100100101001010110111011010,101010101110101001101011100001011101011001,Public,37,HeatMap,SmartCompression,AutomatedTiering,InDatabaseArchiving,NetworkCompression,AutomaticDataOptimization,Optimizedatastoragebasedonusage,Public,38,AutomaticDataOptimization,Simplifyingthelifecycleofdata,Anin-memoryheatmaptracksblockandsegmentaccessDataisperiodicallywrittentodiskInformationisaccessiblebyviewsorstoredproceduresUsescanattachpoliciestotablestocompressortierdatabasedonaccesstodataTablesorPartitionscanbemovedbetweencompressionlevelswhilstdataisstillbeingaccessed,Public,39,AutomaticDataOptimization,Compressdataoveritslifecycle,PartitionedByTime,OldestData,MostRecentData,NoCompression,AdvancedRowCompression,HybridColumnarQueryCompression,HybridColumnarArchiveCompression,3XCompressionOLTP,10XCompressionReporting,15XCompressionCompliance,Public,40,AutomaticDataOptimization,Addcompressionandtieringpoliciestotables,PartitionedByTime,OldestData,MostRecentData,Public,41,AutomaticDataOptimization,Aheatmaptrackstheactivityofsegmentsandblocks,PartitionedByTime,OldestData,MostRecentData,Public,42,AutomaticDataOptimization,Policiesareautomaticallyappliedtotables,PartitionedByTime,OldestData,MostRecentData,Public,43,AutomaticDataOptimization,Policiesareautomaticallyappliedtotables,PartitionedByTime,OldestData,MostRecentData,Public,44,AutomaticDataOptimization,Policiesareautomaticallyappliedtotables,PartitionedByTime,OldestData,MostRecentData,Public,45,AutomaticDataOptimization,Reducestoragefootprint,readcompresseddatafaster,PartitionedByTime,OldestData,MostRecentData,Public,46,AutomaticDataOptimization,Automaticallytierdatatolowercoststorage,PartitionedByTime,OldestData,MostRecentData,Tier1Storage,Tier2Storage,Public,47,MaximumAvailabilityArchitecture,DataGuardFarSync,DataGuardFastSync,GlobalDataServices,ActiveDataGuardReportingEnhancements,FlexASM,RollingUpgradeusingDataGuard,ApplicationContinuity,HighAvailability,GoldenGateIntegratedCapture,Public,49,OracleDatabase12cenhancements,ZeroDataLossChallenge,Trade-offbetweenZeroDataLossandPerformance,Thelongerthedistance,thelargertheperformanceimpact,Primary,Standby,Commit,CommitAck,NetworkSend,NetworkAck,Public,50,DataGuardFarSync,NoCompromiseBetweenAvailabilityandPerformance,Public,51,DataGuardFarSync,Standbybetweencontinentswithzerodataloss,FarSyncInstance(Idle),NewYork,Bridgeport,Reading,London,sync,async,Public,52,DatabasesinReplicatedEnvironments,Challenges,NoseamlesswaytoefficientlyuseallthedatabasesNoautomatedloadbalancingandfaulttolerance,Primary,ActiveStandby,ActiveStandby,GoldenGate,Public,53,GlobalDataServices,GlobalDataServices,LoadBalancingandServiceFailoverforReplicatedDatabases,ExtendsRAC-styleservicefailover,loadbalancing(withinandacrossdatacenters),andmanagementcapabilitiestoasetofreplicateddatabasesTakesintoaccountnetworklatency,replicationlag,andserviceplacementpoliciesAchievehigheravailability,improvedmanageabilityandmaximizeperformance,Public,54,Cross-PlatformBackupDropanalyticindexestospeedupOLTP,OracleIn-MemoryRequiresZeroApplicationChanges,FullFunctionality-NorestrictionsonSQLEasytoImplement-NomigrationofdataFullyCompatible-AllexistingapplicationsrununchangedFullyMultitenant-OracleIn-MemoryisCloudReady,UniquelyAchievesAllIn-MemoryBenefitsWithNoApplicationChanges,ApplicationDevelopmentOverTheYears,Changingdynamics,OLTPthroughputParallelQuery,Partitioning,86,BigData&Cloud,Internet,Client-Server,RethinkhowtodeliverITservices,Deliveragileinfrastructure,responsivetodevelopersFastprovisioningSchema-lessdatastoresOfferadditionalvalueIntegrationwithenterprisedataWhilemaintainingcoreITadvantagesCentralizedmanagementAdherencetosecurityguidelines,AlignITprioritieswithLOBbusinessgoals,NoSQLorRelational?,?,Schemasharedbymultipleapplications,Atomic,Consistent,Isolated,Durable,Inter-relatedcollectionsofdataobjects,RelationalDBMS,Oraclefor“NoSQL”,JSON,OracleDatabase12.1.0.2,FlexibleSchemadevelopment,JSON,JSON,ViaRESTfulservice,ViaNativeAPIs,DatapersistedindatabaseInJSON,SQL,DataanalyzedviaSQL,OracleDatabase12c,JSON,CustomerInitiatives,ThePowerofOracleSQL,forawidevarietyofBigDatatypes,92,StructureddataNumeric,string,date,RowandcolumnformatsUnstructureddataLOBsTextXMLJSONSpatialGraphMultimedia,EvolutionofBigDataAnalyticsintheEnterprise,93,SocialMedia,BigDataPlatform,DataAnalyticsChallenge,Separatesilosofinformationtoanalyze,94,DataAnalyticsChallenge,Separatedataaccessinterfaces,95,TablesonNoSQLSQLonHadoop,96,DataAnalyticsChallenge,NocomprehensiveSQLinterfaceacrossOracle,HadoopandNoSQL,97,Whatcustomerswant,Rich,comprehensiveSQLaccesstoallenterprisedata,98,NoSQL,WhatgivesExadataextremeperformance?,99,OracleDatabase12c,SQL,OffloadQuerytoExadataStorageServers,Smalldatasubsetquicklyreturned,Hadoop,IntroducingOracleBigDataSQL,100,MassivelyParallelSQLQueryacrossOracle,NoSQLandHadoop,OracleDatabase12c,OffloadQuerytoExadataStorageServers,Smalldatasubsetquicklyreturned,Hadoop,OffloadQuerytoDataNodes,SQL,datasubset,SQL,OracleBigDataManagementSystem,UnifyAllQuery,101,NoSQL,OracleBigDataManagementSystem,OracleConfidentialInternal/Restricted/HighlyRestricted,102,DataReservoir,DataWarehouse,BigDataAppliance+Hadoop,Scale-out,lowcoststoreCollectanydataMap-reduce,SQLAnalyticapplications,Exadata+OracleDatabase,Scale-outandscale-upCollectanydataSQLTransactionalandanalyticapplicationsfortheenterpriseSecureandhighlyavailable,Breakthrough:OracleBigDataSQL,Onefastquery,onallyourdata.,OracleSQLonHadoop,NoSQLandbeyond,withaSmartScanserviceasinExadataandthesecurityandcertaintyofOracleDatabase.,OracleBigDataSQLANewArchitecture,Powerful,high-performanceSQLonHadoopFullOracleSQLcapabilitiesonHadoopSQLqueryprocessinglocaltoHadoopnodesSimpledataintegrationofHadoopandOracleDatabaseSingleSQLpoint-of-entrytoaccessalldataScalablejoinsbetweenHadoopandRDBMSdataOptimizedhardwareHigh-speedInfinibandnetworkbetweenHadoopandExadata,OracleConfidentialInternal/Restricted/HighlyRestricted,104,IntroducingBigDataSQL,105,WEB_LOGS,BigDataSQLServer,HadoopCluster,CUSTOMERS,SmartScanHDFSdatanodesStorageIndexingCaching,ReadytoreaddatafromHcatalogHugereductionofdatamovementHighperformanceOracleSQL,AccessingBigData,WithoutSQLPushDown,106,HadoopCluster,WEB_LOGS,Lowutilizationofavailableresources,Highloadondatabaseserver,Selectw.sess_id,w.cust_id,w.page_idFromweb_logswWherew.source_country=BrazilAndw.catego