Results 1 to 3 of 3

Thread: One DB or Many?

  1. #1
    Join Date
    Jul 2006
    Location
    peaceful earth
    Posts
    2

    Thumbs up One DB or Many?

    Hello,

    I am debating on whether I should use one Db or many for a project I am assigned to. The application is store front application for a 7 online retailers, number of retailers will grow. Each should be able to manage their settings sparately.

    Should I design a separate Db for each, which I suspect could be a maintainance nightmare, OR one DB with a Table for Account that holds the identity of each store front and link data accordingly.

    From your expereinces I would like to hear feedback on pros and cons.

    Thanks
    Mike

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    If you will be hosting the data for all these retailers, then a single database will be more manageable for you. However, more care will need to be taken to ensure that they cannot accidentally see or update each others' data.

    While the number of retailers is small, a database each would probably not be too difficult to manage, but for 50 or 100 it would be onerous.

  3. #3
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255
    One database, definitely.

    Most db offerings have security that will allow you to limit the access based on your Account table. But actually that will probably not be relevant, as the joins (links) will do that anyway.

    Cheers
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •