liu.seSearch for publications in DiVA
System disruptions
We are currently experiencing disruptions on the search portals due to high traffic. We are working to resolve the issue, you may temporarily encounter an error message.
Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • oxford
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Utvidgning av SQL-bibliotek i kompilatorn Storm: En jämförande studie av SQL-satser och datatyper i olika databashanterare
Linköping University, Department of Computer and Information Science.
Linköping University, Department of Computer and Information Science.
2023 (Swedish)Independent thesis Basic level (degree of Bachelor), 10,5 credits / 16 HE creditsStudent thesis
Abstract [en]

This thesis investigates the possibilities of further developing an SQL library in the interactive compiler Storm. Currently, the library only supports the database handler SQLite, and the ambition is  to add support for more database systems. To achieve this addition, a common SQL syntax that is compatible with different database systems is required. The main challenge of developing a common SQL syntax is that each database system has its own variations and deviations from the standard SQL. The study focuses on a comparison between database handlers with the aim of identifying common SQL statements and data types. The goal is to establish a common subset that can be used as the foundation for the general SQL syntax in Storm. The results of the study confirm that it is possible to develop a general SQL syntax in Storm. In addition to the comparative study, the work also involves implementing support for the database handler MariaDB in Storm. 

Abstract [sv]

Detta examensarbete undersöker möjligheterna att vidareutveckla ett SQL-bibliotek i den interaktiva kompilatorn Storm. Vidareutvecklingen innebär tillägg av stöd för fler databashanterare, då SQL-biblioteket för närvarande endast stödjer SQLite. För att möjliggöra tillägget krävs en generell SQL-syntax som är kompatibel med olika databashanterare. Utmaningen som uppstår vid framtagandet av en generell syntax är databasernas variationer och avvikelser från varandra och SQL-standarden. Denna studie fokuserar på en jämförelse mellan databashanterarna med syfte att identifiera gemensamma SQL-satser och datatyper. Målet är att ta fram ett gemensamt subset som kan stå till grund för den generella syntaxen i SQL-biblioteket i Storm. Utifrån studiens resultat kan det fastställas att framtagning av en generell SQL-syntax i Storm är genomförbar. Utöver den jämförande studien innebär dessutom arbetet en implementering av stöd för databasen MariaDB i Storm. 

Place, publisher, year, edition, pages
2023. , p. 34
Keywords [en]
SQL, database handlers, database systems, MariaDB
Keywords [sv]
SQL, SQL-bibliotek, SQL-standard, databaser, databashanterare, MariaDB
National Category
Other Engineering and Technologies
Identifiers
URN: urn:nbn:se:liu:diva-197986ISRN: LIU-IDA/LITH-EX-G--23/037--SEOAI: oai:DiVA.org:liu-197986DiVA, id: diva2:1798890
Subject / course
Computer Engineering
Supervisors
Examiners
Available from: 2024-06-17 Created: 2023-09-20 Last updated: 2025-02-10Bibliographically approved

Open Access in DiVA

fulltext(523 kB)43 downloads
File information
File name FULLTEXT01.pdfFile size 523 kBChecksum SHA-512
31533cd87f16dbe738a65cddca71c19fd05463688b428f28fb110695bf9e2f09a94d5b0f8f6284d379726d27ab9e621b8a8bd397e793b8b5dd47fec83c261d61
Type fulltextMimetype application/pdf

Search in DiVA

By author/editor
Westerberg Jernström, SimonHäger, Hanna
By organisation
Department of Computer and Information Science
Other Engineering and Technologies

Search outside of DiVA

GoogleGoogle Scholar
Total: 43 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

urn-nbn

Altmetric score

urn-nbn
Total: 265 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • oxford
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf