4.5 Core Concept . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 SQL Dialect . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 8.4.6 Limitations way in which Apache Shard‐ ingSphere provides services by database protocol, the way in which SQL dialect operates data, and the database type that interacts with storage nodes. 2.3. Pluggable: Building of using one SQL dialect to access all heterogeneous databases is increasing. 8.4.2 Challenges The existence of diversified databases makes it difficult to standardize the SQL dialect accessing the database

5.5 Core Concept . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 SQL Dialect . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 3.5.6 Limitations way in which Apache Shard‐ ingSphere provides services by database protocol, the way in which SQL dialect operates data, and the database type that interacts with storage nodes. 1.3 Deployment Apache of using one SQL dialect to access all heterogeneous databases is increasing. 3.5.2 Challenges The existence of diversified databases makes it difficult to standardize the SQL dialect accessing the database

project are Link, Enhance and Pluggable. • Link: Flexible adaptation of database protocol, SQL dialect and database storage. It can quickly link applications and multi‐mode heterogeneous databases quickly Multi‐model Databases Sup‐ ported Shadow D atabase Readwrit e‐ splitting Row Authority (TODO) SQL Dialect Translate (TODO) Observ ability Distributed Transaction SQL Audit (TODO) Elastic Scale‐out fragmentation is coming. 4.1.2 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

project are Connect, Enhance and Pluggable. • Connect: Flexible adaptation of database protocol, SQL dialect and database storage. It can quickly connect applications and heterogeneous databases quickly. Heterogeneous Databases Sup‐ ported Shadow D atabase Readwrit e‐ splitting Row Authority (TODO) SQL Dialect Translate (TODO) Observ ability Distributed Transaction SQL Audit (TODO) Elastic Scale‐out fragmentation is coming. 4.1.2 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

5.5 Core Concept . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 SQL Dialect . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 3.5.6 Limitations way in which Apache Shard‐ ingSphere provides services by database protocol, the way in which SQL dialect operates data, and the database type that interacts with storage nodes. 1.3 Deployment 1.3.1 Deployment of using one SQL dialect to access all heterogeneous databases is increasing. 3.5.2 Challenges The existence of diversified databases makes it difficult to standardize the SQL dialect accessing the database

4.5 Core Concept . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 SQL Dialect . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 8.4.6 Limitations way in which Apache Shard‐ ingSphere provides services by database protocol, the way in which SQL dialect operates data, and the database type that interacts with storage nodes. 2.3. Pluggable: Building of using one SQL dialect to access all heterogeneous databases is increasing. 8.4.2 Challenges The existence of diversified databases makes it difficult to standardize the SQL dialect accessing the database

project are Connect, Enhance and Pluggable. • Connect: Flexible adaptation of database protocol, SQL dialect and database storage. It can quickly connect applications and heterogeneous databases quickly. Heterogeneous Databases Sup‐ ported Shadow D atabase Readwrit e‐ splitting Row Authority (TODO) SQL Dialect Translate (TODO) Observ ability Distributed Transaction SQL Audit (TODO) Elastic Scale‐out fragmentation is coming. 4.1.2 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

indivisible atomic signs, i.e., Token. According to the dictionary provided by different database dialect, it is categorized into keyword, expression, literal value and operator. SQL is then converted into performance. Considering similarities and differences between SQL of all kinds of database dialect, SQL dialect dictionaries of different types of databases are provided in the parsing module. 3.1. Sharding version} // According to the needs, introduce the parsing module of the specified dialect (take MySQL as an example), you can add all the supported dialects, or just what you need

shardingsphere:shardingsphere-mysql-dialect-exception，数据库网 关的 MySQL 实现 • org.apache.shardingsphere:shardingsphere-parser-core，SQL 解析核心 • org.apache.shardingsphere:shardingsphere-postgresql-dialect-exception，数 据库网关的 parser. MySQLParserF acade dialect/mysql/src/main/java/org/apache/shardi ng‐ sphere/sql/parser/mysql/parser/MySQLParserFacade.java>‘__ parser. OpenGaussParserFacade dialect/opengauss/src/main/java/org/apache/shardingsphere /sql/parser/opengauss/parser/OpenGaussParserFacade

shardingsphere:shardingsphere-mysql-dialect-exception，数据库网 关的 MySQL 实现 • org.apache.shardingsphere:shardingsphere-parser-core，SQL 解析核心 • org.apache.shardingsphere:shardingsphere-postgresql-dialect-exception，数 据库网关的 parser. MySQLParserF acade dialect/mysql/src/main/java/org/apache/shardi ng‐ sphere/sql/parser/mysql/parser/MySQLParserFacade.java>‘__ parser. SQLServerParserFacade dialect/sqlserver/src/main/java/org/apache/shardingsphere /sql/parser/sqlserver/parser/SQLServerParserFacade