Lists Home |
Date Index |
Thomas B. Passin <firstname.lastname@example.org> writes:
> For example, it is easy to model a two-level hierarchy in
> SQL, but it is awkward to model (and query) a hierarchy of an
> indefinite number of levels. So when the data model is deeply
> hierarchical, xml structures might have an advantage.
There are standard methods for modeling any finite hierarchy in SQL; the
limitations on depth have more to do with update time than to do with
the model. Many SQL implementation also support some form of recursive
query (as repulsive as that may be to the purists).