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 TPCH 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.
GU Ling
,
WENG Hai-Xing
,
HU Hua-Liang
,
ZHAO Qiong
. OceanBase schema design for OLAP application[J]. Journal of East China Normal University(Natural Science), 2014
, 2014(5)
: 301
-310
.
DOI: 10.3969/j.issn.10005641.2014.05.027