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

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

作　　者：李亮 丁杰 刘盼伟 熊佳敏 

机构地区：[1]湖南文理学院

出　　处：《信息技术与标准化》2023年第1期85-88,共4页Information Technology & Standardization

基　　金：湖南省科技创新计划资助之“基于物联网交互的环境监测智能配光路灯”项目,项目编号:2021RC1013。

摘　　要：针对当前城市路灯照明功能单一、空间资源利用不足等问题,提出构建一种具有环境数据监测功能的智能路灯系统,介绍其总体架构,将路灯的海量数据上传至阿里云物联网平台,利用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.

关 键 词：智能路灯系统 环境数据 SQL语言 阿里云 物联网 

分 类 号：TU113.666[建筑科学—建筑理论] TP311.13[自动化与计算机技术—计算机软件与理论]