Statistical Functions and Polynomial Fits - What's the BEST Database?

[eja5866]

Hello,
We are helping a co-partner of our company with a redesign of their data storage and the best program/package set up for their needs. They need to query sets of data (totaling right now in the MB range) and apply statistical analysis and best degree fits for multivariable equations. My question is - without going to a statistical analysis package, do any of the major database players have such options incorporated in their packages? I'm an Oracle guy running Oracle 9i so I know that they don't have stat packages past linear regression.
How about DB2 or SQL_Server - might they have built it within functions of these databases.

I'm thinking at this point that Access may be the way to go since I know I can link into the trendline extrapolations available in Excel. Is Access the only one?


Thanks for your thoughts and opinions on this!

 

[Craig0201]

You can link to Excel via any ODBC compliant database.

Craig

 

[eja5866]

I guess I'll use the excel Link as a last option then. How about SQL_Server or DB2 - do either of these have statistical functions built into the database?

Thanks.

 

[ClydeData]

you could try total access statistics the add on for access.

http://www.fmsinc.com/Products/statistics/

cheers

Jimmy

 

[eja5866]

Thanks Jimmy,

Thank Access ad-in seems like a good way to go (though they would have to buy the plug-in).
It def seems as if Access is a very plausible way to go, but,
just want to weigh all options here, does anyone have info about SQL_Server or DB2 - do either of these have statistical functions built into the database and how have they worked for you?

Any real world exp. on these other 2 would be helpful in my report to the bosses.

Thanks,
Ed