Context
openGauss is a standalone database. It has the basic features of relational databases as well as enhanced features.
Features
-
Standard SQLs
Supports SQL92, SQL99, SQL2003, and SQL2011 standards, GBK, GB18030, UTF-8, SQL ASCII, and Latin-1 character sets, SQL standard functions and analytic functions, and stored procedures.
-
Database storage management
Supports tablespaces where different tables can be stored in different locations.
-
Primary/standby deployment
Supports the ACID properties, single-node fault recoveries, primary/standby data synchronization, and primary/standby switchover.
-
APIs
Supports standard JDBC 4.0 and ODBC 3.5.
-
Management tools
Provides installation and deployment tools, instance start and stop tools, and backup and restoration tools.
-
Security management
Supports SSL network connections, user permission management, password management, security auditing, and other functions, to ensure data security at the management, application, system, and network layers.