BestHub
Sign in
Alibaba Cloud Developer
Alibaba Cloud Developer
Feb 27, 2025 · Databases

Boosting PostgreSQL Analytics with DuckDB: Architecture, Optimizations, and Performance Gains

This article explains how integrating DuckDB as an extension for RDS PostgreSQL creates a unified HTAP solution that dramatically accelerates complex analytical queries through columnar storage, vectorized execution, and advanced optimizer techniques, delivering up to hundreds‑fold performance improvements and superior compression.

AnalyticsColumnarDuckDB
0 likes · 11 min read
Boosting PostgreSQL Analytics with DuckDB: Architecture, Optimizations, and Performance Gains
Liangxu Linux
Liangxu Linux
Oct 11, 2023 · Databases

Beyond MySQL: A Practical Guide to 10+ Database Types and Their Ideal Use‑Cases

This article provides a concise yet comprehensive overview of relational, key‑value, document, search‑engine, time‑series, vector, spatial, graph, columnar, and multimodel databases, explaining their data models, typical queries, core advantages, and popular implementations to help developers choose the right storage solution for any project.

ColumnarNoSQLRelational
0 likes · 16 min read
Beyond MySQL: A Practical Guide to 10+ Database Types and Their Ideal Use‑Cases
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Aug 4, 2023 · Databases

How GaussDB(DWS) HStore Tables Enable Real‑Time Ingestion and Lightning‑Fast Queries

Discover how GaussDB(DWS) HStore tables combine columnar storage with Delta capabilities to support high‑concurrency real‑time data ingestion, upsert operations, and ultra‑fast analytical queries, while offering full ACID consistency, strong compression, and practical configuration tips for developers.

ColumnarData WarehousingDatabase Storage
0 likes · 8 min read
How GaussDB(DWS) HStore Tables Enable Real‑Time Ingestion and Lightning‑Fast Queries
ITPUB
ITPUB
Jul 13, 2023 · Databases

Exploring 10+ Database Types: From Relational to Vector and Beyond

This article provides a concise yet comprehensive overview of over ten database categories—including relational, key‑value, document, time‑series, vector, spatial, graph, columnar, and multi‑model systems—explaining their core concepts, typical use cases, popular implementations, and underlying storage mechanisms.

ColumnarRelationalVector
0 likes · 16 min read
Exploring 10+ Database Types: From Relational to Vector and Beyond
High Availability Architecture
High Availability Architecture
Sep 7, 2018 · Databases

Understanding NoSQL and Database Selection in the Big Data Era

This article analyzes the shortcomings of traditional relational databases in big‑data scenarios and introduces five major NoSQL categories—columnar, key‑value, document, full‑text search, and graph databases—detailing their principles, advantages, disadvantages, common implementations, and appropriate use cases to guide storage technology selection.

ColumnarNoSQLdata storage
0 likes · 18 min read
Understanding NoSQL and Database Selection in the Big Data Era
ITPUB
ITPUB
Jul 2, 2016 · Databases

Understanding NoSQL: Key-Value, Columnar, and Document Databases Explained

An overview of NoSQL database types—including key‑value stores like Redis, column‑oriented systems such as BigTable and HBase, and document databases like MongoDB—covers their architectures, strengths, typical use cases, and key factors to consider when selecting a NoSQL solution for web applications.

ColumnarDocumentMongoDB
0 likes · 8 min read
Understanding NoSQL: Key-Value, Columnar, and Document Databases Explained