Published

2008-09-01

Comparing two spatio-temporal query languages: SQLST and Güting’s language

Una comparación de dos lenguajes de consulta espacio temporales: SQLST y el de Güting

DOI:

https://doi.org/10.15446/ing.investig.v28n3.15133

Keywords:

spatio-temporal database, spatio-temporal query language, SQL, comparison criteria (en)
bases de datos espacio-temporales, lenguajes de consulta espacio-temporales, SQL, criterios de comparación (es)

Authors

  • Luis Miguel Pérez Montoya .
  • Francisco Javier Moreno Arboleda Universidad Nacional de Colombia

Spatio-temporal databases allow us to represent objects and phenomena from the real world which change position or shape as time elapses. Several query languages have been proposed during the last decade to deal with this type of database. Two of these languages have been compared in this paper: SQLST and Güting’s language. The comparison was based on criteria which have been applied to programming languages; however, they were adapted here to evaluate database query languages. The results led to concluding that both languages high degree of expressiveness may affect other criteria such as readability and simplicity, especially in the case of Güting’s language.

Las bases de datos espacio-temporales permiten representar objetos y fenómenos del mundo real que cambian de posición o forma a medida que transcurre el tiempo. En la última década se han propuesto diversos lenguajes de consulta para dicho tipo de bases de datos. En este artículo se comparan dos de estos lenguajes: SQLST y el de Güting. La comparación se realiza por medio de criterios que se han aplicado a lenguajes de programación, pero que se han adaptado para evaluar lenguajes de consulta de bases de datos. Los resultados permiten concluir que el alto grado de expresividad evidenciado por ambos lenguajes puede afectar otros criterios, como la legibilidad y la simplicidad, especialmente en el caso del lenguaje de Güting.

References

Bonifati, A., Ceri, S., Comparative Analysis of Five XML Query Languages., SIGMOD Record, Vol. 29, No.1, 2000, pp. 68-79. DOI: https://doi.org/10.1145/344788.344822

Chen, C., Zaniolo, C., Universal Temporal Extensions for Database Languages., 15th International Conference on Data Engineering, IEEE Computer Society Press, May, 1999, pp. 428-437.

Chen, C., Zaniolo, C., SQLST: A Spatio-Temporal Data Model and Query Language., Conceptual Modeling - ER 2000, 19th International Conference on Conceptual Modeling., October, 2000, pp. 96-111. DOI: https://doi.org/10.1007/3-540-45393-8_8

Chomicki, J., Revesz, P. Z., A Geometric Framework for Specifying Spatiotemporal Objects, 6th International Workshop on Temporal Representation and Reasoning., Orlando, IEEE Computer Society, May, 1999, pp. 41-46.

Darwen, H., Comunicación privada, Diciembre, 2007.

Date, C. J., An Introduction to Database Systems., 8a ed., Nueva York, Addison-Wesley, 2003.

Eisemberg, A., Melton, J., Kulkarni, K. G., Michels, J. E., Zemke, F., SQL: 2003., SIGMOD Record., Vol. 33, No. 1, 2004, pp. 119-126. DOI: https://doi.org/10.1145/974121.974142

Erwig, M., Schneider, M., STQL: A Spatio-Temporal Query Language., En: Mining Spatio-Temporal Information Systems (eds. R. Ladner, K. Shaw, M. Abdelguerfi), Kluwer Academic Publishers, 2002, pp. 105-126. DOI: https://doi.org/10.1007/978-1-4615-1149-6_6

Flon, L., On Research in Structured Programming., ACM SIGPLAN Notices, Vol. 10, No. 10, 1975, pp. 16-17. DOI: https://doi.org/10.1145/987253.987256

Gilman, L., Rose, A. J., APL: An Interactive Approach., 3a ed., Washington, Wiley, 1984.

Güting, R. H., Böhlen, M. H., Erwig, M., Jensen, C. S., Lorentzos, N. A., Schneider, M., Varzirgiannis, M., A Foundation for Representing and Querying Moving Objects., ACM Transactions on Databases Systems, Vol. 25, No. 1, 2000, pp. 1-42. DOI: https://doi.org/10.1145/352958.352963

Güting, R. H., Schneider, M., Moving Objects Databases., Oxford, Morgan Kaufmann, 2005.

Haase., P., Broekstra, J., Eberhart, A., Volz, R., A Comparison of RDF Query Languages., The Semantic Web – ISWC, 3rd International Semantic Web Conference, November, 2004, pp. 502-517. DOI: https://doi.org/10.1007/978-3-540-30475-3_35

