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