Optimizing MySQL database system on information systems research, publications and community service

Satoto, KI; Isnanto, RR; Kridalukmana, R; Martono, KT

Optimizing MySQL database system on information systems research, publications and community service

Satoto, KI Isnanto, RR Kridalukmana, R

Martono, KT

Permalink

Publication Type:: Conference Proceeding
Citation:: Proceedings - 2016 3rd International Conference on Information Technology, Computer, and Electrical Engineering, ICITACEE 2016, 2017, pp. 1 - 5
Issue Date:: 2017-04-04

Closed Access

	Filename	Description	Size
	07892476.pdf	Published version	237.2 kB	Adobe PDF	View/Open

Copyright Clearance Process

Recently Added
In Progress
Closed Access

This item is closed access and not available.

Full metadata record

Field	Value	Language
dc.contributor.author	Satoto, KI	en_US
dc.contributor.author	Isnanto, RR	en_US
dc.contributor.author	Kridalukmana, R https://orcid.org/0000-0003-3797-0134	en_US
dc.contributor.author	Martono, KT	en_US
dc.date.issued	2017-04-04	en_US
dc.identifier.citation	Proceedings - 2016 3rd International Conference on Information Technology, Computer, and Electrical Engineering, ICITACEE 2016, 2017, pp. 1 - 5	en_US
dc.identifier.isbn	9781509014347	en_US
dc.identifier.uri	http://hdl.handle.net/10453/127547
dc.description.abstract	© 2016 IEEE. 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.	en_US
dc.relation.ispartof	Proceedings - 2016 3rd International Conference on Information Technology, Computer, and Electrical Engineering, ICITACEE 2016	en_US
dc.relation.isbasedon	10.1109/ICITACEE.2016.7892476	en_US
dc.title	Optimizing MySQL database system on information systems research, publications and community service	en_US
dc.type	Conference Proceeding
utslib.for	0804 Data Format	en_US
pubs.embargo.period	Not known	en_US
pubs.organisational-group	/University of Technology Sydney
pubs.organisational-group	/University of Technology Sydney/Faculty of Engineering and Information Technology
pubs.organisational-group	/University of Technology Sydney/Students
utslib.copyright.status	closed_access
pubs.publication-status	Published	en_US

Abstract:

© 2016 IEEE. 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.

Please use this identifier to cite or link to this item:

http://hdl.handle.net/10453/127547