Tagged articles
timeseries
14 articles · Page 1 of 1
The article walks through a systematic method for selecting the right storage technology—relational OLTP, search engine, OLAP, or time‑series—based on query intent, data volume, latency tolerance, and consistency needs, using an e‑commerce “optimal store” scenario to illustrate the decision process and practical trade‑offs.
CDCOLAPread-model
0 likes · 30 min read


21CTOApr 9, 2026 · Databases
TimescaleDB 2.26.2 focuses on fixing high‑impact bugs—continuous aggregates errors, compression task crashes, and lock‑related deadlocks—while improving memory stability and PostgreSQL compatibility, and the article provides detailed upgrade instructions and best‑practice recommendations.
BugFixesDatabaseUpgradePostgreSQL
0 likes · 5 min read

This comprehensive guide walks you through PromQL fundamentals, covering data types, gauge and counter metrics, time‑series concepts, query selectors, offsets, arithmetic and logical operators, vector matching, aggregation functions, and key Prometheus functions such as increase, rate, and histogram_quantile, with practical examples and visual illustrations.
MetricsPromQLPrometheus
0 likes · 29 min read

An open-source, Kaggle‑ranked solution for the Mitsui Commodity Prediction Challenge details data preprocessing, feature engineering, and multiple tree‑based modeling strategies—including multi‑target, single‑target, and price‑difference models—with code, evaluation metrics, and suggestions for further improvements.
CatBoostCommodityFeatureEngineering
0 likes · 17 min read

This article explains how to model massive time‑series data in Cassandra by using bucketing techniques to control partition size, avoid hotspots, and improve write and read performance, including practical CQL schema examples and Python code for concurrent queries.
BucketingCQLCassandra
0 likes · 13 min read

This article details the redesign of Ctrip's internal Dashboard monitoring system, explaining why the original HBase‑based TSDB was replaced, the new architecture using VictoriaMetrics and ClickHouse, component upgrades, unified query layer, performance gains, and future roadmap for metrics handling.
ClickHouseHBaseMetrics
0 likes · 12 min read

This article details a practical, semi‑automated monitoring solution for environments with fewer than 500 nodes, covering active monitoring concepts, Prometheus data modeling, service‑framework instrumentation, data scraping and visualization with Grafana, and alert handling via AlertManager.
GrafanaPrometheusmonitoring
0 likes · 13 min read

This article explains how Prometheus transforms raw monitoring data into actionable insights by using a time‑series database (TSDB) that efficiently stores massive metric streams, supports powerful queries, and enables pre‑computed calculations for fast dashboards and alerts.
PrometheusTSDBmonitoring
0 likes · 7 min read

This article demystifies Prometheus by explaining its core concepts, daily monitoring queries, the role of its TSDB storage engine, how series, label, and time indexes enable fast time‑series queries, and how pre‑computed recording rules boost performance for dashboards and alerts.
ObservabilityPrometheusTSDB
0 likes · 8 min read

This article explains how JD.com’s JUST platform leverages the open‑source columnar database ClickHouse to store, query and analyze massive time‑series data, covering data modeling, lifecycle management, system goals, technology selection, cluster architecture, deployment, scaling and future enhancements.
ClickHouseDistributedSystemsbigdata
0 likes · 20 min read

This article provides a comprehensive overview of Prometheus, covering its open‑source monitoring architecture, multi‑dimensional data model, query language, storage mechanisms, service discovery, alerting workflow with Alertmanager, and visualization using Grafana, all illustrated with key diagrams and configuration examples.
GrafanaMetricsPrometheus
0 likes · 9 min read

This tutorial walks through deploying InfluxDB, cAdvisor, and Grafana containers, configuring them to collect and visualize time‑series metrics such as CPU, memory, network, and disk usage from Docker workloads, and shows how to create dashboards and queries for effective container monitoring.
GrafanaInfluxDBcAdvisor
0 likes · 6 min read

The article compiles Meituan‑Dianping engineers' Q&A covering SQL book suggestions, relational versus NoSQL engine choices, performance tuning techniques, time‑series database uses, sharding versus partitioning strategies, query handling in distributed systems, proxy limitations, and practical advice on replication and pre‑database setups.
MySQLNoSQLOptimization
0 likes · 12 min read


21CTOJul 6, 2017 · Big Data
Facing the challenge of storing over 120 billion daily monitoring points from hundreds of thousands of servers, Tencent’s monitoring platform migrated from a custom solution and OpenTSDB to a finely tuned HBase architecture, achieving 3‑5× higher throughput, improved reliability, and significant storage savings.
DistributedStorageHBasePerformanceTuning
0 likes · 11 min read
