Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Real Time Data Stream Expand / Collapse
Author
Message
Posted Monday, April 14, 2014 2:34 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 6:55 AM
Points: 1, Visits: 13
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.
Post #1561671
Posted Tuesday, April 15, 2014 10:08 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 30, 2014 6:38 AM
Points: 33, Visits: 65
There are a few ways to do this and really depends on the task at hand.

SQL Server Reporting Services is a great tool that will make graphs and reports off the data you have collected. It is as current as the last time the report was loaded (Its web based so refresh the page to see new data). You could probably code something in C# that would refresh the page automatically every minute or so.

You could also make a custom web application to do something like this. Although this would require knowledge of web technologies (HTML, CSS, JavaScript, Ajax, ASP/PHP/Ruby)


- Tony Sweet
Post #1561962
Posted Wednesday, April 16, 2014 4:05 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 9:30 AM
Points: 67, Visits: 448
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...
Post #1562215
Posted Thursday, April 17, 2014 4:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 27, 2014 7:04 AM
Points: 13, Visits: 21
Definitely checkout StreamInsight. There is a lot of potential there around real-time processing. I stated but never finished (sorry) a blog series on real-time processing. Your can take a look here: http://wp.me/p2TQhX-5l

If you have any questions let me know and I can see what I can do to help.
Post #1562596
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse