Call For Papers
Contact Us

  Integration of Database and Mobile APP to Manage the Activities of Unmanned Aerial Vehicle (UAV) In a Named Locality  
  Authors : Richard Obeng; Peng Zong; Yang FengFan
  Cite as:


With the development of database management systems and the advent of android application to ease the burden of data storage and retrieval (management), collection and processing of data on devices and artifacts that seemed extremely difficult is presently made quite easy. In this paper, the concept of database management is introduced and a mobile application is designed and hosted online. Management software of database server is established to realize instruction-level management and scheduling of databases. A Web-based management application interface (android APP) is set up to meet user needs, thus to retrieve a variety of repositories. Thereby, meets the needs of stakeholders, researchers and all sectors of society for statistical query of UAV data.


Published In : IJCSN Journal Volume 8, Issue 1

Date of Publication : February 2019

Pages : 52-57

Figures :06

Tables : --


Richard Obeng : College of Information Systems Nanjing University of Aeronautics and Astronautics, Nanjing Jiangsu Province, 210016, China.

Peng Zong : College of Information Systems Nanjing University of Aeronautics and Astronautics, Nanjing Jiangsu Province, 210016, China.

Yang FengFan : College of Information Systems Nanjing University of Aeronautics and Astronautics, Nanjing Jiangsu Province, 210016, China.


Android APP, Database Management System, Java classes, MySQL database

The problem of indiscriminate use of UAVs which has been a cancer in many countries as perpetrators use them dubiously has been investigated and a possible antidote of such a menace suggested. By the use of a management system that take into cognizance collection and storage of information on all UAVs in the area taking into consideration, the purpose, location and the specific details of each device. Adopting a mobile application system, an APP is developed with an underlying database to host the information. The app is hosted online to be accessed ubiquitously by all stakeholders. After building the app and hosting online, it is tested using different test values to prove if the app can really be used to manage the information as required. In larger perspective, the piece of work could be adopted in different fields. It has the ability to be accessed universally and hence useful for top managers and decision makers since they can still work remotely. The challenge associated with this software is that it cannot track the activities of the UAV when it takes off because it is not connected to the UAV's sensor. It is therefore the foresight of the researcher to include into the project a sensor detection component that will be able to read and record the state (GPS and other flight information) of the UAV when it is in the flight mode, thus, in the future works.


[1] MacDorman, K. F., & Ishiguro, H. (2006b). The uncanny advantage of using androids in social and cognitive science research. interaction Studies, 7(3), 297-337. [2] www.blog.htmel.com/2014/08/18/-awesome-ways-drones-areused- today [3] www.blogwills.com2015/12-drones-safety-consideration - potential-liability-concerns-definitely-more-than-just-a-toy/ [4] N. Prakash, Understanding Database Management. Tata- McGraw-Hill, New Delhi (1985). [5] https://www.digitaltrends.com/mobile/best-drone-apps/ [6] Wang Hongman , Zhu Xiaocheng , Chang Jiangbo Acceleration and Orientation Multisensor Pedometer Application Design and Implementation on the Android Platform. IEEE 2011 First International Conference on Instrumentation, Measurement, Computer, Communication and Control (IMCCC) - Beijing, China [7] Zhang Xinyu, Song Jinyu Design and Development of Campus Dating Social Application Based on Android 2nd IEEE International Conference on Engineering and Technology (ICETECH), 17th & 18th March 2016, Coimbatore, TN, India. [8] Cheryl Bagley Thompson and Katherine Sward Modeling and Teaching Techniques for Conceptual and Logical Relational Database Design Journal of Medical Systems, Vol. 29, No. 5, October 2005 [9] Dhammika Pieris* and Jayantha Rajapakse+ Logical Database Design with Ontologically Clear Entity Relationship Models, [IEEE 2012 IEEE 6th International Conference on Information and Automation for Sustainability (ICIAfS) - Beijing, China [10] C. Fahrner and G. Vossen, "A survey of database design transformations based on the Entity-Relationship model," Data & Knowledge Engineering, vol. 15, pp. 213-250, 1995. [11] Date, C. J., An Introduction to Database Systems, 8th edn. Addison-Wesley, Reading, MA, 2003. [12] http://developer.android.com/index.html, May 2011 [13] Gasolin, Shijiang Wang. Android Development Portal Guide. Beijing: PTPRSS.2009