V.4: Sql/tp|a Temporal Extension of Sql
نویسنده
چکیده
We use constraint technology as a basis for SQL/TP, a sound temporal extension of SQL. In contract to most of the earlier proposals, SQL/TP has clean syntax that is consistent with standard SQL, and unambiguous semantics that is rooted in the theory of constraint databases. We also deene a meaningful way of handling aggregation and duplicates, and provide an eecient implementation path on top of existing relational systems based on compilation of queries.
منابع مشابه
Point-based Temporal Extension of SQL
Most of the common proposals for temporal extensions of SQL (e.g., ATSQL2 or SQL/Tem-poral) use explicit interval-based references to time (interval attributes). In this paper we propose a diierent approach: we use point-based references to time as a basis for a temporal extension of SQL. The proposed language|SQL/TP|extends the syntax and semantics of SQL/92 in a very natural way: by adding a ...
متن کاملA Point-based Temporal Extension of SQL
We propose a new approach to temporal extensions of SQL. Unlike the current proposals, e.g., SQL/Temporal, we use point-based references to time as the basis of our approach. The proposed language| SQL/TP|extends the syntax and semantics of SQL/92 in a very natural way: by adding a single data type to represent a linearly ordered universe of individual time instants. Such an extension allows th...
متن کاملPoint-based Temporal Extensions of Sql and Their Eecient Implementation 1.2 Our Proposal 2 the Data Model for Temporal Databases 3.1 Data Deenition Language 3.2 the Query Language
This chapter introduces a new approach to temporal extensions of SQL. The main diierence from most of the current proposals is the use single time points, rather than intervals or various other complex-values for references to time, while still achieving eecient query evaluation. The proposed language, SQL/TP, extends the syntax of SQL/92 to handle temporal data in a natural way: it adds a sing...
متن کاملConstraint Logic Programming and Logic Modality for Event's Valid-time Approximation
The Temporal Probabilistic (TP) Database management systems should provide support for valid-time indeterminacy of events, by proposing the concept of an indeterminate instant, that is, an interval of time-points (event’s time-window) with an associated, lower and upper, probability distribution. In particular, users should be able to control, via query language constructs, the amount of tempor...
متن کاملA History-Oriented Temporal SQL Extension
Dozens of temporal extension of the relational data model and of the query language SQL have appeared in recent years. Recently, a committee formed by researchers from the academic and the industrial worlds designed a consensual extension of the SQL-92 standard to include time, epitomized as TSQL2. According to the fundamental concepts of temporal grouping and temporal completeness elaborated b...
متن کامل