Understanding the differences between Temporal tables, CDC and Time Series.

Поиск
Список
Период
Сортировка
От SQL Padawan
Тема Understanding the differences between Temporal tables, CDC and Time Series.
Дата
Msg-id -6G4DflKS7DGekpDCJwxfFi-cGwrdnftqvxBirKKSxnVT-OmPkn9kKPmyG7BDHLNfGWHtcchPSOkdUuR2UvxaTTZOCs4JEz0VYa8E02Agwc=@protonmail.com
обсуждение исходный текст
Ответы Re: Understanding the differences between Temporal tables, CDC and Time Series.
Список pgsql-general

Good morning to everyone,

I'm looking into Temporal Tables (TT - i.e. System/Application time versioning) but I would like to understand the differences between TTs and two other features (which appear similar in many ways) - Change Data Capture and Time Series.

Are Temporal Tables (in a sense) a query framework framework around CDC?

And if that's the case, what then are Time Series - which are specifically designed to host (time) changing data?

Are Temporal Tables (again, in a sense) Time Series databases which only record changes in time(-stamps)?

I'm unclear as to the "philosophical" distinctions here and would be grateful if anybody could explain the diffence(s) between them?

I did look at this myself and found these posts on StackOverflow, but I don't feel as if they've fundamentally explained the difference(s).



Any ideas, discussion, references, URLs welcome.

Thx,

SQLP!


Sent with ProtonMail Secure Email.


В списке pgsql-general по дате отправления:

Предыдущее
От: Mark Dilger
Дата:
Сообщение: Re: Logical Replication - Should Destination Table Columns Be Defined With Default Value
Следующее
От: Дмитрий Иванов
Дата:
Сообщение: E.1.2. Migration to Version 14