Database Paradigms for Recordings Management
(2015) In LU-CS-EX 2015-21 EDA920 20151Department 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:
http://lup.lub.lu.se/student-papers/record/7358115
- author
- Ottosson, Eric LU and Sinha, Suraj LU
- supervisor
- organization
- course
- EDA920 20151
- year
- 2015
- 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}}, language = {{eng}}, note = {{Student Paper}}, series = {{LU-CS-EX 2015-21}}, title = {{Database Paradigms for Recordings Management}}, year = {{2015}}, }