Tagged articles
data aggregation
30 articles · Page 1 of 1
This article explains how to solve the Student Geographic Information Report problem by defining a Student class, using three‑level nested Java Maps for province‑city‑district grouping, and implementing aggregation and ranking logic to count students per region and identify the city with the most students.
AlgorithmGeographic InformationJava
0 likes · 6 min read

This tutorial provides a detailed overview of Pandas, covering its core data structures, data import/export, selection, cleaning, aggregation, merging, and a practical sales analysis example, with complete code snippets for each operation.
Pandasdata aggregationdata cleaning
0 likes · 8 min read

This tutorial teaches how to use the Pandas library's groupby method to group data by one or multiple columns and apply aggregation functions such as sum, mean, max, and min, with clear code examples and a practical exercise.
Pythondata aggregationdata analysis
0 likes · 4 min read

This article describes the background, requirements, and architectural design of a custom counting system for a B2B second‑hand trading platform, covering dimension definitions, internal vs external implementations, data flow, persistence strategies, code interfaces, and read‑query optimizations.
Backend Architecturecounting systemdata aggregation
0 likes · 20 min read

This article explains a real‑world question about grouping 5,000 nationwide records by province to compute counts, totals, averages and ratios, compares using Excel pivot tables, SQL, and demonstrates a concise Python pandas pivot_table solution.
PythonSQLdata aggregation
0 likes · 4 min read

The article describes how Bilibili tackled exploding fan‑out reads on its video detail page by introducing a Redis‑backed business‑association index and a generic Data Aggregation Gateway, which together cut downstream service traffic and load by over 90% while simplifying aggregation across multiple terminals and scenarios.
BFFBackendIndexing
0 likes · 13 min read

This article walks through a real‑world Pandas grouping problem, showing how to aggregate song and actor data, concatenate song IDs with commas, and sum tags, providing clear code examples and explanations to help Python learners solve similar data‑processing challenges.
Code TutorialPandasPython
0 likes · 3 min read

An experienced data practitioner shares a concise pandas tutorial that shows how to recompute column aggregates after grouping, using a flexible function that applies arithmetic operations like addition, subtraction, multiplication, or division to the grouped results.
PandasPythondata aggregation
0 likes · 6 min read

The Xianyu fan‑tag system solves the challenge of displaying full‑history purchase counts with real‑time updates and low‑latency, high‑throughput queries by daily exporting multi‑system data to a LevelDB‑based KV store, converting schemas, and applying real‑time compensation from transaction and follow‑change messages, merging offline and live data to produce sorted fan lists at ~10 k QPS.
KV storagedata aggregationhigh QPS
0 likes · 6 min read

The article explains how to define, collect, and calculate effective reading duration and screen count for mobile app H5 content using event timestamps, formulas, fragment reporting, and aggregation methods to improve content quality analysis and visualization.
Mobile Appdata aggregationevent tracking
0 likes · 9 min read

This tutorial shows how to use Citus, a distributed PostgreSQL extension, to ingest immutable HTTP event logs, shard them by site_id, create real‑time and pre‑aggregated tables, schedule roll‑up jobs, handle data expiration, estimate distinct counts with HyperLogLog, and store unstructured JSONB counters for a low‑latency analytics dashboard.
CitusHyperLogLogJSONB
0 likes · 16 min read

Baidu’s advertising platform computes high‑precision response‑time quantiles at massive scale by intercepting each API call, locally summarizing data with mergeable T‑Digest histograms, periodically uploading compressed, Base64‑encoded summaries to a warehouse where they are merged on demand, enabling low‑latency, cost‑effective percentile analysis with sub‑0.1% error.
Quantiledata aggregationmonitoring
0 likes · 11 min read

This article explains how a user‑behavior data dashboard originally built on a daily T+1 batch process was redesigned to achieve real‑time T+0 updates by introducing message‑queue notifications, a dedicated aggregation service, and MongoDB storage, improving data freshness and user experience.
Backend ArchitectureMongoDBdata aggregation
0 likes · 5 min read

The article presents a real‑time quantile solution using the TDigest data structure, which clusters data into centroids and stores digests in Redis or Doris, pre‑computes quantiles for all dimension combinations, and provides a reusable API that delivers fast, accurate, low‑memory quantile statistics for diverse business scenarios.
Dorisdata aggregationreal-time quantile
0 likes · 11 min read

The article describes a backend‑for‑frontend architecture that pushes GraphQL into the BFF layer, separates fetch and display units, drives execution with metadata, unifies query models, applies caching and parallel processing optimizations, and demonstrates over 50 % logic reuse and doubled development efficiency in production.
BFFGraphQLPerformance Optimization
0 likes · 35 min read

