I need to model one of my RDBMS table in couchbase
Columns: customer_id, country_id, interval_end_time, unique_user_identifier
Basically this table keeps unique users id for each hour from each country associated to each customer. And my read request could be
1. Get number of distinct user for x customer group by country in certain time frame. Query will never be across customer.
My question are as follows
1. Is there any schema normalization will be fruitful in this case?
2. Can we create data bucket on runtime? So that store each customer data in different bucket. Will it boost any performance?
3. Can we segragete each customer data so that get response is optimized?
I will appriciate any help.