What are models for storing tree structures and what are their characteristics?

C:
   Temp
   Windows
       System32

Key     Name     Parent     Path
1       C:                  *1*
2       Temp       1        *1*2*
3       Windows    1        *1*3*
4       System32   3        *1*3*4*

WHERE Path LIKE '*1*2*%'