Temporal Database and its Relational Algebra

Click For Summary

Discussion Overview

The discussion revolves around the design and query mechanisms of temporal databases in comparison to standard relational databases. Participants explore whether queries in temporal databases utilize temporal logic and its operators, and how this relates to the outputs of such queries.

Discussion Character

  • Exploratory, Conceptual clarification

Main Points Raised

  • One participant questions if temporal databases are structured similarly to standard relational databases, specifically regarding the use of temporal logic for queries.
  • Another participant mentions a lack of experience with temporal databases and expresses uncertainty about the query mechanisms involved.
  • A participant shares a link to a wiki article discussing the evolution of temporal database design from relational databases, suggesting it may provide relevant insights.
  • A later reply acknowledges a missed part of the article and indicates a plan to read it more carefully.

Areas of Agreement / Disagreement

Participants do not reach a consensus, and multiple viewpoints remain regarding the structure and querying of temporal databases.

Contextual Notes

Some assumptions about the definitions of temporal logic and its operators may not be fully articulated, and there is a lack of firsthand experience with temporal databases among participants.

WWGD
Science Advisor
Homework Helper
Messages
7,802
Reaction score
13,105
Hi all,
Just curious on whether temporal databases are designed in the same way as "standard" relational databases,
so that queries on temporal databases are wffs in temporal logic , i.e., using Until, Release and all other unary
operators , and the query outputs is the set of models for the wff? Thanks.
 
Physics news on Phys.org
There are wff's from spatial relations resultsets for spatial databases. I have never worked in a temporal db environment. I do not know.
 
jedishrfu said:
This wiki article talks about the evolution of temporal database design from relational databases which may answer your question:

https://en.m.wikipedia.org/wiki/Temporal_database
Sorry I missed rhat [art when reading the article; will read more carefully next time.
 

Similar threads

  • · Replies 40 ·
2
Replies
40
Views
9K
  • · Replies 8 ·
Replies
8
Views
2K
  • · Replies 7 ·
Replies
7
Views
3K
  • · Replies 21 ·
Replies
21
Views
3K
  • · Replies 6 ·
Replies
6
Views
2K
  • · Replies 4 ·
Replies
4
Views
1K
Replies
2
Views
3K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 8 ·
Replies
8
Views
3K
  • · Replies 3 ·
Replies
3
Views
393