Re: efficiency problem
Date: Sat, 9 Dec 2000 06:07:47 -0500
Message-ID: <3a321151_4_at_news3.prserv.net>
Karol,
I understand the appeal of inexpensive software, but you might also want to factor in the time that will be spent "re-inventing" the wheel.
SQL Server 7.0 ships with OLAP Services, and SQL Server 2000 ships with Analytic Services (basically an improved, and renamed, OLAP Services).
Certainly SQL Server is more expensive than Access, but the built-in functionality is probably going to exceed what you can provide, not to mention that there are third party tools that will be able to access OLAP / Analytic Services, but not a home-grown solution.
Even Excel has built-in support for OLAP / Analytic Services, but you will have to provide such front-end support yourself.
Is it really cheaper when you factor in ALL the associated costs?
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which can be cut and pasted into Query Analyzer is appreciated.
"KAROL SUDNIK" <KS315_at_mdx.ac.uk> wrote in message
news:3A311975.339938B8_at_mdx.ac.uk...
> Hi,
>
> I have a question I hope someone can help me with...
> I want to create a database consisting of 10 tables, capable of holding
> aprox. 100 000 entries each. I need to perform cross queries between
> these tables (I mean that I need to do multidimensional statistical
> analysis). These queries must give quite fast answers (I want to
> present results graphically). Is it possible to create such, efficient
> database using quite cheap software for ex. MS Access? Program which I
> build should work within Windows environment (that is why I mentioned
> Access).
>
> thanks,
> Karol
>
Received on Sat Dec 09 2000 - 12:07:47 CET