Skip to content

Integration from 2 databases

Jump to bottom
Jérôme Beau edited this page Mar 5, 2018 · 4 revisions

This sample show how data from 2 online databases can be integrated into a single meta model.

Scenario 1 : build the meta-model from the available data

This scenario is about the automatic building of a meta-model from the structure of data found in available databases.

  1. Define the UUDF schema for each database
  2. base 1 :
&lt;schema&gt;<br>
&nbsp;&nbsp;&lt;class name=&quot;Sighting&quot;&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;field name=&quot;year&quot;/&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;webpage url=&quot;http://rr0.org/{fieldValue}.html&quot;/&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/field&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;field name=&quot;month&quot;&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;in-field name=&quot;year&quot; &gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/in-field&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/field&gt;<br>
&nbsp;&nbsp;&lt;/class&gt;<br>
&nbsp;&nbsp;&lt;sighting&gt;<br>
&lt;/schema&gt;
  1. Define the UUDF mapping from each database to the meta-model.

Scenario 2 : map to a predefined meta model

This "meet-in-the-middle" scenario illustrates the case where a meta model has been pre-defined by the user. This is likely to be the most common case, as it is not practicable to maintain processes on a continouously-varying meta-model. Hence, even if such a use case could have started as a "bottom-up" case, it will more likely evolve in the present meet-in-the-middle case, where we have to map to static models.

  1. Define the UUDF schema for the meta model
  2. Define the UUDF schema for each database
  3. Define the UUDF mapping from each database to the meta-model
Clone this wiki locally