BestHub
Sign in
Tagged articles
8 articles
Page 1 of 1
Xiaokun's Architecture Exploration Notes
Xiaokun's Architecture Exploration Notes
Mar 29, 2025 · Databases

Exploring Data Models: From Hierarchical to Graph and Schema-on-Read/Write

This article examines the evolution of data models—from conceptual, logical, and physical layers to hierarchical, network, relational, document, and graph structures—explaining their characteristics, implementation examples, and the contrasting schema‑on‑read versus schema‑on‑write approaches for modern data storage systems.

data modelingdatabasesgraph database
0 likes · 10 min read
Exploring Data Models: From Hierarchical to Graph and Schema-on-Read/Write
IT Architects Alliance
IT Architects Alliance
Jan 13, 2023 · Databases

Database Design Fundamentals: Key Concepts, ER Diagrams, and Normal Forms

This article explains fundamental database design concepts, including candidate and primary keys, attributes, relations, ER diagram components, and detailed descriptions of the first, second, third, and BC normal forms with examples and how to resolve insertion, deletion, update, and redundancy anomalies.

Database designER Diagramdata integrity
0 likes · 9 min read
Database Design Fundamentals: Key Concepts, ER Diagrams, and Normal Forms
JavaEdge
JavaEdge
Jun 10, 2022 · Databases

Why Choosing the Right Data Model Matters: Relational vs Document vs Graph

This article explains how different data models—from relational tables to JSON documents and graph structures—affect software design, storage, querying, and scalability, illustrating concepts with a resume example and discussing trade‑offs such as impedance mismatch, normalization, and multi‑entity relationships.

JSONNoSQLORM
0 likes · 14 min read
Why Choosing the Right Data Model Matters: Relational vs Document vs Graph
Programmer DD
Programmer DD
Oct 12, 2020 · Databases

Mastering Set-Based SQL: From Relational Theory to Practical Queries

This article explains the relational model, its data structures, set-oriented operations, and integrity constraints, then demonstrates core SQL clauses such as SELECT, WHERE, GROUP BY, UNION, INTERSECT, EXCEPT, and various JOIN types with clear examples and diagrams.

GROUP BYJOINSQL
0 likes · 12 min read
Mastering Set-Based SQL: From Relational Theory to Practical Queries
ITPUB
ITPUB
Jan 27, 2018 · Databases

Why NewSQL Matters: From Relational Roots to Modern HTAP

This article traces the evolution of database systems—from early navigational models and Codd's relational theory through the rise of NoSQL and sharding, to the resurgence of NewSQL and the emerging HTAP paradigm—highlighting technical motivations, design trade‑offs, and future directions.

HTAPNewSQLSQL
0 likes · 21 min read
Why NewSQL Matters: From Relational Roots to Modern HTAP
Architect
Architect
Nov 30, 2015 · Databases

A Historical Overview of Database Models: From Hierarchical to Relational and Beyond

This article traces the evolution of database models—from early hierarchical and network structures through the relational revolution and entity‑relationship diagrams to modern distributed and multi‑tenant designs—highlighting key concepts, technical challenges, and the theoretical foundations that shaped today’s data storage systems.

Hierarchical Modeldata modelingdatabase
0 likes · 27 min read
A Historical Overview of Database Models: From Hierarchical to Relational and Beyond