Given a Database D, i need to distribute it over different DBMS in a LAN. D will be split into tables, and each DBMS will store a given table. Here is a sketch of what i need to do :
I also need to query this "cluster" in a transparent way : if Client1 queries the MySQL DB for Table2, he should get it without knowing where Table2 is stored. This also need to take care of update and insert statements.
I've seen that i could use FWD : Foreign Data Wrapper, but i think this work in a one way only, and doesn't support data modification statements. Same for ODBC drivers, i'm not sure if they can work in a DBMS <-> DBMS way.
Is there any know solution for my Distributed Heterogeneous Database problem ?