Databases
StackOverflow2013
Postsdbo
POSoftware Architecture and Database Design: One database/web application per each company or one database/web application for all companies?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSoftware Architecture and Database Design: One database/web application per each company or one database/web application for all companies?
    primarykey
    data
    text
    <p>I'm designing a web driven SQL database application from ground up. The application will manage information for clients that are in the same type of industry. In other words, the information (entities and relations among them) regarding each client does not vary too much from one to the next. However, the volume of the information is dictated by the size of the company. The application could be hosted on our server(s) or anywhere a client chooses. </p> <p><strong>My first question is: what are the pros and cons given the following options:</strong></p> <ul> <li>A. Manage multiple clients information in the same database; </li> <li>B. Manage one client information per database; so each client will have its own database;</li> </ul> <p><strong>My second question is: what are the pros and cons given the following methods of deployment?</strong></p> <ul> <li>A. Each client gets its own server (node);</li> <li>B. Use large RAID drive(s) with one powerful server with multiple websites;</li> </ul> <p>As decisions to these choices affect my design, I would like to know the pros and cons from different perspectives including maintenance, cost(financially and in time) and architecture to name a few.</p> <p>Technologies used:</p> <ul> <li>Database: MS SQL</li> <li>Platform: ASP.NET</li> <li>Language: C#</li> </ul> <p>Any comments or suggestions are most welcome,</p> <p>Thanks,</p> <p>Cullen</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCade Roux
    1. USLeo Nix
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSoftware Architecture and Database Design: One database/web application per each company or one database/web application for all companies?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSoftware Architecture and Database Design: One database/web application per each company or one database/web application for all companies?
      1. USChris Latta
      1. VTFavorite
    3. VO
      singulars
      1. POSoftware Architecture and Database Design: One database/web application per each company or one database/web application for all companies?
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload