Tellingmachine

Getting started with Windows Azure Websites, Azure SQL Server, ASP.NET Web API and ASP.NET MVC 4 Mobile

Klaus Graefensteiner — Fri, 15 Mar 2013 01:59:06 -1400

Introduction

This article is a collection of useful links that will help you hitting the ground running when learning how to build cloud based RESTful services and ASP.NET MVC 4 Mobile client applications.

Figure 1: Bringing out the big guns for hitting the ground running with Azure and ASP.NET Web API and MVC

Tutorials

Windows Azure Tutorials

http://www.windowsazure.com/en-us/manage/services/web-sites/how-to-create-websites/
http://www.windowsazure.com/en-us/develop/net/tutorials/get-started/
http://www.windowsazure.com/en-us/develop/net/end-to-end-Apps/
http://www.windowsazure.com/en-us/develop/net/tutorials/aspnet-mvc-4-mobile-website/
http://www.windowsazure.com/en-us/develop/net/tutorials/rest-service-using-web-api/
http://www.windowsazure.com/en-us/develop/mobile/tutorials/get-started-ios/
http://www.windowsazure.com/en-us/develop/nodejs/common-tasks/publishing-with-git/

ASP.NET MVC 4 and Web API

http://net.tutsplus.com/tutorials/building-an-asp-net-mvc4-application-with-ef-and-webapi/
https://github.com/jcreamer898/NetTutsMvcEf
http://www.codeproject.com/Articles/344078/ASP-NET-WebAPI-Getting-Started-with-MVC4-and-WebAP
http://www.asp.net/web-api/overview/creating-web-apis
http://www.asp.net/mvc
http://www.asp.net/mvc/mvc4

ASP.NET Mobile

http://www.hanselman.com/blog/CreateAGreatMobileExperienceForYourWebsiteTodayPlease.aspx
http://coding-in.net/asp-net-mvc4-create-a-mobile-application/

JQuery Mobile

http://jquerymobile.com/

Azure DB Design

http://msdn.microsoft.com/en-us/data/tools.aspx

IOS JSON Consuming App

http://www.raywenderlich.com/store/ios-apprentice (Store Search Tutorial)
http://www.raywenderlich.com/13511/how-to-create-an-app-like-instagram-with-a-web-service-backend-part-12
http://www.raywenderlich.com/13541/how-to-create-an-app-like-instagram-with-a-web-service-backend-part-22

Videos

ASP.NET MVC 4 and Web API

Building Responsive Web Applications with MVC4, WebAPI and HTML5
https://channel9.msdn.com/Events/TechEd/Australia/2012/DEV332

ASP.NET for Mobile and Tablet Development
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DEV304

Building HTTP Services with ASP.NET Web API
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DEV309

ASP.NET Roadmap: One ASP.NET – Web Forms, MVC, Web API, and more
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DEV301

Building Services for Any Client with ASP.NET Web API
http://channel9.msdn.com/Events/Build/2012/3-036

Bleeding edge ASP.NET: See what is next for MVC, Web API, SignalR and more…
http://channel9.msdn.com/Events/Build/2012/3-028

DB Design

Microsoft SQL Server Data Tools: Database Development from Zero to Sixty
http://channel9.msdn.com/Events/TechEd/Europe/2012/DBI311

Online Training

ASP.NET MVC 4 and Web API

ASP.NET MVC Fundamentals
http://www.pluralsight.com/training/Courses/TableOfContents/aspdotnet-mvc

Building Applications with ASP.NET MVC 4
http://www.pluralsight.com/training/Courses/TableOfContents/mvc4-building

Introduction to the ASP.NET Web API
http://www.pluralsight.com/training/Courses/TableOfContents/aspnetwebapi

Building ASP.NET MVC Apps with EF Code First, HTML5, and jQuery
http://www.pluralsight.com/training/Courses/TableOfContents/web-development

jQuery Fundamentals
http://www.pluralsight.com/training/Courses/TableOfContents/jquery-fundamentals

jQuery Mobile and ASP.NET MVC 4
http://www.pluralsight.com/training/Courses/TableOfContents/jquery-mobile

Git Fundamentals
http://www.pluralsight.com/training/Courses/TableOfContents/git-fundamentals

Introduction to CSS
http://www.pluralsight.com/training/Courses/TableOfContents/css-intro

CSS3
http://www.pluralsight.com/training/Courses/TableOfContents/css3

HTML5 Fundamentals
http://www.pluralsight.com/training/Courses/TableOfContents/html5-fundamentals

Using HTML5 and CSS3
http://www.pluralsight.com/training/Courses/TableOfContents/html5css3-upgrade

Ausblick

ASP.NET Web API is cool because, it lets you create services that can be consumed by an MVC 4 website or by an IPad app. Azure is nice, because it provides you with a free integration server for hosting your web service and your database server. And not to forget to mention the tight integration with Visual Studio and PowerShell for peace-of-mind development, testing and deployment.

