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
Post a Comment