Hi All,
For a DMS, I want to replace MySQL with Cassandra to store file/folder nodes.
Current I use adjacency list model to stores nodes hierarchy. The shortage of
the adjacency list model is the expensive traversal cost. While I want to
navigate the entire workspace or folder in hierarchy, I have to execute
multiple queries (for each sub folder). In addition, special care must be taken
when deleting nodes because of the potential for orphaning an entire sub-tree
in the process (delete a folder and all of its children may be orphaned). How
to design to store files/folders'node as tree structure in Cassandra?
Thanks,
-Brink
