Essays about: "thesis in sql query database"

Showing result 1 - 5 of 18 essays containing the words thesis in sql query database.

  1. 1. Bridging Language & Data : Optimizing Text-to-SQL Generation in Large Language Models

    University essay from Linköpings universitet/Artificiell intelligens och integrerade datorsystem

    Author : Niklas Wretblad; Fredrik Gordh Riseby; [2024]
    Keywords : Chaining; Classification; Data Quality; Few-Shot Learning; Large Language Model; Machine Learning; Noise; Prompt; Prompt Engineering; SQL; Structured Query Language; Text-to-SQL; Zero-Shot Learning; Noise Identification;

    Abstract : This thesis explores text-to-SQL generation using Large Language Models within a financial context, aiming to assess the efficacy of current benchmarks and techniques. The central investigation revolves around the accuracy of the BIRD-Bench benchmark and the applicability of text-to-SQL models in real-world scenarios. READ MORE

  3. 2. Clustering SQL-queries using unsupervised machine learning

    University essay from Luleå tekniska universitet/Institutionen för system- och rymdteknik

    Author : Thomas Schmidt; [2022]
    Keywords : unsupervised machine learning; machine learning; SQL; AI; clustering;

    Abstract : Decerno has created a business system that utilizes Microsoft's Entity Framework (EF) which is an object-database mapper. It can automatically generate SQL queries from code written in C#. Some of these queries has started to display significant increase in query response time which require further examination. READ MORE

  4. 3. Organizing HLA data for improved navigation and searchability

    University essay from Linköpings universitet/Databas och informationsteknik

    Author : Karl Söderbäck; [2021]
    Keywords : HLA; SQL; relational databases; time-series data; read- and write performance;

    Abstract : Pitch Technologies specializes their work on the HLA standard, a standard that specifies data exchange between simulators. The company provides a solution for recording HLA data into a database as raw byte data entries. READ MORE

  5. 4. Comparing database optimisation techniques in PostgreSQL : Indexes, query writing and the query optimiser

    University essay from KTH/Skolan för elektroteknik och datavetenskap (EECS)

    Author : Elizabeth Inersjö; [2021]
    Keywords : PostgreSQL; Query optimisation; Query tuning; Database indexing; Database tuning; DBMS; PostgreSQL; SQL optimering; DBMS; SQL justering; Databasoptimering; Indexering;

    Abstract : Databases are all around us, and ensuring their efficiency is of great importance. Database optimisation has many parts and many methods, two of these parts are database tuning and database optimisation. These can then further be split into methods such as indexing. READ MORE

  6. 5. New Result Database for the Automotive Industry using Dynamic Columns

    University essay from Uppsala universitet/Institutionen för informationsteknologi

    Author : Lukas Magnusson; [2020]
    Keywords : database; dynamic columns; virtual columns; mariadb; sql; systemlink; cloud;

    Abstract : Scania is undergoing a transformation from being a supplier of trucks, buses and engines to a supplier of complete and sustainable transport solutions. Scania Test Rig Development (NLR) group is responsible for developing technical solutions for component testing at Scania R&D and its subdivision Testing Systems (NLRI) is responsible for the development of the software. READ MORE