The University of Southampton
University of Southampton Institutional Repository

Optimising data storage for performance in a modern binary relational database based on a triple store

Optimising data storage for performance in a modern binary relational database based on a triple store
Optimising data storage for performance in a modern binary relational database based on a triple store

This thesis introduces a new approach to understanding the issues relating to the efficient implementation of a binary relational database built upon a triple store. The place of the binary relational database is established with reference to other database models, and a detailed description of a new triple store implementation is presented, together with a definition of the architecture. The use of a model, which reflects the performance of the triple store database, is described, and the results of performance investigations are presented. In the first, the use of more than one sort order in the triple store database is analyzed, and the use of two sort orders is found to be optimal. In the second, the effect of compression in the triple store is considered, and compared with other approaches to compressing the non-index portion of a database management system. In conclusion, the model successfully predicts the effect of using two sort orders, and this was confirmed upon subsequent incorporation into the database. It is also found that significant performance gains can be made by the use of compression in the triple store. It is shown that by extending the compression algorithm even greater gains could be made. In addition, it is found that by keeping the design of the database as simple and pure as possible, a foundation for a variety of higher level views can be achieved, leading to the possibility of the triple store being used as the foundation for new databases.

University of Southampton
O'Connell, Stephen John
30d72b27-0726-42d1-a7c9-26761b7efe47
O'Connell, Stephen John
30d72b27-0726-42d1-a7c9-26761b7efe47

O'Connell, Stephen John (2002) Optimising data storage for performance in a modern binary relational database based on a triple store. University of Southampton, Doctoral Thesis.

Record type: Thesis (Doctoral)

Abstract

This thesis introduces a new approach to understanding the issues relating to the efficient implementation of a binary relational database built upon a triple store. The place of the binary relational database is established with reference to other database models, and a detailed description of a new triple store implementation is presented, together with a definition of the architecture. The use of a model, which reflects the performance of the triple store database, is described, and the results of performance investigations are presented. In the first, the use of more than one sort order in the triple store database is analyzed, and the use of two sort orders is found to be optimal. In the second, the effect of compression in the triple store is considered, and compared with other approaches to compressing the non-index portion of a database management system. In conclusion, the model successfully predicts the effect of using two sort orders, and this was confirmed upon subsequent incorporation into the database. It is also found that significant performance gains can be made by the use of compression in the triple store. It is shown that by extending the compression algorithm even greater gains could be made. In addition, it is found that by keeping the design of the database as simple and pure as possible, a foundation for a variety of higher level views can be achieved, leading to the possibility of the triple store being used as the foundation for new databases.

Text
905809.pdf - Version of Record
Available under License University of Southampton Thesis Licence.
Download (12MB)

More information

Published date: 2002

Identifiers

Local EPrints ID: 465064
URI: http://eprints.soton.ac.uk/id/eprint/465064
PURE UUID: 4f3fb05f-1339-4054-a4c1-60bf229890a3

Catalogue record

Date deposited: 05 Jul 2022 00:21
Last modified: 16 Mar 2024 19:55

Export record

Contributors

Author: Stephen John O'Connell

Download statistics

Downloads from ePrints over the past year. Other digital versions may also be available to download e.g. from the publisher's website.

View more statistics

Atom RSS 1.0 RSS 2.0

Contact ePrints Soton: eprints@soton.ac.uk

ePrints Soton supports OAI 2.0 with a base URL of http://eprints.soton.ac.uk/cgi/oai2

This repository has been built using EPrints software, developed at the University of Southampton, but available to everyone to use.

We use cookies to ensure that we give you the best experience on our website. If you continue without changing your settings, we will assume that you are happy to receive cookies on the University of Southampton website.

×