Features List #

All features supported by SphereEx-DBPlusSuite are listed below, including the terminal control provided by SphereEx-Boot, the visual monitoring and diagnostics provided by SphereEx-Console, as well as other functions provided by SphereEx-DBPlusEnginge.

Level One Features	Level Two Features
Dialect compatibility	MySQL
	PostgreSQL
	Oracle
	SQL Server
	openGauss
	SQL 92/2003 standard
	DBMS in China
Database protocol support	MySQL
Database protocol support	PostgreSQL
SQL Extension	SQL Hint
	SQL SQL dialect conversion
	Standard DistSQL
	Enhanced DistSQL
Distributed Transaction	XA transaction
	Enhanced XA transaction
	Flexible transaction
	Global transaction & MVCC
Query optimizer	Computing pushdown
Query optimizer	Federated query optimization
Data integration	Global CDC
Data sharding	Basic sharding strategy
	Customized sharding strategy
	Automated sharding management
	Pre-sharding capability
	Automatic data redistribution
	Heterogeneous secondary index
	Instant distribution
Data security (encryption)	Data storage encryption
	Open-source encryption algorithm
	Commercial encryption algorithm
	Customized datatype and length
	Assisted query column
	Simple dense state calculation
	Complex dense state calculation
	Data encryption
	Local key management
	Cloud key management
	Sensitive data identification
Data security (authority)	User management
	Role management
	Statement-level authority control
	Database-level authority control
	Table-level authority control
	Column-level authority control
	Row-level authority control
	Authority changing online
	LDAP docking
	Third-party authority docking
Behavior Security (AUDIT)	User behavior audit
Behavior Security (AUDIT)	Proactive audit (beforehand)
Shadow stress test	Production data isolation test
Read/write splitting	Read/write access splitting
	Delay detection & consistent access
	Built-in precision delay detection
Data migration	Full data migration
	Distributed high-performance migration
	Single consistency check
	Distributed high-performance verification
Elastic scale-out	Single data redistribution
	Distributed data redistribution
	Single data redistribution
	Single consistency check
	Distributed high-performance check
	Statement flow control
	Load flow control
	Flow switching and control
Metadata Management	Online strong consistency change
Metadata Management	Decentralization on cloud
Terminal control	Cluster management component
Terminal control	Cluster management
Visual control	Host Management
	Cluster management component
	Cluster management
	SQL Management
	Logs Management
High Availability	Compute node high availability
	Storage node high availability
	Storage node fault perception and self-healing
Monitoring diagnosis	Host-level monitoring
	Component-level monitoring
	Statement-level monitoring (slow query)
	Enhanced monitoring indicators
	Monitoring alarm docking
	Link tracing (APM)