Oracle11g

InsertPictureHere全新的Oracle数据库11gOracle数据库11g专题网络研讨会孙戎甲骨文（中国）软件系统有限公司技术顾问2008年10月15日2持续的技术革新AuditVaultAuditVaultDatabaseVaultDatabaseVaultGridComputingGridComputingAutomaticStorageMgmtAutomaticStorageMgmtSelfManagingDatabaseSelfManagingDatabaseXMLDatabaseXMLDatabaseOracleDataGuardOracleDataGuardRealApplicationClustersRealApplicationClustersFlashbackQueryFlashbackQueryVirtualPrivateDatabaseVirtualPrivateDatabaseBuiltinJavaVMBuiltinJavaVMPaPartitioningSupportrtitioningSupportBuiltiBuiltinMessagingnMessagingObjectRelationalObjectRelationalSupportSupportMultimediaSupportMultimediaSupportDataWarehousingOptimizationsDataWarehousingOptimizationsParallelOperationsParallelOperationsDistributedSQL&TransactionDistributedSQL&TransactionSupportSupportClusterandMPPSupportClusterandMPPSupportMultiMulti--versionReadConsistencyversionReadConsistencyClient/ServerSupportClient/ServerSupportPlatformPortabilityPlatformPortabilityCommercialSQLImplementationCommercialSQLImplementationOracle2Oracle9iOracle5Oracle6Oracle7Oracle8Oracle8iOracle10g3客户所关注的核心焦点4网格的增长趋势……5GridControlFusionMiddlewareAutomaticStorageManagementRealApplicationClusters网格计算6Oracle数据库11g的革新领域•在所有数据类型中更加的业务洞察力•有效管理数据的增长•以更低的成本获取更高的服务质量•缓解变更的压力7非结构化数据的集成Images8完整的信息管理方案MultimediaMultimediaAudio,ImageandVideoAudio,ImageandVideoLocation&SpatialLocation&SpatialLocationEnabledDatabasesLocationEnabledDatabasesSecureEnterpriseSearchSecureEnterpriseSearchEnterpriseWideSearchEnterpriseWideSearchXMLXMLIntegratedNativeXMLDatabaseIntegratedNativeXMLDatabaseTextTextTextIndexingandClassificationTextIndexingandClassificationRelationalRelationalCharacters,Numbers,Dates,LOBsCharacters,Numbers,Dates,LOBsContentDBandRecordsDBContentDBandRecordsDBContentManagementintheDatabaseContentManagementintheDatabaseMultimediaMultimediaMedicalImageSupport(DICOM)MedicalImageSupport(DICOM)Location&SpatialLocation&Spatial3DSupport3DSupportXMLXMLBinaryXMLSupportBinaryXMLSupportTextTextRDFandOWLSupportRDFandOWLSupportRelationalRelationalNewSecureFilesLOBStorageNewSecureFilesLOBStorageSecureEnterpriseSearchSecureEnterpriseSearchCompleteSetofConnectorsCompleteSetofConnectorsContentDBandRecordsDBContentDBandRecordsDBContentManagementintheDatabaseContentManagementintheDatabase利用Oracle数据库11g管理&强化您的企业信息安全性9Oracle数据库11g新特性关键的新数据类型RFIDDataTypesDICOMMedicalImages3DSpatialImages10OracleSecureFiles突破性能的壁垒…ReadPerformanceWritePerformance0.010.1110100Mb/Sec0.010.1110100Mb/SecFileSize(Mb)FileSize(Mb)SecureFilesLinuxFilesSecureFilesLinuxFiles11Oracle数据库11g新特性扩展的XML支持－BinaryXMLXML-BinaryXML-LOBXML-ObjectRelationalUnstructuredStructuredFlexiblePerformantSchema-lessSchema-based12Oracle数据库11g的革新领域•在所有数据类型中更加的业务洞察力•有效管理数据的增长•以更低的成本获取更高的服务质量•缓解变更的压力13管理数据的增长非结构化数据结构化数据法规适应性商业智能数据合并数据整合14数据增长的挑战管理挑战•查询性能•基本数据操作的持续时间•数据的可用性成本挑战•存储容量的需求•管理负担•系统停顿的成本15分区的好处大表难于管理分区分而治之更易于管理提高性能复合分区更高的性能更高的灵活性以满足商业需求ORDERSORDERSJanFebORDERSJanFebEuropeUSA16Oracle数据库11g新特性分区顾问ORDERSORDERSJanFebORDERSJanFebEuropeUSA17Oracle数据库11g新特性自动化的分区:间隔分区ORDERSJanFebORDERSJanFebMar18Oracle数据库11g新特性自动分区:参照分区OrdersInventoryBackOrdersLineItemsPickListsOrdersOrdersOrdersJanFebMar19Oracle数据库11g新特性商业驱动分区:新的复合分区OrdersJanFebRange-Range•Datebyordervalue50001000-5000OrdersList-Range•RegionbyordervalueList-List•RegionbytypeGoldSilverUSAEUR50001000-5000OrdersJanFeb20Oracle数据库11g新特性高级压缩•压缩大数据量的应用表•交易处理,数据仓库•压缩所有的数据类型•结构化和非结构化数据•典型压缩比2-3倍•降低数据中心的存储成本21数据量的增长趋势Source:2005TopTenProgram,November2005©WinterCorporation,Waltham,MA,USA02040608010019981999200020012002200320042005DatabaseSize(TB)SizeofthelargestdatawarehouseinTopTenPrograms245%Increasejustfrom2003to200522传统的数据存储方式所有数据位于单一的存储层高性能存储层=$72perGbAlldataonactive=$972,000!ActiveActive23信息生命周期管理将数据分区到适当的存储层ActiveLessActiveHistorical高性能存储层=$72perGb低成本的存储层=$14perGb只读存储层=$7perGb245%Active35%LessActive60%Historical信息生命周期管理将数据分区到适当的存储层高性能存储层=$72perGb低成本的存储层=$14perGb只读存储层=$7perGb255%Active35%LessActive60%Historical$49,800$67,700$58,000信息生命周期管理将数据分区到适当的存储层高性能存储层=$72perGb低成本的存储层=$14perGb只读存储层=$7perGb26高级压缩在所有的存储层中降低存储成本…5%Active35%LessActive60%Historical$16,600$22,600$19,400Letsusecompressionfactorof3$49,800$67,700$58,00027为何选择Oracle数据库11g?管理数据增长与应用无关特定应用低成本高成本自动处理手工处理多层数据存储单一存储层在线归档离线归档$972,000$58,60028Oracle数据库11g的革新领域•在所有数据类型中更加的业务洞察力•有效管理数据的增长•以更低的成本获取更高的服务质量•缓解变更的压力29服务质量的挑战降低总体成本•更佳的性能和可扩展性•更高的数据安全性和合规性•访问数据更高的可用性30更高的性能JavaJust-In-TimeCompiler024681012SpeedUpto11xFasterDatabaseResidentConnectionPoolUpto20xconnectionsRACPerformanceEnhancements0%50%100%150%200%QueryIntensiveUpto70%FasterQueryResultCaching020406080100120140QueriesUpto25%FasterClientSideCaching0%20%40%60%80%100%120%140%ImprovementUpto22%FasterOracleSecureBackup020406080100120140BackupUpto25%FasterOracleStreamsEnhancements050100150200ReplicationUpto2xFaster0%500%1000%1500%2000%NbrConnectionsOptimizerStatsCollection02004006008001000StatsCollectionUpto10xFaster31数据存储加密数据安全挑战保护数据、监控访问数据传输加密控制DBA访问确保数据的安全部署收集、监控、审计活动数据备份加密控制用户访问32数据安全在数据库中加密数据透明的数据加密－TransparentDataEncryptionOracle数据库11g新特性…表空间级别的加密基于硬件主密钥的保护33数据安全加密备份OracleSecureBackupOracle数据库11g新特性压缩备份34数