Journal of East China Normal University(Natural Sc ›› 2018, Vol. 2018 ›› Issue (4): 90-98.doi: 10.3969/j.issn.1000-5641.2018.04.009

Previous Articles     Next Articles

Sublink elimination and optimization in data storage and processing separation architecture

WANG Yan-zhao, HU Hui-qi, ZHANG Zhao, LIU Xiao-bing, DUAN Hui-chao   

  1. School of Data Science and Engineering, East China Normal University, Shanghai 200062, China
  • Received:2017-06-26 Online:2018-07-25 Published:2018-07-19

Abstract: This paper implemented a sublink elimination optimizer in NewSQL RDBMS (Relational Database Management System). The purpose of the optimizer is to make complex SQL so that it can be executable in New SQL systems, and achieve auto-tuning of complex SQL to reduce the cost of migrating from a centralized database to a distributed database; this would make the NewSQL DBMS (Database Management System) available to telecomunications and banking industries. We also provide a method to minimize data transmission between servers after sublink promotion. Experiments show that the optimization effect of the query optimizer is notable and can replace manual optimization and reduce the workload of application migration.

Key words: distributed database, NewSQL, sublink elimination

CLC Number: