To separate content object and the data by its location in the hierarchy?

It sounds probably not clear so I will explain:

Suppose we have a tree of comments (Nested Sets or something, in principle, not important). Whether to make a field not related directly to comments (lft, rgt, parent_id, etc.) in a separate database table? On the one hand, we get rid of the binding to a specific structure of the review (you can always change NS to MP or something else), and with another — have difficulty with the Union of these tables.
2 answers
October 10th 19 at 10:19
I think the question posed is wrong. The basis is a tree, not comments. IMHO, the tree is stored separately. For the above reason and further, you never know what else you want to stick in, it will be easier to do it with a clear wood than it. And the difficulty joyname there should be no...
I do not understand about the basics. The main goal is to keep the content (comments). And the trees are essentially metadata (method of storage) which are of special meaning are not, is registration. - jamil_Turcotte commented on October 10th 19 at 10:22
Although incorrectly question, I got excited... - Justyn.Champlin82 commented on October 10th 19 at 10:25
I do not understand about the basics.

Yes, I got excited, now just doing a project where a large nested set. Table in which nested sets more precisely. I have it is the basis, that somehow freaked out.
In General, I mean that, in practice, no problem, if you divide the entity. Joiny sometimes of course there are 10-12 tables, but there's that 10 that 20 is not important. Most importantly no problems with it. - Justyn.Champlin82 commented on October 10th 19 at 10:28
Table nested sets ie
Damn, sorry... Time to go home to sleep... - Justyn.Champlin82 commented on October 10th 19 at 10:31
October 10th 19 at 10:21
Only for reviews (or other similar objects are United in hierarchy), IMHO, is not only unnecessarily increase the complexity when it is necessary to change the structure, then change it, may not will need, and may need to make multiple hierarchies.

Another thing, if the United hierarchy of heterogeneous objects, or one object can be part of different hierarchies — there is definitely (if not, the question is denormalization with the aim of increasing performance) the objects separately of the hierarchy separately, can also metadata make sense to endure. In General, for hierarchy makes sense, IMHO, to look towards NoSQL.

Find more questions by tags Data structuresSearch engine optimizationAlgorithmsClient side optimization