Styjun

What do we gain with higher order logics?

What is the history of the check mark / tick mark?

What are they doing to this poor rocket?

How much water is needed to create a Katana capable of cutting flesh, bones and wood?

Movie where a boy is transported into the future by an alien spaceship

If Boris Johnson were prosecuted and convicted of lying about Brexit, can that be used to cancel Brexit?

Metal bar on DMM PCB

What are the words for people who cause trouble believing they know better?

Is it legal in the UK for politicians to lie to the public for political gain?

One End of Light Fixture Appears To Be Dead

How can I determine the spell save DC of a monster/NPC?

Adding extra constness causes compiler error

Word for a small burst of laughter that can't be held back

Pros and cons of writing a book review?

X-shaped crossword

Comma Code - Ch. 4 Automate the Boring Stuff

Can Green-Flame Blade be cast twice with the Hunter ranger's Horde Breaker ability?

It possible to have subscript and super script that does not shrink the font size?

What is the right way to float a home lab?

How can Iron Man's suit withstand this?

Did thousands of women die every year due to illegal abortions before Roe v. Wade?

Anatomically Correct Swarm of Rodents

How could a possessed body begin to rot and decay while it is still alive?

Is it a problem that pull requests are approved without any comments

How to structure database of an application that will utilize multiple datasources for its models?

How does database indexing work?How do I quickly rename a MySQL database (change schema name)?How to list the tables in a SQLite database file that was opened with ATTACH?How do I connect to a MySQL Database in Python?Database development mistakes made by application developersHow to get size of mysql database?How to get the sizes of the tables of a MySQL database?Database Best Practice with multiple similar entitiesHow to copy data between databases which has different table structures?Getting data from multiple databases with same tablenames in django

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I'm creating an application that will use at minimum two different API for data of its models. For example, I'll have an entity / model of a person. The data for this person comes at minimum two different API and more may be relevant in the future. For example, email and phonenumber may come from one data source and first name and second name from another.

How would one structure an database for this, that is flexible enough to handle adding / removing of the "data sources".

I initially though of an database structure looking like this:

[Person]
- ID
- FirstName
- LastName
- Email
- PhoneNumber

[Person_FIRST_SOURCE]
- Person_ID
- Person_FIRST_SOURCE_ID

[Person_SECOND_SOURCE]
- Person_ID
- Person_SECOND_SOURCE_ID

Which I then would be able to in the data synchronization script to look up what "Person" entity in my database, the current iterating person from the source represents. This would allow me to easily connect/add more sources as I go.

EDIT: I would like to add that it's not always that Person A exist within both sources of data.

EDIT 2: The main question is not really dependent on the "Person" model. This could have been any type of model; Book, School, Company etc. Just some form of model, where its data comes from multiple sources.

mysql database

share|improve this question

edited Mar 25 at 13:18

CookiePolicy

asked Mar 24 at 13:13

CookiePolicyCookiePolicy

11

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  What are you really trying to model? Things like "persons", or things more like "claims of facts about persons"?
  
  – Mike Sherrill 'Cat Recall'
  Mar 24 at 16:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @MikeSherrill'CatRecall' Well it's employees of an organization, really. But the main question is noy really depedent on the model. This could have been any type of model; Book, School, Company etc. Just some form of model, where its data comes from multiple sources.
  
  – CookiePolicy
  Mar 25 at 13:16
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  My question still stands. Your proposed structure says "One or more attributes of person having id 'n' came from source having id 'm'." So your proposed structure can handle any number of sources per person, but it doesn't seem very useful.
  
  – Mike Sherrill 'Cat Recall'
  Mar 25 at 18:34
  

  
  
  
  

add a comment | 

0

I'm creating an application that will use at minimum two different API for data of its models. For example, I'll have an entity / model of a person. The data for this person comes at minimum two different API and more may be relevant in the future. For example, email and phonenumber may come from one data source and first name and second name from another.

How would one structure an database for this, that is flexible enough to handle adding / removing of the "data sources".

I initially though of an database structure looking like this:

[Person]
- ID
- FirstName
- LastName
- Email
- PhoneNumber

[Person_FIRST_SOURCE]
- Person_ID
- Person_FIRST_SOURCE_ID

[Person_SECOND_SOURCE]
- Person_ID
- Person_SECOND_SOURCE_ID

Which I then would be able to in the data synchronization script to look up what "Person" entity in my database, the current iterating person from the source represents. This would allow me to easily connect/add more sources as I go.

EDIT: I would like to add that it's not always that Person A exist within both sources of data.

EDIT 2: The main question is not really dependent on the "Person" model. This could have been any type of model; Book, School, Company etc. Just some form of model, where its data comes from multiple sources.

mysql database

share|improve this question

edited Mar 25 at 13:18

CookiePolicy

asked Mar 24 at 13:13

CookiePolicyCookiePolicy

11

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  What are you really trying to model? Things like "persons", or things more like "claims of facts about persons"?
  
  – Mike Sherrill 'Cat Recall'
  Mar 24 at 16:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @MikeSherrill'CatRecall' Well it's employees of an organization, really. But the main question is noy really depedent on the model. This could have been any type of model; Book, School, Company etc. Just some form of model, where its data comes from multiple sources.
  
  – CookiePolicy
  Mar 25 at 13:16
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  My question still stands. Your proposed structure says "One or more attributes of person having id 'n' came from source having id 'm'." So your proposed structure can handle any number of sources per person, but it doesn't seem very useful.
  
  – Mike Sherrill 'Cat Recall'
  Mar 25 at 18:34
  

  
  
  
  

add a comment | 

I'm creating an application that will use at minimum two different API for data of its models. For example, I'll have an entity / model of a person. The data for this person comes at minimum two different API and more may be relevant in the future. For example, email and phonenumber may come from one data source and first name and second name from another.

How would one structure an database for this, that is flexible enough to handle adding / removing of the "data sources".

I initially though of an database structure looking like this:

[Person]
- ID
- FirstName
- LastName
- Email
- PhoneNumber

[Person_FIRST_SOURCE]
- Person_ID
- Person_FIRST_SOURCE_ID

[Person_SECOND_SOURCE]
- Person_ID
- Person_SECOND_SOURCE_ID

Which I then would be able to in the data synchronization script to look up what "Person" entity in my database, the current iterating person from the source represents. This would allow me to easily connect/add more sources as I go.

EDIT: I would like to add that it's not always that Person A exist within both sources of data.

EDIT 2: The main question is not really dependent on the "Person" model. This could have been any type of model; Book, School, Company etc. Just some form of model, where its data comes from multiple sources.

mysql database

share|improve this question

edited Mar 25 at 13:18

CookiePolicy

asked Mar 24 at 13:13

CookiePolicyCookiePolicy

11

share|improve this question

edited Mar 25 at 13:18

CookiePolicy

asked Mar 24 at 13:13

CookiePolicyCookiePolicy

11

share|improve this question

edited Mar 25 at 13:18

CookiePolicy

asked Mar 24 at 13:13

CookiePolicyCookiePolicy

11

asked Mar 24 at 13:13

CookiePolicyCookiePolicy

11

asked Mar 24 at 13:13

CookiePolicyCookiePolicy

11