Razvoj SUPB z integracijo v programski jezik Python

Sedeljšak, Janez (author), Slivnik, Boštjan (mentor), Poženel, Marko (co-mentor)

V diplomskem delu so predstavljeni nekateri izmed najbolj uveljavljenih sistemov za upravljanje podatkovnih baz (SUPB). Kljub napredku na tem področju ostajajo relacijske podatkovne baze v veliki meri osrednja paradigma. V okviru diplomskega dela smo se osredotočili na razvoj in predstavitev lastnega relacijskega SUPB za programski jezik Python. Razvoj namenske rešitve je realiziran v programskem jeziku C++. Gre za nizkonivojski jezik, kjer imamo visoko fleksibilnost pri upravljanju s pomnilnikom. Predstavljen je razvoj vseh potrebnih segmentov za dobro delujočo relacijsko podatkovno bazo. Ključnega pomena tekom razvoja je bila uporaba podatkovnih struktur in algoritmov, ki dobro izkoristijo vhodno/izhodne operacije in omogočajo zanesljivo in optimalno delovanja podatkovne baze. V zadnjem delu diplomskega dela smo izvedli primerjalno analizo našega razvitega SUPB-ja z že uveljavljenima rešitvama SQLite in MySQL, ter predstavili dosežene rezultate.

• Language: Slovenian
• Keywords: Podatkovne baze, C++, Python, B+ drevesa, SQL, SUPB, ORM
• Work type: Bachelor thesis/paper
• Organization: FRI - Faculty of Computer and Information Science
• Year: 2023
• PID: 20.500.12556/RUL-152698
• COBISS.SI-ID: 166316803
• Publication date in RUL: 04.12.2023

Secondary language

• Language: English
• Title: Development of a DBMS with integration into the Python programming language

Abstract

The thesis introduces some of the most established Database Management Systems (DBMS) available. Despite advancements in the field, relational databases remain a prominent paradigm. Consequently, our focus within the study was directed towards developing and presenting our dedicated DBMS solution tailored for the Python programming language. The development of this specialized solution was implemented using the C++ programming language due to its low-level nature, offering high flexibility in memory management. The development encompasses all the necessary components for a well-functioning relational database. A crucial aspect during development was the utilization of data structures and algorithms that efficiently leverage the input/output operations provided. This approach ultimately ensures reliable and optimal database performance. In the final section of the thesis, we conducted a comparative analysis of our developed DBMS with the established solutions SQLite and MySQL, presenting the achieved results.

• Keywords: Databases, C++, Python, B+ trees, SQL, DBMS, ORM