Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Grayco
Starting Member
22 Posts |
 Posted - 2010-03-23 : 14:28:48
|
| Greetings Everyone,My name is Glen. I work as a Facilities Maintenance Technician in a semiconductor manufacturing facility.In Facilities we monitor and control the plants infrastructure. All the utilities and all the waste systems are monitored and controlled using programmable logic controllers which collect and store data in a couple different databases. The realtime data and historic data are available to us using a man/machine interface software named Cimplicity.Cimplicity is a graphic interface that allows us to control all the critical perameters of our operations.Access to the databases is limited to read only access. My current ambition is to be able to access the databases through MS Excel, using SQL querries. The amount of data is staggering. There thousands of sensors being scanned and timestamped data recorded every two seconds.I'm hoping to learn how to filter through this data. I will need to summerize data to managable levels. I would like to use SQL to condense two second data into five minute average data. This will allow me to use excels graphing capabilities to analyze up to 90 days of data at once.I have been through an online SQL tutorial at "http://sqlcourse2.com/". This was a good primer but I perceive it is only a very basic start. It is a good platform but doesn't go into the specific things I need to know.I would appreciate your suggestions as to how I can gain the understanding I need to deal with a huge amount of quantitative data with look only access.Thanks in advance for your thoughts.Glen |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-23 : 15:09:29
|
| Welcome to the forum.Read up on T-SQL, and specifically Aggregate functions in SQL Server.You may discover that SSIS is going to be an invaluable tool for you as well, so once you have a basic understanding of SQL, start reading up on SSISWhen you have more specific questions, by all means, post 'em here. |
 |
|
|
|
|
|
Introduction