Abstract
Multidimensional array data, including satellite images and weather simulations in the Earth Science, confocal microscopy and CAT scans in the Life Science, as well as telescope and cosmological observations in Space science, is traditionally the type of data seriously contributing to “Big Data”. Traditionally, the database community has neglected this, with the effect that ad hoc implementations prevail. With the advent of NewSQL in recent years, however, the database scope has broadened, and array modelling and query support is seriously considered. Hence, we address integration of array queries into SQL by proposing a generic model, ASQL, for modelling and querying multi-dimensional arrays in ISO SQL. The model integrates concepts from the three major array models seen today: rasdaman, SciQL, and SciDB. ASQL has been implemented and is currently being discussed in ISO for extending standard SQL.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
(www.rasdaman.org, Accessed on 22 Aug, 2013)
- 2.
References
Andrejev A, Risch T (2012) Scientific SPARQL: semantic web queries over scientific data. In: Proceedings of the 2012 IEEE 28th international conference on data engineering workshops, ICDEW ’12. IEEE Computer Society, pp 5–10
Baumann P (1994) Management of multidimensional discrete data. VLDB J 3(4):401–444
Baumann P (1999) A database array algebra for spatio-temporal data and beyond. In: Proceedings of the 4th international workshop on next generation information technologies and systems, NGITS ’99. Springer, Berlin, pp 76–93
Cornacchia R, Héman S, Zukowski M, Vries AP, Boncz P (2008) Flexible and efficient IR using array databases. VLDB J 17(1):151–168
ISO (1999) Information technology—database language SQL. Standard No. ISO/IEC 9075:1999. International Organization for Standardization (ISO)
ISO (2003) ISO IEC 9075-1:2003: information technology—database languages—SQL—part 1: framework (SQL framework). ISO, Geneva
Lerner A, Shasha D (2003) Aquery: query language for ordered data, optimization techniques, and experiments. In: Proceedings of the 29th international conference on very large data bases, vol 29, VLDB ’03. VLDB Endowment, pp 345–356
Libkin L, Machlin R, Wong L (1996) A query language for multidimensional arrays: design, implementation, and optimization techniques. In: Proceedings of the 1996 ACM SIGMOD international conference on management of data, SIGMOD ’96. ACM, New York, pp 228–239
Marathe AP, Salem K (2002) Query processing techniques for arrays. VLDB J 11(1):68–91
Misev D, Baumann P (2014) Extending the SQL array concept to support scientific analytics. In: Conference on scientific and statistical database management, SSDBM ’14. ACM, Aalborg, 30 June–02 July
Obe R, Hsu L (2011) PostGIS in action. Manning Publications, Manning Pubs Co Series
rasdaman GmbH (2013) rasdaman query language guide, 8.5 edition
Stonebraker M, Brown P, Poliakov A, Raman S (2011) The architecture of SciDB. In: Proceedings of the 23rd international conference on scientific and statistical database management, SSDBM ’11. Springer, Berlin, pp 1–16
T. H. D. Group (2013) HSQLDB—100 % Java database. http://hsqldb.org/. Accessed on 15 Feb 2014
van Ballegooij AR (2004) RAM: a multidimensional array DBMS. In: Proceedings of the 2004 international conference on current trends in database technology, EDBT ’04. Springer, Berlin, pp 154–165
Waldrop M, Lippel P (2008) The sensor revolution. www.nsf.gov/news/special_reports/sensor. Accessed on 22 Aug 2013
Zhang Y, Kersten ML, Ivanova M, Nes N (2011) SciQL, bridging the gap between science and relational DBMS. In: Desai BC, Cruz IF, Bernardino J (eds) IDEAS. ACM, pp 124–133
Acknowledgments
This work is being supported by the European Commission funded project EarthServer.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this chapter
Cite this chapter
Misev, D., Baumann, P. (2015). A Database Language More Suitable for the Earth System Sciences. In: Lohmann, G., Meggers, H., Unnithan, V., Wolf-Gladrow, D., Notholt, J., Bracher, A. (eds) Towards an Interdisciplinary Approach in Earth System Science. Springer Earth System Sciences. Springer, Cham. https://doi.org/10.1007/978-3-319-13865-7_24
Download citation
DOI: https://doi.org/10.1007/978-3-319-13865-7_24
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-13864-0
Online ISBN: 978-3-319-13865-7
eBook Packages: Earth and Environmental ScienceEarth and Environmental Science (R0)