Optimizing MySQL database system on information systems research, publications and community service
MySQL is the most trusted and depended on open source database platform in use today. Many of the most popular and highly trafficked websites in the world are built on MySQL because of its ubiquity across heterogeneous platforms and application stacks and for its well known performance, reliability and ease of use. Research, publications and community service is one activity that is managed by the Institute for Research and Community Service. The process of managing these activities today cannot be separated from the Internet, therefore we need a system that can manage every activity. To obtain the proper management it needs a system that is supported by the database system is also good. This paper discusses how to conduct the process of optimizing the database system so that when the data is accessed does not affect the performance of server systems. Process optimization is done on the design of the database system. Database design plays an important role in determining system performance. Process optimization is done in this study by using one of the functions that have been given in MySQL by using VIEW. This virtual table process to be performed by the system to be faster. This is because during the system requests to the server is does not need to query over and over because it has been done in the database management system.
2016 3rd International Conference on Information Technology, Computer, and Electrical Engineering (ICITACEE)