时间序列数据库和关系数据库之间的区别

I have read some concept about time-series database and some answers about the differences between these 2 but I can't still get my head around these differences.

我已经阅读了一些关于时间序列数据库的概念以及关于这两者之间差异的一些答案,但我仍然无法理解这些差异。

How data is written and stored to disk that make the differences between time-series database and rdbms?

如何将数据写入并存储到磁盘中,以便在时间序列数据库和rdbms之间产生差异?

What are the best use cases for time-series database over rdbms and VICE VERSA?. I mean the cases that make the time-series database provide outstanding performance over rdbms, also I want to know the cases that rdbms is a more suitable choice than time-series database.

rdbms和VICE VERSA的时间序列数据库的最佳用例是什么?我的意思是使时间序列数据库提供优于rdbms的性能的情况,我也想知道rdbms比时间序列数据库更合适的情况。

1 个解决方案

#1

Time Series Database Advantages:

时间序列数据库优势:

Throughout 100K+ to 1M+ inserts per second

每秒超过100K +至1M +插入

Bytes stored per time/value tuple: 2-10 vs 30-100 (rdbms)

每个时间/值元组存储的字节数:2-10 vs 30-100(rdbms)

Built-in time series transformation and aggregations functions

内置时间序列转换和聚合功能

Schema optimized for time-series arrays with built-in sharding and indexing

针对具有内置分片和索引的时间序列阵列优化的模式

Relational Database Advantages:

关系数据库的优点:

Full SQL support

完整的SQL支持

Ability to store any data other than time-series

能够存储时间序列以外的任何数据

Extensive DBA resources and tooling

广泛的DBA资源和工具

By writing your own application code and stored procedures you can accomplish almost everything that TSDBs provide, but you may end up with an implementation that is slower and more demanding in terms of underlying compute and storage resources.

通过编写自己的应用程序代码和存储过程,您几乎可以完成TSDB提供的所有操作,但最终可能会遇到基础计算和存储资源较慢且要求较高的实现。

For all practical purposes and with some compromises to referential integrity, you can have both databases run concurrently: store your extended app schema in relational database and time-series in TSDB.

出于所有实际目的并且对参照完整性有一些妥协,您可以同时运行两个数据库:将扩展应用程序模式存储在关系数据库中,并将时间序列存储在TSDB中。

#1