A Virtual Assistant Design and Application on Industrial Database

Öz

The development and advancement of technology allows people to access information in a variety of ways. Whether in commerce, marketing or communication, the amount and variety of data is increasing in every field. Collecting this data in different fields and drawing conclusions based on the data has become very important for the development of individuals, companies, industries, and countries, and especially collecting this data in databases has become popular. In this paper, an industrial database was created, a wireless sensor network was set up using ZigBee protocol for data collection, the collection of data in the database was done quickly and cheaply, and a natural language processing based Virtual Assistant was created to query the data. Unlike other traditional rule-based methods, Virtual Assistant has a non-predetermined structure that allows Virtual Assistant to answer different types of questions from the user. The communication between the created Sensor Network, database and Virtual Assistant is done using XMPP message protocol. Again, with the help of this protocol, a system is presented to communicate with the user. With the method presented in the study, the data in the relational database was made queryable regardless of location and platform. With the virtual help system provided, the distance between natural language and computer language is shortened and people can get information quickly and easily.

Anahtar Kelimeler

• virtual assistant
• natural language processing
• database
• ZigBee
• XMPP

Kaynakça

1. Adalı, Eşref. 2016. “Doğal Dil İşleme.” Türkiye Bilişim Vakfı Bilgisayar Bilimleri ve Mühendisliği Dergisi 5(2).
2. Akyildiz, Ian, Su WY, Y. Sankarasubramaniam, and E. Cayirci. 2002. “Wireless Sensor Networks: A Survey.” Computer Networks 38:393–422. doi: 10.1016/S1389-1286(01)00302-4.
3. Ali, Anum, Ghalib A. Shah, Muhammad Omer Farooq, and Usman Ghani. 2017. “Technologies and Challenges in Developing Machine-to-Machine Applications: A Survey.” Journal of Network and Computer Applications 83:124–39. doi: 10.1016/j.jnca.2017.02.002.
4. Al-Rasyid, M. Udin Harun, Sritrusta Sukaridhoto, Muhammad Iskandar Dzulqornain, and Ahmad Rifai. 2020. “Integration of IoT and Chatbot for Aquaculture with Natural Language Processing.” TELKOMNIKA (Telecommunication Computing Electronics and Control) 18(2):640–48.
5. Anon. n.d. “Cisco Visual Networking Index: Forecast and Trends, 2017–2022.” Cisco. Retrieved August 21, 2021 (https://www.cisco.com/c/en/us/solutions/collateral/service-provider/visual-networking-index-vni/white-paper-c11-741490.html).
6. Atzori, Luigi, Antonio Iera, and Giacomo Morabito. 2010. “The Internet of Things: A Survey.” Computer Networks 54(15):2787–2805. doi: 10.1016/j.comnet.2010.05.010.
7. Baker, Nick. 2005. “ZigBee and Bluetooth Strengths and Weaknesses for Industrial Applications.” Computing & Control Engineering Journal 16(2):20–25.
8. Bandyopadhyay, Debasis, and Jaydip Sen. 2011. “Internet of Things: Applications and Challenges in Technology and Standardization.” Wireless Personal Communications 58(1):49–69. doi: 10.1007/s11277-011-0288-5.

9. Banks, Andrew, and Rahul Gupta. 2014. “MQTT Version 3.1. 1.” OASIS Standard 29:89.
10. Bansal, Himanshu, and Rizwan Khan. 2018. “A Review Paper on Human Computer Interaction.” International Journals of Advanced Research in Computer Science and Software Engineering 8:53–56.
11. Başarslan, Muhammet Sinan, and Fatih Kayaalp. 2021. “Sentiment Analysis on Social Media Reviews Datasets with Deep Learning Approach.” Sakarya University Journal of Computer and Information Sciences 4(1):35–49.
12. Bhadgale, Anil M., Sanhita R. Gavas, and P. R. Goyal. 2013. “Natural Language to SQL Conversion System.” International Journal of Computer Science Engineering and Information Technology Research 3(2):161–66.
13. Couderc, Benoît, and Jérémy Ferrero. 2015. “Fr2sql: Interrogation de Bases de Données En Français.” in 22ème Traitement Automatique des Langues Naturelles.
14. Dener, Murat. 2019. “A New Home Gateway Design and A Sensor-Based Smart Home Application Including Privacy Protection.” Bilişim Teknolojileri Dergisi 12(1):23–32.
15. Erdoğan, Hamdi, Kerem Küçük, and Sajjad Ahmad Khan. 2020. “Endüstriyel IoT Bulut Uygulamaları Için Düşük Maliyetli Modbus/MQTT Ağ Geçidi Tasarımı ve Gerçekleştirilmesi.” Bilecik Şeyh Edebali Üniversitesi Fen Bilimleri Dergisi 7(1):170–83.
16. Farahani, Shahin. 2011. ZigBee Wireless Networks and Transceivers. Newnes.
17. Group, Somayya Madakam$IT Applications, National Institute of Industrial Engineering (NITIE), Vihar Lake, Mumbai, India╃R Ramaswamy$IT Applications Group, National Institute of Industrial Engineering (NITIE), Vihar Lake, Mumbai, India╃Siddharth Tripathi$IT Applications Group, National Institute of Industrial Engineering (NITIE), Vihar Lake, Mumbai, and India. 2015. “Internet of Things (IoT): A Literature Review.” Journal of Computer and Communications 03(05):164. doi: 10.4236/jcc.2015.35021.
18. Gubbi, Jayavardhana, Rajkumar Buyya, Slaven Marusic, and Marimuthu Palaniswami. 2013. “Internet of Things (IoT): A Vision, Architectural Elements, and Future Directions.” Future Generation Computer Systems 29(7):1645–60. doi: 10.1016/j.future.2013.01.010.
19. Jeschke, Sabina, Christian Brecher, Tobias Meisen, Denis Özdemir, and Tim Eschert. 2017. “Industrial Internet of Things and Cyber Manufacturing Systems.” Pp. 3–19 in Industrial Internet of Things: Cybermanufacturing Systems, Springer Series in Wireless Technology, edited by S. Jeschke, C. Brecher, H. Song, and D. B. Rawat. Cham: Springer International Publishing.
20. Khalil, Nacer, Mohamed Riduan Abid, Driss Benhaddou, and Michael Gerndt. 2014. “Wireless Sensors Networks for Internet of Things.” Pp. 1–6 in 2014 IEEE Ninth International Conference on Intelligent Sensors, Sensor Networks and Information Processing (ISSNIP).
21. Kiani, Farzad. 2018. “Animal Behavior Management by Energy-Efficient Wireless Sensor Networks.” Computers and Electronics in Agriculture 151:478–84. doi: 10.1016/j.compag.2018.06.046.
22. Lee, Jin-Shyan, Yu-Wei Su, and Chung-Chou Shen. 2007. “A Comparative Study of Wireless Protocols: Bluetooth, UWB, ZigBee, and Wi-Fi.” Pp. 46–51 in IECON 2007 - 33rd Annual Conference of the IEEE Industrial Electronics Society.
23. Mainetti, Luca, Luigi Patrono, and Antonio Vilei. 2011. “Evolution of Wireless Sensor Networks towards the Internet of Things: A Survey.” Pp. 1–6 in SoftCOM 2011, 19th International Conference on Software, Telecommunications and Computer Networks.
24. Mainwaring, Alan, David Culler, Joseph Polastre, Robert Szewczyk, and John Anderson. 2002. “Wireless Sensor Networks for Habitat Monitoring.” Pp. 88–97 in Proceedings of the 1st ACM international workshop on Wireless sensor networks and applications, WSNA ’02. New York, NY, USA: Association for Computing Machinery.
25. Mohamudally, Nawaz, and Mahejabeen Peermamode-Mohaboob. 2018. “Building An Anomaly Detection Engine (ADE) For IoT Smart Applications.” Procedia Computer Science 134:10–17. doi: 10.1016/j.procs.2018.07.138.
26. Parthornratt, Tussanai, Dollachart Kitsawat, Pasd Putthapipat, and Prapap Koronjaruwat. 2018. “A Smart Home Automation Via Facebook Chatbot and Raspberry Pi.” Pp. 52–56 in 2018 2nd International Conference on Engineering Innovation (ICEI).
27. Roca, Surya, Jorge Sancho, José García, and Álvaro Alesanco. 2020. “Microservice Chatbot Architecture for Chronic Patient Support.” Journal of Biomedical Informatics 102:103305. doi: 10.1016/j.jbi.2019.103305.
28. Rodrigues, Joel J. P. C., and Paulo A. C. S. Neves. 2010. “A Survey on IP-Based Wireless Sensor Network Solutions.” International Journal of Communication Systems 23(8):963–81. doi: 10.1002/dac.1099.
29. Sadeghi, Ahmad-Reza, Christian Wachsmann, and Michael Waidner. 2015. “Security and Privacy Challenges in Industrial Internet of Things.” Pp. 1–6 in 2015 52nd ACM/EDAC/IEEE Design Automation Conference (DAC).
30. Saint-Andre, Peter. 2004. “Rfc 3920: Extensible Messaging and Presence Protocol (Xmpp): Core.” Internet Engineering Task Force.
31. Saint-Andre, Peter, Kevin Smith, Remko Tronçon, and Remko Troncon. 2009. XMPP: The Definitive Guide. O’Reilly Media, Inc.
32. Shelby, Zach, Klaus Hartke, and Carsten Bormann. 2014. The Constrained Application Protocol (CoAP). Request for Comments. RFC 7252. Internet Engineering Task Force. doi: 10.17487/RFC7252.
33. Sun, Zhi, Pu Wang, Mehmet C. Vuran, Mznah A. Al-Rodhaan, Abdullah M. Al-Dhelaan, and Ian F. Akyildiz. 2011. “BorderSense: Border Patrol through Advanced Wireless Sensor Networks.” Ad Hoc Networks 9(3):468–77. doi: 10.1016/j.adhoc.2010.09.008.
34. Taştan, Mehmet. 2019. “Akıllı Ev Uygulamaları Için Yeni Nesil IoT Denetleyici Ile Gerçek Zamanlı Uzaktan İzleme ve Kontrol Uygulaması.” Süleyman Demirel Üniversitesi Fen Bilimleri Enstitüsü Dergisi 23(2):481–87.
35. Thangavel, Dinesh, Xiaoping Ma, Alvin Valera, Hwee-Xian Tan, and Colin Keng-Yan Tan. 2014. “Performance Evaluation of MQTT and CoAP via a Common Middleware.” Pp. 1–6 in 2014 IEEE ninth international conference on intelligent sensors, sensor networks and information processing (ISSNIP). IEEE.
36. TOÇOĞLU, Mansur Alp. 2020. “Sentiment Analysis for Software Engineering Domain in Turkish.” Sakarya University Journal of Computer and Information Sciences 3(3):296–308.
37. Toğay, Cengiz, Gökhan Mutlu, Durmuş KURTULUŞ, and Faik ÖZGÜR. 2019. “Secure Gateway for the Internet of Things.” Avrupa Bilim ve Teknoloji Dergisi (16):414–26.
38. Vermesan, Ovidiu, and Peter Friess. 2014. Internet of Things-from Research and Innovation to Market Deployment. Vol. 29. River publishers Aalborg.
39. Yazar, Dogan, and Adam Dunkels. 2009. “Efficient Application Integration in IP-Based Sensor Networks.” Pp. 43–48 in Proceedings of the First ACM Workshop on Embedded Sensing Systems for Energy-Efficiency in Buildings, BuildSys ’09. New York, NY, USA: Association for Computing Machinery.
40. Yick, Jennifer, Biswanath Mukherjee, and Dipak Ghosal. 2008. “Wireless Sensor Network Survey.” Computer Networks 52(12):2292–2330.
41. Yu, Liyang, Neng Wang, and Xiaoqiao Meng. 2005. “Real-Time Forest Fire Detection with Wireless Sensor Networks.” Pp. 1214–17 in Proceedings. 2005 International Conference on Wireless Communications, Networking and Mobile Computing, 2005. Vol. 2.
42. Zhu, Qian, Ruicong Wang, Qi Chen, Yan Liu, and Weijun Qin. 2010. “IOT Gateway: BridgingWireless Sensor Networks into Internet of Things.” Pp. 347–52 in 2010 IEEE/IFIP International Conference on Embedded and Ubiquitous Computing.
43. Ziegler, Sébastien, Peter Kirstein, Latif Ladid, Antonio Skarmeta, and Antonio Jara. 2015. “The Case for Ipv6 as an Enabler of the Internet of Things.” IEEE Internet of Things.