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.

It is the mission of Vocational High School (SMK) education in Indonesia to produce highly competitive and skilled graduates. One standard for evaluating the success of vocational education is assessing the achievements of alumni. The evaluation process can be carried out with programmed alumni tracking activities or commonly known as tracer studies. However, the implementations of tracer studies that have been carried out by vocational schools in Kediri are still using the manual method. These conditions make the school find many obstacles in the implementation of tracer studies. Some schools have used technology with e-mail applications but have financial constraints. This research aims to improve the performance of assessing the alumni achievement of Vocational Schools in Kediri by integrating the website-based tracer study information system with social media Telegram API. Usability testing that gave 4.83 of 5 scales has shown that the integration can improve the performance and benefits of an application compared to the application before integration