Real-time analytics on Postgres tables

Free GUI Tool for Index Maintenance on SQL Server and Azure

Benchmark suite for analytical DBs using real-world SQL queries, Docker-based automation, and reproducible tests. Tailored for comparing systems like Apache Doris and ClickHouse with realistic datasets and actionable insights.

Example OLAP queries and dataset

An in-memory column-store time-series database that uses query compilation

Kysely dialects, plugins and other goodies for Singlestore (formerly MemSQL)

A repository that provides samples that use MariaDB Connector/Python

This walkthrough will get you up and running with a MariaDB Community Server, using ColumnStore and Docker, and to create a Hybrid Transactional/Analytical (HTAP) database solution in less than 15 minutes.

Dev container for ColumnStore 🔥

資料行存放區索引 (columnstore index) 快速筆記的範例程式碼與擷圖

Demo Scripts for SQL Server on Linux

Bachelor thesis on query optimization for Business Intelligence systems. Analysis of ETL, physical design (indexing, partitioning, compression, caching), and materialized views on SQL Server and Azure Synapse. Includes SQL scripts and TPC-DS evaluations.

Implementation of column store with underlying mysql database with implemented adhoc queries

Pass Summit 2017 - Summary Presentation

A C++ library for reading MonetDB's persisted storage format (BBP)

A distributed HTAP SQL engine with dual rowstore/columnstore, Raft consensus, and vectorized execution.

Perfmon counters warehoused in SQL Server for long-term trend analysis.