Please use this identifier to cite or link to this item: http://dspace.lib.uom.gr/handle/2159/29080
Full metadata record
DC FieldValueLanguage
dc.contributor.advisorΕυαγγελίδης, Γεώργιοςel
dc.contributor.authorΧατζηπαρασκευάς, Μιχαήλel
dc.date.accessioned2023-06-27T09:04:56Z-
dc.date.available2023-06-27T09:04:56Z-
dc.date.issued2023el
dc.identifier.urihttp://dspace.lib.uom.gr/handle/2159/29080-
dc.descriptionΔιπλωματική εργασία--Πανεπιστήμιο Μακεδονίας, Θεσσαλονίκη, 2023.el
dc.description.abstractThe main objective of this diploma thesis is to analyze and present the features of various open source SQL engines that perform text indexing for specific documents. We will explain the concept of text indexing and the fields used to enhance efficiency and reduce search time. Additionally, we will compare and enhance the performance of different Database Management Systems (DBMS) used for storing, processing, and searching large amounts of rapidly growing data. However, collecting and storing massive amounts of data alone does not address the issue of proper data organization and classification. To enable faster query processing and quick access to data records, indexing is necessary. It is crucial to carefully design indexes as they can oc cupy significant disk space. Hence, selecting the most suitable database management system and effectively managing the database are important considerations. For this diploma thesis, we will utilize MySQL, PostgreSQL, and SQLite as the database man agement systems. By using these systems, we aim to gain a comprehensive understanding of their construction and how text indexing can be implemented for specific documents. We will follow a consistent approach for all engines, covering fundamental text searching commands, text searching characteristics, auxiliary functions, and the creation of text indexing tables. Once we have gathered all the necessary data, we will conduct data visualization analysis to examine the response time of each system. This analysis will enable us to compare different functions not only within the same system but also across different SQL enginesen
dc.format.extent75el
dc.language.isoenen
dc.publisherΠανεπιστήμιο Μακεδονίαςel
dc.rightsCC0 1.0 Παγκόσμιαel
dc.rights.urihttp://creativecommons.org/publicdomain/zero/1.0/en
dc.subjectOpen-source SQL enginesen
dc.subjectText indexingen
dc.subjectDBMSen
dc.subjectMySQLen
dc.subjectIndexingen
dc.subjectPostgreSQLen
dc.subjectSQLiteen
dc.titleFull-text indexing in open source DBMSen
dc.title.alternativeΕυρετηρία κειμένου σε DBMS ανοιχτού κώδικαel
dc.typeElectronic Thesis or Dissertationen
dc.typeTexten
dc.contributor.departmentΠρόγραμμα Μεταπτυχιακών Σπουδών Ειδίκευσης στην Εφαρμοσμένη Πληροφορικήel
Appears in Collections:Π.Μ.Σ. στην Εφαρμοσμένη Πληροφορική (M)

Files in This Item:
File Description SizeFormat 
ChatziparaskevasMichailMsc2023.pdf918.29 kBAdobe PDFView/Open


This item is licensed under a Creative Commons License Creative Commons