SQL to NoSQL : What to do and How

6th Annual 2018 International Conference on Geo-Spatial Knowledge and Intelligence

Dai, Jiao^1

School of Cyber Security, University of Chinese Academy of Sciences, Beijing

100193, China^1

关键词: Column-oriented;    Database transformation;    Enterprise applications;    Enterprise management;    High availability;    Nosql database;    Query optimization;    Query translations;   

Others  :  https://iopscience.iop.org/article/10.1088/1755-1315/234/1/012080/pdf
DOI  :  10.1088/1755-1315/234/1/012080

来源: IOP

【 摘 要 】

Due to complex logic of enterprise management, enterprise applications may contain thousands of tables with mass connections or constraints among them. Traditional enterprises still use RDBMS while NoSQL system is widely adopted due to its excellent performance and high availability. So tools for migrating from RDBMS to NoSQL database is on demand. However, schema matters not only in RDBMS but also in NoSQL system for better query response. In this paper we discuss technology in database transformation including schema transforming, query translation and query optimization. And we mainly focus on the open issues in the context of OLAP workload and column-oriented NoSQL.