real-time deduplication

Qunar Tech Salon

Jul 11, 2017 · Databases

Applying PostgreSQL GIN Index for Real‑Time Deduplication, Precise Advertising, and TOB Profiling at Alibaba

The article presents several large‑scale Alibaba use cases—real‑time deduplication of shopping‑guide articles, precision ad targeting, TOB real‑time profiling, arbitrary field combination queries, and fuzzy matching—demonstrating how PostgreSQL’s array types, GIN indexes and pg_trgm extensions enable millisecond‑level responses on billions of records.

Database OptimizationGIN indexPostgreSQL

0 likes · 20 min read

Applying PostgreSQL GIN Index for Real‑Time Deduplication, Precise Advertising, and TOB Profiling at Alibaba

Efficient Ops

Jul 9, 2017 · Databases

How Alibaba Scales Real‑Time Deduplication and Targeted Ads with PostgreSQL

This article explains how Alibaba Cloud leverages PostgreSQL’s GIN indexes, array types, and pg_trgm extension to achieve real‑time deduplication of massive guide articles, precise ad targeting, TOB profiling, arbitrary field combination, and fuzzy matching, delivering millisecond‑level latency while drastically reducing hardware requirements.

GIN indexPostgreSQLTOB profiling

0 likes · 18 min read

How Alibaba Scales Real‑Time Deduplication and Targeted Ads with PostgreSQL