What’s New in the Database World? 2024 H2 Industry Review and Key Product Updates

Technical Innovation Overview

AI‑Database Fusion – Vendors embed AI capabilities to enhance data analysis and support AI‑driven applications.

Multimodal Data Support – Native handling of vectors, graphs, and time‑series in many relational databases.

Architecture Advances – Storage‑compute separation and lake‑warehouse convergence improve scalability and cost efficiency.

Core Product Enhancements – Focus on performance, compatibility, and security across major systems.

Major RDBMS Updates (H2 2024)

Oracle – Introduced an AI‑centric enterprise architecture, enhanced JSON‑relational duality, low‑code APEX AI assistant, and compliance with GB 42250‑2022 security standards.

MySQL – Bug‑fix releases for 8.0 (8.0.39, 8.0.40) and LTS 8.4 (8.4.2, 8.4.3). The innovative 9.0 series adds JavaScript stored procedures, a VECTOR data type, optimizer improvements, new EXPLAIN JSON output, and removes several legacy components.

SQL Server 2025 CTP 1 – Integrated AI services, vector search, Fabric & Azure Arc sync, T‑SQL regex, Copilot assistance, Azure SQL DB feature back‑port, and extensive security upgrades.

SQL Server 2022 (16.x) – Added Azure Synapse Link, object‑storage integration, enhanced high‑availability, advanced security (Entra, Always Encrypted, dynamic data masking), and performance optimisations.

PostgreSQL 17.2 – Vacuum memory reduction (up to 20×), I/O gains (up to 2×), BRIN parallel builds, JSON/SQL/JSON_TABLE enhancements, MERGE RETURNING, improved logical replication, new TLS options, and expanded system views.

MariaDB 11.4 LTS – Oracle compatibility mode via SET sql_mode='ORACLE';, native VECTOR support, Spider sharding engine improvements, and a solution for MySQL temporary tablespace growth using SET GLOBAL innodb_truncate_temporary_tablespace_now = 1;.

OceanBase – LTS 4.2.5 delivers 26% read/write and 54% batch write performance gains, adaptive linking, baseline‑first SPM, enhanced MySQL and Oracle compatibility, backup configuration, resource isolation, and AI‑vector search in 4.3.3 GA.

TiDB – LTS 8.5.0 and DMR 8.4‑8.2 introduce vector search, stability for massive clusters, schema cache limits, resource‑group management, global indexes for partitioned tables, and extensive observability improvements.

Big‑Data Ecosystem Highlights

Elasticsearch – Versions 8.15‑8.17 add int4 vectors, zstd compression, and a logsdb index mode for cost‑effective log storage.

Apache Flink – 2.0‑preview removes deprecated APIs, simplifies configuration, and prepares for a stable 2.0 release in 2025.

ClickHouse – Releases 24.6‑24.11 (24.8 LTS) bring parallel hash join, BFloat16 vectors, refreshable materialised views, Variant mode inference, JSON type, time‑series engine, and other performance‑oriented features.

Apache Doris – 2.0‑3.0 series implement storage‑compute separation, lake‑warehouse integration, vector search, and upcoming CDC and incremental batch processing.

StarRocks – Versions 3.1‑3.3 add storage‑compute separation, COS support, cache optimisation, materialised view enhancements, and data‑lake capabilities.

Cloud Database Updates

Alibaba Cloud (PolarDB) – Added disaster‑recovery drills, Elastic Memory Pool, serverless column‑store index, ePQ cold‑data parallel query, Orca Redis‑compatible service, and Zero‑ETL data integration.

PolarDB PostgreSQL – Launched International Standard edition, SQL throttling, Apache AGE‑compatible graph database, and V2.0 security plan.

PolarDB Distributed – Introduced Global Database Network, cold‑data row‑level archiving, open‑source 2.4.1 release, and V2.0 MySQL‑compatible solution.

Baidu Intelligent Cloud – Updated RDS console (DBSC), cross‑region MySQL backup, PostgreSQL plugin management, AI‑driven assistant, and added VectorDB with RBAC, HNSW PQ index, TLS/TDE encryption.

JD Cloud – Added TiDB 7.5, multi‑AZ deployment, PostgreSQL cross‑major upgrades, MySQL 5.6 minor upgrades, MongoDB SmartDBA integration, ClickHouse 24.3/24.8, and Starwift node‑group isolation.

For further reference on MariaDB VECTOR support, see: https://mariadb.com/kb/en/vector-overview/.