| Author |
Topic Search Topic Options
|
eph_
Newbie
Joined: 17 May 2003
Status: Offline
Points: 3
|
Topic: Survey Application Posted: 17 May 2003 at 11:34am |
|
I've been asked to create a web-based service that essentially conducts a survey of a small group and reports simple statistical information. As the stats are based on a group of surveys, I will need some sort of database. Although I am fairly experienced in C/C++ coding, I've never done any sort of web development. I would like to learn all of the most powerful tools and languages, but, to start, I need to learn what will be necessary to complete this project.
So my question is this: what language/combination of languages would you suggest I use? The survey would be quite simple, consisting only of a series of questions, each with the conventional user input controls (radio boxes, check boxes, text entry, etc.) I plan to code the statistic calculation myself, and the language I use for this portion won't really need anything beyond simple arithmetic functions and looping. Would ASP suffice? (I've heard it is relatively simple and efficient.) Will I need to use something more complex, perhaps Java, for the statistical calculations?
In addition, I'm thinking about how to represent the database. The survey would not be extraordinarily long, and it would be administered to about 200 people at once. I guess the type of database I would use depends on the language(s) I choose, but I was thinking of a simple collection of text files with a standard naming convention. Like I said, I've never designed anything in this area, so I don't know the downside to this method nor am I aware of the alternatives. Any suggestions?
I know my questions are a little basic, but I hope someone can help me get started. Thanks a lot in advance.
|
 |
Gary
Senior Member
Joined: 20 March 2002
Location: United Kingdom
Status: Offline
Points: 326
|
Posted: 19 May 2003 at 2:31am |
asp will anable you to do this quite 'easily'. You should look to use either MS Access or preferably MS SQL server as the database. Vbscript will be more than suffice for the analysis (totals, percentages, etc).
However, it depends on how you want to design/manage the survey....
The easiest way would be for you to design the survey itself (ie specify the questions and available answers). If you are looking to build a dynamic survey application which gives the users the abaility to create their own surveys online, then this will be quite tricky.
The latter is something that I have been working of for a while and is by no means straight forward.
Good Luck !!!
|
 |
Bluefrog
Senior Member
Joined: 23 October 2002
Location: Korea, South
Status: Offline
Points: 1701
|
Posted: 19 May 2003 at 5:53am |
If you are good with C/C++, why not try out .NET and C#? You might feel more at home using ASP.NET with C# underneath for all the hardcore programming. That way you can sort of recycle some of your existing skills. .NET also forces better programming techniques than traditional ASP/VBScript ask for. You should feel more at home there.
As for the database, if you can, SQL Server is much nicer, but you can just as easily do it with Access. If you've never done any database programming, Access is easier to work with for beginners, but by the same token you could use an ERD program like ErWin or DeZign (which I use).
I would suggest staying away from flat file databases as you are going to have massive performance penalties from that. As long as you use a relational database like Oracle or SQL Server (Sybase or MS) or an object oriented database, you'll get much better speed. And you won't have to much around with all the logic for them as that is as simple as writing a few SQL statements. Basic SQL takes about 2 hours to learn.
My suggesstion - ASP.NET with C# and MS SQL Server. Tons of resources for all of them. A good place to start for the programming language is http://asp.net.
Cheers
|
 |
eph_
Newbie
Joined: 17 May 2003
Status: Offline
Points: 3
|
Posted: 19 May 2003 at 12:34pm |
|
Ah thanks for both of your replies. I always assumed there was a reason for products like SQL to exist, but I never understood why :). I will look into all my database options.
In terms of language, I've never used C#. How similar is it to C/C++? I don't mind learning a new language for this project, but I would certainly be more comfortable writing the "hardcore" code in a C-like language (believe it or not, I have never learned any sort of visual basic--I began with qbasic and progressed to C.)
I think I will pursue the .NET framework thoroughly to see if that is a viable option. You are absolutely right, Bluefrog, in that I will be so happy in a very structured environment. I have done mostly mathematical software development to this point and I cringe at the thought of something very loose and open.
To address your comments, Gary, Im not sure why dynamic survey creation would be so difficult. Maybe I am not thinking in the right framework, but it seems such a task would be relatively simple. In C++, at least, I would just create a data type (class) for each question type and write separate functions for each to display the pertinent information and report the results quantitatively to the statistical portion. The questions themselves would be transparent to the stat functions, only displayed to the user. Or is the actual process of displaying the question and retrieving input difficult to accomplish?
Anyways thanks again for yout help, I have a bit of learning to do but this is exactly the starting point I needed.
|
 |
Gary
Senior Member
Joined: 20 March 2002
Location: United Kingdom
Status: Offline
Points: 326
|
Posted: 20 May 2003 at 2:51am |
The 'complexity' kicks in when the survey author has the option of selecting a question type. What I mean by this is that they may want a simple single line text <INPUT>, or a multiline text <TEXTAREA>, or a drop-down <SELECT> (single/multi selection), or a group of radio buttons, etc.
Ok, so it's not that bad - I just need to put my thinking hat on, sit back and figure it out when/if I get a spare few hours.
Oh, and the other thing - it has to be based on an Ingres db !!! Ingres, who has used (let alone heard of) Ingres !!!
|
 |
eph_
Newbie
Joined: 17 May 2003
Status: Offline
Points: 3
|
Posted: 20 May 2003 at 4:23pm |
|
haha I see the dilemma now. I can't think of a solution either, but I hardly know the language and structure yet. Once I have made some real progress I'll tackle this one; I'm sure there is a solution.
|
 |