• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

I need an advisement for a web application project

I am new on the use of java, but I am getting an interesting project that I would like to develop. These are the characteristics:
1. Create an web application with java for performing marketing analyses. These analyses are delivered in Excel charts and tables, power point presentations, and word documents.
2. The data is provided by customers and charged in a Database. The web application will use this database to query the data to perform above analyses
3. This application does not have any administrative module, but it should be easy to grow and integrate with existing object oriented administrative applications
3. We will rent a server in order to place our application.
4. The number of users will vary from 3 to 5
5. The company is small, but it is expecting to grow very fast for next year
6.The owner of this project wants a world class application, so he can compete with big companies.

My questions are:
1. Should I use MySQL or SQLServer for the database management?
2.I want use java 6.0 for this project, but I am open to any other language (I know c# and .NET)
3.Do you have an idea of time and price for this project?
4. The owner of this project wants a world class application, so he can compete with big companies
5. What are the security issues I have to consider since we will use a rented server?

Please refer me to another expert if you do not know about my questions.
Thanks




0
mescalona
Asked:
mescalona
1 Solution
 
surajgupthaCommented:
>>  These analyses are delivered in Excel charts and tables, power point presentations, and word documents.

Since you are planning to generate a lot of microsoft files i would suggest the use of c# .net but again if you are familiar with a technology i would suggest you use it. Because this application is very classical and can be implemented in any language.

>> Should I use MySQL or SQLServer for the database management?

MYSQL is free and SQL server is charged. Both databases are going to be ok. If the client can afford it you get use SQL server. But again since you are looking at a peak load of 5 users you could just use the MYSQL server

>> Estimating the cost
Estimating the time and effort is an art by itself and would need a lot of requirement analysis. In my opinion estimation would need much more details

>>What are the security issues I have to consider since we will use a rented server?
Security would depend on which server you are going to rent and the OS. Based on which you can encrpt the connection strings/ harden the machine
0
 
ovuleCommented:
1. Should I use MySQL or SQLServer for the database management?

I would say go for SQL Server Express Edition, it's free and will allow you to seemlessly move to SQL Server if/when the time permits.  If you are using .Net this is better since there it is optimised for SQL Server rather than using an ODBC driver for MySQL


2.I want use java 6.0 for this project, but I am open to any other language (I know c# and .NET)

I would say the same as surajguptha.  You will have an easier time working with Excel and other MS technologies using .Net.  Again since you are using MS Office you will no doubt be on an MS Server so


3.Do you have an idea of time and price for this project?

No, too few details are provided.  Plus a bit more than 500 points would be needed to do such a task ;)


4. The owner of this project wants a world class application, so he can compete with big companies

This isn't really a question.  However a good old saying goes something like this:
"You want software that is cheap, good quality and on time - choose two"
Basically this states that if you want good quality software, on time then it isn't going to be cheap.  If you want cheap software thats good quality then it wont be delivered on-time and if you want cheap software on time then it will be rubbish.



5. What are the security issues I have to consider since we will use a rented server?

Are you renting a server, or space on a server?  Both have their down sides,  if you are renting space then it is likely that the host will lock down the server as much as possible, however you may have problems doing what you want with Excel, etc.  If you rent the actual server then you will have more freedom but with that comes more responsibilities when it comes to securing the application.  If you go with a good company then I am sure they will advise you well - don't go for something cheap!

 
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now