Approximate query evaluation using linear constraint databases

This paper shows that constraint databases can be used for the approximation of several types of discretely recorded continuous data, for example time series data and some spatio-temporal geographic data. We show that time series data can be approximated by a piecewise linear approximation that runs in linear time in the number of data points, and the piecewise linear approximation can be represented in a linear constraint database. Similarly, the spatio-temporal geographic data that is composed of a set of spatial locations, where each location is associated with a time series, can be also approximated and represented in a linear constraint database. The approximations provide data compression, faster query evaluation-that preserve high precision and recall-and interpolation enabling the evaluation of queries that could not be evaluated before.

[1]  Gabriel M. Kuper,et al.  Constraint Query Languages , 1995, J. Comput. Syst. Sci..

[2]  Jayant Sharma,et al.  Oracle8i Spatial: Experiences with Extensible Databases , 1999, SSD.

[3]  Nabil R. Adam,et al.  Database Issues in Geographic Information Systems , 2012, Advances in Database Systems.

[4]  J. Estes,et al.  Geographic Information Systems: An Introduction , 1990 .

[5]  Pankaj K. Agarwal,et al.  Efficient Algorithms for Approximating Polygonal Chains , 2000, Discret. Comput. Geom..

[6]  Min Ouyang,et al.  Approximating Data in Constraint Databases , 2000, SARA.

[7]  A. Prasad Sistla,et al.  DOMINO: databases fOr MovINg Objects tracking , 1999, SIGMOD '99.

[8]  A. Prasad Sistla,et al.  Modeling and querying moving objects , 1997, Proceedings 13th International Conference on Data Engineering.

[9]  Jeffrey S. Torguson,et al.  Cartography , 2019, Dictionary of Geotourism.

[10]  Andrew U. Frank,et al.  Chorochronos a Research Network for Spatiotemporal Database Systems , 2022 .

[11]  S. Louis Hakimi,et al.  Fitting polygonal functions to a set of points in the plane , 1991, CVGIP Graph. Model. Image Process..

[12]  Bruce Momjian,et al.  PostgreSQL: Introduction and Concepts , 2000 .

[13]  Stéphane Grumbach,et al.  Manipulating Interpolated Data is Easier than You Thought , 2000, VLDB.