PolarDB for Oracle is highly compatible with Oracle syntax, including commonly used features like built-in data types, stored procedure syntax, common system views, database link, partitioned tables, and partitioned indexes. Paired with the Advanced Database & Application Migration (ADAM) tool, it helps you seamlessly migrate existing Oracle database workloads.
Existing Oracle users can switch to PolarDB for Oracle with minimal to no code changes. As the fastest-growing database product in the history of Alibaba Cloud, it has a proven track record of success both within Alibaba Group and on the public cloud. It is widely used across industries such as finance, public services, energy, telecommunications, new retail, and education. PolarDB for Oracle is a leader in the evolution of Alibaba Group's relational database technology.
Compared to a traditional Oracle database, PolarDB for Oracle provides the architectural benefits of PolarDB and offers the following advantages:
-
Low-latency replication with physical logs
By using shared storage and physical logs, replication latency between the primary and standby nodes stays within milliseconds. For workloads that require zero data loss, you can enable strong consistency, though this may impact write performance.
-
HTAP cross-node parallel execution
PolarDB for Oracle supports Hybrid Transactional/Analytical Processing (HTAP). By using distributed parallel computing, it can execute a single SQL query across multiple read-only nodes. This approach fully utilizes the high I/O throughput of the shared storage layer and the CPU and memory resources of the read-only nodes. You can run real-time analytical queries on your transactional data without moving it to a separate analytics platform. To prevent performance impact on your transactional workloads, the read-only nodes that run analytical queries can be physically isolated from the nodes that handle transactional queries. If you need more processing power, you can elastically add compute nodes without redistributing your data.
-
Accurate execution plans with a next-generation optimizer
Database workloads can be diverse, and an incorrect execution plan can lead to slow query performance. To address this challenge, PolarDB for Oracle uses a next-generation cost-based optimizer.
-
Scenario-specific kernel features
PolarDB for Oracle provides specialized kernel features for specific scenarios, such as optimizing for flash sales or providing built-in connection pool management.
-
Enhanced enterprise-grade capabilities
With deep optimizations to its architecture and kernel, PolarDB for Oracle delivers more than double the performance. It meets enterprise security requirements with in-transit and storage encryption. Based on a one-write-multiple-read architecture, a cluster can be scaled out to 15 read-only nodes to handle dynamic workloads. The service supports a pay-as-you-go billing model, and storage can be scaled up to 500 TB.
-
On-demand scaling
-
You can create PolarDB instances with different instance specifications to handle various business workloads.
-
You can upgrade instance specifications as database workloads and storage requirements grow, and downgrade them during off-peak periods. This on-demand scaling allows you to plan your underlying hardware resources more effectively and optimize costs.
-
-
Oracle compatibility
-
Built on the extensive experience of Alibaba Group, PolarDB for Oracle is compatible with the Oracle syntax most frequently used by developers and DBAs, eliminating the need for retraining.
-
When used with the Advanced Database & Application Migration (ADAM) platform, it offers a structured, workflow-based migration process. ADAM offers end-to-end migration capabilities, including pre-migration assessment, data synchronization and verification, SQL syntax compatibility analysis for Java applications, and post-migration performance comparison.
-