Gabriele Pozzani

Learn More
In the database research field the management of temporal and spatial information is crucial. Many information may be temporally and spatially qualified, i.e., data may be associated to temporal and spatial locations. In the management of qualified data, the notion of "granularity" plays an important role; it allows one to reason about temporal and spatial(More)
Spatial granularities allow one to qualify classical data adding them space locations. In order to compare data qualified with different granularities and to associate data to different granularities (e.g., in analysis similar to drill-down and roll-up operations), it is necessary to know how the involved granularities are related. However, the explicit(More)
In many different application fields the amount and importance of spatio-temporal data (i.e., temporally and/or spatially qualified data) is increasing in last years and users need new solutions for their management. In this paper we propose a spatio-temporal query language, called ST4SQL. The proposed language extends the well-known SQL syntax and the(More)
The notion of granularity is used in several areas of computing. In temporal databases, granularity relates to the fact that the time frame associated to an event of interest (e.g., an accident) can be envisaged at several levels of detail (e.g., hour, day, month, etc.). Similarly, granularity in data warehousing is the level of detail at which facts (e.g.,(More)
In Pozzani and Combi proposed ST4SQL, an SQL-based query language extending SQL with new constructs for querying spatio-temporal data. In particular ST4SQL deals with different temporal and spatial semantics, allowing one to specify how the system has to manage temporal and spatial dimensions for evaluating queries. Moreover, the query language introduces(More)
  • 1