Background #

Thanks to technology innovation, an increasing number of applications are established in new fields. This is causing a rapid data increase, leading to fast innovation for data storage and computing methods.

Transaction, big data, association analysis, Internet of Things and other scenarios have emerged quickly, resulting in a single database not being applicable to all application scenarios anymore. At the same time, it has become normal for similar scenarios to use different databases.

The trend of database fragmentation is emerging.

Challenges #

There is no unified database access protocol and SQL dialect, as well as the maintenance and monitoring methods differences by various databases, learning and maintenance cost of developers and DBAs are increasing rapidly. Improving the compatibility with the original database is the premise for providing incremental services on it.

The compatibility between SQL dialect and database protocol is the key point to improve database compatibility.

Goal #

The goal of database compatibility for Apache ShardingSphere is to minimize or eliminate the differences between various databases for the user.