DZone
For some reason, data is sometimes divided into segments to be stored in different databases. This will involve mixed cross-database computing. There are various methods based on different theories for handling such a computation. Now let’s look at them through the aspects of coding design, deployment and configuration, and computing performance.
1. DBLink
Since Oracle DBLink handles cross-database computations using Oracle SQL, it generates simple and easy-to-understand code.
Source: DZone