一种面向海量分布式数据库的嵌套查询策略  

A nested query strategy oriented massive distributed database

作　　者：裴欧亚 刘文洁[1] 李战怀[1] 田征[1] 

机构地区：[1]西北工业大学计算机学院,西安710129

出　　处：《华东师范大学学报（自然科学版）》2014年第5期271-280,共10页Journal of East China Normal University(Natural Science)

基　　金：国家973课题(2012CB316203);国家863课题(2012AA011004);国家自然科学基金重点项目(61033007);国家自然基金青年项目(61303037)

摘　　要：面向大数据分析和处理的NoSQL数据库具有非常好的读写性能和可扩展性,但是无法支持完整的SQL查询和跨行跨表的事务,对于传统的以关系数据库为主的金融业务在应用上有所限制.OceanBase是面向海量数据查询的分布式数据库,结合了关系数据库和非关系数据库的优势,同时支持关系查询和跨行跨表事务,具有可扩展性.但是,目前OceanBase只支持简单的、非嵌套子查询的SQL语句,无法很好地支持金融应用.本文在研究OceanBase架构和查询策略的基础上,提出了一种基于BloomFilter和HashMap的查询策略,实验表明该策略能够提高和改善现有查询策略的不足,在实现嵌套查询的基础上,可提高查询性能.NoSQL databases have very good read/write performance and scalability in Big dataanalysis and processing, but they cannot support complete SQL queries and transactions acrosstables or rows, which limits the application of financial business based on the traditional relationdatabases. OceanBase, a distributed database, combines the advantages of relational databasesand non-relational databases, supporting relational queries and transactions across tables orrows. However, at present OceanBase only supports simple and non-nested queries which cannotmeet the needs of financial business. After studying the OceanBase architecture and query strate-gy, a new strategy based on BloomFilter and HashMap is proposed in this paper. Experimentsshow that the strategy can improve the existing query strategy and enhance query performance.

关 键 词：嵌套查询 大数据 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]