First kindly accept my apologies for posting question large number of
groups. I believe posting question to following three groups would suffice
the job:
1. microsoft.public.dotnet.general (to get an idea of .NET strength about
this particular problem)
2. microsoft.public.sqlserver.programming (to get feeling how SQL Server
could be helpful)
3. microsoft.public.dotnet.framework.aspnet (to know how ASP.NET could be
helpful)
4. microsoft.public.dotnet.languages.csharp (development language of the
project in case of .NET)
5. microsoft.public.sqlserver.olap (how OLAP could be helpful in analyzing
static data)
Sorry about this mistake.
Thank you for previous help. It has given some clue to the right way.
Another thing which I probably left in the question is the budget
consideration, sometimes a major factor when you select SQL Server over
Oracle. This project is non profit project community project and money comes
from people/organizations donating money. Currently we are in the process of
finalizing budget. But I believe my main concern right now is not the cost
but to get confident that if SQL Server could support following data volume
requirement:
Over the period of 5 years, "more than 100, 000 Books" will be stored in a
Database along with a LARGE amount of book attributes majorly consists of
very large amount of people reviews about a book.
I wanted to get an idea if SQL Server has any performance or otherwise any
limitation when data volume increases.
Similarly you can design data driven web sites using both .NET and J2EE. But
again does .NET has all it takes to develop highly available and efficent
large data driven website with expected daily vistor count to the website
over half-million.
Also to analyze large volume of static data would it be better to use SQL
Server OLAP analysis services or does it has any limitation.
Once again Thnaking you,
Regards,
Rafey.
"Syed Mudussir Husain" <sy**************@yahoo.com> wrote in message
news:OW**************@TK2MSFTNGP09.phx.gbl...
Hello,
I am doing a very large web based database project.
Over the period of 5 years, "more than 100, 000 Books" will be stored in a
Database along with a LARGE amount of book attributes majorly consists of
very large amount of people reviews about a book.
We then need to analyze or generate reports from that large volume of
STATIC data in Infinite number of ways.
My questions are:
Q1. Just to get general sence, Which suits the best Oracle or SQL Server
for this project and Why? Keeping scalibility, volume of data, etc. in mind?
Q2. Which development platform best suits best for this kind of project
..NET or J2EE and Why.
Q3. We have to analyze or generate reports from that STATIC data in
Infinite number of ways, Which analysis technology should be used and Why?
Thanks,
Rafey.