Retrieving counter values with the Wonderware Historian Counter Retrieval Mode

Klaus Graefensteiner — Mon, 20 Aug 2012 10:19:59 -1400

Introduction

Last week I blogged about how to store and retrieve time series data from the Wonderware Historian. The T-SQL queries in this post used “wwRetrievalMode = 'Delta'”.The wwRetrievalMode parameter lets you specify how you would like to project the original data during the retrieval operation. There is a wide range of predefined projections. The main goal of the projections is to minimize the amount of data that needs to be sent to the client. For example, if you would like to find the max value of a tag in a specific time interval you would use the Maximum Retrieval mode instead of retrieving all values and then processing the result set to get the highest value.

Figure 1: The Grid

Historian 10 Retrieval Modes

Here is a list of the modes used in Historian 10

Cyclic Retrieval
Delta Retrieval
Full Retrieval
Interpolated Retrieval
“Best Fit” Retrieval
Average Retrieval
Minimum Retrieval
Maximum Retrieval
Integral Retrieval
Slope Retrieval
Counter Retrieval
ValueState Retrieval
RoundTrip Retrieval

Counter Retrieval

The retrieval mode that can save a lot of headaches during data processing on the client is the Counter retrieval. Let’s for example assume that you would like to know how much water got added to your swimming pool in the last hour. You get your water meter reading before and after and calculate the difference. The counter retrieval does exactly that, but it also takes into account meters that reset themselves after their maximum counted value has been reached (counter overflow). For example the counter retrieval for the SysTimeSec system tag which represents the seconds of a wall clock would return 300 when asked for the counts during the last five minutes.

Here are some sample queries:

-- Counter Retrieval
SELECT DateTime, TagName, Value, Quality, QualityDetail as QD 
FROM History
WHERE TagName = 'SysTimeSec'
AND DateTime BETWEEN DATEADD(MINUTE, -10, GETDATE()) AND GETDATE() 
AND wwRetrievalMode = 'counter'
AND wwCycleCount = 1

-- Counter Retrieval Multiple Tags
SELECT DateTime, TagName, Value, Quality, QualityDetail as QD 
FROM History
WHERE TagName IN ('SysTimeSec', 'SysTimeMin')
AND DateTime BETWEEN DATEADD(MINUTE, -10, GETDATE()) AND GETDATE() 
and wwRetrievalMode = 'counter'
and wwCycleCount = 1

Figure 2: Retrieval of resettable counter values

Ausblick

More information about Counter Retrieval can be found in the Historian Concepts User Guide.

SQL Queries for storing and retrieving real time data from the Wonderware Historian

Klaus Graefensteiner — Tue, 14 Aug 2012 22:54:53 -1400

Wonderware Historian = SQL Server Mod for real time data

You can think of the Wonderware Historian to be an extension of Microsoft SQL Server to handle large amounts of time series data efficiently. It is optimized to store and retrieve time series data. The data is actually not stored in SQL Server tables, but in files called History Blocks. The Wonderware Historian has an OLE DB Provider to interface with the storage and retrieval system. This blog posts shows some simple queries to store and retrieve an analog value using T-SQL.

Figure 1: Wonderware Historian System Management Console

Wonderware Historian Clients = Tools for analyzing time series data

The Wonderware Historian Clients are a set of tools that help to visualize and analyze time series data. The Trend application (below) visualizes the values that got stored by one of the T-SQL queries.

Figure 2: Trend Client

T-SQL Queries for storing and retrieving data from the Wonderware Historian

Here is a set of queries that show how easy it is to store and retrieve time series and real time data from the Wonderware Historian.

USE Runtime
-- IMPORTANT -> START HISTORIAN (STORAGE)

-- Insert new real time value
INSERT AnalogHistory (DateTime, TagName, 
Value, QualityDetail, wwVersion) 
VALUES(null, 'EFAnalogManual001', 52, 192, 'REALTIME') --Null for time stamp -> Historian sets the timestamp

-- Get original value from in memory cache (Active Image)
SELECT TagName, Value 
FROM Live
WHERE TagName = 'EFAnalogManual001'

-- Get original value for current time
SELECT DateTime, Sec = DATEPART(ss, DateTime), TagName, Value, Quality, QualityDetail
FROM History
WHERE TagName = 'EFAnalogManual001'
AND DateTime = GETDATE()
AND wwRetrievalMode = 'Delta'

-- Get original values for the last 10 minutes
SELECT DateTime, Sec = DATEPART(ss, DateTime), TagName, Value, Quality, QualityDetail
FROM History
WHERE TagName = 'EFAnalogManual001'
AND DateTime BETWEEN DATEADD(MINUTE, -10, GETDATE()) AND GETDATE() 
AND wwRetrievalMode = 'Delta'
ORDER BY DateTime

Figure 3: Query results

Ausblick

This is the first of a series of blog post about the Wonderware Historian. In one of the next posts I’d like to demonstrate how to write .NET applications that interface with the real-time storage via the Microsoft Entity Framework.