Comparison of Eloquent ORM with Query Builder in Work Management System (Case Study: Muhammadiyah Lamongan Hospital)

Febryan Akhdani, Danur Wijayanto

Abstract

A management system is a set of policies, processes, and procedures used by an organization to ensure that the system can fulfill the tasks required to achieve its objectives. With this system, the company can make it easier for the management of a task/project that is being done by the employee/employee. In the SIRS Unit at Lamongan Muhammadiyah Hospital, the implementation of Work Management is still done manually, namely by holding monthly meetings held at the beginning of the month which can affect the efficiency and effectiveness of employees in terms of collecting/reporting tasks assigned by the project leader. For this reason, a Job Management System is needed that can overcome these problems. Job Management System, created on a Web-based basis using Laravel 8.0 as the framework and MySQL as the database. In this study, researchers will focus on implementing Eloquent ORM which is a special feature in Laravel to make it easier for developers to process data and compare Eloquent ORM with Query builder in its implementation on Job Management System. The result of this research is Query Builder can execute database query more faster and more memory efficient than Eloquent, but Eloquent use simple code than Eloquent.

Keywords

Laravel, Eloquent, Query Builder, Database, MySQL

References

RSML, “Sejarah Rumah Sakit Muhammadiyah Lamongan,” Sejarah Rumah Sakit Muhammadiyah Lamongan. https://www.rsmlamongan.com/profil/sejarah-rumah-sakit-muhammadiyah-lamongan (accessed Jan. 10, 2022).

R. Azhari, “Unit SIRS pada RS Muhammadiyah Lamongan,” 2021.

Laravel, “Meet Laravel,” Installation. https://laravel.com/docs/8.x (accessed Jan. 10, 2022).

Iryana and R. Kawasati, Teknik Pengumpulan Data Metode Kualitatif. Sorong.

M. Nazir, Metode Penelitian. Bogor: Ghalia Indonesia, 2005.

E. Danial and N. Warsiah, Metode Penulisan Karya Ilmiah. Bandung: Laboraturium Pendidikan Kewarganegaraan, 2009.

K. Aikat, “PHP war 1.0: Comparing 5 most popular PHP frameworks, which is the best among all?,” PHP war 1.0: Comparing 5 most popular PHP frameworks, which is the best among all?, Jul. 12, 2021. https://content.techgig.com/php-war-1-0-comparing-5-most-popular-php-frameworks-which-is-the-best-among-all/articleshow/84344709.cms (accessed Jan. 12, 2021).

Wikipedia, “MySQL,” MySQL. 2021. [Online]. Available: https://id.wikipedia.org/wiki/MySQL

The Computer Language Co, “Flowchart,” Flowchart. PC Magazine, 2020. Accessed: Jan. 17, 2022. [Online]. Available: https://www.pcmag.com/encyclopedia/term/flowchart#:~:text=A%20graphical%20representation%20of%20the,an%20information%20system%20or%20program.&text=Program%20flowcharts%20show%20the%20sequence,draw%20each%20type%20of%20flowchart.

Y. Waykar and S. S. Mule, “ROLE OF USE CASE DIAGRAM IN S/W DEVELOPMENT,” 2015, Accessed: Jan. 17, 2022. [Online]. Available: https://www.researchgate.net/publication/322991847_role_of_use_case_diagram_in_software_development

L. Atencio, “Object-Relational Mapping with Laravel’s Eloquent,” vol. 15, no. 3, 2016, Accessed: Jan. 17, 2022. [Online]. Available: https://www.phparch.com/wp-content/uploads/2016/03/Object-Relational_Mapping_with_Laravels_Eloquent-phparchitect-March2016.pdf

I. Jound and H. Halimi, “Comparison of performance between Raw SQL and Eloquent ORM in Laravel,” 2019.

M. Akash, “Laravel Eloquent Vs DB Query Builder [Performance and other statistics],” 2021.

Article Metrics

Abstract view: 60 times
Download     : 8   times

Refbacks

  • There are currently no refbacks.