Clever Geek Handbook

Metadata Views / Data Integration

Is there a (free) tool or framework that allows you to define views across multiple databases (preferably java and object based)?

For example, I have 2 databases: One database contains a table or class (doesn't really matter) PersonX (name, address) and the other contains PersonY (name, dateOfBirth)

Now I want to create a view that concatenates them in Person(name, address, dateOfBirth)

like (pseudocode):

Person(n, a, dob) :=
    Couple(x.name, y.name) as n, x.address as a, y.dateOfBirth as dob From PersonX as x outer join PersonY as y on (x.name = y.name)

But I not only want to see, but I also want to be able to do updates in the view that should delegate the changes back to the sources. This "Pair" keyword here should mean that the update in the Persion.name field should be delegated to both primary sources.

So from what I've seen about data integration, this is all about creating views of some kind, so my question is related to that, but I don't have much experience with this topic.

any help on this is appreciated - thanks :)

+1


source to share


1 answer


Some databases (such as Oracle) allow you to create "INSTEAD OF" triggers on views that convert inserts, updates, and deletions from DML views to underlying tables. Java is not involved, but this is good as it means the view can be used from any application.



+1


source






More articles:


All Articles