Example of materialized path data
Main trick in materialized path method (to store tree like data) is path column. Item with path 1.1.1 is child of item with path 1.1
In this series of articles we will take a look at implementation of this method in SQL. Here is a tree stored using this method:
| name | path |
| level1 | 1 |
| level1.1 | 1.1 |
| level1.1.1 | 1.1.1 |
| level1.1.1.1 | 1.1.1.1 |
| level1.1.1.2 | 1.1.1.2 |
| level1.1.1.3 | 1.1.1.3 |
| level1.1.2 | 1.1.2 |
| level1.1.2.1 | 1.1.2.1 |
| level1.1.2.2 | 1.1.2.2 |
| level1.1.2.3 | 1.1.2.3 |
| level1.1.3 | 1.1.3 |
| level1.1.3.1 | 1.1.3.1 |
| level1.1.3.2 | 1.1.3.2 |
| level1.1.3.3 | 1.1.3.3 |
| level1.2 | 1.2 |
| level1.2.1 | 1.2.1 |
| level1.2.1.1 | 1.2.1.1 |
| level1.2.1.2 | 1.2.1.2 |
| level1.2.1.3 | 1.2.1.3 |
| level1.2.2 | 1.2.2 |