DB2是否支持时间表的连接和聚合?

huangapple go评论91阅读模式
英文:

Does DB2 Support temporal tables join and aggregation?

问题

DB2是否支持在时间字段上对这种类型的表进行时态连接?

英文:

I am looking for a resource which indicates whether Db2 on Ubuntu supports temporal tables join and aggregation or not.

Example:

  1. customer (
  2. customer_id ,
  3. name ,
  4. address ,
  5. valid_period ,
  6. tx_period
  7. );
  8. orders (
  9. order_id ,
  10. customer_id,
  11. order_total,
  12. valid_period ,
  13. tx_period
  14. );

Does DB2 support temporal join for these kind of tables on period fields?

答案1

得分: 1

Db2文档中提供了有关系统时间周期表的限制信息。这些限制也适用于双时态表。接下来,查看查询双时态表。它结合了应用时间段和系统时间段上的谓词。

英文:

The Db2 documentation has information on restrictions for system-period temporal tables. They also apply for bi-temporal tables. Next, look at querying bi-temporal tables. It is combining predicates on application periods and system periods.

huangapple
  • 本文由 发表于 2023年2月8日 15:53:07
  • 转载请务必保留本文链接:https://go.coder-hub.com/75382742.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定