troubleshooting Question

Calculating correlation between several time series with sql server data mining

Avatar of gnf
gnf asked on
DatabasesMicrosoft SQL ServerMicrosoft SQL Server 2008SSAS
6 Comments1 Solution1503 ViewsLast Modified:
I am trying to calculate the trailing correlation between two streams of numbers, each stored in a column in a large table.  Each row is time stamped with a datetime key, but the time stamps are not at regular intervals. They occur at random times.  
I am wondering whether I can use Sql Server data mining and somehow use the functionality of the time series algorithm to get to calculations like correlation.  One advantage of the time series algo in SSAS is that it does not depend on regularly spaced time intervals.  
Or should I calculate it on a streaming basis using an ETL tool like SSIS, sampling the data at regular time intervals, and write the results out to a table?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros