基于Android的智能終端通信勘察設計系統(tǒng)數(shù)據(jù)庫模塊的設計與實現(xiàn)
本文選題:通信勘察設計 + Android智能終端; 參考:《北京郵電大學》2016年碩士論文
【摘要】:隨著4G網(wǎng)絡的大量普及,通信工程中的勘察設計工作也會得到大量的機會和發(fā)展。而智能勘察行業(yè)在日趨激烈的競爭中也會面臨著更加嚴峻的問題。因此在智能勘察行業(yè)中也迫切需要采取和實施更加行之有效的勘察項目管理辦法。在通信勘察過程中,勘察設計人員需要采集大量的勘察數(shù)據(jù),對這些勘察數(shù)據(jù)進行處理和存儲?辈爝^程中需要進行存儲的數(shù)據(jù)有勘察人員信息、基站信息、現(xiàn)場拍攝的照片、設計圖紙和excel表格等。通過對當前勘察市場進行調(diào)研,當前市場上的的勘察軟件已經(jīng)實現(xiàn)了部分勘察數(shù)據(jù)的保存,但是存在著勘察人員權限劃分模糊,勘察人員訪問勘察數(shù)據(jù)透明化,勘察基站及勘察人員之間關聯(lián)薄弱等不足。本文中提出了以下改進方案:通過Android端數(shù)據(jù)庫和服務器端數(shù)據(jù)庫的方式實現(xiàn)勘察數(shù)據(jù)處理和存儲,可以同時在Android手機端和服務器端進行數(shù)據(jù)保存,Android手機端的數(shù)據(jù)保存實現(xiàn)了 Android端系統(tǒng)的離線使用。通過數(shù)據(jù)庫的用戶管理子模塊,明確細分了勘察人員權限,給予勘察人員不同的權限,在用戶登錄時進行用戶權限鑒定,不同權限勘察人員訪問到不同的基站和數(shù)據(jù),達到了數(shù)據(jù)安全的目的;通過數(shù)據(jù)庫基站子模塊的設置,實現(xiàn)省、市、和基站三級地域歸屬方案,達到了方便快捷管理數(shù)據(jù)的目的;通過數(shù)據(jù)庫勘察文件管理子模塊的設置,實現(xiàn)了勘查文件市、基站、勘察任務、勘察文件多級管理模式,同時實現(xiàn)了勘察文件按照文件類型分類管理的目的;通過數(shù)據(jù)庫的日志管理子模塊,實現(xiàn)了勘察人員登錄日志管理的目的。根據(jù)勘察設計的實際需求,設計實現(xiàn)了基于Android智能終端的勘察設計系統(tǒng),該系統(tǒng)的功能有數(shù)據(jù)采集、GPS定位、標準繪圖和數(shù)據(jù)存儲等模塊。在該系統(tǒng)中,數(shù)據(jù)庫模塊是通信勘察設計系統(tǒng)中的一個重要組成部分。本文中的主要成果如下:1)通過對通信勘察實際過程中需要保存的數(shù)據(jù)進行調(diào)查分析,提出并實現(xiàn)了勘察設計系統(tǒng)中的數(shù)據(jù)庫模塊。數(shù)據(jù)庫模塊主要包含了用戶管理子模塊,基站管理子模塊、勘察文件管理子模塊和日志管理子模塊。2)針對Android手機端,設計出適合Android系統(tǒng)的SQLite數(shù)據(jù)庫模型,實現(xiàn)了 Android端SQLite數(shù)據(jù)庫,并在Android端數(shù)據(jù)庫實現(xiàn)了各種數(shù)據(jù)庫操作;針對后臺服務器端,設計出適合服務器端的MySQL數(shù)據(jù)庫模型,實現(xiàn)了服務器端MySQL數(shù)據(jù)庫,并在服務器端數(shù)據(jù)庫實現(xiàn)了各種數(shù)據(jù)庫操作的目的。通過手機端軟件可以將數(shù)據(jù)上傳至服務器中的數(shù)據(jù)庫,同時通過服務器端可以派發(fā)勘察任務給手機端。3)完成了數(shù)據(jù)庫模塊的開發(fā),并給出了實際的運行案例。數(shù)據(jù)庫模塊對勘察過程中產(chǎn)生的勘察數(shù)據(jù)進行了高效合理的存儲,能夠方便勘察數(shù)據(jù)的后期查詢和整理,降低了勘察過程中的人力和物力,提高了勘察設計工作效率。經(jīng)過勘察人員實際測試表明,本系統(tǒng)滿足了勘察設計工作的需求。
[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
【參考文獻】
相關期刊論文 前10條
1 龍海濤;;IOS移動終端平臺與通信勘察設計結合的方案嘗試[J];中國新通信;2014年01期
2 葉雪梅;;項目管理在通信勘察設計企業(yè)的應用[J];企業(yè)研究;2012年16期
3 陳正舉;;基于HIBERNATE的數(shù)據(jù)庫訪問優(yōu)化[J];計算機應用與軟件;2012年07期
4 張恒喜;史爭軍;;基于SQLite的Android數(shù)據(jù)庫編程[J];電腦編程技巧與維護;2011年21期
5 張銳麗;石云;;基于Struts+Hibernate架構的圖書信息管理系統(tǒng)研究[J];科技信息;2009年33期
6 謝辛;;J2EE輕量級SSH架構無縫集成的研究[J];科技信息;2009年06期
7 劉曄;;勘察設計企業(yè)項目目標成本控制初探[J];當代經(jīng)濟(下半月);2008年08期
8 楊明根;鄭明秀;廖浩德;;Struts+Spring+Hibernate架構及開發(fā)方法[J];西南民族大學學報(自然科學版);2007年04期
9 竇東陽;趙英凱;許文稼;;利用Myeclipse簡化基于Hibernate的數(shù)據(jù)庫訪問[J];計算機工程與設計;2007年04期
10 連衛(wèi)民;張建偉;;基于Web工程數(shù)據(jù)庫的SQL語言系統(tǒng)的設計與實現(xiàn)[J];計算機工程與設計;2006年18期
,本文編號:1862323
本文鏈接:http://sikaile.net/kejilunwen/ruanjiangongchenglunwen/1862323.html