Part 87: Bill of Materials (BOM) & Graph Traversal with Recursive CTEs

Calculating total parts and costs across nested product assembly graphs.

1. The BOM Problem

A Bicycle contains a Wheel Assembly, which contains a Rim and 32 Spokes. Recursive CTEs calculate the multiplied quantities down through all component layers.

Key Takeaways

• Recursive CTEs model real-world manufacturing bill-of-materials and dependency graphs.

In Part 88, we explore Generating Number and Date Series with Recursive Queries!