Transactional database design information system web-based tracer study integrated telegram bot

Abstract A database is a software that is used to store data. Data stored is generally in the form of text. Database functions are not only for storing data but also used to speed up access to information systems. Optimal database management can increase access to information systems. One management that can improve performance is the appropriate relational data design. Relational is a relationship between tables. The design of the relational database must pay attention to the selection of data types, data type values, and constraints that will be selected. This study will examine the optimization of the MariaDB database on information systems in tracer studies. Database design will accommodate data from two application sources, namely web-based applications and telegram bots. Using two paths to the database to make it easier for users to register via a telegram bot, users can then access the tracer study questionnaire on web-based applications. The MariaDB database performance test shows that the highest performance average query is 6501 microsecond.