This guide walks through two methods for using PowerDesigner to reverse‑engineer existing database tables into a PDM file, detailing the recommended step‑by‑step UI workflow and an alternative approach that may not work across all versions.
This article explains the role of dimension tables in data warehouses, compares natural and surrogate keys, and details three strategies—overwrite, insert new rows, and add new attributes—for managing slowly changing dimensions, including full‑snapshot tables.
This article presents PDMan, a lightweight open‑source database modeling tool that simplifies schema design, supports automatic code generation for MySQL, Oracle and Java, offers version management, and provides step‑by‑step instructions for installation and usage to boost development efficiency.
DeWu chose the open‑source time‑series database TDengine to store billions of daily Sentinel flow‑control metrics, using a super‑table design with per‑resource tables, a three‑node cluster, Druid/MyBatis pooling, and raw‑SQL writes, achieving 10 ms batch write latency, sub‑millisecond queries, and 90 % compression.
The article reflects on the parallels between urban planning and software design, critiques the pitfalls of unplanned legacy systems, outlines a typical three‑layer development workflow, and introduces domain‑driven design concepts as a disciplined approach to building maintainable backend architectures.
