Journal of East China Normal University(Natural Sc ›› 2014, Vol. 2014 ›› Issue (5): 301-310.doi: 10.3969/j.issn.10005641.2014.05.027

• Article • Previous Articles     Next Articles

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

PDF

1703

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

CLC Number: