I'm looking for help/guidance on building the appropriate model in Cassandra ...
I have a collection of items I need to store in Cassandra. Each item can be in ore or more packages. Each package again can be in one or more other packages. The structure of the data can change frequently. The following queries will be executed on this data and thus need to be as efficient as possible (preferably one singled get operation):
- What are the immediate "children" of a certain package (items and other package)? This is one level deep in the structure
- Is a certain item part of a certain package?
- Is a certain item part of one package in a list of packages?
- What are all the items in a package (full recursive)? --> not the most important query, so willing to accept lower performance for this one.
Changing data can be a bit more time and resource intensive but not too much.
I'd appreciate all help to get to a scalable and efficient Cassandra data model.
Not sure if it matters, but I use Astyanax for accessing Cassandra.