Developing virtual databases

The data virtualization journey comes down to developing a set of virtual databases and interconnecting them to client applications. In this section, we will cover both creation of and connection to a virtual database thrown from a practical business use case.

Business case

Client: Hello JBoss Doctor, regarding the Beosbank money transfer database, following connectivity issues from some countries, high loads, and various regulatory and business needs, we decided to have two separate databases for the EMEA regions. The beosbank-africa database is used for all our customers in Africa; this database runs on a cluster. MySQL is in South Africa and holds all the transactions sent from Africa. On the other hand, for European customers, due to European Union regulations on customer data privacy and backup policies, management decided to keep this database in Europe. This database runs on Postgres and only keeps the details of transactions sent by customers from a European...