A Framework for Evaluating Maintainability and Performance of Object-Relational-Mapping Tools in Web Application Frameworks

Web Application Frameworks (WAF) and Object-Relational Mapping (ORM) tools reduce the time and effort needed to develop high quality applications. However, there are many of them and choosing the best suited for a particular project is not easy. There are comparative studies about these tools, incon...

Full description

Autores:
Alvarez Eraso, Danny Alejandro
Tipo de recurso:
Fecha de publicación:
2017
Institución:
Universidad Nacional de Colombia
Repositorio:
Universidad Nacional de Colombia
Idioma:
spa
OAI Identifier:
oai:repositorio.unal.edu.co:unal/59316
Acceso en línea:
https://repositorio.unal.edu.co/handle/unal/59316
http://bdigital.unal.edu.co/56719/
Palabra clave:
0 Generalidades / Computer science, information and general works
object-relational mapping
relational databases
object-oriented languages
class diagram
performance
maintainability
software architecture
mapeo objeto-relacional
base de datos relacionales
lenguajes orientados a objetos
diagrama de clases
desempeño
mantenibilidad
arquitectura de software
Rights
openAccess
License
Atribución-NoComercial 4.0 Internacional
id UNACIONAL2_e58fac89bab1966bc2b493256d753dfd
oai_identifier_str oai:repositorio.unal.edu.co:unal/59316
network_acronym_str UNACIONAL2
network_name_str Universidad Nacional de Colombia
repository_id_str
spelling Atribución-NoComercial 4.0 InternacionalDerechos reservados - Universidad Nacional de Colombiahttp://creativecommons.org/licenses/by-nc/4.0/info:eu-repo/semantics/openAccesshttp://purl.org/coar/access_right/c_abf2Arango Isaza, FernandoAlvarez Eraso, Danny Alejandrocdabe26a-4933-48b1-8442-ce249628930b300Universidad Nacional de Colombia – Sede Medellín2019-07-02T15:48:46Z2019-07-02T15:48:46Z2017-05-21https://repositorio.unal.edu.co/handle/unal/59316http://bdigital.unal.edu.co/56719/Web Application Frameworks (WAF) and Object-Relational Mapping (ORM) tools reduce the time and effort needed to develop high quality applications. However, there are many of them and choosing the best suited for a particular project is not easy. There are comparative studies about these tools, inconveniently, the existing studies do not considerate a domain complex enough that allow us to measure in a more precise way their advantages and disadvantages, also they do not analyze the maintainability related to ORM usage. To contribute in understanding these tools, we propose a WAF-ORM evaluation framework that measures performance and maintainability which we used to compare a group of WAF-ORM technologies. Our study includes a case study that separates queries in three different complexity levels that use both pure SQL and ORM’s API. We addressed performance analysis by studying the impact of queries’ complexity and database size, leaving all other variables affecting performance constant. Also, as maintainability is harder to measure, we propose a qualitative way to classify WAF-ORM technologies. A comparison based on these aspects is important because understanding performance and architectural benefits of ORMs technologies is helpful for both users and developers of WAF-ORM technologies.Maestríaapplication/pdfspaUniversidad Nacional de Colombia Sede Medellín Facultad de Minas Escuela de Sistemas Ingeniería de Sistemas e InformáticaIngeniería de Sistemas e InformáticaAlvarez Eraso, Danny Alejandro (2017) A Framework for Evaluating Maintainability and Performance of Object-Relational-Mapping Tools in Web Application Frameworks. Maestría thesis, Universidad Nacional de Colombia - Sede Medellín.0 Generalidades / Computer science, information and general worksobject-relational mappingrelational databasesobject-oriented languagesclass diagramperformancemaintainabilitysoftware architecturemapeo objeto-relacionalbase de datos relacionaleslenguajes orientados a objetosdiagrama de clasesdesempeñomantenibilidadarquitectura de softwareA Framework for Evaluating Maintainability and Performance of Object-Relational-Mapping Tools in Web Application FrameworksTrabajo de grado - Maestríainfo:eu-repo/semantics/masterThesisinfo:eu-repo/semantics/acceptedVersionTexthttp://purl.org/redcol/resource_type/TMORIGINAL1087411095.2017.pdfTesis de Maestría en Ingeniería - Ingeniería de Sistemasapplication/pdf3136219https://repositorio.unal.edu.co/bitstream/unal/59316/1/1087411095.2017.pdffabe3c40fc75776e94673f6e7e91c59cMD51bibliography.txttext/plain9614https://repositorio.unal.edu.co/bitstream/unal/59316/2/bibliography.txt418992f8ef3e1062fff141d7864891c4MD52THUMBNAIL1087411095.2017.pdf.jpg1087411095.2017.pdf.jpgGenerated Thumbnailimage/jpeg4664https://repositorio.unal.edu.co/bitstream/unal/59316/3/1087411095.2017.pdf.jpgfea8af8d22021658c22fe0de6f102071MD53unal/59316oai:repositorio.unal.edu.co:unal/593162024-04-07 00:23:32.445Repositorio Institucional Universidad Nacional de Colombiarepositorio_nal@unal.edu.co
dc.title.spa.fl_str_mv A Framework for Evaluating Maintainability and Performance of Object-Relational-Mapping Tools in Web Application Frameworks
title A Framework for Evaluating Maintainability and Performance of Object-Relational-Mapping Tools in Web Application Frameworks
spellingShingle A Framework for Evaluating Maintainability and Performance of Object-Relational-Mapping Tools in Web Application Frameworks
0 Generalidades / Computer science, information and general works
object-relational mapping
relational databases
object-oriented languages
class diagram
performance
maintainability
software architecture
mapeo objeto-relacional
base de datos relacionales
lenguajes orientados a objetos
diagrama de clases
desempeño
mantenibilidad
arquitectura de software
title_short A Framework for Evaluating Maintainability and Performance of Object-Relational-Mapping Tools in Web Application Frameworks
title_full A Framework for Evaluating Maintainability and Performance of Object-Relational-Mapping Tools in Web Application Frameworks
title_fullStr A Framework for Evaluating Maintainability and Performance of Object-Relational-Mapping Tools in Web Application Frameworks
title_full_unstemmed A Framework for Evaluating Maintainability and Performance of Object-Relational-Mapping Tools in Web Application Frameworks
title_sort A Framework for Evaluating Maintainability and Performance of Object-Relational-Mapping Tools in Web Application Frameworks
dc.creator.fl_str_mv Alvarez Eraso, Danny Alejandro
dc.contributor.author.spa.fl_str_mv Alvarez Eraso, Danny Alejandro
dc.contributor.corporatename.spa.fl_str_mv Universidad Nacional de Colombia – Sede Medellín
dc.contributor.spa.fl_str_mv Arango Isaza, Fernando
dc.subject.ddc.spa.fl_str_mv 0 Generalidades / Computer science, information and general works
topic 0 Generalidades / Computer science, information and general works
object-relational mapping
relational databases
object-oriented languages
class diagram
performance
maintainability
software architecture
mapeo objeto-relacional
base de datos relacionales
lenguajes orientados a objetos
diagrama de clases
desempeño
mantenibilidad
arquitectura de software
dc.subject.proposal.spa.fl_str_mv object-relational mapping
relational databases
object-oriented languages
class diagram
performance
maintainability
software architecture
mapeo objeto-relacional
base de datos relacionales
lenguajes orientados a objetos
diagrama de clases
desempeño
mantenibilidad
arquitectura de software
description Web Application Frameworks (WAF) and Object-Relational Mapping (ORM) tools reduce the time and effort needed to develop high quality applications. However, there are many of them and choosing the best suited for a particular project is not easy. There are comparative studies about these tools, inconveniently, the existing studies do not considerate a domain complex enough that allow us to measure in a more precise way their advantages and disadvantages, also they do not analyze the maintainability related to ORM usage. To contribute in understanding these tools, we propose a WAF-ORM evaluation framework that measures performance and maintainability which we used to compare a group of WAF-ORM technologies. Our study includes a case study that separates queries in three different complexity levels that use both pure SQL and ORM’s API. We addressed performance analysis by studying the impact of queries’ complexity and database size, leaving all other variables affecting performance constant. Also, as maintainability is harder to measure, we propose a qualitative way to classify WAF-ORM technologies. A comparison based on these aspects is important because understanding performance and architectural benefits of ORMs technologies is helpful for both users and developers of WAF-ORM technologies.
publishDate 2017
dc.date.issued.spa.fl_str_mv 2017-05-21
dc.date.accessioned.spa.fl_str_mv 2019-07-02T15:48:46Z
dc.date.available.spa.fl_str_mv 2019-07-02T15:48:46Z
dc.type.spa.fl_str_mv Trabajo de grado - Maestría
dc.type.driver.spa.fl_str_mv info:eu-repo/semantics/masterThesis
dc.type.version.spa.fl_str_mv info:eu-repo/semantics/acceptedVersion
dc.type.content.spa.fl_str_mv Text
dc.type.redcol.spa.fl_str_mv http://purl.org/redcol/resource_type/TM
status_str acceptedVersion
dc.identifier.uri.none.fl_str_mv https://repositorio.unal.edu.co/handle/unal/59316
dc.identifier.eprints.spa.fl_str_mv http://bdigital.unal.edu.co/56719/
url https://repositorio.unal.edu.co/handle/unal/59316
http://bdigital.unal.edu.co/56719/
dc.language.iso.spa.fl_str_mv spa
language spa
dc.relation.ispartof.spa.fl_str_mv Universidad Nacional de Colombia Sede Medellín Facultad de Minas Escuela de Sistemas Ingeniería de Sistemas e Informática
Ingeniería de Sistemas e Informática
dc.relation.references.spa.fl_str_mv Alvarez Eraso, Danny Alejandro (2017) A Framework for Evaluating Maintainability and Performance of Object-Relational-Mapping Tools in Web Application Frameworks. Maestría thesis, Universidad Nacional de Colombia - Sede Medellín.
dc.rights.spa.fl_str_mv Derechos reservados - Universidad Nacional de Colombia
dc.rights.coar.fl_str_mv http://purl.org/coar/access_right/c_abf2
dc.rights.license.spa.fl_str_mv Atribución-NoComercial 4.0 Internacional
dc.rights.uri.spa.fl_str_mv http://creativecommons.org/licenses/by-nc/4.0/
dc.rights.accessrights.spa.fl_str_mv info:eu-repo/semantics/openAccess
rights_invalid_str_mv Atribución-NoComercial 4.0 Internacional
Derechos reservados - Universidad Nacional de Colombia
http://creativecommons.org/licenses/by-nc/4.0/
http://purl.org/coar/access_right/c_abf2
eu_rights_str_mv openAccess
dc.format.mimetype.spa.fl_str_mv application/pdf
institution Universidad Nacional de Colombia
bitstream.url.fl_str_mv https://repositorio.unal.edu.co/bitstream/unal/59316/1/1087411095.2017.pdf
https://repositorio.unal.edu.co/bitstream/unal/59316/2/bibliography.txt
https://repositorio.unal.edu.co/bitstream/unal/59316/3/1087411095.2017.pdf.jpg
bitstream.checksum.fl_str_mv fabe3c40fc75776e94673f6e7e91c59c
418992f8ef3e1062fff141d7864891c4
fea8af8d22021658c22fe0de6f102071
bitstream.checksumAlgorithm.fl_str_mv MD5
MD5
MD5
repository.name.fl_str_mv Repositorio Institucional Universidad Nacional de Colombia
repository.mail.fl_str_mv repositorio_nal@unal.edu.co
_version_ 1814089944954568704