382 Order‐by Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 382 Group‐by Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 384 Aggregation Merger integrity and security and is also one of the databases’core technologies. ShardingSphere provides distributed transaction ca‐ pability on top of a single database, which can achieve data security across underlying the data usage experience. Data En‐ cryp‐ tion Data Encryption is a basic way to ensure data security. ShardingSphere provides a set of data encryption solutions that are complete, secure, transparent

409 Order‐by Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 409 Group‐by Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 411 Aggregation Merger Dis‐ tributed Trans‐ action Transactional capability is key to ensuring database integrity and security and is also one of the databases’core technologies. With a hybrid engine based on XA and BASE trans‐ ShardingSphere provides distributed transaction capabilities on top of standalone databases, enabling data security across underlying data sources. Read/write Split‐ ting Read/write splitting can be used to cope

257 Order‐by Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 257 Group‐by Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 259 Aggregation Merger (sharding, readwrite‐splitting and shadow), transform (data encrypt and mask), authen‐ tication (security, audit and authority), governance (circuit breaker and access limitation and an‐ alyze, QoS and ShardingSphere document, v5.0.0 1.2 Solution S olutions/ Fea- tures • Distributed Database* Data Security Database Gateway Stress T esting Data Sharding Data Encrypt Multi‐model Databases Sup‐ ported

267 Order‐by Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 267 Group‐by Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 269 Aggregation Merger (sharding, readwrite‐splitting and shadow), transform (data encrypt and mask), authen‐ tication (security, audit and authority), governance (circuit breaker and access limitation and an‐ alyze, QoS and ShardingSphere document, v5.1.1 1.2 Solution S olutions/ Fea- tures • Distributed Database* Data Security Database Gateway Stress T esting Data Sharding Data Encrypt Heterogeneous Databases Sup‐ ported

521 Order‐by Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 521 Group‐by Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 523 Aggregation Merger ib ut ed T ra ns ac ti on Transactional capability is key to ensuring database integrity and security and is also one of the databases’core technologies. With a hybrid engine based on XA and BASE transac‐ ShardingSphere provides distributed transaction capabilities on top of standalone databases, enabling data security across underlying data sources. Re ad /w ri te S pl it ti ng Read/write splitting can be used

278 Order‐by Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 278 Group‐by Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 280 Aggregation Merger (sharding, readwrite‐splitting and shadow), transform (data encrypt and mask), authen‐ tication (security, audit and authority), governance (circuit breaker and access limitation and an‐ alyze, QoS and ShardingSphere document, v5.1.2 1.2 Solution S olutions/ Fea- tures • Distributed Database* Data Security Database Gateway Stress T esting Data Sharding Data Encrypt Heterogeneous Databases Sup‐ ported

550 Order‐by Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 550 Group‐by Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 552 Aggregation Merger ib ut ed T ra ns ac ti on Transactional capability is key to ensuring database integrity and security and is also one of the databases’core technologies. With a hybrid engine based on XA and BASE transac‐ ShardingSphere provides distributed transaction capabilities on top of standalone databases, enabling data security across underlying data sources. Re ad /w ri te S pl it ti ng Read/write splitting can be used

name after sharding, or misconducts caused by operations such as pagination, order by or aggregated group by are just the case in point. 3.1. Sharding 10 Apache ShardingSphere document, v5.0.0-beta Cross‐database information, sharding conditions, auto‐increment primary key information, Order By information, Group By information, and pagination information (Limit, Rownum and Top). One‐ time SQL parsing process the query SQL. This kind of situation aims mainly at GROUP BY and ORDER BY. Result merger requires sorting and ranking according to items of GROUP BY and ORDER BYfield. But if sorting and ranking items

environment, ElasticJob provide dump command to export job runtime information for debugging. For security reason, the information dumped had already mask sensitive information, it instead of real IP address Operation 76 Apache ShardingSphere ElasticJob document Now we can use it Function list • Login security control • Registration center, event tracking data source management • Quickly modify job settings JinCaiHuLian Lianlian Pay SR online IcInfo LaoCaiBao NiuCard JieDaiBao JinHui365 91 Tech Group 9.2.3 Digitalization and Cloud Services YunJia cloud Joyowo Tree Bear 南方电网深圳数研院 9.2.4 Transportation

select_expr [, select_expr ...] FROM table_reference [, table_reference ...] [WHERE predicates] [GROUP BY {col_name | position} [ASC | DESC], ...] [ORDER BY {col_name | position} [ASC | DESC], ...] [LIMIT document, v5.2.0 3.9.7 使用限制 基于 Hint 的影子算法 • 无。 基于列的影子算法 • 不支持 DDL； • 不支持范围、分组和子查询，如：BETWEEN、GROUP BY ⋯HAVING 等。SQL 支持列表： – INSERT SQL 是 否 支 持 INSERT INTO table (column,⋯) VALUES (value,⋯) 支持 BETWEEN SELECT/UPDATE/DELETE ⋯WHERE column BETWEEN value1 AND value2 不 支 持 GROUP BY ⋯ HAVING⋯ SELECT/UPDATE/DELETE ⋯WHERE ⋯GROUP BY column HAV‐ ING column > value 不 支 持 子查询 SELECT/UPDATE/DELETE ⋯WHERE