Change search
ReferencesLink to record
Permanent link

Direct link
Relational Database Web Application: Web administration interface for visualizing and predicting relationships to manage relational databases
Mid Sweden University, Faculty of Science, Technology and Media, Department of Information and Communication systems.
2015 (English)Independent thesis Advanced level (degree of Master (Two Years)), 20 credits / 30 HE creditsStudent thesis
Abstract [en]

There is a need of storing and keeping track of things. As the amount of information increases, so does the demand for suitable applications that can manage the data. This thesis has had its focus on developing a web administration interface for relational databases, where the focus has been on managing and visualizing the data, where relationships between data within the database could be predicted through an algorithm. During the thesis, it was revealed that administrators can utilize naming conventions for databases, a property which can be used to predict its relationships. Furthermore, existing applications for managing databases has been compared with the thesis' implementation. Notable differences are that existing solutions are focused towards the structure of the data, rather than the data itself. To accomplish all this, an agile method was chosen for fast results within the deadline, together with standardized web development tools and JavaScript frameworks. The resulting implementation consists of a front- and backend. The frontend was developed using the Ember.JS framework for making web applications and the backend was implemented using Node.JS, together with a component for handling different database dialects called Sequelize. It has been concluded that the prototype this thesis has resulted in works as a proof of concept, complete with a prediction algorithm that can suggest relationships within databases that utilizes convenient and consistent naming conventions. In the future, further research and tests could be conducted to evaluate the security, reliability and usability of the application, to ensure its production quality.

Place, publisher, year, edition, pages
2015. , 65 p.
Keyword [en]
Relational databases, single page application, web, predicting relationships, Ember.JS, Node.JS, Sequelize
National Category
Computer and Information Science
URN: urn:nbn:se:miun:diva-25879OAI: diva2:854503
External cooperation
Subject / course
Computer Engineering DT1
Educational program
Master of Science in Engineering - Computer Engineering TDTEA 300 higher education credits
Available from: 2015-09-30 Created: 2015-09-17 Last updated: 2015-09-30Bibliographically approved

Open Access in DiVA

Relational Database Web Application(1360 kB)55 downloads
File information
File name FULLTEXT01.pdfFile size 1360 kBChecksum SHA-512
Type fulltextMimetype application/pdf

Search in DiVA

By author/editor
Hansson, Andreas
By organisation
Department of Information and Communication systems
Computer and Information Science

Search outside of DiVA

GoogleGoogle Scholar
Total: 55 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

Total: 314 hits
ReferencesLink to record
Permanent link

Direct link