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

Satoto, Kodrat Iman; Isnanto, R. Rizal; Kridalukmana, Rinta; Martono, Kurniawan Teguh

doi:10.1109/icitacee.2016.7892476

Cited by 23 publications

(12 citation statements)

References 5 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…In designing and building an application or system database, several stages are needed, which is called the database lifecycle [22]. The steps carried out in this research methodology were a modification of the Database Application Lifecycle stages in previous studies [23][19] [24]. The stages of the research carried out were:…”

Section: Methodsmentioning

confidence: 99%

Database Design for Child Special Development Institution’s Service Performance E-Dashboard

Hadiwijaya¹,

Febrianty²,

Azdy³

2021

Atlantis Highlights in Engineering

View full text Add to dashboard Cite

The Child Special Development Institute (LPKA) is a place used to foster and educate correctional students (Andikpas). LPKA has a duty to provide services related to the fulfillment of Andikpas rights. In this study, LPKA services that became the focus of research were visits to Andikpas and services for processing leave requests, remissions, assimilation, complaints from the general public and Andikpas, as well as obtaining service users feedback from questionnaires. The development of information technology allows the integration of LPKA service data in an e-dashboard system with a centralized database. This study offers a database that can be used to store data processing for LPKA services. The research method used was a modification of the Database Application Life Cycle method. The result of the research is a database that can be processed on the e-dashboard system to facilitate the performance of LPKA services in the fields of visits, complaints, leave requests, remissions and Andikpas integration, obtaining feedback on service performance through filling out online questionnaires, and delivering information about Andikpas' records to Andikpas ('s family).

show abstract

Section: Methodsmentioning

confidence: 99%

Database Design for Child Special Development Institution’s Service Performance E-Dashboard

Hadiwijaya¹,

Febrianty²,

Azdy³

2021

Atlantis Highlights in Engineering

View full text Add to dashboard Cite

show abstract

“…It can consist of a large number of tables. According to the paper of the engineer Kodrat Iman about the optimization of the MySQL database, he explains that this is one of the best DB platforms nowadays because many of the popular pages are built with this manager since it provides a better performance, it is easy to use and it gives us reliability [14].…”

Section: Methodsmentioning

confidence: 99%

Web System Design for Human Resources Management in an SME in the Textile Sector

Delgado¹,

Antunez-Maguiña²

2020

IJETER

View full text Add to dashboard Cite

In Peru, many of the SMEs do not have a system focused on Human Resources (employees), many times because the companies do not have the necessary technology to implement it, they are not aware of it or the prices are quite high. That is why in the following work we designed a payroll control and monitoring system based on the Agile Scrum Methodology, based on the example of the textile company Chalicen S.A.C, which is within the range of small companies. The results are the development of prototypes according to the functionalities proposed by the Scrum team, which leads to better teamwork, customer satisfaction and constant communication between project members. The development of a design of a payroll system appropriate to the requirements of the company can achieve control of human resources, thus helping to implement it in SMEs in Peru.

show abstract

“…MySQL is a RDBMS (Relational Database Management System) application, which is used to manage databases that apply relational principles to store its values. Each table of data are interconnected through the relation of primary keys, linking within tuple (records) and attributes (fields), in the commonly-known form of rows and columns [10].…”

Section: Mysqlmentioning

confidence: 99%

Geographic Information System for Mapping and Complaint of Damaged Roads

Winarta

Piarsa

Mandenni

2021

JIM

View full text Add to dashboard Cite

Indonesia is a massive archipelago of 1.919.400 km², containing roads that span at 542.000 km across various terrain conditions. This diverse geographic environment is a challenge to road constructions and repairs across the country, which has lead to disruption in public service and traffic accidents each year. We propose the Geographic Information System for Mapping and Complaint of Damaged Roads, a solution which can provide users a digital interface to report damaged roads to the transportation department in their area. This research uses Google Maps API to digitize and make a complaint about damaged roads. The result of this research is an android application for the users and a website application for the road managers. The android application is used by the users to make complaints of damaged roads. The web application is used by road managers to draw the road on Google Maps using polyline feature. With this our goal is to systematize the handling of damaged roads information, leading to faster service times and hopefully help reduce the level of traffic accidents in Indonesia. Keywords: Complaint, Damaged road, Geographic Information System, Google Maps, Road digitization.

show abstract

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

Cited by 23 publications

References 5 publications

Database Design for Child Special Development Institution’s Service Performance E-Dashboard

Database Design for Child Special Development Institution’s Service Performance E-Dashboard

Web System Design for Human Resources Management in an SME in the Textile Sector

Geographic Information System for Mapping and Complaint of Damaged Roads

Contact Info

Product

Resources

About