HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Multi-database object-oriented proxy

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
proxymultidatabaseorientedobject

Problem

Do you know if there is a system/product/technique which would allow to "wrap" one or more relational databases into one object-oriented virtual database (or could we call it a "multi-database object-oriented proxy")?

Let me illustrate the principle:

So, basically, the pink thing in the middle (hereafter "object proxy") would contain definitions of business entities and their mappings to data in multiple relational databases. Applications would request or insert/update/delete data from the object proxy, which would magically synchronize with underlying relational databases.

Is that possible? Does such a system exist?

Solution

Do you mean products like InfoSphere Federation Server or WebSphere Federation Server? As variant it is possible, on my opinion, to use microsoft's implementation based on sql server partitioned tables and some ORM (Nhibernate or Entity Framework). And, of course: Cloud-based database solution

ADDED:

Maxim, please review this presentation (page #74): Not Only SQL (NOSQL) and you will find names of some non relational databases. it can help you, i think:

  • Hypertable



  • HBase



  • ..

Context

StackExchange Database Administrators Q#728, answer score: 4

Revisions (0)

No revisions yet.