When importing relational data in to Couchbase , should each table corresponds to a bucket. I ask because older documentation recommends minimizing the number of buckets and keep multiple document types together and use a type attribute to differentiate between. The tutorials I’ve see for using N1QL have one bucket for each entity which makes joining documents easier.
Imagen importing employee and department data when the employee has a dept_id foreign key. Should employees and departments be in separate buckets? Or should I put them in the same bucket and give them type attributes with keys like emp_id_1 and dept_id_2 which doesn’t seem to work as well with N1QL.