It’s good to use Nested Sets for hierarchical data. But in this design, you should always calculate the right and left nodes if you are deleting or inserting some data. In addition, you do not have any additional keys.
How can I reflect this model with JPA ?? Is it possible?
I think you still want PARENT_ID, even with RIGHT and LEFT, otherwise the parent / child queries will be inefficient, or I'm not even sure.
RIGHT LEFT, /, PrePersist/PreUpdate/PreRemove.
, . allChildren, ManyToMany. node, .
- , CONNECT BY Oracle.
Source: https://habr.com/ru/post/1526155/More articles:Is it possible to parameterize the display name of the NUnit test case when using the `` Ticked names of methods ''? - f #How to implement a binary tree in matlab - matlabHow to remove child or parent objects from a relationship? - javaThe command to list all file types and their average size in the directory is unixWriting Unicode to a file using Python - pythonscrollViewTexturedBackgroundColor устарел в iOS 7.0 - iosIs it possible to show the progress on the page when downloading a file? - c #Video recording of portrait activity video - androidHow can I recursively print a list of files with file names less than 25 characters long using single line? - command-lineHow to navigate a user to log in when not logged in - dartAll Articles