TimescaleDB explained

TimescaleDB
Developer:Timescale Inc[1]
Latest Release Version:2.15.0
Latest Release Date:[2]
Repo:https://github.com/timescale/timescaledb
Programming Language:C
Operating System:Cross-platform
Genre:Time series database
License:Apache 2.0

TimescaleDB is an open-source time series database[3] [4] [5] developed by Timescale Inc. It is written in C and extends PostgreSQL.[6] [7] TimescaleDB is a relational database[8] and supports standard SQL queries. Additional SQL functions and table structures provide support for time series data oriented towards storage, performance, and analysis facilities for data-at-scale.[9]

One of the key features of TimescaleDB is its performance, which has been compared to InfluxDB.[10] Time-based data partitioning provides for improved query execution and performance when used for time oriented applications.[11] More granular partition definition is achieved through the use of user defined attributes.[12]

TimescaleDB is offered as open source software under the Apache 2.0 license. Additional features are offered in a community edition as source available software under the Timescale License Agreement (TLS).[13]

History

Timescale was founded by Ajay Kulkarni (CEO)[14] and Michael J. Freedman (CTO) in response to their need for a database solution to support internet of things workloads.[15]

Notes and References

  1. Web site: Miller . Ron . Timescale grabs $40M Series B as it goes all in on cloud version of time series database . techcrunch.com. 5 May 2021 .
  2. Web site: TimescaleDB v2.15.0 release notes . 10 May 2024.
  3. Book: Design Recommendations for Intelligent Tutoring Systems: Volume 8 - Data Visualization . December 29, 2020 . Army Research Laboratory . 9780997725780 . 50 . For example, the emergence of reliable, open-source, timeseries databases, such as InfluxDB and TimescaleDB, have made them indispensable tools upon which to build metric-driven workflows (Assay, 2019).The value in these specialized data-stores is in their singluar focus around ingesting and vending massive amounts of tagged measurements at specific points in time. The optimization and specificity to common issues related to measurement in general --- as well as their open-source licenses --- have made them indispensable solutions for a wide range of needs requiring measurement at scale..
  4. Book: Dr. Quan Ha Le . Marcelo Diaz . Developing Modern Database Applications with PostgreSQL . 13 August 2021 . Packt Publishing . 9781838641061 . 162 . TimescaleDB is an open source database for time series data; we first heard about TimescaleDB when we investigated standalone PostgREST because it had TimescaleDB as a built-in extension..
  5. Book: Nathan Liefting . Brian van Baekel . Zabbix 5 IT Infrastructure Monitoring Cookbook . 26 February 2021 . Packt Publishing . 9781800208452 . 358 . TimescaleDB is an open source relational PostgreSQL database for time-based series data..
  6. Web site: Baer . Tony . Timescale scales out and sets its sights on analytics . June 17, 2021 . Thus, TimescaleDB joins what is literally a crowd in the PostgreSQL community, but it is unique in being one of the few, if not the only, PostgreSQL variants that have been specifically designed for time series data. . ZDNet.
  7. Book: Grzesik. Piotr. Mrozek. Dariusz. Computational Science – ICCS 2020 . Comparative Analysis of Time Series Databases in the Context of Edge Computing for Low Power Sensor Networks . 2020-05-25 . Lecture Notes in Computer Science. 12141. 371–383. 10.1007/978-3-030-50426-7_28. 7302557. 978-3-030-50425-0.
  8. Struckov . Alexey . Yufa . Semen . Visheratin . Alexander A. . Nasonov . Denis . 2019-01-01 . Evaluation of modern tools and techniques for storing time-series data . Procedia Computer Science . en . 156 . 19–28 . 10.1016/j.procs.2019.08.125 . 1877-0509 . free.
  9. Web site: High Volume Space Exploration Time-Series Data Storage in PostgreSQL. 2021-08-04. InfoQ. en.
  10. Book: Jowanza Joseph . Mastering Apache Pulsar . December 6, 2021 . O'Reilly Media . 9781492084853 . English . Ebook . TimescaleDB shares some philosophical and performance characteristics with InfluxDB, a database supported out of the box by Pulsar IO..
  11. Web site: Martin. Steven J.. 2018-09-01. Cray Advanced Power Management Updates. 2021-08-04. CUG Proceedings 2018.
  12. Web site: Jinka. Preetam. 2018-12-05. Time Series at ShiftLeft. 2021-08-04. Medium. en.
  13. Web site: 2020-09-24. TimescaleDB License Agreement. 2021-08-09.
  14. Book: David G. Cohen . Brad Feld . Do More Faster India . July 2020 . Wiley . 9781119698913 . Founded by Andrew Cheung and Ajay Kulkarni, Sensobi was a mobile address book that enabled users to record notes, set follow-up reminders, stay connected, and manage relationships. Sensobi received a small amount of funding and was acquired by GroupMe in 2011, when the app was relaunched as a mobile chat platform. Andrew is currently a technical lead at Signal Services and Ajay is cofounder and CEO of TimescaleDB..
  15. Web site: 2017-06-22. A scalable time-series database that supports SQL. 2021-08-09. O'Reilly Data Show Podcast.

This article is licensed under the GNU Free Documentation License. It uses material from the Wikipedia article "TimescaleDB".

Except where otherwise indicated, Everything.Explained.Today is © Copyright 2009-2024, A B Cryer, All Rights Reserved. Cookie policy.