TSI logo
LV EN
Home > About Us > Structure and Government > Abstracts

DEGREE

PROGRAMME

FACULTY

YEAR

LANGUAGE

COMPARATIVE ANALYSIS OF LLM-BASED APPROACHES FOR SQL GENERATION

The rapid development of Large Language Models has unlocked opportunities for restructuring software development processes in general as well as in such cases as converting natural language into SQL queries. This study seeks to experimentally evaluate the effects of four LLM-based methods on the efficiency and quality of SQL generation. Evaluation is being held based on following metrics: Correctness, Completeness and Consistency. Studied LLM-based SQL generation methods include Specific LLMs tailored for SQL code generation like SQL Coder frameworks for generating SQL code (Vanna.ai, 2023; Llamaindex, 2023) and Multi agent collaborative networks for transforming language into SQL.The research utilizes a mix of literature review case studies and simulations. It offers a comprehensive review of the advancements in LLM-driven SQL generation encompassing concepts, technologies, methodologies, strengths, limitations, and ethical considerations.This research successfully bridges the gap between theoretical foundations and practical application of AI-augmented approaches while promoting the integration of LLM-based SQL generation, into automated software development processes.

Author: Maksim Ilin

Supervisor: Dmitry Pavlyuk

Degree: Master

Year: 2024

Work Language: English

Study programme: Computer Sciences

More...

Development of computer game with focus on emotional player engagement.

The aim of this bachelor thesis is to develop a video game with unique mechanics that can create emotional engagement for players. The study analyzed the gaming industry and its development trends, conducted a survey within the gaming community, and developed a game using Unreal Engine 5. The results highlight the importance of emotional engagement in fostering a positive player experience.

Author: Maksims Kļaviņš

Supervisor: Olga Dribeņeca

Degree: Bachelor

Year: 2025

Work Language: Latvian

Study programme: Computer Science

More...

Development of a web application for a bank transfer system

The aim of this bachelor thesis is to develop a bank web application capable of processing both MT103 and pacs.008 payment types. The system will evaluate whether it is necessary to convert payments to facilitate transactions between different account types. This work includes a comprehensive review of payment types, along with the challenges and limitations associated with SWIFT and ISO standards. Essential functionalities for such systems are identified, and an overview of similar products, their adoption of ISO standards, costs, and available services are provided. The comparison of web development frameworks affirmed ASP.NET Core as the optimal choice for this project. An internal questionnaire identified critical features and prioritised payment types for the application. Based on these insights, detailed requirements and specifications were developed, leading to the creation of the application using the ASP.NET Core Blazor framework. Upon completion, the application underwent manual and unit testing to evaluate its performance and ensure it meets the outlined requirements. This thesis documents the entire development process, from theoretical research to practical implementation and testing.

Author: Maksims Raciņš

Supervisor: Boriss Mišņevs

Degree: Bachelor

Year: 2024

Work Language: English

Study programme: Computer Science

More...

The role of marketing in the SIA "LUX-TA" enterprise

The bachelor’s paper aim is to explore how marketing strategies employed by the travel agency SIA "LUX TA" impact brand visibility and customer engagement, within the travel industry. It delves into the tactics utilized by LUX TA on platforms like Facebook and Instagram to attract and retain audiences through appealing content. The research evaluates the effectiveness of targeted hashtags influencer partnerships and interactive polls in fostering user engagement and loyalty. Additionally it examines the return, on investment (ROI) of these strategies by analyzing their ability to convert engagement into bookings while maintaining cost marketing practices. Ultimately the thesis scrutinises how SIA "LUX TA" utilises its marketing resources to drive sales establish a brand presence and stay competitive in the evolving tourism sector.

Author: Maksims Zubkovs

Supervisor: Ilze Sproģe

Degree: Bachelor

Year: 2024

Work Language: English

Study programme: Business and Management

More...

Development of a mobile robot for moving goods in an unknown environment

The bachelor's thesis consists of five parts, aimed at describing the process of creating a mobile robot.The first part describes requirements for the mobile robot and testing environment.The second part describes the components of the mobile robot, their characteristics, and the connections between them.The third part analyzes existing localization and navigation algorithms used in robotics.The fourth part details the development of algorithms and software in ROS, including the application of navigation and control methods and algorithms that enable the robot to move and map unknown environments.The fifth part describes the testing of the finished robot in real operating conditions to evaluate its performance and identify potential areas for improvement.

Author: Manu Viktors Vilks

Supervisor: Aleksandrs Kraiņukovs

Degree: Bachelor

Year: 2024

Work Language: English

Study programme: Robotics

More...

Table View
Text View