《阿里自研数据库-OceanBase实践教学提纲》由会员分享,可在线阅读,更多相关《阿里自研数据库-OceanBase实践教学提纲(38页珍藏版)》请在金锄头文库上搜索。
1、苏真 2013.4,1,阿里自研数据库Oceanase实践,课程大纲,Why OceanBase 系统架构 数据模型 如何使用,2,WHY Oceanbase,Why OceanBase,传统数据库(mysql Select * from t1 where c1=x and c2=x; Select * from t1 where c1=x; Select * from t1 where c1=x and c2=x and c4=x; Select * from t1 where c1=x and c6=x; Select sum(c5) where c1=x;,实例,35,C1+C2+C3组
2、成主键,C4,C5,C6为普通字段 NOT OK Select * from t1 where c2=x and c3 =xxxx; Select * from t1 where c3=xxxx; Select * from t1 where c2=x; Select * from t1 where c5=x ; 更多OceanBase SQL手册参见: http:/oceanbase.alibaba-,Select,update,replace,delete,insert where 条件过滤(and, or) like group by having order by limit,offset reverse scan aggregate(count,sum,average),支持的SQL操作,OceanBase应用接口,应用接口:MySQL兼容 (JDBC/ODBC),APP,OceanBase,OBSQL客户端库,MySQL客户端库,PRELOAD,38,