Tag

column store

1 views collected around this technical thread.

IT Architects Alliance
IT Architects Alliance
Oct 10, 2022 · Databases

Row Store vs Column Store: Comparison, Advantages, and Experimental Evaluation in openGauss

The article explains the fundamental differences between row‑based and column‑based storage in databases, compares their write and read performance, presents a practical openGauss experiment showing storage size and insert speed differences, and offers guidance on when to choose each model.

DatabaseOpenGausscolumn store
0 likes · 8 min read
Row Store vs Column Store: Comparison, Advantages, and Experimental Evaluation in openGauss
Top Architect
Top Architect
Aug 3, 2022 · Databases

Row Store vs Column Store in openGauss: Comparison, Advantages, Disadvantages and Experimental Evaluation

This article explains the fundamental differences between row‑based and column‑based storage in relational databases, compares their performance for writes, reads, compression and use cases, presents an openGauss experiment with sample tables and SQL commands, and offers practical guidance on when to choose each storage model.

Database StorageOpenGaussPerformance Comparison
0 likes · 10 min read
Row Store vs Column Store in openGauss: Comparison, Advantages, Disadvantages and Experimental Evaluation
Top Architect
Top Architect
Jul 26, 2022 · Databases

Row Store vs Column Store: Comparison, Advantages, and Experimental Evaluation in openGauss

This article explains the differences between row-based and column-based storage in databases, compares their advantages and disadvantages, presents experimental results using openGauss including space usage and insert performance, and offers practical guidance on selecting the appropriate storage model for various workloads.

Database StorageOpenGaussPerformance Comparison
0 likes · 10 min read
Row Store vs Column Store: Comparison, Advantages, and Experimental Evaluation in openGauss
Architecture Digest
Architecture Digest
Jul 19, 2022 · Databases

Row Store vs Column Store in openGauss: Comparison, Advantages, Disadvantages, and Experimental Evaluation

This article explains the fundamental differences between row‑based and column‑based storage in databases, compares their read/write performance, presents experimental results on openGauss showing space and speed trade‑offs, and offers practical guidance on when to choose each storage model.

Database StorageOpenGaussPerformance Comparison
0 likes · 11 min read
Row Store vs Column Store in openGauss: Comparison, Advantages, Disadvantages, and Experimental Evaluation