面向OLAP应用的OceanBase模式设计  

OceanBase schema design for OLAP application

作　　者：顾伶 翁海星 胡华梁[1,2] 赵琼[3] 

机构地区：[1]华东师范大学软件学院,上海200062 [2]浙江理工大学经济管理学院,浙江310018 [3]交通银行软件研发中心,上海201201

出　　处：《华东师范大学学报（自然科学版）》2014年第5期301-310,共10页Journal of East China Normal University(Natural Science)

基　　金：浙江省自然科学基金(LY12F02044)

摘　　要：随着大数据时代的来临,用户查询需求也越来越复杂,对数据库的可扩展性和SQL查询效率都提出了很高的要求.OceanBase是Alibaba研发的适应互联网规模的关系型分布式数据库,能够做到可扩展、低成本、高可用,并能应用到很多业务场景,包括OLTP和OLAP.然而,当前发布的最新OceanBase只支持主键索引,还不能支持二级索引.其次,OceanBase在连接上没有并行处理,使得查询效率较低.因此,为了能够使用主键索引及减少连接来加快查询速率,OceanBase模式设计是必要的.本文主要以TPC-H的22个查询为OLAP的研究案例,分析传统数据库的模式设计,并提出OceanBase分布式数据库下的模式设计规则,最后将会通过实验来验证这套模式设计规则的有效性.As big data era is coming, high demands on the scalibility and query efficiency of da-tabase as user requirements are becoming more and more complicated. OceanBase developed byAlibaba is the relational distributed database. It is eqiupped with the feature of scalibility, lowcost and availability. In addition, it is used in much wider applications, including OLTP andOLAP. However, the newest released version of OceanBase can only support the primary key in-dex and cannot support the secondary index. Besides, OceanBase has no parallelism for join,which affects the query efficiency enormously. Therefore, the OceanBase schema design is necessaryto make the primary key index and decreasing times of join useful. This paper studies TPC-H applica-tion as the OLAP example to analyse the relational database schema design and propose the OceanBaseschema design. At last, we varify the efficiency of the schema design through experiments.

关 键 词：OceanBase OLAP TPC-H 

分 类 号：TP392[自动化与计算机技术—计算机应用技术]