Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a pretty simple question, but it seems that there are controversies as to how to solve it in the best possible way.

Say I have a web app that makes online surveys. My challenge is that each of these surveys must be isolated from one another (their address book, responses, etc.) while allowing duplication, deletion, backups (of only one survey, not of the whole database).

I know that some apps, like LimeSurvey that has a good reputation for online surveys, create a new set of tables for each survey. This seems to go against everything I've always considered as best practice, but on the other end it seems to simplify many things: the duplication of databases, the de facto separation between databases, etc..

Still, I am not convinced that this is the way to go. What is your opinion? How would you do it?


migration rejected from stackoverflow.com Jul 13 at 8:12

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as primarily opinion-based by RolandoMySQLDBA, Vérace, Paul White, dezso, Colin 't Hart Jul 13 at 8:12

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise. If this question can be reworded to fit the rules in the help center, please edit the question.

If there are many controversies for your question you will only obtain more controversial answers if you don't ask for very specific details. –  Andreas Jun 27 '13 at 9:11

Browse other questions tagged or ask your own question.