Comparison of object-relational data mapping technology in Symfony 3 framework


Abstract

The article presents the results of a comparative analysis of object-relation mapping technologies in the framework Symfony 3: Doctrine and Propel. The analysis was performed in terms of script execution speed and memory usage during database operations. The analysis allowed to identify the technology with faster and more efficient algorithms. Doctrine is up to three times faster than Propel.


Keywords

ORM; php; symfony 3; DBMS; doctrine; prope

[1] Matt Zandstra: PHP Objects, Patterns and Practice, 5th Edition, 2016.
[2] Chris Pitt: Pro PHP MVC, 2012
[3] O’Reilly Media: Learning PHP Design Patterns, 2013
[4] Kevin Dunglas: Persistance in PHP with Doctrine ORM, 2013
[5] http://docs.doctrine-project.org/projects/doctrineorm/en/latest/reference/association-mapping.html [18.08.2017]
[6] Jason E. Sweat: PHP Architect’s Guide to PHP Design Patterns, 2005
[7] Martin Fowler: Patterns of Enterprise Application Architecture, 2002
[8] http://docs.doctrine-project.org/projects/doctrineorm/en/latest/reference/working-with-objects.html [3.12.2017]
[9] http://www.vertabelo.com/blog/technical-articles/side-by-sidedoctrine2-and-propel-2-comparison [20.09.2017]
[10] https://blog.appdynamics.com/engineering/top-6-databaseperformance-metrics-to-monitor-in-enterprise-applications/ [4.12.2017]
[11] http://docs.doctrine-project.org/projects/doctrineorm/en/latest/reference/architecture.html [4.12.2017]
[12] https://en.wikipedia.org/wiki/Propel_(PHP) [4.12.2017]
[13] O’Reilly Media: High Performance MySQL, 3rd Edition, 2012
Download

Published : 2018-11-30


Sawłuk, K., & Miłosz, M. (2018). Comparison of object-relational data mapping technology in Symfony 3 framework . Journal of Computer Sciences Institute, 8, 235-240. https://doi.org/10.35784/jcsi.687

Karol Sawłuk  karol.sawluk@gmail.com
Institute of Computer Science, Lublin University of Technology, Nadbystrzycka 36B, 20-618 Lublin, Poland  Poland
Marek Miłosz 
Institute of Computer Science, Lublin University of Technology, Nadbystrzycka 36B, 20-618 Lublin, Poland  Poland