Korth, H. F., Silberschatz, A., Sudarshan, S., Database Systems Concepts., 5a ed., Nueva York, McGraw-Hill, 2005.

McIver, L., Conway, D., Seven Deadly Sins of Introductory Programming Language Design., SEEP '96, International Conference on Software Engineering: Education and Practice, January, 1996, pp. 1-8.

Mendelzon, A., Vaisman, A. Temporal Queries in OLAP., 26th International Conference on Very Large Data Bases, Morgan Kaufmann, September, 2000, pp. 242-253.

Sebesta, R. W., Concepts of Programming Languages., 7a ed., Washington, Addison Wesley, 2007.

Turbak, F. A., Gifford, D. K., Design Concepts in Programming Languages., 1a ed., Boston, The MIT Press, 2008.

Wirth, N., On the Design of Programming Languages., Information Processing 74, North-Holland Publishing Co., 1974, pp. 386- 393.

Worboys, M. F., A Unified Model for Spatial and Temporal Information., The Computer Journal, Vol. 37, No.1, 1994, pp. 26-34. DOI: https://doi.org/10.1093/comjnl/37.1.26

How to Cite

APA

Pérez Montoya, L. M. and Moreno Arboleda, F. J. (2008). Comparing two spatio-temporal query languages: SQLST and Güting’s language. Ingeniería e Investigación, 28(3), 138–144. https://doi.org/10.15446/ing.investig.v28n3.15133

ACM

[1]
Pérez Montoya, L.M. and Moreno Arboleda, F.J. 2008. Comparing two spatio-temporal query languages: SQLST and Güting’s language. Ingeniería e Investigación. 28, 3 (Sep. 2008), 138–144. DOI:https://doi.org/10.15446/ing.investig.v28n3.15133.

ACS

(1)
Pérez Montoya, L. M.; Moreno Arboleda, F. J. Comparing two spatio-temporal query languages: SQLST and Güting’s language. Ing. Inv. 2008, 28, 138-144.

ABNT

PÉREZ MONTOYA, L. M.; MORENO ARBOLEDA, F. J. Comparing two spatio-temporal query languages: SQLST and Güting’s language. Ingeniería e Investigación, [S. l.], v. 28, n. 3, p. 138–144, 2008. DOI: 10.15446/ing.investig.v28n3.15133. Disponível em: https://revistas.unal.edu.co/index.php/ingeinv/article/view/15133. Acesso em: 28 mar. 2024.

Chicago

Pérez Montoya, Luis Miguel, and Francisco Javier Moreno Arboleda. 2008. “Comparing two spatio-temporal query languages: SQLST and Güting’s language”. Ingeniería E Investigación 28 (3):138-44. https://doi.org/10.15446/ing.investig.v28n3.15133.

Harvard

Pérez Montoya, L. M. and Moreno Arboleda, F. J. (2008) “Comparing two spatio-temporal query languages: SQLST and Güting’s language”, Ingeniería e Investigación, 28(3), pp. 138–144. doi: 10.15446/ing.investig.v28n3.15133.

IEEE

[1]
L. M. Pérez Montoya and F. J. Moreno Arboleda, “Comparing two spatio-temporal query languages: SQLST and Güting’s language”, Ing. Inv., vol. 28, no. 3, pp. 138–144, Sep. 2008.

MLA

Pérez Montoya, L. M., and F. J. Moreno Arboleda. “Comparing two spatio-temporal query languages: SQLST and Güting’s language”. Ingeniería e Investigación, vol. 28, no. 3, Sept. 2008, pp. 138-44, doi:10.15446/ing.investig.v28n3.15133.

Turabian

Pérez Montoya, Luis Miguel, and Francisco Javier Moreno Arboleda. “Comparing two spatio-temporal query languages: SQLST and Güting’s language”. Ingeniería e Investigación 28, no. 3 (September 1, 2008): 138–144. Accessed March 28, 2024. https://revistas.unal.edu.co/index.php/ingeinv/article/view/15133.

Vancouver

1.
Pérez Montoya LM, Moreno Arboleda FJ. Comparing two spatio-temporal query languages: SQLST and Güting’s language. Ing. Inv. [Internet]. 2008 Sep. 1 [cited 2024 Mar. 28];28(3):138-44. Available from: https://revistas.unal.edu.co/index.php/ingeinv/article/view/15133

Download Citation

CrossRef Cited-by

CrossRef citations0

Dimensions

PlumX

Article abstract page views

326

Downloads

Download data is not yet available.

Most read articles by the same author(s)