I would like to go from an anchor model which has only( anchor, knot, tie and attributes) to physical model. i'm working on column oriented database, i'm using cassandra database.
Anyone has any document or any idea that could help me throught this passage ?
Anchor modeling isn't compatible with data modeling in Cassandra.
Unlike relational databases, tables in Cassandra are denormalised. You start to model your data by identifying all the application queries then design a table for each query so that reads are very fast since there are no foreign lookups and no joins -- all the data you need to satisfy a query are contained within one table.
If you're interested, we have a free hands-on tutorial for Cassandra Data Modeling here -- https://www.datastax.com/dev/modeling. Cheers!