基于物联网应用的SQL数据服务系统研究

发布时间：2018-02-16 08:13

  本文关键词： 物联网 数据库 塔机安全 卫星导航 数据服务　出处：《南京航空航天大学》2014年硕士论文　论文类型：学位论文

【摘要】：随着信息化、网络化和数字化时代的到来,各领域的技术融合成为未来产品的发展趋势。物联网作为世界信息产业的第三次浪潮,综合了多项技术,实现了物与物之间的连接。本文从物联网的角度思考,对物联网、网络技术与数据库三者的结合进行了探讨,研究了一套通用的数据服务系统,并对该系统的框架结构进行了分析和设计,将其主要分为三个模块:基于嵌入式的数据采集接收模块、基于网络的数据传输模块和基于数据库的数据存储与管理模块。针对结构中各模块的方案进行了探讨、分析与比较,为具体应用实现奠定了基础;最后以塔机远程监测与卫星导航模拟信号源为应用背景,对此系统进行了应用研究。以塔机远程监测为例,基于物联网的三层结构,探讨分析了系统软硬件架构。首先对硬件平台选择进行了分析阐述,完成了Wince嵌入式系统的定制、裁剪;然后分析了三层C/S软件构架的实现,实现了基于以太网的UDP远程数据实时传输;并基于SQL Server数据库系统,设计创建了塔机群数据库,采用ADO数据库访问技术实现了数据库的连接、读写等操作,最后通过功能测试,很好地实现了远程监测功能,证实了该数据服务系统的可行性。以卫星导航模拟信号源为例,分析了模拟信号源的系统架构,并将数据服务系统理论应用于导航数据、轨迹最佳路径等配置参数的更新实现。首先基于SQL Server数据库系统,设计创建了GPS导航数据库,采用ADO数据库访问技术实现了数据库的连接、读写等操作,并实现了基于以太网的TCP远程数据传输,为信号源提供了实时的导航数据;然后采用C++与Matlab联合编程,模拟生成了GPS中频信号,最后经过其它硬件模块转换生成卫星导航信号,用接收机对其进行了定位测试,定位结果与预期一致,表明了该数据服务系统的有效性。
[Abstract]:With the development of information technology, network and digital era, the field of technology integration has become the future development trend of the product. The Internet of things as the third wave of global information industry, integrated technology, realize the connection between objects and objects. The thinking of things from the perspective of things, the combination of network technology and database the three discusses the research, a general data service system, and the frame structure of the system are analyzed and designed, which is mainly divided into three modules: data acquisition module based on embedded receiver, data transmission module based on network and based on the data storage and database management module. For each module in the structure of the scheme is discussed, and the comparative analysis, laid the foundation for the realization of the tower crane; remote monitoring and satellite navigation simulation signal source for application background In this regard, the system was studied. The tower crane remote monitoring as an example, the three layer structure of IOT based on the analysis of the system hardware and software architecture. The choice of hardware platform are analyzed, and completed the Wince embedded system customization, tailoring; then analyzes the three layer C/S architecture, realized UDP remote data real-time transmission based on Ethernet; and based on SQL Server database system, the design of tower crane group created a database, using ADO database access technology to realize the database connection, read and write operations, and finally through the functional test, good implementation of the remote monitoring function, confirm the feasibility of the data service system by satellite. Navigation simulation signal source for example, analyzes the system architecture of the analog signal source, and the application of data service system theory in the navigation data, the best path track configuration parameters of the real update At first. Based on the SQL Server database system design, create a GPS navigation database, using ADO database access technology to realize the database connection, read and write operations, and implement the TCP remote data transmission based on Ethernet, to provide real-time data for the navigation signal; then the C++ and Matlab joint programming, simulate GPS intermediate frequency signal, finally through the other hardware module to convert the satellite navigation signal, the positioning test used in the receiver, the positioning results are consistent with expectations, show the effectiveness of the data service system.

【学位授予单位】：南京航空航天大学
【学位级别】：硕士
【学位授予年份】：2014
【分类号】：TN929.5;TP391.44;TP311.13
，

本文编号：1515060