数据驱动与一体化整合云时代it架构创新及变革

Whoam 国内第⼀个OracleACE及ACE 技 ITPUB的主要倡导者之⼀已 了12本技术书籍和张乐奕共创Oracle用户组-ACOUG,OracleACE（6位），OracleACE（2位），SQL⼤以及数⼗位OCM专家，同时具备MySQL、DB2 3 金融：传统到互联网–支付宝、余额宝 海量数据，价值变现 视察前海微众银行，“希望 Development Application Deployment& Application

2008年，微软以1.15 收购了 和和2008年，微软以1.15 收购了 ABCD–FutureisNow智能化云 大数据

ABCD–JustDoIT免费的SaaS服务，免费的SaaS服务，BethuneSQL审核企业级服务，自动筛查 2017尽在云端 中的数据管理TransformingDataWhilepreservingcustomer’sØFromDisk-basedtoIn-MemoryØFromDataWarehousetoBigØFromOn-PremtoDatabaseOptimizedAWSisSlower,MoreExpensive,andLessReliablethantheOraclePublic2017：Database Oracle

OracleOracle18(12.2.0.2)and19(12.2.0.3)tobetreatedasundertheumbrellaof12.2.Current nisforOracle19tobethelastreleasefor12.2.MaychangeinthefuturetoOracle20asthelastreleasefor12.2.WaivedExtendedSupport PaidExtended

Database12c：Scale-UpScale-In-Memory

DBIn- OrderColumnShardingIn

内存选件：Scale-OutIn- ；In-Memory查询parallelized 数据库分片：Scale-OutOn- Linear

Split

数据库分片：Scale-OutOn-CREATESHARDEDTABLE

(CustId…

VARCHAR2(60)NOT

PRIMARY)PARTITIONBYCONSISTENTHASH

OneGiantDBto Small

Userdefined-range,list 12万

3

3 2CPU绑定到LGWR

1

3 RedoSize 2，006，801.5Transactions:1，349.4 响应，降低单次LOGFILEPARALLELWRITE等待时间

12c–adaptivescalable

12c–adaptivescalableNVRAM-Non-Volatilememory areinExpecttostartingavailableinWillbehugedisruptiontostorageanddatabaseOracleDatabase12cRelease2andupwillOracleDatabaseCorewillbere-writeforAlibabaOceanBaseSDD+NoUndoLog支付类业务最高每小时约3000万事务（全球支付类业务最高每小时约3000万事务（全球金融业务最高每小时约100万事务 类业务最高每小时约50万事务（单省

ActiveData

LB

在11g30个ADGNorestrictionsondatatypesorindexesReplicationkeepspacewithpeakHighReadaccessReaderfarmtransparentlytransitionstonewprimaryatfailovertime

PolarDB采用SharedDisk架构，计算 分离逻辑上DB数据都放在所有DBserver都能够共享 主节点发生故障进行Failover短到30 GRDFrozenDRMGlobalResourceDirectory(GRD)Instance1Instance Instance Instance

Nomoreuntilpages

I/ORequestsare

needrecoveryarelockedNoLock GRDFrozenDRMredo redo redoInstance1Instance Instance Instance

RecoveryInstancereadslogoffailednode

I/ORequestsare

Mustreadlogandlockpagesbeforezeislifted. xRecoveryinstancelockspagesthatneedRecoveryBuddyZeroDowntimefaster!faster! 数据块变化-Tracksblockschangesonbuddyinstance快速识别重配置时需要恢复的数据块-Quicklyidentifiesblocksrequiringrecoveryduringreconfiguration允许快速处理新事务-Allowsrapidprocessingofnewtransactions实现4倍以上的性能提升-*upto4timesfasterwithRecoveryBuddyandOptimized(Singleton)ReconfigurationTime双活架构：ExtendedRAC 数据累积性能分割数据降低

12cCloudScale

捷 •Softwareasa

252PDBsperRelease12.2•4096PDBsRelease12.2•4096PDBsper内存管理Memory

快速开通和克隆provisioningand热克隆和刷新Hotcloningand热克隆租户迁移Onlinetenant

即时Saas架构InstantSaaSNoappchanges共享应用对象Sharedapplication租户迁移Onlinetenant –从传统业务的可度 –到互联网的不可预 性 BufferCache

NewIn-Memory

简单、易用与高效

inmemory_size=XXX

NO

Hardwareforcommonrange”“Howmanybetweenstart-dateandend-”

in

ApplicationDataSELECT…WHERElo_orderdate=SELECT…WHERElo_orderdate=…ANDlo_partkeyANDd_year_monthnumBETWEEN201311AND

ClusterzData–弹性分布 SolutionsandServicesIntegratedtoWorkSolutionsandServicesIntegratedtoWork去“IE”架构通过VirtualSAN替代FC20倍的IO动态扩