University of Twente Student Theses

Login

SQLento: database programming made easier

Balk, Roland (2016) SQLento: database programming made easier.

[img] PDF
1MB
Abstract:Relational databases take care of many problems, like storing digital information on a physical medium and providing search algorithms. However, programming relational databases can be improved a lot. For example, programming languages like Java, PHP and C# provide solutions to write SQL code in strings, which increases vulnerability for SQL injections. We propose to make database programming easier by developing a new database programming language called SQLento. First we have explored eight concerns related to programming relational databases from a general purpose programming language and the SQL database programming language. Each found concern is not very crucial to solve and may have already a solution. Therefore we continued our research by evaluating ten different solutions. After the evaluation, we conclude that none of the solutions solve all concerns. We also realized that not all concerns can be solved by providing a new database programming language for relational databases. Thus we decided to design an architecture as well, to separate our database programming language from general purpose programming languages. This makes our solution more portable compared to other solutions and allows to optimize the database code. The prototype of SQLento provides two new features to make database programming easier.
Item Type:Essay (Master)
Faculty:EEMCS: Electrical Engineering, Mathematics and Computer Science
Subject:54 computer science
Programme:Computer Science MSc (60300)
Link to this item:https://purl.utwente.nl/essays/68972
Export this item as:BibTeX
EndNote
HTML Citation
Reference Manager

 

Repository Staff Only: item control page