Arpit Sharma (ArpitSharmaLSA)
Oversea-Chinese Banking Corporation Ltd
Lead System Architect - Associate Director
Oversea-Chinese Banking Corporation Ltd
ArpitSharmaLSA Member since 2017 3 posts
Oversea-Chinese Banking Corporation Ltd
Posted: January 21, 2018
Last activity: December 7, 2018
Posted: 21 Jan 2018 21:15 EST
Last activity: 7 Dec 2018 10:27 EST

Is it recommended to have different Data schema for each application ?


I would like to understand, if it is recommended to use different data schema for different applications built on same Org layer.

For Eg:

- We are implementing 3 applications (App1, App2 & App3) for an Organisation ABC. Two applications (App1 and App3) are under Division 1 and 1 application (App2) is under Division 2.

- All 3 applications are sharing AD authentication, Int layer and User admin function (as most of the users are common).

In such a scenario,

1. Should we use the same data schema with app specific transactional work tables?


2. Should we split the data schema further for each application?

and what are the pros and cons of each approach.

Thank you in advance.

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.