Help required on Database Model
-
Hi Everybody, Please note that I am not a very senior developer so want help from you guys... We are going to start a new project which is very similar to Shopify. The proposed solution will include the following, 1. A admin site which manages Merchants. Here the merchants will have multiple stores under him. 2. A Tablet client which downloads/updates the data from/to the website using web services. My questions is, 1. So while designing the database model whether is it a good idea to keep separate databases for each merchant or keep a single database?. 2. How much data can be kept in a single table?. 3. Regarding the scalability and maintainability which is the proper design, single database or multiple database? 4. Is there a bottle neck in MS SQL server when creating multiple databases instead of one?. 5. Which kind of sever solution in this case we need to propose, Cloud based database or Godaddy like hosting server?. Can a godaddy like hosting service provide a performance like Amazon. Please note that we are planning to use MS SQL server for keeping the data. Thanks & Regards, Nitheesh George
Nitheesh George http://www.simpletools.co.in
-
Hi Everybody, Please note that I am not a very senior developer so want help from you guys... We are going to start a new project which is very similar to Shopify. The proposed solution will include the following, 1. A admin site which manages Merchants. Here the merchants will have multiple stores under him. 2. A Tablet client which downloads/updates the data from/to the website using web services. My questions is, 1. So while designing the database model whether is it a good idea to keep separate databases for each merchant or keep a single database?. 2. How much data can be kept in a single table?. 3. Regarding the scalability and maintainability which is the proper design, single database or multiple database? 4. Is there a bottle neck in MS SQL server when creating multiple databases instead of one?. 5. Which kind of sever solution in this case we need to propose, Cloud based database or Godaddy like hosting server?. Can a godaddy like hosting service provide a performance like Amazon. Please note that we are planning to use MS SQL server for keeping the data. Thanks & Regards, Nitheesh George
Nitheesh George http://www.simpletools.co.in
1. Single database is the better design, there are strategies to handle large volume. Extreme data (think Google, facebook, Amazon etc) requires a different strategy but it is probably too early to begin taking that into account. 2. Much more than a startup site can expect to see. 3. See 1 - same question 4. Don't create multiple databases - removes the question. 5. Performance like Amazon is above and beyond your short/medium term expectations, I imagine they have a large dedicated team simply looking after their database systems. Any of the hosting companies will be delighted to meet you short/medium term needs. If your database is designed properly it will be scalable, I would suggest getting a professional to design your system. An excellent specification will facilitate the design.
Never underestimate the power of human stupidity RAH
-
Hi Everybody, Please note that I am not a very senior developer so want help from you guys... We are going to start a new project which is very similar to Shopify. The proposed solution will include the following, 1. A admin site which manages Merchants. Here the merchants will have multiple stores under him. 2. A Tablet client which downloads/updates the data from/to the website using web services. My questions is, 1. So while designing the database model whether is it a good idea to keep separate databases for each merchant or keep a single database?. 2. How much data can be kept in a single table?. 3. Regarding the scalability and maintainability which is the proper design, single database or multiple database? 4. Is there a bottle neck in MS SQL server when creating multiple databases instead of one?. 5. Which kind of sever solution in this case we need to propose, Cloud based database or Godaddy like hosting server?. Can a godaddy like hosting service provide a performance like Amazon. Please note that we are planning to use MS SQL server for keeping the data. Thanks & Regards, Nitheesh George
Nitheesh George http://www.simpletools.co.in
-
Hi Everybody, Please note that I am not a very senior developer so want help from you guys... We are going to start a new project which is very similar to Shopify. The proposed solution will include the following, 1. A admin site which manages Merchants. Here the merchants will have multiple stores under him. 2. A Tablet client which downloads/updates the data from/to the website using web services. My questions is, 1. So while designing the database model whether is it a good idea to keep separate databases for each merchant or keep a single database?. 2. How much data can be kept in a single table?. 3. Regarding the scalability and maintainability which is the proper design, single database or multiple database? 4. Is there a bottle neck in MS SQL server when creating multiple databases instead of one?. 5. Which kind of sever solution in this case we need to propose, Cloud based database or Godaddy like hosting server?. Can a godaddy like hosting service provide a performance like Amazon. Please note that we are planning to use MS SQL server for keeping the data. Thanks & Regards, Nitheesh George
Nitheesh George http://www.simpletools.co.in
Quote:
1. So while designing the database model whether is it a good idea to keep separate databases for each merchant or keep a single database?.
Separate databases with separate security credentials. You really don't want a data breach if you can possibly avoid it.
Quote:
5. Which kind of sever solution in this case we need to propose, Cloud based database or Godaddy like hosting server?.
Cloud database - as you have already specified SQL Server I recommend SQL Azure.