Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!postnews.google.com!p24g2000vbl.googlegroups.com!not-for-mail
From: OSteine <osteine@gmail.com>
Newsgroups: comp.databases.theory
Subject: Merging/mapping and or integrate on database level
Date: Thu, 3 Mar 2011 00:07:10 -0800 (PST)
Organization: http://groups.google.com
Lines: 23
Message-ID: <96c6703d-72fc-42e9-b5c3-1a2e9502aa57@p24g2000vbl.googlegroups.com>
NNTP-Posting-Host: 213.161.247.15
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1299139630 25815 127.0.0.1 (3 Mar 2011 08:07:10 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 3 Mar 2011 08:07:10 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: p24g2000vbl.googlegroups.com; posting-host=213.161.247.15; posting-account=htlxdwoAAACpJ9n2ay4GKRiManbkb3rZ
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; nb-NO; rv:1.9.2.10)
 Gecko/20100914 Firefox/3.6.10,gzip(gfe)
Xref:  news.cambrium.nl

I've got the following scenario:

Two applications with their own database needs to be integrated on
some common basic data (let's say person data). When the ApplicationA
enters a new users, this user should also be available in
ApplicationB.

Using a replication method, I've completed the flow of data between
the databases, so that all tables are available in the database schema
for ApplicationB.

personA [id_person {int}, sur_name {varchar40}, last_name{varchar40}]
- table definition
personB [id {char10}, fullname{varchar60}, lastname{20}, surname{40}]
- table definition

What would be the best approach to share the data between the two
application?

1. Adjust (if possible) ApplicationB to use the personA table?
2. Use a interface table int_person which may be used to map and
distribute data between the tables
3. Other solutions???