Advanced

Database Paradigms for Recordings Management

Ottosson, Eric LU and Sinha, Suraj LU (2015) In LU-CS-EX 2015-21 EDA920 20151
Department of Computer Science
Abstract
The relational database has long been considered the de facto standard for managing data in software applications. Today, a need for more scalable, flexible and distributed software solutions has led to the development of NoSQL database technologies that aim to replace the relational database in applications where such features are needed.

In this thesis we have investigated the potential benefits of replacing SQLite, the database used by Axis Communications to manage recordings in their camera products, with a “Not only SQL” (NoSQL) database in an embedded camera system. To evaluate performance, test cases to measure execution times and resource consumption for database operations, based on important functionality in Axis’ storage... (More)
The relational database has long been considered the de facto standard for managing data in software applications. Today, a need for more scalable, flexible and distributed software solutions has led to the development of NoSQL database technologies that aim to replace the relational database in applications where such features are needed.

In this thesis we have investigated the potential benefits of replacing SQLite, the database used by Axis Communications to manage recordings in their camera products, with a “Not only SQL” (NoSQL) database in an embedded camera system. To evaluate performance, test cases to measure execution times and resource consumption for database operations, based on important functionality in Axis’ storage solution, were designed.

In the end the Embedded JSON Database Engine (EJDB) document database was identified. EJDB was found to be more efficient than SQLite at creating, updating and removing records. It was, however, less efficient when perform- ing queries based on conditional operators. (Less)
Please use this url to cite or link to this publication:
author
Ottosson, Eric LU and Sinha, Suraj LU
supervisor
organization
course
EDA920 20151
year
type
H3 - Professional qualifications (4 Years - )
subject
keywords
Databases, Embedded Systems, NoSQL, Relational Databases, Document Databases, SQLite, EJDB
publication/series
LU-CS-EX 2015-21
report number
LU-CS-EX 2015-21
ISSN
1650-2884
language
English
additional info
This paper is the result of a collaboration between Axis Communications, Lund Sweden, and the Faculty of Engineering at Lund University. As part of work completion, the students received payments from Axis Communications.
id
7358115
date added to LUP
2015-06-16 11:19:28
date last changed
2015-06-18 14:04:28
@misc{7358115,
  abstract     = {The relational database has long been considered the de facto standard for managing data in software applications. Today, a need for more scalable, flexible and distributed software solutions has led to the development of NoSQL database technologies that aim to replace the relational database in applications where such features are needed.

In this thesis we have investigated the potential benefits of replacing SQLite, the database used by Axis Communications to manage recordings in their camera products, with a “Not only SQL” (NoSQL) database in an embedded camera system. To evaluate performance, test cases to measure execution times and resource consumption for database operations, based on important functionality in Axis’ storage solution, were designed.

In the end the Embedded JSON Database Engine (EJDB) document database was identified. EJDB was found to be more efficient than SQLite at creating, updating and removing records. It was, however, less efficient when perform- ing queries based on conditional operators.},
  author       = {Ottosson, Eric and Sinha, Suraj},
  issn         = {1650-2884},
  keyword      = {Databases,Embedded Systems,NoSQL,Relational Databases,Document Databases,SQLite,EJDB},
  language     = {eng},
  note         = {Student Paper},
  series       = {LU-CS-EX 2015-21},
  title        = {Database Paradigms for Recordings Management},
  year         = {2015},
}