DB-EnginesInfluxDB download bannerEnglish
Informationen zu relationalen und NoSQL DatenbankmanagementsystemenEin Service von solid IT

DBMS > TimescaleDB

TimescaleDB Systemeigenschaften

Bitte wählen Sie ein weiteres System aus, um es mit TimescaleDB zu vergleichen.

Unsere Besucher vergleichen TimescaleDB oft mit InfluxDB, PostgreSQL und Prometheus.

Redaktionelle Informationen bereitgestellt von DB-Engines
KurzbeschreibungA time series DBMS optimized for fast ingest and complex queries, based on PostgreSQL
Primäres DatenbankmodellTime Series DBMS
Sekundäre DatenbankmodelleRelational DBMS
DB-Engines Ranking infomisst die Popularität von Datenbankmanagement- systemenranking trend
Trend Chart
Rang#115  Overall
#8  Time Series DBMS
Technische Dokumentationdocs.timescale.com
Lizenz infoCommercial or Open SourceOpen Source infoApache 2.0
Ausschließlich ein Cloud-Service infoNur als Cloud-Service verfügbarnein
DBaaS Angebote (gesponserte Links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Server BetriebssystemeLinux
Typisierung infovordefinierte Datentypen, z.B. float oder dateja
XML Unterstützung infoVerarbeitung von Daten in XML Format, beispielsweise Speicherung von XML-Strukturen und/oder Unterstützung von XPath, XQuery, XSLTja
SQL infoSupport of SQLja infofull PostgreSQL SQL syntax
APIs und andere ZugriffskonzepteADO.NET
native C library
streaming API for large objects
Unterstützte Programmiersprachen.Net
Java infoJDBC
Server-seitige Scripts infoStored Proceduresbenutzerdefinierte Funktionen, PL/Tcl, PL/Perl, PL/Python, PL/Java, PL/PHP, PL/R, PL/Ruby, PL/Scheme, PL/Unix shell
Partitionierungsmechanismen infoMethoden zum Speichern von unterschiedlichen Daten auf unterschiedlichen Knotenyes, across time and space (hash partitioning) attributes
Replikationsmechanismen infoMethoden zum redundanten Speichern von Daten auf mehreren KnotenMaster-Slave Replikation info
MapReduce infoBietet ein API für Map/Reduce Operationennein
Konsistenzkonzept infoMethoden zur Sicherstellung der Konsistenz in einem verteilten SystemImmediate Consistency
Fremdschlüssel inforeferenzielle Integritätja
Transaktionskonzept infoUnterstützung zur Sicherstellung der Datenintegrität bei nicht-atomaren DatenmanipulationenACID
Concurrency infoUnterstützung von gleichzeitig ausgeführten Datenmanipulationenja
Durability infoDauerhafte Speicherung der Datenja
In-Memory Unterstützung infoGibt es Möglichkeiten einige oder alle Strukturen nur im Hauptspeicher zu haltennein
Berechtigungskonzept infoZugriffskontrolleBenutzer mit feingranularem Berechtigungskonzept entsprechend SQL-Standard
Weitere Informationen bereitgestellt vom Systemhersteller
Specific characteristics

Timescale is the creator of TimescaleDB, the first open-source time-series database to offer the reliability, flexibility, query power, ease-of-use, and scalability that today's software applications, data analytics infrastructure, and complex systems require. 

All data is time-series data, and Timescale offers cloud-hosted, self-managed, and open source versions of TimescaleDB to help developers and data teams across all industries and use cases store, monitor, and analyze their time-series data (common scenarios include: DevOps, IT Monitoring, and IoT). 

Built on PostgreSQL and supporting full SQL, TimescaleDB works with the tools and skills teams already have – and TimescaleDB has an active community of developers and robust technical resources for ongoing support and education.

TimescaleDB at-a-glance

Supports full SQL and JOINS

TimescaleDB natively supports full SQL and adds specialized functions (and query optimizations) for working with time-series data. Support for SQL, a query language your developers and business analysts already know, means that teams don’t have to spend time learning a "SQL-like" syntax or custom query language. 

This also means JOINs with metadata are possible, so you simplify your stack and eliminate data silos between their relational and non-relational databases. More specifically, you’re able to consolidate time-series data (stored in hypertables) with the relational metadata, such as customer data, that gives it meaning (standard tables).

Looks and feels like PostgreSQL 

TimescaleDB scales PostgreSQL in ways previously reserved for non-relational systems and optimizes for fast ingestion on big data. In order to scale far beyond their relational counterparts, non-relational systems sacrifice query power and flexibility. 

TimescaleDB is the best of both worlds: ingests millions of data points per second; scales tables to 100s of billions of rows; and returns quick responses to complex queries.

Works with the entire PostgreSQL ecosystem and offers full extensibility

With its roots in PostgreSQL, TimescaleDB inherits an operational interface familiar to developers, 20+ years of reliability work, and ability to integrate with PostgreSQL extensions. This includes PostGIS for geo-temporal analytics and building a data pipeline with other open-source tools like Kafka, Grafana, Prometheus, and many more.

If it works with PostgreSQL, it works with Timescale.

Optimizes storage and query performance 

With built-in features like native compression, data retention policies, and real-time aggregates, you can apply best-in-class compression algorithms (internal benchmark reports show 90%+ lossless compression rates), execute queries against pre-calculated results (v. querying all underlying raw data), and automatically drop data as it ages. 

For more information about which TimescaleDB version is right for you and to get started, please view our product detail page, documentation, and join us in our active Slack Community.

Competitive advantages

TimescaleDB is purpose-built to scale and handle time-series data workloads and is intentionally designed as a PostgreSQL extension. 

Additionally, with fully managed (cloud), self-managed, and open source versions, developers can opt for the solution that works for their needs.

TimescaleDB is a category-defining time-series database for many reasons, including features like:

  • Native support for ANSI SQL, including JOINs with relational metadata that can be stored right in standard PostgreSQL tables
  • time_bucket and gap_fill, allowing users to query data at any time interval (v. SQL limitations) and choose how they solve for NULL values and missing data
  • GIS support (via PostGIS, another PostgreSQL extension) to roll your own geo-temporal database
  • Support for ACID operations and transactions 
  • Secondary indexes, including composite indexes
  • Secondary JOINs
  • Transparent resource utilization and performance (e.g., many options for administration and tooling, offers the ability to run EXPLAIN, etc.)
  • Native compression and real-time aggregation capabilities to reduce data stored on disk, while still allowing users to analyze historical data
  • Automated data retention policies to remove the burden of manual data lifecycle management
  • Integration with Grafana and Prometheus for data visualization and long-term data storage (roll your own IT Monitoring stack)

TimescaleDB combines the reliability and tooling of PostgreSQL with enterprise-grade security, production-ready SLAs, and community-based and professional support services. 

TimescaleDB is also flexible and customizable, supporting thousands of extensions, products, and integrations critical for data analysis, including: Tableau, Looker, Mode, Grafana, PowerBI, Apache Kafka, RabbitMQ, Apache Spark, Prometheus, Zabbix, JDBC/ODBC, Telegraf, and more.

Typical application scenarios

IoT, Industrial Machine, and Sensor Data

Various industrial IoT use cases across manufacturing, mining, oil & gas, energy, retail, healthcare, and more.

Customer and Internal-facing SaaS applications and Data Pipelines

Surface time-series metrics to end-users, or use to power internal applications, business operations, and data intelligence (Machine Learning pipelines).

DevOps and Infrastructure Monitoring

DevOps and infrastructure monitoring, especially custom initiatives, where siloed metrics are a concern and metadata and trend analysis is important.

Financial Information

Financial information and services across segments such as market research, commodities, and cryptocurrencies.

Key customers

Comcast, Cray, Cree, DNSFilter, LAIKA, Nutanix, Sakura Internet, Schneider Electric, TransferWise, and many more.

Market metrics

With over 8.5K GitHub stars and growing, 1.8 million+ downloads, and an active Slack community, TimescaleDB is trusted by developers and teams around the world.

Licensing and pricing models

TimescaleDB comes in 3 versions, including a fully managed Cloud-hosted solution, licensed under Apache 2 and Timescale License (TSL).

To learn more and find the version that’s best for you, please see our product matrix here (and read more about our support options).

Zugehörige Produkte und Dienstleistungen

Wir laden Vertreter von Anbietern von zugehörigen Produkten ein uns zu kontaktieren, um hier Informationen über ihre Angebote zu präsentieren.

Weitere Ressourcen
Erwähnungen in aktuellen Nachrichten

TimescaleDB Delivers Another Option for Time-Series Analytics
17. Oktober 2019, Datanami

TimescaleDB goes distributed; implements ‘Chunking’ over ‘Sharding’ for scaling-out
22. August 2019, Packt Hub

Timescale announces $15M investment and new enterprise version of TimescaleDB
29. Januar 2019, TechCrunch

Building a Global Environmental Datastack for Climate Action
28. April 2020, hackernoon.com

Introducing Timescale Cloud: The First Fully-Managed, Multi-Cloud Time-Series Database Service
18. Juni 2019, Business Wire

bereitgestellt von Google News


Application/Database Developer
State Street, Boston, MA

Senior Engineer: Storage
Digital Ocean Jobs, Cambridge, MA

Senior Engineer: Storage
DigitalOcean, New York, NY

Senior Engineer: Storage
Digital Ocean Jobs, Palo Alto, CA

Systems Engineer - Monitoring
RingCentral, Denver, CO

jobs by Indeed

Teilen sie diese Seite mit ihrem Netzwerk

Featured Products

RavenDB logo

Setup a fully managed RavenDB Cloud Database in minutes. Enjoy hosting, management, backups all in one place.
Grab a Free Instance

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Couchbase logo

Power, flexibility & scale.
All open source.
Get started now.

Datastax Luna logo

Simple, subscription-based support for open source
Apache Cassandra™ from the Cassandra experts.
Learn more.

Präsentieren Sie hier Ihr Produkt