This article explains fact tables in data warehousing, covering their definition, granularity, additive classifications, null handling, consistency rules, and the various types such as transaction, snapshot, cumulative, fact‑less, and aggregate tables, along with design trade‑offs and ETL considerations.
This article explains the principles behind timestamp design, compares absolute and relative time formats, discusses granularity levels, and offers practical guidelines for applying timestamps effectively across various product scenarios to improve user perception and business outcomes.
The article explains software engineering’s first‑principle laws—software is a virtual product that can only be created once—critiques waterfall, advocates agile and DevOps, and emphasizes granularity and decoupling (including Infrastructure as Code) as essential practices for modern development.
This article explains how to write high-quality, maintainable frontend code by exploring component abstraction, granularity, design principles, and classification—from atomic to page-level components—illustrated with React and Vue examples, code snippets, and practical guidelines for balancing reuse and complexity.
This article explains the concept of granularity in data warehouse design, describing data models composed of structures, operations, and constraints, illustrating how granularity affects storage detail, query performance, and resource consumption, and recommending a dual‑granularity approach to balance efficiency and analytical depth.
This article records Xu Lei's online DevOps talk, outlining his ten‑year journey, emphasizing the importance of managing granularity and engineering decoupling, and providing practical strategies, agile insights, continuous delivery frameworks, Docker benefits, and a Q&A to help teams improve software delivery efficiency.
