1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

DB architecture geopgraphically distributed

Discussion in 'General' started by saracooper, Apr 24, 2014.

  1. saracooper

    saracooper Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    80
    I need to design the DB architecture for my client, the best possible approach. This is the scenario -

    There would be a software running in more than 200 locations which we have called local sites, connected to Database. There is also a Central site with a BI application connected to the same Database.

    The volume of data is not an issue, it is the geographical locations a problem.

    What is the right approach for this kind of architecture -

    1. Go for the cloud option?

    Get a powerful Server. Put the BI application, the Database and the software that will run on the local sites all on the same Server ?

    OR

    2. Get 2 servers, one for Central site (BI application) and one for local sites software and the Database

    Let the local sites software be used as Saas with the Database and the BI application on Central Site connect to the Database remotely?

    OR

    3. Get 5 servers, one for Central site with the Database, 4 servers for local sites distributed geographically

    In this case use one Database and 5 instances one for each server? One instance for Central and 4 instances for local?

    I am a bit confused. Any help, idea would be really appreciated. Thanks.
     
  2. saracooper

    saracooper Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    80
    I gave it some more thought and this seems like the right solution -
    I would like to decide on the database... The volume of data between the Server and database is not much. Its a non profit organization and has their offices/sites in 200+ different locations. So the data sent to the Database from these sites is donations received each day and the formalities done for the issuing of loans.
    The Central site with the BI application would need to read the data from all these sites for generating various reports.
    So I guess the ideal solution probably is to have 5 App/Web servers connected to around 50 sites. And a Central Site that gathers information from these 5 servers for reports. The question is whether to have 1 Database and 5 instances one for each server or 5 different Databases?
     
  3. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Having 5 different databases poses the problem of data synchronization and aggregation; in this case it's better, in my opinion, to have one database and 5 instances (a traditional RAC configuration). You then have one 'repository' of the data for aggregation and reporting.
     
  4. saracooper

    saracooper Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    80
    Ok thank u David