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.