0

Exists: Several databases on different DBSM(Postgres, Mysql, Oracle, Firebird etc) Databases have several identical rows (ids, entities names)

The task: Execute read SQL query on the whole list of databases.

The question: Is there any known solution? May be there some kind of sql cache database or something like this exists already.

Any suggestions, ideas, keywords?

Thank you.

Spoonwalker Highwater
  • 411
  • 2
  • 9
  • Do you need to join across each database, or just have a means to dynamically connect and query? What programming language? – Spevy Oct 06 '12 at 20:42
  • I need join across each database and integrate result in SQL way. So the language is SQL or pl/SQL. If your say about language the such integrator is written i prefer C/C++ but it's not the main matter. – Spoonwalker Highwater Oct 07 '12 at 05:19
  • MS SQL Server has a concept of a linked server I think it is called "database Link" in Oracle. – Spevy Oct 07 '12 at 12:09
  • It seems the virtuoso can do such things, but it´s proprietary soft. I´ḿ looking for an open source. – Spoonwalker Highwater Oct 07 '12 at 17:21

0 Answers0