PolarDB for PostgreSQL(Compatible with Oracle) is fully compatible with the Oracle syntax, uses a shared-everything architecture, and supports common features of Oracle databases. The structure that is used by PolarDB for Oracle to organize files is the same as the structure that is used by Oracle. PolarDB for Oracle supports the common Oracle syntax, the multiversion concurrency control (MVCC) feature, and the native Oracle Call Interface (OCI). This way, you can migrate data from an Oracle database to a PolarDB for Oracle cluster in a few clicks.
PolarDB for PostgreSQL(Compatible with Oracle) supports diverse features for partitioning. This includes range partitioning, interval partitioning, partition splitting, partition merging, and partition templates. PolarDB for Oracle allows you to create global indexes for partitioned tables. This makes data queries efficient.
Stored procedures
A stored procedure is a programming language that is commonly used for database development. Application developers are familiar with this language. PolarDB for PostgreSQL(Compatible with Oracle) is highly compatible with stored procedures in Oracle. PolarDB for Oracle supports the following common statements: COLLECTION, GOTO, SAVEPOINT, ROLLBACK TO, CURSOR, EXECUTE IMMEDIATE, and RETURN.
DBLINK
A database link in PolarDB for PostgreSQL(Compatible with Oracle) allows you to execute SQL statements to query data sources outside PolarDB for Oracle. You can query data sources outside PolarDB for Oracle in the same manner as you query data in a PolarDB for Oracle database. You can use a foreign data wrapper, a database link, or a dblink function to query data sources outside PolarDB for Oracle. For example, you can connect a PolarDB for PostgreSQL(Compatible with Oracle) database to another PolarDB for PostgreSQL(Compatible with Oracle) database, connect a PolarDB for PostgreSQL(Compatible with Oracle) database to an Oracle database, a PolarDB for PostgreSQL(Compatible with Oracle) database, to a PostgreSQL, a PolarDB for PostgreSQL(Compatible with Oracle) to a MySQL database. When you run complex SQL queries based on a database link, PolarDB for PostgreSQL(Compatible with Oracle) applies pushdown optimization, ORDER BY optimization, and SORT BY optimization. The supported pushdown optimization includes predicate pushdown and join pushdown. This way, the calculation process can be pushed down to the database from which data is queried. This significantly improves query performance.
Compatibility with advanced features
PolarDB for PostgreSQL(Compatible with Oracle) is compatible with advanced features of Oracle databases and common Oracle drivers such as the OCI driver and the Pro*C driver. The supported advanced features include hints, SQL plan management (SPM), the CREATE TYPE statement, materialized views, and profiles. PolarDB for PostgreSQL(Compatible with Oracle) is also fully compatible with the PostgreSQL syntax and PostgreSQL tools. PolarDB for Oracle provides an ecosystem that is compatible with diverse databases.