本文選題：通信勘察設(shè)計(jì) + Android智能終端�。� 參考：《北京郵電大學(xué)》2016年碩士論文

【摘要】：隨著4G網(wǎng)絡(luò)的大量普及,通信工程中的勘察設(shè)計(jì)工作也會(huì)得到大量的機(jī)會(huì)和發(fā)展。而智能勘察行業(yè)在日趨激烈的競(jìng)爭(zhēng)中也會(huì)面臨著更加嚴(yán)峻的問(wèn)題。因此在智能勘察行業(yè)中也迫切需要采取和實(shí)施更加行之有效的勘察項(xiàng)目管理辦法。在通信勘察過(guò)程中,勘察設(shè)計(jì)人員需要采集大量的勘察數(shù)據(jù),對(duì)這些勘察數(shù)據(jù)進(jìn)行處理和存儲(chǔ)�？辈爝^(guò)程中需要進(jìn)行存儲(chǔ)的數(shù)據(jù)有勘察人員信息、基站信息、現(xiàn)場(chǎng)拍攝的照片、設(shè)計(jì)圖紙和excel表格等。通過(guò)對(duì)當(dāng)前勘察市場(chǎng)進(jìn)行調(diào)研,當(dāng)前市場(chǎng)上的的勘察軟件已經(jīng)實(shí)現(xiàn)了部分勘察數(shù)據(jù)的保存,但是存在著勘察人員權(quán)限劃分模糊,勘察人員訪(fǎng)問(wèn)勘察數(shù)據(jù)透明化,勘察基站及勘察人員之間關(guān)聯(lián)薄弱等不足。本文中提出了以下改進(jìn)方案:通過(guò)Android端數(shù)據(jù)庫(kù)和服務(wù)器端數(shù)據(jù)庫(kù)的方式實(shí)現(xiàn)勘察數(shù)據(jù)處理和存儲(chǔ),可以同時(shí)在Android手機(jī)端和服務(wù)器端進(jìn)行數(shù)據(jù)保存,Android手機(jī)端的數(shù)據(jù)保存實(shí)現(xiàn)了 Android端系統(tǒng)的離線(xiàn)使用。通過(guò)數(shù)據(jù)庫(kù)的用戶(hù)管理子模塊,明確細(xì)分了勘察人員權(quán)限,給予勘察人員不同的權(quán)限,在用戶(hù)登錄時(shí)進(jìn)行用戶(hù)權(quán)限鑒定,不同權(quán)限勘察人員訪(fǎng)問(wèn)到不同的基站和數(shù)據(jù),達(dá)到了數(shù)據(jù)安全的目的;通過(guò)數(shù)據(jù)庫(kù)基站子模塊的設(shè)置,實(shí)現(xiàn)省、市、和基站三級(jí)地域歸屬方案,達(dá)到了方便快捷管理數(shù)據(jù)的目的;通過(guò)數(shù)據(jù)庫(kù)勘察文件管理子模塊的設(shè)置,實(shí)現(xiàn)了勘查文件市、基站、勘察任務(wù)、勘察文件多級(jí)管理模式,同時(shí)實(shí)現(xiàn)了勘察文件按照文件類(lèi)型分類(lèi)管理的目的;通過(guò)數(shù)據(jù)庫(kù)的日志管理子模塊,實(shí)現(xiàn)了勘察人員登錄日志管理的目的。根據(jù)勘察設(shè)計(jì)的實(shí)際需求,設(shè)計(jì)實(shí)現(xiàn)了基于Android智能終端的勘察設(shè)計(jì)系統(tǒng),該系統(tǒng)的功能有數(shù)據(jù)采集、GPS定位、標(biāo)準(zhǔn)繪圖和數(shù)據(jù)存儲(chǔ)等模塊。在該系統(tǒng)中,數(shù)據(jù)庫(kù)模塊是通信勘察設(shè)計(jì)系統(tǒng)中的一個(gè)重要組成部分。本文中的主要成果如下:1)通過(guò)對(duì)通信勘察實(shí)際過(guò)程中需要保存的數(shù)據(jù)進(jìn)行調(diào)查分析,提出并實(shí)現(xiàn)了勘察設(shè)計(jì)系統(tǒng)中的數(shù)據(jù)庫(kù)模塊。數(shù)據(jù)庫(kù)模塊主要包含了用戶(hù)管理子模塊,基站管理子模塊、勘察文件管理子模塊和日志管理子模塊。2)針對(duì)Android手機(jī)端,設(shè)計(jì)出適合Android系統(tǒng)的SQLite數(shù)據(jù)庫(kù)模型,實(shí)現(xiàn)了 Android端SQLite數(shù)據(jù)庫(kù),并在Android端數(shù)據(jù)庫(kù)實(shí)現(xiàn)了各種數(shù)據(jù)庫(kù)操作;針對(duì)后臺(tái)服務(wù)器端,設(shè)計(jì)出適合服務(wù)器端的MySQL數(shù)據(jù)庫(kù)模型,實(shí)現(xiàn)了服務(wù)器端MySQL數(shù)據(jù)庫(kù),并在服務(wù)器端數(shù)據(jù)庫(kù)實(shí)現(xiàn)了各種數(shù)據(jù)庫(kù)操作的目的。通過(guò)手機(jī)端軟件可以將數(shù)據(jù)上傳至服務(wù)器中的數(shù)據(jù)庫(kù),同時(shí)通過(guò)服務(wù)器端可以派發(fā)勘察任務(wù)給手機(jī)端。3)完成了數(shù)據(jù)庫(kù)模塊的開(kāi)發(fā),并給出了實(shí)際的運(yùn)行案例。數(shù)據(jù)庫(kù)模塊對(duì)勘察過(guò)程中產(chǎn)生的勘察數(shù)據(jù)進(jìn)行了高效合理的存儲(chǔ),能夠方便勘察數(shù)據(jù)的后期查詢(xún)和整理,降低了勘察過(guò)程中的人力和物力,提高了勘察設(shè)計(jì)工作效率。經(jīng)過(guò)勘察人員實(shí)際測(cè)試表明,本系統(tǒng)滿(mǎn)足了勘察設(shè)計(jì)工作的需求。
[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.
【學(xué)位授予單位】：北京郵電大學(xué)
【學(xué)位級(jí)別】：碩士
【學(xué)位授予年份】：2016
【分類(lèi)號(hào)】：TP311.52;TP316

【參考文獻(xiàn)】

相關(guān)期刊論文 前10條

1 龍海濤;;IOS移動(dòng)終端平臺(tái)與通信勘察設(shè)計(jì)結(jié)合的方案嘗試[J];中國(guó)新通信;2014年01期

2 葉雪梅;;項(xiàng)目管理在通信勘察設(shè)計(jì)企業(yè)的應(yīng)用[J];企業(yè)研究;2012年16期

3 陳正舉;;基于HIBERNATE的數(shù)據(jù)庫(kù)訪(fǎng)問(wèn)優(yōu)化[J];計(jì)算機(jī)應(yīng)用與軟件;2012年07期

4 張恒喜;史爭(zhēng)軍;;基于SQLite的Android數(shù)據(jù)庫(kù)編程[J];電腦編程技巧與維護(hù);2011年21期

5 張銳麗;石云;;基于Struts+Hibernate架構(gòu)的圖書(shū)信息管理系統(tǒng)研究[J];科技信息;2009年33期

6 謝辛;;J2EE輕量級(jí)SSH架構(gòu)無(wú)縫集成的研究[J];科技信息;2009年06期

7 劉曄;;勘察設(shè)計(jì)企業(yè)項(xiàng)目目標(biāo)成本控制初探[J];當(dāng)代經(jīng)濟(jì)(下半月);2008年08期

8 楊明根;鄭明秀;廖浩德;;Struts+Spring+Hibernate架構(gòu)及開(kāi)發(fā)方法[J];西南民族大學(xué)學(xué)報(bào)(自然科學(xué)版);2007年04期

9 竇東陽(yáng);趙英凱;許文稼;;利用Myeclipse簡(jiǎn)化基于Hibernate的數(shù)據(jù)庫(kù)訪(fǎng)問(wèn)[J];計(jì)算機(jī)工程與設(shè)計(jì);2007年04期

10 連衛(wèi)民;張建偉;;基于Web工程數(shù)據(jù)庫(kù)的SQL語(yǔ)言系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)[J];計(jì)算機(jī)工程與設(shè)計(jì);2006年18期

，

本文編號(hào)：1862323