Transitioning temporal support in TSQL2 to SQL3

Snodgrass, Richard T.; Böhlen, Michael H.; Jensen, Christian S.; Steiner, Andreas

doi:10.1007/bfb0053702

Cited by 58 publications

(26 citation statements)

References 4 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…SQL/Temporal's sequenced queries [SBJS98] and TempOQL's pointwisely generalized operators [FDS99]). With respect to these works, our contribution has been to demonstrate the need to integrate this synchronization at the browsing level, and to propose a browsing technique to this end.…”

Section: Discussionmentioning

confidence: 99%

Pointwise Temporal Object Database Browsing

Dumas

Daassi

Fauvet

et al. 2001

Objects and Databases

View full text Add to dashboard Cite

Visual object database browsers are essentially based on two kinds of interactions: navigation within a collection of objects, and navigation between objects via their relationships. These two interactional operators have proven to adequately support the main user task addressed by these tools, i.e. exploring the states of a set of related objects. In temporal object databases, visual browsing tools should additionally support users tasks such as studying a snapshot of a collection of objects at a given instant, or detecting and examining changes within object states. In this paper, we show that the two interactional operators supported by classical object browsers do not adequately address these tasks. We consequently propose an interactional operator dedicated to navigation through time, and we study how it can be orthogonally integrated with the above two.

show abstract

Section: Discussionmentioning

confidence: 99%

Pointwise Temporal Object Database Browsing

Dumas

Daassi

Fauvet

et al. 2001

Objects and Databases

View full text Add to dashboard Cite

show abstract

“…Data language versus query language-The two should be differentiated [12]. ATSQL2 [8], SQL/Temporal [35], [36], and SQL/TP [41], [43], [44] support time intervals in their data representation language; however, while the query languages of ATSQL2 [13] and SQL/Temporal are based on time intervals, that of SQL/TP is based on time points. 3.…”

Section: Distinctionsmentioning

confidence: 99%

Reconciling point-based and interval-based semantics in temporal relational databases: a treatment of the telic/atelic distinction

Terenziani

Snodgrass

2004

IEEE Trans. Knowl. Data Eng.

View full text Add to dashboard Cite

Abstract-The analysis of the semantics of temporal data and queries plays a central role in the area of temporal databases. Although many different algebrae and models have been proposed, almost all of them are based on a point-based (snapshot) semantics for data. On the other hand, in the areas of linguistics, philosophy, and, recently, artificial intelligence, an oft-debated issue concerns the use of an interval-based versus a point-based semantics. In this paper, we first show some problems inherent in the adoption of a point-based semantics for data, then argue that these problems arise because there is no distinction drawn in the data between telic and atelic facts. We then introduce a three-sorted temporal model and algebra including coercion functions for transforming relations of one sort into relations of the other at query time which properly copes with these issues.

show abstract

“…Assumptions have been made in the literature about the ease of use of temporal extensions [16]. Conceptual models have been presented which are claimed to be more intuitive to the user [17,5].…”

Section: Motivationmentioning

confidence: 99%

ProSQL: A Prototyping Tool for SQL Temporal Language Extensions

Green

Johnson

2003

Lecture Notes in Computer Science

View full text Add to dashboard Cite

Abstract. This paper describes ProSQL, a novel prototyping tool to support the development of extensions to SQL. ProSQL provides a simple way to prototype the features of a proposed extension and thus provide a proof of concept. Further, it provides proposers and reviewers of extensions with a clearer view of their positive and negative features. The approach adopted has been to build a wrapper around an existing database management system, in this case Microsoft Access, and to provide a collection of interfaces with which a designer can define extensions to the basic relational database.

show abstract

Transitioning temporal support in TSQL2 to SQL3

Cited by 58 publications

References 4 publications

Pointwise Temporal Object Database Browsing

Pointwise Temporal Object Database Browsing

Reconciling point-based and interval-based semantics in temporal relational databases: a treatment of the telic/atelic distinction

ProSQL: A Prototyping Tool for SQL Temporal Language Extensions

Contact Info

Product

Resources

About