Joins are the simplest way to fetch data from different sources. The moment we can't use them (due to microservices), the other solutions involve eventual consistency which can be tricky to handle. The trade-offs should be considered.
Very good article. One way to use option 3 (batch data sync) in a systematic way in a corporation is by using the Data Mesh model. It is quite challenging to implement, but once the main services are ready, it starts to generate benefits quickly for the organization.
Nice explanation Raul.
Joins are the simplest way to fetch data from different sources. The moment we can't use them (due to microservices), the other solutions involve eventual consistency which can be tricky to handle. The trade-offs should be considered.
Thanks for the mention as well!
Spot on, Saurabh. Thanks!!!
Very good article. One way to use option 3 (batch data sync) in a systematic way in a corporation is by using the Data Mesh model. It is quite challenging to implement, but once the main services are ready, it starts to generate benefits quickly for the organization.