Tag

SQL Compatibility

0 views collected around this technical thread.

DataFunSummit
DataFunSummit
Feb 29, 2024 · Big Data

Trino at Xiaomi: Architecture, Practices, and Future Plans

This article details Xiaomi’s practical deployment of Trino, covering its architectural role, core and extended capabilities, performance comparisons, integration with Iceberg and Spark, operational enhancements, multi‑cluster and ad‑hoc query scenarios, future cloud‑storage plans, and a Q&A session.

Big DataIcebergOLAP
0 likes · 20 min read
Trino at Xiaomi: Architecture, Practices, and Future Plans
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 21, 2022 · Databases

Migrating from MyCat to DBLE: Parameter Settings, Sharding Functions, and SQL Compatibility

This article details a low‑impact migration from MyCat to DBLE, covering required parameter adjustments, sharding function replacement, data node handling, and business‑SQL compatibility issues, while providing concrete configuration examples and practical recommendations for a smooth transition.

DBLEDistributed SystemsMycat
0 likes · 7 min read
Migrating from MyCat to DBLE: Parameter Settings, Sharding Functions, and SQL Compatibility
Youzan Coder
Youzan Coder
Jul 7, 2022 · Big Data

Optimizing Apache Doris Performance: A Case Study in Query Processing

Youzan replaced ClickHouse and Druid with Apache Doris, refined its vectorized engine by eliminating deserialization overhead in the merge‑aggregation phase, achieving roughly a 30 % query‑time boost, and validated compatibility through SQL rewriting and traffic replay, while planning further SIMD‑based optimizations and broader adoption.

Apache DorisClickHouseDruid
0 likes · 8 min read
Optimizing Apache Doris Performance: A Case Study in Query Processing
Tencent Architect
Tencent Architect
Dec 10, 2021 · Databases

How a Cloud‑Native MPP Query Layer Turns ClickHouse into a Snowflake‑Like Data Warehouse

This article explains the design and implementation of a cloud‑native MPP query layer for ClickHouse, detailing its architecture, core features, execution flow, performance advantages, SQL compatibility, and future development plans to create a high‑performance, multi‑source OLAP data platform.

ClickHouseData WarehouseMPP
0 likes · 13 min read
How a Cloud‑Native MPP Query Layer Turns ClickHouse into a Snowflake‑Like Data Warehouse
AntTech
AntTech
Mar 12, 2020 · Databases

Comprehensive Overview of OceanBase 2.2: Architecture, Core Features, and Enterprise Solutions

This article provides an in‑depth technical overview of OceanBase 2.2, covering its distributed architecture, high‑availability design, multi‑tenant resource pool, Oracle/MySQL compatibility, performance benchmarks, ecosystem tools such as OCP, ODC, OMS, and disaster‑recovery solutions for financial‑grade workloads.

Distributed DatabaseHigh AvailabilityOceanBase
0 likes · 14 min read
Comprehensive Overview of OceanBase 2.2: Architecture, Core Features, and Enterprise Solutions
Architects' Tech Alliance
Architects' Tech Alliance
Jul 8, 2019 · Databases

Guidelines for Selecting In-Memory Databases and Corresponding Hardware

This article compares ten typical in‑memory databases, discusses their technical characteristics such as performance, ACID support and SQL compatibility, and provides comprehensive technical and non‑technical criteria as well as hardware recommendations for choosing the most suitable in‑memory database solution.

PerformanceSQL Compatibilityconsistency
0 likes · 7 min read
Guidelines for Selecting In-Memory Databases and Corresponding Hardware