I'm thinking of creating referenced documents instead of embedded because I have a database in which an airplane has flights and flights have airports. Anyone experienced that could indicate the best option?
Imagine that I choose the referenced, the reference would be the foreign key in a relational database, ie just export the mysql JSON document with the secondary keys and just load it for the right collections? the references are not necessarily linked in the system, it's just an id that's there if you need a query for what I realized right? As my goal is a comparative study with mysql I have to make similar queries and take time but I've already seen that with referenced documents I had to do more than one query, is that so?
In relation to embedded already I researched and I can not understand how I will load different JSON and point out that it is contained within another one.
This is for mongodb. Regarding the couchdb does anyone know how this reference between collections is made? so I read it is not as trivial as in mongodb.