SQL Server DB and Statistical Analysis

[19991008]

Hello Everyone,

I am new to this forum and was told it is very helpful.

I am working with an engineering firm and using SQL Server database. The company wants to add some features of trend analysis to the DB. I understand it is not easy to have it done because it requires both strong programming skills and good math/statistical background. With the source code for the trend analysis (using Mann-Kendall, Seasonal Kendall, and Related Nonparametric Techniques) available in FORTRAN 77 I am wondering how difficult is to incorporate the statistical functions into the DB. What issues are needed to consider when trying to develop such program? I appreciate any expertise opinions and suggestion about the time and cost effective approaches for the needs.

Thank you very much for your time and help.

 

[NoCoolHandle]

1999
Did you know that sql has some statistical functions built into it?
stdev, stdevp ,var and varp

There might be a few more but I don't know.
Re the fortran thing.. NO CLUE..

Also.. You can create your own "extended stored proceedures"
These are functions in c dll's so if you programming skills lie in that direction, you might want to look into it.

My experience is that I can code just about any logic inside sql code.. It is simple as a langage, but provides just every feature you might need for data.

HTH


Rob

 

[Catadmin]

Your first, and biggest, hurdle is figuring out what kind of analysis you need to do and what data you need to pull to do the analysis.

After that, the rest is fairly simple. Do you have some details (I.E., are they looking for quantities bought within a time frame, or customers from different regions, etc) that you could pass to us to help us answer your question in a less than generic manner?



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[19991008]

The company I work for is an environmental services firm which has many environmental monitoring programs to detect changes or trends in environmental contaminant levels with time. It stores all the data about various chemical compounds in the DB and now wish to perform some statistical analysis on the data. The analysis includes desdcriptive statistics (mean, median, standard deviation, etc.) and 8 other more sophesticated statistics (I meantioned some of them in my first thread.). It seems very hard to me.

thanks.

 

[NoCoolHandle]

DAMN ... this is the second post likme this today.

WHAT ORIGINAL THREAD?

LOOK AT SQL"S BUILT IN FUNCTIONS MOST OF WHAT YOU MENDITONED ARE THERE ALREADY