Yahoo strategy: aggregation, AI search Scout and advertising DSP platforms https://sudonull.com/yahoo-strategy-aggregation-ai-search-scout-and-advertising-dsp-platforms
How Yahoo returns to the roots of content aggregation, launches AI search engine Scout and focuses on DSP for advertising. Strategy analysis for IT audience.
Three Data Aggregation Errors in BI Systems https://sudonull.com/three-data-aggregation-errors-in-bi-systems
Learn why BI systems lie: mathematical errors in averaging, count distinct, and snapshot metrics. How to build analytics without distortions.
Robotaxi Safety During Pedestrian Aggression https://sudonull.com/robotaxi-safety-during-pedestrian-aggression
Waymo Passenger Lock-in Incidents Due to Vandals. How Autonomous Driving Systems React to Threats and What to Do. Analysis of Real Cases for Developers.
SummingMergeTree and AggregatingMergeTree in ClickHouse https://sudonull.com/summingmergetree-and-aggregatingmergetree-in-clickhouse
Incremental aggregation in ClickHouse: how SummingMergeTree and AggregatingMergeTree speed up dashboards by 100 times. Examples, materialized views, pitfalls, and comparison.
ClickHouse Materialized Views: triggers on INSERT https://sudonull.com/clickhouse-materialized-views-triggers-on-insert
How MV work in ClickHouse: incremental aggregation, chains minute→hour→day, Null+Kafka pattern, POPULATE and its dangers. Examples with SummingMergeTree and AggregatingMergeTree.