基于SQL语言智能路灯系统环境数据处理与分析

Environment Data Processing and Analysis of Intelligent Street Lamp System based on SQL Language

针对当前城市路灯照明功能单一、空间资源利用不足等问题,提出构建一种具有环境数据监测功能的智能路灯系统,介绍其总体架构,将路灯的海量数据上传至阿里云物联网平台,利用SQL进行数据处理分析,发布结果至Web界面,实现对路灯环境数据价值的深入挖掘。

For the current problems of single function and insufficient utilization of space resources of urban street lighting,this paper proposes an intelligent street lamp system which habors environmental data monitoring function and exploit SQL language to conduct research on environmental data processing and analysis.Massive data of street lamps are uploaded to Alibaba cloud IOT platform,the platform uses its own SQL data analysis service for data processing and analysis and publish results to web interface.In this way,we can realize the in-depth mining of the value of street lamp environmental data.