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

2021-11-10 Thread SQL Padawan
Hi Peter, and thanks for answering. > > I'm unclear as to the "philosophical" distinctions here and would be > > grateful if anybody could explain the diffence(s) between them? > A time series database contains data records containing a time stamp > A temporal database contains records that

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

2021-11-09 Thread Peter Eisentraut
On 10.11.21 07:43, SQL Padawan wrote: 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 Table