Bitemporal Sliding Windows

The bitemporal data model associates two time intervals with each record - system time and application time - denoting the validity of the record from the perspective of the database and of the real world, respectively. One issue that has not yet been addressed is how to efficiently answer sliding window queries in this model. In this work, we propose and experimentally evaluate a main-memory index called BiSW that supports sliding windows on system time, application time, and both time attributes simultaneously. Our experimental results show that BiSW outperforms existing approaches in terms of space footprint, maintenance overhead and query performance

Schema Vacuuming in Temporal Databases

Temporal databases facilitate the support of historical information by providing functions for indicating the intervals during which a tuple was applicable (along one or more temporal dimensions). Because data are never deleted, only superceded, temporal databases are inherently append-only resulting, over time, in a large historical sequence of database states. Data vacuuming in temporal databases allows for this sequence to be shortened by strategically, and irrevocably, deleting obsolete data. Schema versioning allows users to maintain a history of database schemata without compromising the semantics of the data or the ability to view data through historical schemata. While the techniques required for data vacuuming in temporal databases have been relatively well covered, the associated area of vacuuming schemata has received less attention. This paper discusses this issue and proposes a mechanism that fits well with existing methods for data vacuuming and schema versioning

On the Semantics of "Now" in Databases

While "now" is expressed in SQL as CURRENT-TIMESTAMP within queries, this value cannot be stored in the database. However, this notion of an ever-increasing current-time value has been reflected in some temporal data models by inclusion of database-resident variables, such as "now," "until-changed," "â," "@" and "-." Time variables are very desirable, but their use also leads to a new type of database, consisting of tuples with variables, termed a variable database. This paper proposes a framework for defining the semantics of the variable databases of temporal relational data models. A framework is presented because several reasonable meanings may be given to databases that use some of the specific temporal variables that have appeared in the literature. Using the framework, the paper defines a useful semantics for such databases. Because situations occur where the existing time variables are inadequate, two new types of modeling entities that address these shortcomings, timestamps which we call now-relative and now-relative indeterminate, are introduced and defined within the framework. Moreover, the paper provides a foundation, using algebraic bind operators, for the querying of variable databases via existing query languages. This transition to variable databases presented here requires minimal change to the query processor. Finally, to underline the practical feasibility of variable databases, we show that database variables can be precisely specified and efficiently implemented in conventional query languages, such as SQL, and in temporal query languages, such as TSQL2.Information Systems Working Papers Serie

Analysis of Methods to Detect Changes in Coverage fromWater Reservoirs of the Pao River Basin, Venezuela

In this paper, four methods of detecting changes in land use and coverage are applied to three reservoirs on the Pao river basin, Carabobo and Cojedes States, Venezuela: 1) difference of reflectance images, 2) reflectance images ratio, 3) difference of index images of vegetation and 4) difference of images of principal components. Eight Landsat satellite images corresponding to L5TM (1986, 1991, 2001), 2) L7ETM (2000, 2002, 2003) and 3) L8OLI (2015 and 2016) are used. The bitemporal change detection methods are: the difference in reflectance in the near-infrared region, the normalized difference in vegetation index, the principal components based on reflectance in the optical and infrared spectral regions and the reflectance ratio in the near infrared region. The global accuracy index varies between 86.67 and 100%, the Kappa coefficient between 0.6 and 1. The water quality changes are estimated in terms of the presence of only sediments, a mixture of sediments and algae; coverage from water to vegetation; the reflectance in the near infrared region and the concentration of sediments vary between 1 and 3%; 50 to 100 mg / l; 0.5 and 1%; 50 to 250 mg / l; an increase from 1% to 40%, respectively

Music and time: tempomorphism: nested temporalities in perceived experience of music.

This thesis represents the results of a theoretical and practical investigation of acoustic and electro-acoustic elements of Western music at the start of the twentyfirst century, with specific attention to soundscapes. A commentary on the development of soundscapes is drawn from a multidisciplinary overview of concepts of time, followed by an examination of concepts of time in music. As a response to Jonathan Kramer's concept of `vertical' music (a characteristic aesthetic of which is an absence of conventional harmonic teleology), particular attention is paid to those theories of multiple nested temporalities which have been referred to by Kramer in support of non-teleological musical structures. The survey suggests that new musical concepts, such as vertical music, have emerged from sensibilities resulting from the musical and associated styles of minimalism, and represent an ontological development of aesthetics characteristic of the twentieth century. An original contention of the debate is that innovations in the practice of music as the result of technological developments have led to the possibility of defining a methodology of process in addition to auditive strategies, resulting in a duality defined as 'tempomorphic'. Further observations are supplied, using findings derived from original creative practical research, to define tempomorphic performance, which complete the contribution to knowledge offered by the investigation. Tempomorphism, therefore, is defined as a duality of process and audition: as auditive tool, tempomorphic analysis provides a listening strategy suited to harmonically static music; as a procedural tool, it affords a methodology based primarily on duration