I have a tree like the graph and I need to store them in the database how efficiently the article is stored in the SQL database Looking for more query information.
The tree graph can be stored using a hierarchy, "Nested Set Model" Very good articles will give. Nested set model allows walking of trees without sequential questions.
The name of the more general approach is "Impact List Model", this approach requires recurring or DBMS specific extension for SQL.
The advantage of the proximity list is in fast and easy updates. The benefits of nested sets are in simple questions.
Comments
Post a Comment