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 |