Comparative analysis of database mapping frameworks available in NuGet Manager
Every year amount of data significantly grows. This causes a need of tools capable of processing data as quickly as possible. The aim of this article is to perform a comparative analysis of ORM (Object Relational Mapping) tools available in the NuGet manager. The comparison of tools was carried out...
Saved in:
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Lublin University of Technology
2024-09-01
|
| Series: | Journal of Computer Sciences Institute |
| Subjects: | |
| Online Access: | https://ph.pollub.pl/index.php/jcsi/article/view/6308 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1832569998332133376 |
|---|---|
| author | Maciej Klimiuk Paweł Karabowicz Małgorzata Plechawska-Wójcik |
| author_facet | Maciej Klimiuk Paweł Karabowicz Małgorzata Plechawska-Wójcik |
| author_sort | Maciej Klimiuk |
| collection | DOAJ |
| description |
Every year amount of data significantly grows. This causes a need of tools capable of processing data as quickly as possible. The aim of this article is to perform a comparative analysis of ORM (Object Relational Mapping) tools available in the NuGet manager. The comparison of tools was carried out on two relational database management systems, PostgreSQL and MySQL. Each tool performed eight DML operations, including SELECT, INSERT and UPDATE operations. The operations were repeated 1, 10, 100, 1000, and 10,000 times, respectively. The execution time of each query was measured using the system StopWatch class available in the .NET environment. The results showed that the best ORM tool turned out to be Dapper.
|
| format | Article |
| id | doaj-art-550947824182439ebec896921f207796 |
| institution | Kabale University |
| issn | 2544-0764 |
| language | English |
| publishDate | 2024-09-01 |
| publisher | Lublin University of Technology |
| record_format | Article |
| series | Journal of Computer Sciences Institute |
| spelling | doaj-art-550947824182439ebec896921f2077962025-02-02T17:59:49ZengLublin University of TechnologyJournal of Computer Sciences Institute2544-07642024-09-013210.35784/jcsi.6308Comparative analysis of database mapping frameworks available in NuGet ManagerMaciej Klimiuk0Paweł Karabowicz1Małgorzata Plechawska-Wójcik2https://orcid.org/0000-0003-1055-5344Department of Computer Science, Lublin University of TechnologyDepartment of Computer Science, Lublin University of TechnologyDepartment of Computer Science, Lublin University of Technology Every year amount of data significantly grows. This causes a need of tools capable of processing data as quickly as possible. The aim of this article is to perform a comparative analysis of ORM (Object Relational Mapping) tools available in the NuGet manager. The comparison of tools was carried out on two relational database management systems, PostgreSQL and MySQL. Each tool performed eight DML operations, including SELECT, INSERT and UPDATE operations. The operations were repeated 1, 10, 100, 1000, and 10,000 times, respectively. The execution time of each query was measured using the system StopWatch class available in the .NET environment. The results showed that the best ORM tool turned out to be Dapper. https://ph.pollub.pl/index.php/jcsi/article/view/6308performance analysisORMDapperOrmLite |
| spellingShingle | Maciej Klimiuk Paweł Karabowicz Małgorzata Plechawska-Wójcik Comparative analysis of database mapping frameworks available in NuGet Manager Journal of Computer Sciences Institute performance analysis ORM Dapper OrmLite |
| title | Comparative analysis of database mapping frameworks available in NuGet Manager |
| title_full | Comparative analysis of database mapping frameworks available in NuGet Manager |
| title_fullStr | Comparative analysis of database mapping frameworks available in NuGet Manager |
| title_full_unstemmed | Comparative analysis of database mapping frameworks available in NuGet Manager |
| title_short | Comparative analysis of database mapping frameworks available in NuGet Manager |
| title_sort | comparative analysis of database mapping frameworks available in nuget manager |
| topic | performance analysis ORM Dapper OrmLite |
| url | https://ph.pollub.pl/index.php/jcsi/article/view/6308 |
| work_keys_str_mv | AT maciejklimiuk comparativeanalysisofdatabasemappingframeworksavailableinnugetmanager AT pawełkarabowicz comparativeanalysisofdatabasemappingframeworksavailableinnugetmanager AT małgorzataplechawskawojcik comparativeanalysisofdatabasemappingframeworksavailableinnugetmanager |