The article presents a general solution that streamlines daily business issue diagnosis by aggregating multi‑service data via GraphQL, converting it into human‑readable semantics, and automatically detecting anomalies with a rule engine, enabling one‑click retrieval, reduced hand‑offs, and extensible monitoring for platforms such as Xianyu.
AutomationGraphQLQLExpress
0 likes · 10 min read

The article examines the key challenges of real‑time data aggregation—data freshness, timely processing, and result visibility—and surveys common solutions such as timestamp‑based sync, CDC, full and incremental computation, storage formats, and trigger mechanisms.
CDCIncremental Computationbig data
0 likes · 11 min read

Hawkeye, iQiyi’s self‑developed front‑end monitoring platform, unifies exception, performance and behavior tracking, automatically aggregates events with unique error IDs, isolates business‑type alerts via configurable codes, links front‑end and back‑end traces through Trace IDs, and leverages a JSSDK, backend services, big‑data stream processing and storage in Redis, Elasticsearch and HBbase, with future plans for small‑program SDKs, wider framework support and open‑source release.
Architecture DesignBusiness IsolationError Tracking
0 likes · 9 min read

InfoSpider is an open‑source Python‑based web‑scraping toolbox that securely aggregates personal data from over 24 sources—including email, e‑commerce, and social platforms—provides a GUI for easy operation, stores results in JSON, and offers basic visual analysis, making personal data integration and insight generation straightforward.
AutomationOpen SourcePython
0 likes · 12 min read

This article explains the end‑to‑end process of designing, implementing, and visualizing a quality‑measurement system that aggregates department, application, and individual data, defines evaluation methods, and uses offline Hive calculations to deliver fast, flexible dashboards for software quality improvement.
DashboardR&D managementdata aggregation
0 likes · 10 min read

The article explains how MySQL multi‑source replication can be employed to back up, horizontally or vertically partition, and merge data from several servers into a single target database, illustrating three typical scenarios and providing example SQL for data consolidation.
Multi-Source ReplicationVertical Partitioningdata aggregation
0 likes · 5 min read

The article details Youku’s new media‑asset platform, which replaces a fragmented MySQL‑based system with a domain‑driven entity model stored in Ali‑HBase, leverages Elasticsearch for flexible front‑and back‑end search, and adds an aggregation layer that unifies diverse data sources and reusable computation tasks, delivering high‑availability, low‑latency service for billions of daily API calls.
ElasticsearchStoragedata aggregation
0 likes · 9 min read

Xianyu introduced a lightweight data‑aggregation service and adopted Alibaba’s TQL GraphQL gateway, allowing front‑ends to fetch multiple domain data in a single request, which cut development costs by over 50%, reduced latency, and accelerated page composition across more than 30 pages.
Frontend DevelopmentGraphQLPerformance Optimization
0 likes · 11 min read

This article explains how the data aggregation platform adopts Apache Flink for high‑throughput, low‑latency stream processing, covering the complete workflow from data source integration, transformation operations, windowing and time concepts, to a concrete order‑count example with custom aggregation logic.
Apache FlinkEvent TimeFlink
0 likes · 10 min read

This article details the design and operation of a high‑concurrency hotel quote search platform, covering business background, core functionalities, system layers, data fetching, aggregation, scheduling, and price‑update mechanisms to ensure comprehensive, real‑time hotel pricing for users.
Backenddata aggregationhigh-concurrency
0 likes · 10 min read


21CTOMay 27, 2018 · Big Data
This guide walks you through downloading and configuring Elasticsearch 5.6.9, setting system limits, creating indices, inserting and deleting documents, executing complex aggregation queries via HTTP, and integrating Elasticsearch with Java using the Transport client for powerful data analysis.
ElasticsearchJavadata aggregation
0 likes · 13 min read

This article walks through installing Elasticsearch 5.6.9, configuring system limits, creating indices, inserting and deleting documents, executing complex aggregation queries, and integrating Elasticsearch with Java using the TransportClient, providing a practical guide for building analytics on large‑scale data.
AnalyticsElasticsearchbig data
0 likes · 12 min read

The seminar provides professionals with a comprehensive deep dive into Spark’s aggregation mechanisms, examining memory overhead, performance bottlenecks, and practical optimization techniques for large‑scale distributed data processing, enabling attendees to tackle real‑world big‑data challenges more efficiently.
OptimizationSparkTechnical Seminar
0 likes · 1 min read

The article shares practical experiences from large‑scale mobile client development, covering user crash scenarios, non‑intrusive data collection, AOP‑based interaction and network monitoring, performance instrumentation, and data aggregation techniques to improve debugging efficiency and operational reliability.
AOPclient architecturedata aggregation
0 likes · 9 min read

This article explains how to count paid and unpaid orders per user‑product pair in PostgreSQL by aggregating order statuses into arrays, using a sub‑query with GROUP BY and a CASE expression to produce accurate payment success and total order counts.
PostgreSQLSQLdata aggregation
0 likes · 4 min read
