面向OLAP应用的OceanBase模式设计

顾伶; 翁海星; 胡华梁; 赵琼

doi:10.3969/j.issn.1000-5641.2014.05.027

留言板

尊敬的读者、作者、审稿人, 关于本刊的投稿、审稿、编辑和出版的任何问题, 您可以本页添加留言。我们将尽快给您答复。谢谢您的支持!

姓名

邮箱

手机号码

标题

留言内容

验证码

面向OLAP应用的OceanBase模式设计

doi: 10.3969/j.issn.1000-5641.2014.05.027

顾伶¹,
翁海星¹,
胡华梁^1,2, ,,
赵琼³

1.
华东师范大学软件学院,上海 200062;
2.
浙江理工大学经济管理学院,浙江 310018;
3.
交通银行软件研发中心,上海 201201

基金项目:

浙江省自然科学基金（LY12F02044）

详细信息

作者简介:
顾伶，女，硕士研究生，研究方向为内存数据管理与分析. E-mail: guling@ecnu.edu.cn.

通讯作者:
胡华梁，男，副教授，硕士生导师，研究方向为数据库

中图分类号: TP392
计量
- 文章访问数: 1612
- HTML全文浏览量: 89
- PDF下载量: 1290
- 被引次数: 0
出版历程
- 刊出日期: 2014-09-25

OceanBase schema design for OLAP application

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

摘要

摘要: 随着大数据时代的来临，用户查询需求也越来越复杂，对数据库的可扩展性和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.
- OceanBase /
- OLAP /
- TPC-H