Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk . Microsoft Data Platform MVP

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein

Friday 6 November 2015

SQL Pass 2015 Day 2 Keynote

The SQL Pass 2015 day 2 keynote by David DeWitt and Rimma Nehme of Microsoft was on IoT.

There are various technical challenge to consider about IoT:

  • variety of sensors
  • number of devices 
  • dirty sensor readings
  • data volume / scale
  • device / sensor security
  • cloud to device messaging
  • set up deployment and maintenance of large sensor networks
 The Azure IOT Services that currently exist are

Azure Stream Analytics can be used for streaming the real time IoT

The Metadata for this is not currently stored in a DBMS so querying of the data is not possible. IoT is a database problem not just a networking problem.

Rimma explained about the Fog. It is the cloud plus the fog. This in database terms is predicate pushdown. Database 101 is to never move the data to the computation always move the computation to the data.

 An interesting set of ideas about Polybase for IoT where discussed covering the declarative language, complex object modeling, scalable metadata management, discrete & continuous queries, multi purpose querying and computation pushdown.

The final picture about the future.

No comments:

Post a Comment

Note: only a member of this blog may post a comment.