Exploring China’s Homegrown Databases: Features of DM, GBase, and Sinoregal

Da Meng DM (DM7) – version V7.1.5.117

Da Meng Database Management System (DM) is a high‑performance, fully proprietary Chinese RDBMS. DM7 is built on a Java‑like virtual machine, supports standard relational models and provides extensive analytics and high‑availability capabilities.

Compatibility enhancements

External data links to IBM DB2, Microsoft SQL Server and Sybase.

Analytical function LISTAGG and other window functions.

Oracle‑compatible MERGE INTO syntax, including operations on derived tables.

Interface extensions

PHP 5.6 and PDO 5.6 drivers for application integration.

Extended OCI interface with new functions such as OCINumberIsInt.

Open‑source Qt‑based QDM driver.

Debug support for internal PACKAGE functions.

Standalone Node.js client.

Query optimizer improvements

Partition‑pruning for partitioned tables.

Interval partition support that accelerates DML on time‑based partitions.

Adaptive optimizer that automatically switches to an alternative execution plan when the current plan exceeds its cost limit.

Index‑monitoring feature for detailed usage analysis.

Advanced features

DM DSC – shared‑storage, multi‑instance high‑availability solution comparable to Oracle RAC.

Web‑based DEM management console for remote administration, event tracking, alerting and performance monitoring.

HUGE partition tables with partition‑switch capability.

Native JSON data type with full set of operators.

Multi‑level partition tables supporting both added and interval partitions.

MPP‑environment table replication that permits UPDATE and DELETE on replicated tables.

GBase

GBase 8a MPP Cluster – version V8511

Fully parallel Massively Parallel Processing (MPP) with a Shared‑Nothing architecture.

Hash‑based and random data distribution with on‑the‑fly compression, suitable for petabyte‑scale datasets.

High‑throughput data loading; benchmarked at up to 2 TB per hour for the whole cluster.

Features: horizontal scalability, fault‑tolerant high availability, high concurrency, mixed row‑column storage, and full SQL‑92/SQL‑99 compliance.

GBase 8t – version V8.7

Derived from IBM Informix 12.10 source code, re‑engineered for independent release.

Performance‑oriented technologies: dynamic shared memory, virtual processors, and advanced disk I/O handling.

High‑availability components:

HDR (High‑availability Data Replication)

RSS (Remote Standalone Secondary)

SDS (Shared Disk Servers)

ER (Enterprise Replication)

Operational tools for health monitoring, HA management, log inspection, performance analysis and server administration.

Sinoregal Dynamic Server (Sinoregal DS) – version 12.10 FC7

Sinoregal DS is built on IBM Informix v12 source code and adds proprietary monitoring, encryption, and audit modules. It targets OLTP, data‑warehouse, sensor‑data, and cloud‑distributed workloads.

Data‑warehouse enhancements

Improved real‑time query performance and in‑memory storage.

Management UI with automatic partition refresh and continuous data loading.

Sensor‑data and time‑series support

Native spatial and time‑series data types.

Warehouse Accelerator for fast time‑series search and analysis.

Integration with ESRI 10.1 for advanced GIS capabilities.

Cloud‑grid capabilities

Flexible Grid architecture with region concepts and simplified configuration.

Enhanced replication monitoring, asynchronous attribute handling and lightweight incremental replication.

Network‑aware connection manager that prioritises traffic to maintain service‑level guarantees during network failures.

Embedded and storage features

Automatic data compression with broader target support.

Dynamic server‑parameter configuration and rolling‑window partitioning for performance optimisation.

Management tools

Open Admin Tool (OAT) for supervising replication grids and the Warehouse Accelerator.

Mobile DBA application for health and performance monitoring.

Primary Storage Manager replaces the legacy Storage Manager, simplifying backup workflows.

Application‑development extensions

New SQL language extensions, including a neutral UNION operator for cross‑server compatibility.

Hash‑join optimisation improves ANSI outer‑join handling.

Extended compression for indexes and large objects reduces I/O latency.