Make use of Cassandra 3.x materialised views instead of duplicating data

[Mert-Z]

That will avoid so many inserts on multiple tables and decrease the risk of having stale/unsync data between tables. On the other hand this will require migration of existing data to the new schema which can be costly.