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