Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 : Distribued Database

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 ?

share|improve this question

closed as off-topic by RolandoMySQLDBA, Max Vernon, Mark Storey-Smith, Michael - sqlbot, Kin Apr 10 '14 at 16:11

This question appears to be off-topic. The users who voted to close gave these specific reasons:

  • "Tip of the iceberg - the question or comments reveal an underlying issue that would need extensive investigation by a consultant or database vendor support team: issues like this do not fit the SE Q&A model well. For more information see this meta post." – RolandoMySQLDBA, Mark Storey-Smith, Kin
  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Max Vernon, Michael - sqlbot
If this question can be reworded to fit the rules in the help center, please edit the question.

We are using Enterprise Service Bus (ESB) for such purposes. We have Oracle, MS SQL, MySQL, 1C, Pentaho BI and so on. – newbie Mar 23 '14 at 12:53
Why on earth would you want to do that? This sounds like an absolutely crazy thing to do. – Craig Ringer Mar 23 '14 at 13:14
Look into Denodo. I agree with @Craig, though. I don't think I'd ever intentionally design an architecture like this. – swasheck Mar 23 '14 at 13:27
That's an assignement for the Distributed Databases classes. I'm sure that seems crazy ! – SkyDoom Mar 23 '14 at 15:16