NoSQL databases have very good read/write performance and scalability in Big data analysis and processing, but they cannot support complete SQL queries and transactions across tables or rows, which limits the application of financial business based on the traditional relation databases. OceanBase, a distributed database, combines the advantages of relational databases and nonrelational databases, supporting relational queries and transactions across tables or rows. However, at present OceanBase only supports simple and nonnested queries which cannot meet the needs of financial business. After studying the OceanBase architecture and query strategy, a new strategy based on BloomFilter and HashMap is proposed in this paper. Experiments show that the strategy can improve the existing query strategy and enhance query performance.
PEI 欧Ya
,
LIU Wen-Jie
,
LI Zhan-Huai
,
TIAN Zheng
. A nested query strategy oriented massive distributed database[J]. Journal of East China Normal University(Natural Science), 2014
, 2014(5)
: 271
-280
.
DOI: 10.3969/j.issn.10005641.2014.05.024