DEV Community

Cover image for openGauss Basic Features
liyang0608
liyang0608

Posted on

openGauss Basic Features

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.

Top comments (0)