StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSoftware Architecture and Database Design: One database/web application per each company or one database/web application for all companies?
text
Body
copied!<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>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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