數(shù)據(jù)庫12cr2概覽教程

SafeHarborThefollowingisintendedtooutlineourgeneralproductdirection.Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.ItisnotacommitmenttoSafeHarborThefollowingisintendedtooutlineourgeneralproductdirection.Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedforOracle’sproductsremainsatthesolediscretionofOracle.Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.OracleDatabase12cRelease2OracleDatabase12cRelease2已已經(jīng)可ExadataExpressCloudServiceDatabaseCloudServicesExadataCloudMachine–ExadataOn-PremisesDBCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.6OracleDatabase12cRelease2?–––OracleDatabase12cRelease2?–––敏捷：在線克隆，刷新和在線SaaS應(yīng)用容器?內(nèi)存列格式能在ActiveDataGuard中使提升性能（比12.1最多快60倍?Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.8Oracle5,6,7,Oracle8i,9i,Oracle11g,可擴(kuò)展RowLevelLocking,B-treeSharedCursors,SharedServerRealApplicationAutomaticStorageManagement,IOTsExadata,SmartOracle5,6,7,Oracle8i,9i,Oracle11g,可擴(kuò)展RowLevelLocking,B-treeSharedCursors,SharedServerRealApplicationAutomaticStorageManagement,IOTsExadata,SmartFlash,In-MemoryNativeDatabase高可用Transactions,RefIntegrity,Backup,Point-in-TimeDataGuard(Active),RecoveryFlashback,Clusterware,OnlineDDL,ZeroDataLossRecoveryAppliance,BasedRedefinition,App.數(shù)據(jù)分Partitions,ParallelSQL,AnalyticFunction,DataMining,OLAP,SQLPatternMatch,R,BigData安Privileges,Roles,Auditing,Encryption,DataEncrypt,Masking,VirtualPrivateDB,Security,DBVault,AuditVault,RealApplicationSecurity,DB開發(fā)人SQL,Views,PL/SQL,Triggers,JavainDB,NativeXML,TableFunctions,PHP,AppExpress,SQLNativeJSON,RESTServices,管EnterpriseManager,v$,waitMultitenant,DB&ExaCloud,DB集DBLinks,2PC,Replication,GoldenGate,XATransaction,ExternalBigDataSQL,BigDataCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.OracleDatabase12c???數(shù)據(jù)庫OracleDatabase12c???數(shù)據(jù)庫ADO??數(shù)據(jù)自DataGuardFar?遠(yuǎn)距離，零數(shù)Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.OracleDatabase12c?失敗事??動態(tài)遮蓋應(yīng)OracleDatabase12c?失敗事??動態(tài)遮蓋應(yīng)用對應(yīng)用?復(fù)雜的行間模500項(xiàng)改進(jìn)Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.OracleDatabase12cOracleDatabaseIn-???OracleDatabase12cOracleDatabaseIn-???JSON???通過RESTfulAPI訪BigData??運(yùn)行在Hadoop上的高性O(shè)racleHadoop數(shù)據(jù)集Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.OracleDatabase12c????OracleDatabase12c????近似統(tǒng)?一個(gè)快速和高效打補(bǔ)丁的中心??FIPS140支OracleKeyCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.OracleDatabase12cRelease主要特OracleDatabase12cRelease主要特MassiveCostSavingsandCloudAgilitywithwithDatabaseIn-MassiveWebwithCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.OracleDatabase12cCPU和OracleDatabase12cCPU和I/O隔快速供應(yīng)和克可插拔在線租應(yīng)用無4,096個(gè)Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.OracleDatabase12cIn-亞秒級報(bào)OracleDatabase12cIn-亞秒級報(bào)表和分析性能OLTP和分析型應(yīng) 把分析任務(wù)卸載到ActiveDataGuard備庫亞秒級報(bào)表和分析性3x速度提升連接，10x速度提升表達(dá)式，60x速度提升JSON應(yīng)用無無內(nèi)存大小限Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.……水平分區(qū)多達(dá)1000個(gè)……水平分區(qū)多達(dá)1000個(gè)分在線分割和重分片可運(yùn)行不同數(shù)據(jù)庫Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.多租戶4PDB，熱克隆/遷移/多租戶4PDB，熱克隆/遷移/Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.12.1多合一CPU和I/O12.1多合一CPU和I/O隔快速供應(yīng)和克可插拔SaaS部署的架應(yīng)用無Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.PDB云環(huán)CRMCRMPDBPDB云環(huán)CRMCRMPDB在線的進(jìn)行PDB數(shù)據(jù)庫的克隆，用HotCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.PDB云環(huán)CRMCRMPDB在線的進(jìn)行PDB數(shù)據(jù)庫的克隆，用PDB云環(huán)CRMCRMPDB在線的進(jìn)行PDB數(shù)據(jù)庫的克隆，用PDBClonedversionnolongerinOnlychangescopiedandChangesmadetoCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.PDBPDB在線的進(jìn)行PDB數(shù)據(jù)庫的克隆，用PDBPDBPDBPDB在線的進(jìn)行PDB數(shù)據(jù)庫的克隆，用PDBPDB云環(huán)Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.ApplicationPDBsApplicationPDBs(foreachApplicationSeed(forPDBs進(jìn)一步簡化管–應(yīng)用程序容器里的所有–SaaSCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.???PDB每個(gè)PDB每個(gè)CDB支持的PDB???PDB每個(gè)PDB每個(gè)CDB支持的PDB252增加到4096個(gè)可以在PDB級別收集AWRDataGuardBroker實(shí)現(xiàn)PDB級故障轉(zhuǎn)??Multitenant??Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.?–租戶(PDBs)?“PDBLockdownProfiles––?–租戶(PDBs)?“PDBLockdownProfiles–––?–PublicDBaaS,SaaS,PrivateCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|更多12.2集中CDB云供應(yīng)框包含服務(wù)目錄和PDB更多12.2集中CDB云供應(yīng)框包含服務(wù)目錄和PDB代理ProxyRemoteAccountsAccountsCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|OracleDatabase12cRelease2OracleDatabase12cRelease2CPU和I/O隔快速供應(yīng)和克可插拔在線租SaaS部署的架應(yīng)用無在線租4,096個(gè)Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.DatabaseIn-更快，更容易，支持Copyright?DatabaseIn-更快，更容易，支持Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.什么是OracleDatabaseIn-??突破:雙格式使用內(nèi)存列格式什么是OracleDatabaseIn-??突破:雙格式使用內(nèi)存列格式的分析和報(bào)表性能提升100全新內(nèi)存??對于向量處理?交易型負(fù)載使用成熟的行格列格???Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.OracleDatabaseIn-MemoryOracleDatabaseIn-Memory支持實(shí)時(shí)業(yè)務(wù)無內(nèi)存大小限Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.內(nèi)存選件也能運(yùn)行在ADG1In-1In-內(nèi)存選件也能運(yùn)行在ADG1In-1In-高效利用備用數(shù)據(jù)庫Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.In-MemoryColumn熱圖追蹤數(shù)據(jù)訪問In-MemoryColumn熱圖追蹤數(shù)據(jù)訪問策略可定SalesCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.實(shí)時(shí)的分析查詢JoinGroup使用的列，是用于多HASHJOINExample:Findtotalsalesinoutlet實(shí)時(shí)的分析查詢JoinGroup使用的列，是用于多HASHJOINExample:FindtotalsalesinoutletStoreIDjoin2-CreateGroup(STORES(STORE_ID),SALESCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.StoreStore實(shí)時(shí)的分析查詢Example:ComputetotalsalesNet=實(shí)時(shí)的分析查詢Example:ComputetotalsalesNet=Price+Price*復(fù)雜查詢比原來快3-5In-MemoryColumnCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.Price+PriceX實(shí)時(shí)/多模式分析內(nèi)存中的?將來自JSON對象的虛擬列裝載到的JSON文檔PureIn-Memory??使用JSON_VALUE函數(shù)在JSON對JSON內(nèi)容或表達(dá)式的查詢自動如：查找包含60xperformancegains{?"Movie":"JurrasicWorld"Tickets":{}}?Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.實(shí)時(shí)/多模式分析內(nèi)存中的?將來自JSON對象的虛擬列裝載到的JSON文檔PureIn-Memory??使用JSON_VALUE函數(shù)在JSON對JSON內(nèi)容或表達(dá)式的查詢自動如：查找包含60xperformancegains{?"Movie":"JurrasicWorld"Tickets":{}}?Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.In-Columnar?In-Columnar??In-ColumnarOnlyHybridcolumnarcompressedobjectsareCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.加載性能改進(jìn)In-Memory??列格式保存到列格式存儲的數(shù)據(jù)按照原格式加載性能改進(jìn)In-Memory??列格式保存到列格式存儲的數(shù)據(jù)按照原格式Column?當(dāng)數(shù)據(jù)庫重新啟動時(shí)，IM列數(shù)據(jù)裝載跟原來相比裝載速度更快(2-5倍)，因?FastCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.In-MemorywithOracleDatabase12cReleaseOLTP行列In-MemorywithOracleDatabase12cReleaseOLTP行列 60倍速度提升JSON把分析任務(wù)卸載到ActiveDataGuard備庫In-MemoryonExadataCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.Copyright?2017,OracleCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.?RACDataGuard能滿99%以上的應(yīng)用?RACDataGuard能滿99%以上的應(yīng)用連續(xù)性要??SQL用于分片表，可分布1000個(gè)分SQL一個(gè)大數(shù)據(jù)庫分區(qū)到許多小數(shù)據(jù)Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.可擴(kuò)展可擴(kuò)展Web應(yīng)用程序必須指定一個(gè)分區(qū)主要應(yīng)用基于分區(qū)鍵值的單分區(qū)數(shù)據(jù)操作，如customer_idaccount_id輔助使用Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.?不需要像NoSQL一樣使用專用…CREATESHARDEDTABLE(CustId…)VARCHAR2(60)?不需要像NoSQL一樣使用專用…CREATESHARDEDTABLE(CustId…)VARCHAR2(60)NOT?????Systemmanaged-consistentUserdefined-range,…?…?…Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.App快速指向需要訪問的Shard。如果應(yīng)用不CoordinatorDB來協(xié)助判定。?ShardingApp快速指向需要訪問的Shard。如果應(yīng)用不CoordinatorDB來協(xié)助判定。?ShardingShardRoutingKEY?可擴(kuò)展：輕松擴(kuò)展更多的客戶端和分片?…支持OCI,ODP.NET和?…Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.沒有鍵值的訪問和跨分片查Coordinator沒有鍵值的訪問和跨分片查CoordinatorSQL并且將請求轉(zhuǎn)?App?ShardRouting?…??…Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.ShardedTableFamilyCREATESHARDEDTABLECustomers(CustNoNUMBERNOTNULL,Name…ClassSQLDDLCREATESHARDEDShardedTableFamilyCREATESHARDEDTABLECustomers(CustNoNUMBERNOTNULL,Name…ClassSQLDDLCREATESHARDEDTABLE(OrderNoNUMBER(5),CustNoNUMBER(3),OrderDateDATE…CONSTRAINTCustFKFOREIGNRootPKREFERENCES))PARTITIONHASHPARTITIONS;TABLESPACESET;CREATESKUNUMBER(4)PRIMARYKEY,ProductVARCHAR2(20),PriceNUMBER(6,2)))TABLESPACEduplCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.ShardedLineCopyright?2017,OracleShardedLineCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.OracleShardingDataCenterDataCenterPrivateOracleShardingDataCenterDataCenterPrivateCloudforLargePublicCloudforAvailabilityZoneAvailabilityZoneCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.Copyright?2017,OracleCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|管理Copyright?2017,Oracleand/orits管理Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|Oracle5,6,7,Oracle8i,9i,Oracle11g,管V$ViewsExplainPlanWaitEventsSQLTracingTuningPackTestingPacksLifecyclePackAWR,ASHSQLMultitenantDatabaseDatabaseApplianceDatabase&ExadataCloud12.2EMCloud???PerPDBAWRPDB12.2EMCloud???PerPDBAWRPDB??SupportforvolumePDBestatesEMRealApplication??ImprovedSimplerManagerImprovedscalabilitylargeforlongrunningcalls???Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|12.2ManageabilityImprovementsIndexUsage?Trackindex12.2ManageabilityImprovementsIndexUsage?TrackindexusagenoViewsprovideusageSQLTuning?Supportfor?Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|Copyright?2017,OracleCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|高可用性O(shè)racle5,6,7,Oracle8i,9i,Oracle11g,高可用性O(shè)racle5,6,7,Oracle8i,9i,Oracle11g,CrashRecoveryOnlineBackupDataGuardRecoveryManagerPortableClusterwareOnlineDDLZeroDataLossEditionBasedRedefinitionApplicationContinuityCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|?WhatItEBR可以修補(bǔ)或升級，在Oracle數(shù)據(jù)庫中實(shí)現(xiàn)零停機(jī)時(shí)間應(yīng)用程序的持久它允許數(shù)據(jù)庫，從客戶端代碼的?WhatItEBR可以修補(bǔ)或升級，在Oracle數(shù)據(jù)庫中實(shí)現(xiàn)零停機(jī)時(shí)間應(yīng)用程序的持久它允許數(shù)據(jù)庫，從客戶端代碼的POV電子商務(wù)套件12.2版（2013）采用EBR做修補(bǔ)和升?–S和美國運(yùn)通在What’s 2014和2015介紹采用EBR?–12.1新增功能使EBREditionabilityofobjectsbecameaperobjectpropertyavoidingneedforschema12.2Editionedobjectsnolongerinusearecleanedupautomaticallyinthe–Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|12.2?Diagnostic,Tuning,andSQLPlanonNouserdisconnectonfailoverMulti-node12.2?Diagnostic,Tuning,andSQLPlanonNouserdisconnectonfailoverMulti-nodeparallelapplyinRACprimaryandstandbyMoresecure(SSL-basedredotransport,automaticallymaintainpasswordfiles)?Planned????SALESCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|RACCopyright?2017,RACCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.RACMassivescalabilityofReader?RACMassivescalabilityofReader?RACReaderNodessupportadynamic,largenumberofcomputenodesTypicalRACAttachedServers?–RACReaderNodesutilizeLeafnodesstartingwith12.2FlexClusterLeafnodesarelooselycoupledandtypicallydonotdirectlyaccessstorageLeafnodefailuresdonotimpactanyothernodeoranyotherworkload–12.2FlexClusterswithRACReader–CoupledServers?Use–LocalreaderfarmsandAttachedServersLeafnodesI/OisCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.RACMassivescalabilityofParallelRACMassivescalabilityofParallel?UtilizingFlexCluster,parallelcanbedistributedacrossLeaf?Use–MassivescalabilityofParallelCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.ASMFlexPre-12.2ASM12.2ASMFlexPre-12.2ASM12.2ASMFileresourceFlexDB1:File File File File File File File DB3:File DB2:File DB3:File DB2:File DB1:File DB2:File File File File DB1:File Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|FileDB2:FileDB3:FileASMFlex12.2ASMFlexDiskgroupsenableOperationstobetargetedagainstallfilesinadatabasee.g.ASMFlex12.2ASMFlexDiskgroupsenableOperationstobetargetedagainstallfilesinadatabasee.g.QuotaFlexfortesting/Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|FileFileFileFileOracleDatabase12cAutonomousHealthWorkingforYou?IntegratesnextOracleDatabase12cAutonomousHealthWorkingforYou?IntegratesnextgenerationrunningDiscoversPotentialIssuesandNotifieswithCorrectiveActionsSpeedsIssueDiagnosisandPreservesDatabaseandServerAvailabilityandPerformanceAutonomouslyMonitorsandManagesresourcestomaintainSLAs????Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|RapidHomeProvisioning,Scaling,PatchingandWhat’sRapidHomeProvisioning,Scaling,PatchingandWhat’snewinManageexisting11.2and12.1Provisionnewpools(11.2,12.1,12.2)ontobasemachinesGridInfrastructure:provision,scale,patch,upgradeDatabase:scale,upgrade???????NotificationAuditRHPGLOBALCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|ClusterLargescaledeploymentsmade?ManaginghundredsofClusterLargescaledeploymentsmade?Managinghundredsofsystemsinadatacenterisachallenge:Maintaingoldimagesforinstalland12.2ClusterDomainenablescentralizedmanagementforsoftwaredeploymentsandupdatesusingRapidHomeProvisioningforcollectingdiagnose-abilityinformationasthebasisforreal-timedataanalysisviatheAutonomousHealthGoal:Onlypayattentiontonodesthathavebeendiagnosedwithsevereissuesthatcouldleadtounplanneddowntime.??DomainServicesSingleNodeCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|Copyright?2017,OracleCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.Security–ContinuousInnovation&InternetCloudSecurity–ContinuousInnovation&InternetCloudCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|Oracle5,6,7,Oracle8i,9i,Oracle11g,PrivilegesandRolesVirtualPrivateDatabaseLabelSecurityDataEncryptionDataMaskingDatabaseVaultAuditDatabaseFirewallPrivilegeAnalysisDataRedactionKeyVaultDatabaseThreatActors,Vectors,andCloud/OS/DBRiskDatabaseThreatActors,Vectors,andCloud/OS/DBRiskHighAvailabilityLegacyApplicationsCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|ExabytesofunencrypteddataexistExabytesofunencrypteddataexist12.2introducesonlineencryptionofexistingdatabasefilesAlsosupportsonlinere-AlsoFullencryptionofinternaldatabasei.e.SYSTEM,SYSAUX,andUNDOAcme10Acme3Acme5Acme12Acme4Acme2DF@￡!1ah Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.Newin12.2DatabaseVaultSimulationDefineandtestsecurityprotectionprofilesthroughapplicationNewin12.2DatabaseVaultSimulationDefineandtestsecurityprotectionprofilesthroughapplicationRealmandHRCreateHRCreateDVIPs,Users,Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|MaintainControlandVisibilityonMaintainControlandVisibilityonKeyAuditCustomerOn-CustomerCloudCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|OracleAVAVAVOracleAVAVAVAVAuditCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.KeyVaultKeyOracleKeyVaultKeyOracleSSHKeyCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.數(shù)據(jù)庫安全評估工具??快速掃描數(shù)據(jù)庫，報(bào)告安全風(fēng)險(xiǎn)和數(shù)據(jù)庫安全評估工具??快速掃描數(shù)據(jù)庫，報(bào)告安全風(fēng)險(xiǎn)和配置，權(quán)限，加密，審計(jì)推薦相關(guān)TDE,DatabaseVault,AVDF,and??可從上免費(fèi)下載的工–10.2,11.2,OracleSupportDocument2138254.1(OracleDatabaseSecurityAssessmentToolCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.BigDW&SQLBigDW&SQLCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.分析Client-ServerInternetCloudCopyright?2017,分析Client-ServerInternetCloudCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|Oracle5,6,7,Oracle8i,9i,Oracle11g,ParallelQuery(SQL)CostBasedOptimizerQueriesonHierarchiesDirectDataDataMiningResourceBigDataApplianceRAnalyticsOraclePartitioninginOracleDatabaseOveradecadeofdevelopmentandbetterthaneverOraclePartitioninginOracleDatabaseOveradecadeofdevelopmentandbetterthaneverCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|CoreOracle10gR2andRangeLocalandglobalRangeindexing,Hashpartitioning,Listpartitioning,GlobalHashindexing,StaticpartitionPartition-wisejoins,FastpartitionSPLIT,Multi-dimensionalBasicmaintenance:ADD,DROP,EXCHANGE,MERGEGlobalindexmaintenance,LocalIndexmaintenance,FastDROPTABLEOracleMorecompositechoices,Referencepartitioning,Hash-*ExpandedReference“AND”PartitionAdvisor,IncrementalstatsMulti-branchexecution(akatableor-Oracle12cInterval-ReferenceAsynchronousglobalindexmaintenanceCascadingTRUNCATE,Partialindexing,Oracle12cAuto-listIntervalsubpartitioning,PartitionedexternaltablesOnlinepartitionmaintenanceoperations,OnlinetableconversiontopartitionedReducedcursorinvalidationsforReadonlypartitions,BigData分區(qū)的外SALESTABLEBigData分區(qū)的外SALESTABLEexena)FullstatisticsgatheredonexternalDynamicUKPaonGmanyPaonUSAPaonExternaltablescanbepartitionedusinganypartitioningtechniquePartitionpruningandbasicpartitionCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|Movesbusinesslogic(Aggregations,Hierarchies,Calculations)backintoSimpleMovesbusinesslogic(Aggregations,Hierarchies,Calculations)backintoSimpleSQLforcomplexanalyticnojoinsorGROUP-BYclausesdefiningcalculationsWorksontopofexistingnopersistentCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|Newin12.2ApproximateQueryCopyrightNewin12.2ApproximateQueryCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|Newin12.2IndexCompressionNewIndexHighcompressionenablesfurthercompressionofindexesNewin12.2IndexCompressionNewIndexHighcompressionenablesfurthercompressionofindexesSignificantspacesavingsforindexheavyapplications(i.e.OLTP)IndexcompressioncanalsoresultinI/OimprovementsasahigherproportionofindexcanbecachedSAP(10,00013%Improvementinworkloadthroughput(forlowCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|PropertyScalesPropertyScalestotrillionsofMemory-basedGraphMorethan35graphanalysisSQL,Tinkerpop:Blueprints,Gremlin,Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|Rules:e.g.UsedefaultparametersRules:e.g.UsedefaultparametersinActions:Copyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.|Copyright?2017,OracleCopyright?2017,Oracleand/oritsaffiliates.Allrightsreserved.Developers–ContinuousInnovation&Client-ServerInternetCloudDevelopers–Continuous