Umeå University's logo

umu.sePublications
Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Time Series Databases For Production Machinery
Umeå University, Faculty of Science and Technology, Department of Computing Science.
2024 (English)Independent thesis Advanced level (degree of Master (Two Years)), 300 HE creditsStudent thesis
Abstract [en]

A time series database is a type of software system that has been optimized for storing and reading time series data. This type of data is defined as a series of datapoints that are individually coupled with a timestamp. Early adopters of the timeseries database were industrial applications that were in need efficiently storingsensory data such as temperature and flow. These types of niche databases became commonly labeled as process/data historians or simply historians for short. MOPSsys, a company in Örnsköldsvik, has been developing historians for 40 years with their most recent one being MOPS HISTORIAN, which is operated by over 120 mills across 20 countries. For process historians, read and write speeds are crucial in order to provide fast and responsive trends, curves and profiles for operators and engineers. Therefore, it is not uncommon for these historians to relax some typical database requirements such as ACID (Atomic, Consistent, Isolated, Durable) transactions to increase performance. One of the crucial parts of designing a process historian is to decide on how data is stored for optimalperformance. This leads to an interesting discussion about how the data should be stored on disk for optimal historian performance. This thesis explores andtests different storage formats suited for historians such as the current storage format in MOPS Historian, Log-Structured Merge trees (LSM) and Indexed Sequential Access Methods (ISAM). The benchmarks include basic reads and writes with heavy emphasis put on range queries. These storage formats are also benchmarked against other databases that exist on the market, those being PostgreSQL and TimescaleDB, a PostgreSQL extension. Results from testing these candidates showed that PostgreSQL and TimescaleDB performed the best and that ISAM and LSM had different strengths and weaknesses depending on the scenario.

Place, publisher, year, edition, pages
2024.
Series
UMNAD ; 1496
National Category
Computer Sciences
Identifiers
URN: urn:nbn:se:umu:diva-227253OAI: oai:DiVA.org:umu-227253DiVA, id: diva2:1878222
External cooperation
MOPSsys AB
Educational program
Master of Science Programme in Computing Science and Engineering
Supervisors
Examiners
Available from: 2024-06-27 Created: 2024-06-26 Last updated: 2024-06-27Bibliographically approved

Open Access in DiVA

fulltext(656 kB)124 downloads
File information
File name FULLTEXT01.pdfFile size 656 kBChecksum SHA-512
fcdfd590c6a87e5cd4a4dda431baeccb1eae3a8ad7a11889bdc4a73a10f4675705695f368a05290422648a89ade3d86e838af3f9d8933aa98472983b69d7de82
Type fulltextMimetype application/pdf

By organisation
Department of Computing Science
Computer Sciences

Search outside of DiVA

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

urn-nbn

Altmetric score

urn-nbn
Total: 405 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf