BestHub
Sign in
dbaplus Community
dbaplus Community
Aug 7, 2022 · Databases

Overcoming Performance and Compatibility Gaps Switching from Oracle to Chinese Databases

In this interview, senior database expert Kong Zaihua explains the main performance, functional, and usability shortcomings of domestic Chinese databases compared with Oracle, and outlines practical strategies, tools, and migration techniques to evaluate compatibility, handle DDL conversion, manage online/offline data transfer, and reduce reliance on stored procedures.

Database MigrationDomestic DatabasesOracle compatibility
0 likes · 10 min read
Overcoming Performance and Compatibility Gaps Switching from Oracle to Chinese Databases
dbaplus Community
dbaplus Community
Nov 25, 2020 · Databases

How OpenGauss Handles Oracle SQL Compatibility: Features, Limits, and Workarounds

This article examines how openGauss implements Oracle SQL compatibility, covering query syntax like ROWNUM and DUAL, unsupported CONNECT BY, HINT handling, execution‑plan commands, Oracle functions such as DECODE, SYSDATE, NVL/NVL2, PL/SQL UDFs, stored procedures, triggers, cursors, VARRAYs, and provides a detailed compatibility summary.

Oracle compatibilityPL/SQLSQL dialect
0 likes · 13 min read
How OpenGauss Handles Oracle SQL Compatibility: Features, Limits, and Workarounds
dbaplus Community
dbaplus Community
Nov 7, 2020 · Databases

How OpenGauss Handles Oracle Objects: Indexes, Constraints, Views, and More

This article evaluates the compatibility of Oracle logical objects—indexes, constraints, views, sequences, and synonyms—in openGauss, detailing each object type, providing concrete SQL examples, highlighting differences such as bitmap index support, and summarizing the overall compatibility in a concise table.

ConstraintsIndexesOracle compatibility
0 likes · 11 min read
How OpenGauss Handles Oracle Objects: Indexes, Constraints, Views, and More
ITPUB
ITPUB
May 8, 2018 · Databases

How Tianxi Tech Is Building a Controllable Open‑Source Database on PostgreSQL

In an interview with Tianxi Technology’s database director, the article explores the company’s strategy of creating a domestically controlled, PostgreSQL‑based database that offers Oracle compatibility, discusses the technical implementation, and outlines the broader challenges facing Chinese database vendors.

Chinese DatabaseOracle compatibilityPostgreSQL
0 likes · 11 min read
How Tianxi Tech Is Building a Controllable Open‑Source Database on PostgreSQL