Bachelor and Master Theses

Title: SQLite in a Robot Control System
Subject: Computer Science
Level: Advanced
Description: The purpose of this thesis is to generate a set of general guidelines to improve performance of the SQLite database management system for use as a component in the main computer in ABB robots. This was accomplished measuring the factors that affect query execution time and comparing SQLite features to systems it could potentially replace: chiefly ABB’s configuration storage system and real-time logging system. Results show that SQlite is slower than ABBs current configuration system and real-time logger. A series of tests were carried out that give a rough description of SQLites performance. Read and update become significantly faster when used with an index, write becomes a bit slower. In an indexed database the number of rows is not important; in a database without an index they cause significant slowing. Surprisingly, increasing the number of threads concurrently accessing a database has only a mild effect on timing.
Company: ABB Robotics, kontaktperson: Patrik Fager
Prel. end date: 2013-10-31
Presentation date: 2013-09-12
Student: Björn Delight bdt08001@student.mdh.se
IDT supervisor: Dag Nyström
dag.nystrom@mdh.se, +46-21-107042
Examinator: Mikael Sjödin
Mikael Sjödin
mikael.sjodin@mdh.se, +46 70 288 2829

Rapport och bilagor

Size

Senaste uppdatering

TR1497.pdf

3128624

2013-11-01, 13:45


  • Mälardalen University |
  • Box 883 |
  • 721 23 Västerås/Eskilstuna |
  • 021-101300, 016-153600 |
  • webmaster |
  • Latest update: 2017.10.14