GBase 8a (OLTP)
Product Introduction
Component Description
Key Technical Indicators
- Storage Mode: Row storage, column storage, and HTAP row-column hybrid storage
- Compatibility: ≥98% compatible with Oracle; highly compatible with MySQL / PostgreSQL
- Distributed Transactions: Strong consistency, supporting global distributed transactions
- GIS Capabilities: Full support for GIS spatial data types and functions
- Migration Capabilities: Full / incremental / reverse synchronization, result comparison, SQL traffic replay
Core Technical Features
- Row Storage: Designed for high-concurrency OLTP with row-level continuous storage. Transactions are guaranteed by MVCC + WAL, delivering excellent performance for point queries, inserts, updates and deletes.
- Column Storage: Optimized for OLAP analytics with columnar compressed storage and CU pruning, significantly reducing I/O operations.
- HTAP Row-Column Hybrid Architecture: Row storage supports core transaction processing while column storage powers analytics. Automatic row-to-column conversion runs in the background with intelligent optimizer routing, enabling one dataset to simultaneously support both transactions and analytics.
- Highly compatible with data types, SQL syntax, system views, and advanced packages (DBMS series).
- Automatic migration of stored procedures, functions, triggers, and sequences.
- Minimal application modification required; in most scenarios, applications can go live by only changing the connection string.
- Supports vector, raster and DEM spatial data models.
- Provides complete GIS functions, geometric calculation, spatial indexing and optimal path calculation.
- Satisfies scenarios such as map services, smart cities, Internet of Things (IoT) and land planning.
Core Advantages
-
Native HTAP Integration, One Dataset for Dual Scenarios
Row storage powers high-concurrency transactions, while column storage handles complex analytics. Automatic switching eliminates the need for database sharding or table splitting, reducing architecture complexity and costs.
-
Smooth Oracle Replacement with Zero Migration Risk
Compatibility rate ≥ 98%. Equipped with full-process supporting tools, it supports forward/reverse synchronization and data comparison, enabling painless replacement of core systems.
-
Built-in GIS Capabilities, Ready-to-Use for Spatial Business
No external components required. Natively supports spatial data storage, computation and analysis, making it ideal for geographic information–related services.
-
Full-Link Tool Coverage for Simplified Development and O&M
Integrates migration, development, O&M, monitoring and intelligent diagnosis, reducing labor costs and technical barriers.
Business Value
- High Oracle compatibility results in minimal application modifications, short cycles and low risks, significantly reducing migration investment.
- The integrated HTAP architecture reduces data synchronization links, enables real-time analytics and supports rapid decision-making.
- Distributed high availability plus multi-active disaster recovery ensures stable 7×24 operation of core systems.
- One-stop platform with intelligent operations reduces manual intervention and cuts O&M costs by more than 50%.
- Elastic scaling, cloud-native design, vector engine and AI enhancements enable smooth upgrades for future business needs.
- Multi-model storage combined with plug-in capabilities including GIS, time-series, full-text search and AI provides one-stop support for transactions, analytics, AI, IoT and other full business scenarios without deploying multiple databases.