RESEARCH ON DATABASE TYPES AND METHODS TO STANDARDIZE DATABASE TYPES IN THE FIELD OF TRANSPORT INFRASTRUCTURE

Details

Hits: 813

Volume 6 (1), June 2023, Pages 3-18

Tran Anh Kiet, Trinh Cong Duy

The University of Danang, Danang, Vietnam, This email address is being protected from spambots. You need JavaScript enabled to view it., This email address is being protected from spambots. You need JavaScript enabled to view it.

Abstract

In truthfully, managing and storing information and data at the Department of Transport and its units in Da Nang city is still done manually and sporadically. Currently, the majority of them still utilize paper or digitized records but still save them separately on personal computers for managing and storing information regarding infrastructure, modes of transportation, etc. (.doc, .xls, .pdf files, Autocad, Video, Audio, Images, ...). Storing, maintaining, looking up, and discovering information is greatly hampered by this. There are still inconsistencies and delays in the deployment of information reporting, management information, digitization, and the availability of exploitation channels. In line with the Ministry of Transport's strategy, information technology should be used to manage transportation activities. Organizations and units in the transportation industry across the nation have developed and implemented various specialized software to assist in managing road transport. Software solutions have offered management information, enhancing professional management effectiveness. The deploying units use each software system separately, storing and handling specialized data in various ways. When it is necessary to handle and review the information of road transport vehicles, including registration information, vehicle registration, and information about traffic safety infractions, the program does not have a connection or data sharing capabilities. To access and compare data, expert employees must look for information and data on each software system to retrieve and compare data. The specificity of the data of each transport infrastructure project is that the data is very large and has many different formats; the information is updated regularly every year according to the maintenance, renovation, and upgrading process, etc. Traditional storage and data representation, like how database management systems and management software are used, will not meet the demand. In this paper, we propose a solution to build a centralized specialized database, have a specific organizational plan according to the specific characteristics of the industry, and be able to integrate data from specialized applications to connect and unify data between authorities. This will be a platform for sharing and exploiting data for professional management between authorities in the city and the whole country. The people and state management agencies highly appreciate this solution, which has been researched and implemented experimentally in Danang City.

Keywords:

Management, Storage, Information,  Transport, Exploitation Channels

DOI: https://doi.org/10.32010/26166127.2023.6.1.3.18

Reference 

Baidal, C. S., Arreaga, N. X., & Padilla, V. S. (2020). Design and testing of a dynamic reactive signage network towards fire emergency evacuations. International Journal of Electrical & Computer Engineering (2088-8708), 10(6).

Burke, R. (2007). Hybrid web recommender systems. The adaptive web: methods and strategies of web personalization, 377-408.

Elnaghi, B. E., Dessouki, M. E., Abd-Alwahab, M. N., & Elkholy, E. E. (2020). Development and implementation of two-stage boost converter for single-phase inverter without transformer for PV systems. International Journal of Electrical & Computer Engineering (2088-8708), 10(1).

Feddaoui, O., Toufouti, R., Jamel, L., & Meziane, S. (2020). Fuzzy logic control of hybrid systems including renewable energy in microgrids. International Journal of Electrical & Computer Engineering (2088-8708), 10(6).

Feddaoui, O., Toufouti, R., Jamel, L., & Meziane, S. (2020). Fuzzy logic control of hybrid systems including renewable energy in microgrids. International Journal of Electrical & Computer Engineering (2088-8708), 10(6).

Lai, Y., & Zeng, J. (2013). A cross‐language personalized recommendation model in digital libraries. The Electronic Library, 31(3), 264-277.

Melnick, A. L. (2002). Introduction to geographic information systems in public health. Jones & Bartlett Learning.

Nguyen, H. H. C., & Nguyen, T. T. (2014, November). Algorithmic approach to deadlock detection for resource allocation in heterogeneous platforms. In 2014 International Conference on Smart Computing (pp. 97-103). IEEE.

Nguyen, H. H. C., Luong, A. T., Trinh, T. H., Ho, P. H., Meesad, P., & Nguyen, T. T. (2021, June). Intelligent fruit recognition system using deep learning. In Recent Advances in Information and Communication Technology 2021: Proceedings of the 17th International Conference on Computing and Information Technology (IC2IT 2021) (pp. 13-22). Cham: Springer International Publishing.

