Yes exactly. Piecing together the state of all the foreign tables across the system at a specific point in time is difficult/painful. This is one place where

Yes exactly. Piecing together the state of all the foreign tables across the system at a specific point in time is difficult/painful. This is one place where document stores really shine as you generally keep everything in a single place. When you update a document you don't have to worry about the values of all the foreign keys, you just save the current version which contains all your values.