Use Cassandra for adserver both master and analytical data -


hi planning use cassandra ad server implementation. have req client can create advertisers publishers , new ads sort of typical relational req interface monitor analytical data ad hits, conversion etc. needs interface client able apply filters based on master fields such name, location etc. based on analytical data ad revenue > x , similar other criterias quite few in nos.

is ok use single databases cassandra maintain both types of data. cassandra has limited querying capacity on fields unless u create views n index skeptical. if keep 2 seperate databases products complicate , add additional redundancy. how companies such facebook, linkedin accounting both master , analytical data req. suggestions appreciated. thx

the typical solution in cassandra have multiple datacenters - 1 online transaction processing, , spark analytical queries. different datacenters allow query them independently spark doesn't impact production. alternatively can denormalize , insert multiple tables using 'batch'


Comments

Popular posts from this blog

Sort a complex associative array in PHP -

vb.net - How to ignore if a cell is empty nothing -

recursion - Can every recursive algorithm be improved with dynamic programming? -