cadam (4/14/2014)
Hello forum. I want to introduce myself as Adam. I am a self starter and self motivated learning. I am an Electrical Engineer by trade but find myself investing time in anything I find interesting.I have made it my lifes calling to learn as much about SQL as is possible! I have been entrusted to develop an energy monitoring system but I dont know where to start. The first thing I will need to do is develop the data base and be able to successfully route the collected data to the said database.
This db will receive data every 30 seconds to 1 minute (or ever every few seconds) and drop the data into SQL. I feel comfortable that I can work with that data as it is delivered to create reports. What I want to learn to do is take the real time data and display it in the form of realtime data or graphs. As the newest data arrives the older data becomes part of the live history. An example would be the Dow Jones ticker.
I do not expect someone to lay out the process of how to do this. I am just asking for someone to point me in the direction so that I can further my education on this subject matter.
Thank you for your time.
I think you might want to take a look at Microsoft StreamInsight.
Here's a link: http://technet.microsoft.com/en-us/library/ee362541.aspx
You'd be able to write an adapter to consume the data being delivered to you, query it on the fly, write it to a database or use some other custom output adapter etc...