Design And Implementation Of Database Module In The Communication Survey And Design System Based On Android

With the increasing popularity of 4G networks,the survey and design of communication engineering will get a lot of opportunities and development.The intelligent survey industry in the increasingly fierce competition will face bigger problems.So intelligent survey industry also needs to adopt and implement more effective survey project management methods.In the process of communication survey,survey designers need to collect a lot of survey data,these survey data need to be processed and stored.The survey personnel information,base station information,site photographs,design drawings and excel spreadsheet need to be stored in the process of communication survey.Based on current survey market research,we found that the current survey software features is simple.The current survey software on the market to achieve a saving of nearly partial survey data,but there is a survey personnel division of authority blurred,survey staff transparent access to survey data,the base station and officers links weak.This paper proposes the following improvements program:By implementing the database in Android system and the database in server system,the data can be simultaneously saved in the Android mobile phone system and server systems,data storage achieve the offline using in Android system.User management sub-module database,a clear breakdown of the survey staff privileges given different permissions survey personnel,identified user permissions when users log on,survey personnel with different permissions access to different base stations and data,reache the data security purposes.By setting database sub-module of the base station,to achieve provincial,municipal,and regional home base three programs.By setting database file management sub-module of the survey,implement exploration file city,base stations,survey mission,survey file multi-level management model while achieving survey file by file type classification management.Through the database log management sub-module,achieve the purpose of survey personnel to log log management.According to the actual needs of survey and design,we design and implementation of the survey and design system based on the Android smart terminal,the functionality of the system is data acquisition,GPS,standard drawing and data storage.In this system,survey and design database module is a communication system is an important component.The main results of this paper are as follows.1)Through investigation and analysis of the data of communications survey and design process,we proposed and implemented a system of survey and design database module.Database module contains the user management sub-module,station management sub-module,survey document management sub-module and log management module.2)For Android system,we have designed a SQLite database model for Android system to achieve Android SQLite database,and achieve a variety of database operations in the Android client database.For backend server,MySQL database models designed for server-side,we have designed server-side MySQL database,and achieve a variety of database operations in the server database.For background on the server side,we design a model for the MySQL database server,the database model used to achieve the MySQL database server,and achieve a variety of database operations in the server database.By phone software the data can be uploaded to the server database,and can be distributed to a mobile terminal reconnaissance mission through the server.3)We completed the development of a database module,and give the actual operating cases.Through database module,survey data generated during survey stored efficient and rational,which can easily query and organize survey data,reduce the survey process of human and material resources,improve the efficiency of the survey and design work.After the survey officer tests show that the system meets the needs of the survey and design work.