基于Android的智能终端通信勘察设计系统数据库模块的设计与实现

发布时间：2018-05-08 17:26

本文选题：通信勘察设计 + Android智能终端　；参考：《北京邮电大学》2016年硕士论文

【摘要】：随着4G网络的大量普及,通信工程中的勘察设计工作也会得到大量的机会和发展。而智能勘察行业在日趋激烈的竞争中也会面临着更加严峻的问题。因此在智能勘察行业中也迫切需要采取和实施更加行之有效的勘察项目管理办法。在通信勘察过程中,勘察设计人员需要采集大量的勘察数据,对这些勘察数据进行处理和存储。勘察过程中需要进行存储的数据有勘察人员信息、基站信息、现场拍摄的照片、设计图纸和excel表格等。通过对当前勘察市场进行调研,当前市场上的的勘察软件已经实现了部分勘察数据的保存,但是存在着勘察人员权限划分模糊,勘察人员访问勘察数据透明化,勘察基站及勘察人员之间关联薄弱等不足。本文中提出了以下改进方案:通过Android端数据库和服务器端数据库的方式实现勘察数据处理和存储,可以同时在Android手机端和服务器端进行数据保存,Android手机端的数据保存实现了 Android端系统的离线使用。通过数据库的用户管理子模块,明确细分了勘察人员权限,给予勘察人员不同的权限,在用户登录时进行用户权限鉴定,不同权限勘察人员访问到不同的基站和数据,达到了数据安全的目的;通过数据库基站子模块的设置,实现省、市、和基站三级地域归属方案,达到了方便快捷管理数据的目的;通过数据库勘察文件管理子模块的设置,实现了勘查文件市、基站、勘察任务、勘察文件多级管理模式,同时实现了勘察文件按照文件类型分类管理的目的;通过数据库的日志管理子模块,实现了勘察人员登录日志管理的目的。根据勘察设计的实际需求,设计实现了基于Android智能终端的勘察设计系统,该系统的功能有数据采集、GPS定位、标准绘图和数据存储等模块。在该系统中,数据库模块是通信勘察设计系统中的一个重要组成部分。本文中的主要成果如下:1)通过对通信勘察实际过程中需要保存的数据进行调查分析,提出并实现了勘察设计系统中的数据库模块。数据库模块主要包含了用户管理子模块,基站管理子模块、勘察文件管理子模块和日志管理子模块。2)针对Android手机端,设计出适合Android系统的SQLite数据库模型,实现了 Android端SQLite数据库,并在Android端数据库实现了各种数据库操作;针对后台服务器端,设计出适合服务器端的MySQL数据库模型,实现了服务器端MySQL数据库,并在服务器端数据库实现了各种数据库操作的目的。通过手机端软件可以将数据上传至服务器中的数据库,同时通过服务器端可以派发勘察任务给手机端。3)完成了数据库模块的开发,并给出了实际的运行案例。数据库模块对勘察过程中产生的勘察数据进行了高效合理的存储,能够方便勘察数据的后期查询和整理,降低了勘察过程中的人力和物力,提高了勘察设计工作效率。经过勘察人员实际测试表明,本系统满足了勘察设计工作的需求。
[Abstract]:With the popularization of 4G network, the investigation and design work in communication engineering will get a lot of opportunities and development. The intelligent survey industry will also face more serious problems in the increasingly fierce competition. Therefore, it is urgent to adopt and implement more effective survey project management methods in intelligent survey industry. In the process of communication investigation, survey and design personnel need to collect a large number of survey data, processing and storage of these survey data. The data needed to be stored in the process of investigation include the information of the surveyor, the information of the base station, the photos taken on the spot, the design drawings and the excel forms, etc. Through the investigation of the current survey market, the survey software in the current market has realized the preservation of some survey data, but there is a fuzzy division of the authority of the surveyor, and the survey personnel visit the survey data transparently. Survey base station and survey between the weak link between the staff and other deficiencies. In this paper, the following improvement schemes are put forward: to realize the processing and storage of survey data by the way of Android database and server-side database, Data saving can be carried out on the Android mobile phone and server simultaneously. The Android system can be used offline. Through the user management sub-module of the database, the authority of the surveyor is clearly subdivided, different permissions are given to the surveyor, the user authority is authenticated when the user logs on, and the surveyor with different permissions accesses different base stations and data. Achieve the purpose of data security; through the database base station sub-module setting, realize the provincial, municipal, and base station three-level regional ownership scheme, to achieve the purpose of convenient and quick management of data; through the database exploration file management sub-module setting, The multilevel management mode of exploration file city, base station, reconnaissance task and reconnaissance file is realized. At the same time, the purpose of classification management of survey file according to file type is realized; through the log management sub-module of database, The purpose of log management for surveyors is realized. According to the actual requirements of survey and design, a survey and design system based on Android intelligent terminal is designed and implemented. The functions of the system include data acquisition and GPS positioning, standard drawing and data storage. In this system, the database module is an important part of the communication reconnaissance and design system. The main achievements in this paper are as follows: (1) through the investigation and analysis of the data needed to be preserved in the actual process of communication investigation, the database module of the survey and design system is put forward and realized. The database module mainly includes the user management sub-module, the base station management sub-module, the reconnaissance file management sub-module and the log management sub-module. (2) aiming at the Android mobile phone, the SQLite database model suitable for Android system is designed. The SQLite database on the Android side is realized, and various database operations are realized in the Android side. The MySQL database model suitable for the server side is designed for the background server, and the MySQL database on the server side is realized. And in the server side of the database to achieve the purpose of various database operations. The data can be uploaded to the database in the server through the software of the mobile phone, and at the same time, the investigation task can be distributed to the mobile terminal. 3) the development of the database module is completed, and the actual operation case is given. The database module can store the survey data efficiently and reasonably, which can facilitate the inquiry and arrangement of the survey data, reduce the manpower and material resources in the survey process, and improve the efficiency of investigation and design. The actual test of the surveyor shows that the system meets the requirements of the survey and design work.
【学位授予单位】：北京邮电大学
【学位级别】：硕士
【学位授予年份】：2016
【分类号】：TP311.52;TP316

【参考文献】