...
In Link 3 all data is divided into two three databases:
Configuration
Transactional
BackupFiles
The Configuration database holds configuration data such as partners, distributions and all the developer objects. Whereas the Transactional database and BackupFiles databases holds data generated by the flow such as interchanges and documents, documents and their associated raw files.
Although these entities are related across databases by id’s, there are NO database constraints enforcing the data consistency.
...
In many cases when updating multiple entities, it makes sense to join these updates in a database transaction. This gives you the possibility to roll back ALL changes if one of them fails.
...