华东师范大学学报(自然科学版) ›› 2014, Vol. 2014 ›› Issue (5): 301-310.doi: 10.3969/j.issn.10005641.2014.05.027

• 计算机科学与技术 • 上一篇    下一篇

面向OLAP应用的OceanBase模式设计

顾伶1,翁海星1,胡华梁1,2,赵琼3   

  1. 1. 华东师范大学 软件学院,上海 200062; 2. 浙江理工大学 经济管理学院,浙江 310018;
    3. 交通银行 软件研发中心,上海 201201
  • 出版日期:2014-09-25 发布日期:2014-11-27
  • 通讯作者: 胡华梁,男,副教授,硕士生导师,研究方向为数据库 E-mail:jmxyandy@126.com
  • 作者简介:顾伶,女,硕士研究生,研究方向为内存数据管理与分析. E-mail: guling@ecnu.edu.cn.
  • 基金资助:

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

OceanBase schema design for OLAP application

 GU  Ling1, WENG  Hai-Xing1, HU  Hua-Liang1,2, ZHAO  Qiong3   

  1. 1. Software Engineering Institute, East China Normal University, Shanghai 200062, China;
    2. School of Economics and Management, Zhejiang Sci-Tech University, Hangzhou 310018, China;
    3. Bank of Communications, Shanghai 201201, China
  • Online:2014-09-25 Published:2014-11-27

摘要: 随着大数据时代的来临,用户查询需求也越来越复杂,对数据库的可扩展性和SQL查询效率都提出了很高的要求.OceanBase是Alibaba研发的适应互联网规模的关系型分布式数据库,能够做到可扩展、低成本、高可用,并能应用到很多业务场景,包括OLTP和OLAP.然而,当前发布的最新OceanBase只支持主键索引,还不能支持二级索引.其次,OceanBase在连接上没有并行处理,使得查询效率较低.因此,为了能够使用主键索引及减少连接来加快查询速率,OceanBase模式设计是必要的.本文主要以TPCH的22个查询为OLAP的研究案例,分析传统数据库的模式设计,并提出OceanBase分布式数据库下的模式设计规则,最后将会通过实验来验证这套模式设计规则的有效性.

关键词: OceanBase, OLAP, TPC-H

Abstract: As big data era is coming, high demands on the scalibility and query efficiency of database as user requirements are becoming more and more complicated. OceanBase developed by Alibaba is the relational distributed database. It is eqiupped with the feature of scalibility, low cost and availability. In addition, it is used in much wider applications, including OLTP and OLAP. However, the newest released version of OceanBase can only support the primary key index and cannot support the secondary index. Besides, OceanBase has no parallelism for join, which affects the query efficiency enormously. 〖JP2〗Therefore, the OceanBase schema design is necessary to make the primary key index and decreasing times of join useful. This paper studies TPCH application as the OLAP example to analyse the relational database schema design and propose the OceanBase schema design. At last, we varify the efficiency of the schema design through experiments.

Key words: OceanBase, OLAP, TPC-H

中图分类号: