Tagged articles

database theory

2 articles · Page 1 of 1

Apr 14, 2021 · Databases

Unlocking the Secrets of Data Anomalies: Tencent’s Groundbreaking Database Research

Tencent Cloud's TDSQL team systematically proves that data anomalies are infinite, defines them formally, classifies them into three core types and detailed sub‑types, and releases an open‑source mini‑program for precise detection, advancing concurrency control theory and practice.

TDSQLdata anomaliesdatabase theory

0 likes · 6 min read

Unlocking the Secrets of Data Anomalies: Tencent’s Groundbreaking Database Research

Aikesheng Open Source Community

Dec 26, 2019 · Databases

Database Design: From ER Modeling to Normalization

This article explains the importance of good database design, walks through the stages of building an ER conceptual model, shows how to map entities, attributes, and relationships to relational schemas, and demonstrates how normalization (1NF, 2NF, 3NF, BCNF) improves schema quality using practical examples.

Data ModelingDatabase DesignER Modeling

0 likes · 17 min read

Database Design: From ER Modeling to Normalization