华东师范大学学报(自然科学版) ›› 2014, Vol. 2014 ›› Issue (5): 271-280.doi: 10.3969/j.issn.10005641.2014.05.024

• 计算机科学与技术 • 上一篇    下一篇

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

裴欧亚,刘文洁,李战怀,田征   

  1. 西北工业大学 计算机学院,西安 710129
  • 出版日期:2014-09-25 发布日期:2014-11-27
  • 通讯作者: 刘文洁,女,副教授,研究方向为软件理论、自律计算、高可用性系统 E-mail:liuwenjie@nwpu.edu.cn
  • 作者简介:裴欧亚,男,博士研究生,研究方向为数据管理. E-mail: peiouya2013@mail.nwpu.edu.cn.
  • 基金资助:

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

A nested query strategy oriented massive distributed database

 PEI  Ou-Ya, LIU  Wen-Jie, LI  Zhan-Huai, TIAN  Zheng   

  1. School of Computer, Northwestern Polytechnical University, Xi’an 710129, China
  • Online:2014-09-25 Published:2014-11-27

摘要: 面向大数据分析和处理的NoSQL数据库具有非常好的读写性能和可扩展性,但是无法支持完整的SQL查询和跨行跨表的事务,对于传统的以关系数据库为主的金融业务在应用上有所限制.OceanBase是面向海量数据查询的分布式数据库,结合了关系数据库和非关系数据库的优势,同时支持关系查询和跨行跨表事务,具有可扩展性.但是,目前OceanBase只支持简单的、非嵌套子查询的SQL语句,无法很好地支持金融应用.本文在研究OceanBase架构和查询策略的基础上,提出了一种基于BloomFilter和HashMap的查询策略,实验表明该策略能够提高和改善现有查询策略的不足,在实现嵌套查询的基础上,可提高查询性能.

关键词: OceanBase, NoSQL, 嵌套查询, 大数据

Abstract: 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 nonrelational databases, supporting relational queries and transactions across tables or rows. However, at present OceanBase only supports simple and nonnested 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.

Key words: OceanBase, NoSQL, nested queries, big data

中图分类号: