Dynamic surveys
Posted by:
Humbert
Date: November 03, 2006 10:01AM
Hello!
I'm trying to implement a online application to generate online dynamic surveys. Like a CMS, the admin will be able to choose the number of questions and for each qüestion the data type, restrictions, etc using a web GUI. This is not a problem, even the storage of the survey structure.
The problem is how to store the user's answers. My first approach is to create a table for each survey, with the proper structure. This seems a good solution because not only both table design and the data storage are optimal but also it is possible to search and summarize using SQL.
But I'm not sure if this is the optimal solution. If the number of surveys increases, the DB will be full of tables and perhaps the performance will degrade. However, I'm not able to find another suitable solution.
Do you have any suggestion?
Thank you!
Subject
Written By
Posted
Dynamic surveys
November 03, 2006 10:01AM
November 03, 2006 01:32PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.