阿里云数据分析最佳实践:二维数据可视化 + 设备数据下发
概述
物联网数据分析,又称Link Analytics,是阿里云为物联网开发者提供的设备智能分析服务,全链路覆盖了设备数据生成、管理(存储)、清洗、分析及可视化等环节。有效降低数据分析门槛,助力物联网开发工作。这里分别演示通过二维数据可视化功能展示设备位置 + 通过数据分析实现定时下发数据到设备。
Step By Step
1、创建产品,导入物模型,参考链接
物模型json内容
{ "schema": "https://iotx-tsl.oss-ap-southeast-1.aliyuncs.com/schema.json", "profile": { "productKey": "a1kVHWEOsM2" }, "properties": [ { "identifier": "GeoLocation", "name": "地理位置", "accessMode": "rw", "required": true, "dataType": { "type": "struct", "specs": [ { "identifier": "Longitude", "name": "经度", "dataType": { "type": "double", "specs": { "min": "-180", "max": "180", "unit": "°", "unitName": "度", "step": "0.01" } } }, { "identifier": "Latitude", "name": "纬度", "dataType": { "type": "double", "specs": { "min": "-90", "max": "90", "unit": "°", "unitName": "度", "step": "0.01" } } }, { "identifier": "Altitude", "name": "海拔", "dataType": { "type": "double", "specs": { "min": "0", "max": "9999", "unit": "m", "unitName": "米", "step": "0.01" } } }, { "identifier": "CoordinateSystem", "name": "坐标系统", "dataType": { "type": "enum", "specs": { "1": "WGS_84", "2": "GCJ_02" } } } ] } }, { "identifier": "CurrentHumidity", "name": "湿度", "accessMode": "rw", "required": false, "dataType": { "type": "double", "specs": { "min": "0", "max": "100", "unit": "%", "unitName": "百分比", "step": "0.01" } } }, { "identifier": "CurrentTemperature", "name": "温度", "accessMode": "rw", "required": false, "dataType": { "type": "double", "specs": { "min": "-40", "max": "120", "unit": "℃", "unitName": "摄氏度", "step": "0.01" } } } ], "events": [ { "identifier": "post", "name": "post", "type": "info", "required": true, "desc": "属性上报", "method": "thing.event.property.post", "outputData": [ { "identifier": "GeoLocation", "name": "地理位置", "dataType": { "type": "struct", "specs": [ { "identifier": "Longitude", "name": "经度", "dataType": { "type": "double", "specs": { "min": "-180", "max": "180", "unit": "°", "unitName": "度", "step": "0.01" } } }, { "identifier": "Latitude", "name": "纬度", "dataType": { "type": "double", "specs": { "min": "-90", "max": "90", "unit": "°", "unitName": "度", "step": "0.01" } } }, { "identifier": "Altitude", "name": "海拔", "dataType": { "type": "double", "specs": { "min": "0", "max": "9999", "unit": "m", "unitName": "米", "step": "0.01" } } }, { "identifier": "CoordinateSystem", "name": "坐标系统", "dataType": { "type": "enum", "specs": { "1": "WGS_84", "2": "GCJ_02" } } } ] } }, { "identifier": "CurrentHumidity", "name": "湿度", "dataType": { "type": "double", "specs": { "min": "0", "max": "100", "unit": "%", "unitName": "百分比", "step": "0.01" } } }, { "identifier": "CurrentTemperature", "name": "温度", "dataType": { "type": "double", "specs": { "min": "-40", "max": "120", "unit": "℃", "unitName": "摄氏度", "step": "0.01" } } } ] } ], "services": [ { "identifier": "set", "name": "set", "required": true, "callType": "async", "desc": "属性设置", "method": "thing.service.property.set", "inputData": [ { "identifier": "GeoLocation", "name": "地理位置", "dataType": { "type": "struct", "specs": [ { "identifier": "Longitude", "name": "经度", "dataType": { "type": "double", "specs": { "min": "-180", "max": "180", "unit": "°", "unitName": "度", "step": "0.01" } } }, { "identifier": "Latitude", "name": "纬度", "dataType": { "type": "double", "specs": { "min": "-90", "max": "90", "unit": "°", "unitName": "度", "step": "0.01" } } }, { "identifier": "Altitude", "name": "海拔", "dataType": { "type": "double", "specs": { "min": "0", "max": "9999", "unit": "m", "unitName": "米", "step": "0.01" } } }, { "identifier": "CoordinateSystem", "name": "坐标系统", "dataType": { "type": "enum", "specs": { "1": "WGS_84", "2": "GCJ_02" } } } ] } }, { "identifier": "CurrentHumidity", "name": "湿度", "dataType": { "type": "double", "specs": { "min": "0", "max": "100", "unit": "%", "unitName": "百分比", "step": "0.01" } } }, { "identifier": "CurrentTemperature", "name": "温度", "dataType": { "type": "double", "specs": { "min": "-40", "max": "120", "unit": "℃", "unitName": "摄氏度", "step": "0.01" } } } ], "outputData": [] }, { "identifier": "get", "name": "get", "required": true, "callType": "async", "desc": "属性获取", "method": "thing.service.property.get", "inputData": [ "GeoLocation", "CurrentHumidity", "CurrentTemperature" ], "outputData": [ { "identifier": "GeoLocation", "name": "地理位置", "dataType": { "type": "struct", "specs": [ { "identifier": "Longitude", "name": "经度", "dataType": { "type": "double", "specs": { "min": "-180", "max": "180", "unit": "°", "unitName": "度", "step": "0.01" } } }, { "identifier": "Latitude", "name": "纬度", "dataType": { "type": "double", "specs": { "min": "-90", "max": "90", "unit": "°", "unitName": "度", "step": "0.01" } } }, { "identifier": "Altitude", "name": "海拔", "dataType": { "type": "double", "specs": { "min": "0", "max": "9999", "unit": "m", "unitName": "米", "step": "0.01" } } }, { "identifier": "CoordinateSystem", "name": "坐标系统", "dataType": { "type": "enum", "specs": { "1": "WGS_84", "2": "GCJ_02" } } } ] } }, { "identifier": "CurrentHumidity", "name": "湿度", "dataType": { "type": "double", "specs": { "min": "0", "max": "100", "unit": "%", "unitName": "百分比", "step": "0.01" } } }, { "identifier": "CurrentTemperature", "name": "温度", "dataType": { "type": "double", "specs": { "min": "-40", "max": "120", "unit": "℃", "unitName": "摄氏度", "step": "0.01" } } } ] } ] }
2、设备端通过开源MQTT SDK上传数据,基于开源JAVA MQTT Client连接阿里云IoT
import com.alibaba.taro.AliyunIoTSignUtil; import org.eclipse.paho.client.mqttv3.*; import org.eclipse.paho.client.mqttv3.persist.MemoryPersistence; import java.util.HashMap; import java.util.Map; public class IoTDemoPubSubDemo { // 设备三元组信息 public static String productKey = "a1kVH******"; public static String deviceName = "device1"; public static String deviceSecret = "XADek3EYXzzTtxJ6a****************"; public static String regionId = "cn-shanghai"; // 物模型-属性上报topic private static String pubTopic = "/sys/" + productKey + "/" + deviceName + "/thing/event/property/post"; // 物模型-属性订阅topic private static String subTopic = "/sys/" + productKey + "/" + deviceName + "/thing/service/property/set"; private static MqttClient mqttClient; public static void main(String [] args){ initAliyunIoTClient(); // 汇报属性 postDeviceProperties(); try { mqttClient.subscribe(subTopic); // 订阅Topic } catch (MqttException e) { System.out.println("error:" + e.getMessage()); e.printStackTrace(); } // 设置订阅监听 mqttClient.setCallback(new MqttCallback() { @Override public void connectionLost(Throwable throwable) { System.out.println("connection Lost"); } @Override public void messageArrived(String s, MqttMessage mqttMessage) throws Exception { System.out.println("Sub message"); System.out.println("Topic : " + s); System.out.println(new String(mqttMessage.getPayload())); //打印输出消息payLoad } @Override public void deliveryComplete(IMqttDeliveryToken iMqttDeliveryToken) { } }); } /** * 初始化 Client 对象 */ private static void initAliyunIoTClient() { try { // 构造连接需要的参数 String clientId = "java" + System.currentTimeMillis(); Map<String, String> params = new HashMap<>(16); params.put("productKey", productKey); params.put("deviceName", deviceName); params.put("clientId", clientId); String timestamp = String.valueOf(System.currentTimeMillis()); params.put("timestamp", timestamp); // cn-shanghai String targetServer = "tcp://" + productKey + ".iot-as-mqtt."+regionId+".aliyuncs.com:1883"; String mqttclientId = clientId + "|securemode=3,signmethod=hmacsha1,timestamp=" + timestamp + "|"; String mqttUsername = deviceName + "&" + productKey; String mqttPassword = AliyunIoTSignUtil.sign(params, deviceSecret, "hmacsha1"); connectMqtt(targetServer, mqttclientId, mqttUsername, mqttPassword); } catch (Exception e) { System.out.println("initAliyunIoTClient error " + e.getMessage()); } } public static void connectMqtt(String url, String clientId, String mqttUsername, String mqttPassword) throws Exception { MemoryPersistence persistence = new MemoryPersistence(); mqttClient = new MqttClient(url, clientId, persistence); MqttConnectOptions connOpts = new MqttConnectOptions(); // MQTT 3.1.1 connOpts.setMqttVersion(4); connOpts.setAutomaticReconnect(false); // connOpts.setCleanSession(true); connOpts.setCleanSession(false); connOpts.setUserName(mqttUsername); connOpts.setPassword(mqttPassword.toCharArray()); connOpts.setKeepAliveInterval(60); mqttClient.connect(connOpts); } /** * 汇报属性 */ private static void postDeviceProperties() { try { System.out.println("上报属性值"); String payloadJson = "{\"params\":{\"CurrentHumidity\":12.3,\"CurrentTemperature\":12.3,\"GeoLocation\":{\"CoordinateSystem\":1,\"Latitude\":29.93089,\"Longitude\":121.59923,\"Altitude\":10}}}"; // https://yq.aliyun.com/articles/706989 MqttMessage message = new MqttMessage(payloadJson.getBytes("utf-8")); message.setQos(1); mqttClient.publish(pubTopic, message); } catch (Exception e) { System.out.println(e.getMessage()); } } }
payLoad设备参考链接。
3、属性上报情况查看
4、通过物联网数据分析中的二维数据可视化功能,接入设备位置到地图
5、物联网数据分析通过SQL将数据下发至设备
- 5.1 查询数据
- 5.2 使用SQL下发数据
insert into ${pk.a1kVH******.device1} select 53.3 as CurrentHumidity; -- 导入数据到表,下发数据到设备
- 5.3 设备端订阅情况
上报属性值 Sub message Topic : /sys/a1kVH******/device1/thing/service/property/set {"method":"thing.service.property.set","id":"419651605","params":{"CurrentHumidity":53.3},"version":"1.0.0"}
参考链接
低调大师中文资讯倾力打造互联网数据资讯、行业资源、电子商务、移动互联网、网络营销平台。
持续更新报道IT业界、互联网、市场资讯、驱动更新,是最及时权威的产业资讯及硬件资讯报道平台。
转载内容版权归作者及来源网站所有,本站原创内容转载请注明来源。
- 上一篇
每日一博 | C语言中用 System V ucontext 实现的协程切换
此文在看了 python 中基于 yield 和 yield from (同步基于 yield 的子生成器/协程)机制的生成器/协程后,就想在C语言中实现类似机制。 在阅读 System V ucontext 手册后,便选择基于他来实现(要是此文自己实现“上下文切换描述”的话,该部分功能所花时间应该会比已有C代码所花时间要多)。所实现功能包括: yield yield from 基于 yield 和 yield from 机制协程的调度器 loop 这些功能皆在 ln_cs.c 中实现,experiences目录下为体验以上功能机制的例子(运行体验可参见 doc 目录下的文档)。 . ├── doc │ ├── A coroutine switching implement ... in C-language.md │ └── An optimization for ... in C-language.md ├── experiences │ ├── make_e │ ├── loop_e │ │ ├── loop_e.c │ │ ├── Makefile │ ├── yield_e ...
- 下一篇
图解kubernetes调度器SchedulerExtender扩展
在kubernetes的scheduler调度器的设计中为用户预留了两种扩展机制SchdulerExtender与Framework,本文主要浅谈一下SchdulerExtender的实现, 因为还有一篇Framework, 所以本文的k8s代码切到1.18版本 1. 设计思路 1.1 实现机制 SchdulerExtender是kubernets外部扩展方式,用户可以根据需求独立构建调度服务,实现对应的远程调用接口(目前是http), scheduler在调度的对应阶段会根据用户定义的资源和接口来进行远程调用,对应的service根据自己的资源数据和scheduler传递过来的中间调度结果来进行决策 1.2 服务插拔 extender只需要实现对应插件的接口,并编写yaml文件来进行注册对应的服务接口,就可以实现scheduler的扩展,不需要修改任何调度器的代码,即可实现调度插件的插拔 1.3 资源存储 因为是独立的服务,extender可以实现自定义资源的存储与获取,甚至可以不依赖于etcd使用第三方的存储来进行资源的存储,主要是用于kubernetes中不支持的那些资源的调度扩...
相关文章
文章评论
共有0条评论来说两句吧...
文章二维码
点击排行
推荐阅读
最新文章
- Docker使用Oracle官方镜像安装(12C,18C,19C)
- CentOS7,CentOS8安装Elasticsearch6.8.6
- CentOS6,CentOS7官方镜像安装Oracle11G
- CentOS7编译安装Cmake3.16.3,解决mysql等软件编译问题
- SpringBoot2编写第一个Controller,响应你的http请求并返回结果
- CentOS8编译安装MySQL8.0.19
- SpringBoot2配置默认Tomcat设置,开启更多高级功能
- Windows10,CentOS7,CentOS8安装Nodejs环境
- Docker快速安装Oracle11G,搭建oracle11g学习环境
- CentOS8,CentOS7,CentOS6编译安装Redis5.0.7