prikaz prve stranice dokumenta Preliminary Study on Effects of Object-Relational Mapping on the Efficiency of Monolithic and Distributed Relational Database Systems
  Download
PDF 2.63 MB
undergraduate thesis
Preliminary Study on Effects of Object-Relational Mapping on the Efficiency of Monolithic and Distributed Relational Database Systems
Pula: University of Pula, 2024. urn:nbn:hr:137:061687
Starić, Elvis
University of Pula
Faculty of Informatics in Pula

Institutional repository: Digital Repository Juraj Dobrila University of Pula

Cite this document

Starić, E. (2024). Preliminary Study on Effects of Object-Relational Mapping on the Efficiency of Monolithic and Distributed Relational Database Systems (Undergraduate thesis). Pula: University of Pula. Retrieved from https://urn.nsk.hr/urn:nbn:hr:137:061687

Starić, Elvis. "Preliminary Study on Effects of Object-Relational Mapping on the Efficiency of Monolithic and Distributed Relational Database Systems." Undergraduate thesis, University of Pula, 2024. https://urn.nsk.hr/urn:nbn:hr:137:061687

Starić, Elvis. "Preliminary Study on Effects of Object-Relational Mapping on the Efficiency of Monolithic and Distributed Relational Database Systems." Undergraduate thesis, University of Pula, 2024. https://urn.nsk.hr/urn:nbn:hr:137:061687

Starić, E. (2024). 'Preliminary Study on Effects of Object-Relational Mapping on the Efficiency of Monolithic and Distributed Relational Database Systems', Undergraduate thesis, University of Pula, accessed 03 September 2024, https://urn.nsk.hr/urn:nbn:hr:137:061687

Starić E. Preliminary Study on Effects of Object-Relational Mapping on the Efficiency of Monolithic and Distributed Relational Database Systems [Undergraduate thesis]. Pula: University of Pula; 2024 [cited 2024 September 03] Available at: https://urn.nsk.hr/urn:nbn:hr:137:061687

E. Starić, "Preliminary Study on Effects of Object-Relational Mapping on the Efficiency of Monolithic and Distributed Relational Database Systems", Undergraduate thesis, University of Pula, Pula, 2024. Available at: https://urn.nsk.hr/urn:nbn:hr:137:061687

Metadata
TitlePreliminary Study on Effects of Object-Relational Mapping on the Efficiency of Monolithic and Distributed Relational Database Systems
Title (croatian)Preliminarno istraživanje utjecaja objektno-relacijskog preslikavanja na efikasnost monolitnih i distribuiranih sustava baza podataka
AuthorElvis Starić
MentorNikola Tanković (mentor)
Committee memberIvan Lorencin (predsjednik povjerenstva)
Committee memberNikola Tanković (član povjerenstva)
Committee memberRobert Šajina (član povjerenstva)
GranterUniversity of Pula
(Faculty of Informatics in Pula)
Pula
Defense date and country2024-07-12, Croatia
Scientific / art field,
discipline and subdiscipline		SOCIAL SCIENCES
Information and Communication Sciences
Information Systems and Information Science
Abstract
As there is a growing need to store and process large amounts of data for the correct operation of many applications, traditional monolithic relational databases, due to their architecture, are becoming insufficient for such applications. Distributed databases are presented as a potential solution. Distributed databases store data on multiple instances, which enables greater scalability, flexibility, database availability, and potentially better performance in data processing. Furthermore, object-relational mapping (ORM) is a programming technique that facilitates the interaction between a database and a program written in an object-oriented language. It allows writing database queries in an object-oriented paradigm instead of using the SQL programming language. Although ORMs make it much easier to write programming code, they are also known to affect database performance negatively. This paper aims to determine the impact of ORM on the performance of monolithic and distributed relational databases and to compare whether it has a greater effect on monolithic or distributed databases. We will use the TPC (Transaction Processing Performance Council)-C benchmark. MySQL will be used for the monolithic database, TiDB for the distributed database, and SQLAlchemy for ORM.
Abstract (croatian)
Kako postoji sve veća potreba za pohranjivanjem i procesiranjem velike količine podataka za ispravan rad mnogih aplikacija, tradicionalne monolitne relacijske baze podataka, zbog svoje arhitekture, postaju nedostatne za takve aplikacije. Kao potencijalno rješenje predstavljaju se distribuirane baze podataka. Distribuirane baze podataka pohranjuju podatke na više instanci, što omogućuje veću skalabilnost, fleksibilnost, dostupnost baze podataka te potencijalno bolje performanse u obradi podataka. Nadalje, objektno-relacijsko preslikavanje (eng. ORM – object-relational mapping) je tehnika programiranja koja olakšava interakciju između baze podataka i programa pisanog u objektno orijentiranom jeziku. Ona omogućuje pisanje upita na bazu podataka u objektnoorijentiranoj paradigmi umjesto korištenja SQL programskog jezika. Iako objektno-relacijsko preslikavanje znatno olakšava pisanje programskog koda, također je poznato da negativno utječe na performanse baza podataka. Ovaj rad ima za cilj utvrditi utjecaj objektno-relacijskog preslikavanja na monolitne te distribuirane relacijske baze podataka te usporediti ima li veći utjecaj na monolitne ili distribuirane baze podataka. Koristiti ćemo TPC (Transaction Processing Performance Council) – C benchmark. MySQL će se koristiti kao monolitna baza podataka, TiDB kao distribuirana te SQLAlchemy kao ORM.
Keywords
Keywords (croatian)
Languageenglish
URN:NBNurn:nbn:hr:137:061687
Study programmeTitle: Informatics
Study programme type: university
Study level: undergraduate
Academic / professional title: sveučilišni/a prvostupnik/prvostupnica (baccalaureus/baccalaurea) informatike (sveučilišni/a prvostupnik/prvostupnica (baccalaureus/baccalaurea) informatike)
Type of resourceText
File originBorn digital
Access conditionsOpen access
Terms of useLicence In copyright icon
Created on2024-07-22 08:27:06