Nguyen, H. H. C., Nguyen, D. H., Nguyen, V. L., & Nguyen, T. T. (2020). Smart solution to detect images in limited visibility conditions based convolutional neural networks. In Advances in Computational Collective Intelligence: 12th International Conference, ICCCI 2020, Da Nang, Vietnam, November 30–December 3, 2020, Proceedings 12 (pp. 641-650). Springer International Publishing.

Nguyen, H. H. C., Nguyen, D. H., Nguyen, V. L., & Nguyen, T. T. (2020). Smart solution to detect images in limited visibility conditions based convolutional neural networks. In Advances in Computational Collective Intelligence: 12th International Conference, ICCCI 2020, Da Nang, Vietnam, November 30–December 3, 2020, Proceedings 12 (pp. 641-650). Springer International Publishing.

Nguyen, H. H. C., Solanki, V. K., Van Thang, D., & Nguyen, T. T. (2017). Resource allocation for heterogeneous cloud computing. Resource, 9(1-2), 1-15.

Papaioannou, I. V., Tsesmetzis, D. T., Roussaki, I. G., & Anagnostou, M. E. (2006, April). A QoS ontology language for web-services. In 20th International Conference on Advanced Information Networking and Applications-Volume 1 (AINA’06) (Vol. 1, pp. 6-pp). IEEE.

Pickles, J. (Ed.). (1995). Ground truth: The social implications of geographic information systems. Guilford Press.

Randall, T. A., Churchill, C. J., & Baetz, B. W. (2005). Geographic information system (GIS) based decision support for neighbourhood traffic calming. Canadian Journal of Civil Engineering, 32(1), 86-98.

Rensema, T., Erickson, C., & Herda, S. (2000). GIS–The Bridge Into the Twenty-First Century. Engineer, 30(2), 34-36.

Riner, M. E., Cunningham, C., & Johnson, A. (2004). Public health education and practice using geographic information system technology. Public health nursing, 21(1), 57-65.

Sofian, H., Ming, J. C., Muhammad, S., & Noor, N. M. (2019). Calcification detection using convolutional neural network architectures in intravascular ultrasound images. Indones. J. Electr. Eng. Comput. Sci, 17(3), 1313-1321.

Sofian, H., Ming, J. C., Muhammad, S., & Noor, N. M. (2019). Calcification detection using convolutional neural network architectures in intravascular ultrasound images. Indones. J. Electr. Eng. Comput. Sci, 17(3), 1313-1321.

Sossa, M. A. R. (2016). Resource provisioning and scheduling algorithms for scientific workflows in cloud computing environments (Doctoral dissertation, University of Melbourne, Department of Computing and Information Systems).

Stillwell, M., Schanzenbach, D., Vivien, F., & Casanova, H. (2010). Resource allocation algorithms for virtualized service hosting platforms. Journal of Parallel and distributed Computing, 70(9), 962-974.

United House Representatives. (n.d.). https://www.house.gov/.

USGS Science for a Changing World Geographic Information Systems, https://www.usgs.gov/ 

Walsh, W. E., Tesauro, G., Kephart, J. O., & Das, R. (2004, May). Utility functions in autonomic systems. In International Conference on Autonomic Computing, 2004. Proceedings. (pp. 70-77). IEEE.

Xiao, Z., Song, W., & Chen, Q. (2012). Dynamic resource allocation using virtual machines for cloud computing environment. IEEE transactions on parallel and distributed systems, 24(6), 1107-1117.

Yazir, Y. O., Matthews, C., Farahbod, R., Neville, S., Guitouni, A., Ganti, S., & Coady, Y. (2010, July). Dynamic resource allocation in computing clouds using distributed multiple criteria decision analysis. In 2010 IEEE 3rd International Conference on Cloud Computing (pp. 91-98). Ieee.

Zhan, F. B. (1997). Three fastest shortest path algorithms on real road networks: Data structures and procedures. Journal of geographic information and decision analysis, 1(1), 69-82.

Zhan, F. B. (1997). Three fastest shortest path algorithms on real road networks: Data structures and procedures. Journal of geographic information and decision analysis, 1(1), 69-82.