Published Jun 8, 2015

Hierarchical Data – Adjacency Lists and Nested Set Models

Dive into the world of hierarchical data with Coding Blocks, as they unravel the intricacies of adjacency lists and the Nested Set Model while offering performance tips and exploring the utility of Recursive Common Table Expressions (CTEs) for managing complex datasets.

Episode Highlights

Topics covered

Episode Highlights

Related Episodes

Data Structures - (some) Trees
Answers 383 questions
95. Data Structures – Arrays and Array-ish
Answers 383 questions
Data Structures - Heaps and Tries
Answers 383 questions
94. Data Structures - Primitives
Answers 383 questions
Data Structures - Arrays and Array-ish
Answers 383 questions
Designing Data-Intensive Applications – Scalability
Answers 383 questions
Designing Data-Intensive Applications - SSTables and LSM-Trees
Answers 383 questions
Graph Algorithms
Answers 383 questions
All Your Database Are Belong to Us
Answers 383 questions
Designing Data-Intensive Applications – Data Models: Query Languages
Answers 383 questions
Strategic Design and Domain Events
Answers 383 questions
Designing Data-Intensive Applications – Multi-Leader Replication
Answers 383 questions
Design Patterns Part 3
Answers 383 questions
Understanding Complexity Theory
Answers 383 questions
Designing Data-Intensive Applications - Data Models: Relational vs Document
Answers 383 questions

Dexa/Coding Blocks

Hierarchical Data – Adjacency Lists and Nested Set Models

Topics covered

Popular Clips

Big O Notation Tips

Recursive CTE Insights

Family Tree Values

Data Management Strategies

Polls and Surveys

Efficient Table Management

Data Integrity Challenges

Cube Visibility Solutions

Code Under Pressure

Efficient Data Querying

Data Modeling Techniques

Data Lakes and Code

Tree Structure Complexity

Resharper Struggles

Episode Highlights

Technical Insights

Adjacency Lists

CTEs and Queries

Nested Set Model

Related Episodes

Data Structures - (some) Trees

95. Data Structures – Arrays and Array-ish

Data Structures - Heaps and Tries

94. Data Structures - Primitives

Data Structures - Arrays and Array-ish

Designing Data-Intensive Applications – Scalability

Designing Data-Intensive Applications - SSTables and LSM-Trees

Graph Algorithms

All Your Database Are Belong to Us

Designing Data-Intensive Applications – Data Models: Query Languages

Strategic Design and Domain Events

Designing Data-Intensive Applications – Multi-Leader Replication

Design Patterns Part 3

Understanding Complexity Theory

Designing Data-Intensive Applications - Data Models: Relational vs Document

Hierarchical Data – Adjacency Lists and Nested Set Models

Topics covered

Popular Clips

Episode Highlights

Technical InsightsThe hosts of Coding Blocks share valuable performance tips and tools for developers. They discuss resources like Big O Cheatsheet, .NET Native, and the pros and cons of Resharper.

Technical Insights

Adjacency ListsThe hosts of Coding Blocks explore hierarchical data management, focusing on adjacency lists and their practical applications. They discuss the simplicity and challenges of this model, providing real-world examples and insights.

Adjacency Lists

CTEs and QueriesThe team explores the utility and limitations of Recursive Common Table Expressions (CTEs) in managing hierarchical data. They delve into advanced querying techniques and the challenges of maintaining data integrity in complex datasets.

CTEs and Queries

Nested Set ModelThe hosts explore the Nested Set Model, a method for managing hierarchical data. They discuss its structure, practical applications, and the challenges it presents.

Nested Set Model

Related Episodes