SQL to NoSQL : What to do and How
Jiao Dai · IOP Conference Series Earth and Environmental Science · 2019
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.