Geek asks and answers

Heterogeneous database connection

I am a student, a specialist in database management. In my 5th semester, we need to create a system using a heterogeneous database. We must use at least 4 different databases. My choices would be MySQL, MS SQL Server, Oracle, and PostgreSQL, as they are some of the most popular and mature databases.

The problem is that so far no group has been able to connect to 4 different databases. I heard that using Java hibernate spring may connect to a different database, but I'm trying to connect to a different database at the database level and not at the application level. Using something like an Oracle database link. But as far as I know, MySQL does not have this function.

If in the industry, what are the common ways to work with a heterogeneous database? Or is there some kind of standard library for me? I hope to get some guidance on how to handle a heterogeneous database using an industry standard

+5
source share
2 answers

Heterogeneous databases are a complex field, and there is a lot of research. You cannot wait for a solution out of the box. It is highly dependent on databases, schemas, security related data. To get started, read this article: A multi-database system as a distributed distributed heterogeneous database system with a 4-tier server

If you are free to choose a scenario, make your life as simple as possible:

  • JDBC ( , ORM).
  • ( ).
+2

, Wrapper. SQL . PostgreSQL , .

, .

0

More articles:


All Articles