Abstract
A large part of sensor, image, and statistics data in the Earth Sciences naturally come as data points aligned to regular grids of some dimension, including 1-D time series, 2-D imagery, 3-D image time series and volumetric data, and 4-D spatio-temporal data. Frequently repositories have to host objects of multi-Terabyte size, in the future multi-Petabytes. Serving this information category, large multi-dimensional arrays, is a task of increasing importance among the Earth Sciences. Still, however, ad-hoc implementations with focused functionality prevail which lack the flexibility of SQL-enabled databases.
The Web Coverage Processing Service (WCPS) geo raster model and language allows navigation, extraction, and ad-hoc analysis on multi-dimensional geoscientific raster data which can be geo-referenced or not. The request language has been designed to offer some key properties considered advantageous by the database community: it is formalized, declarative, data independent, optimizable, and safe in evaluation. WCPS has been adopted as an international standard by the Open GeoSpatial Consortium (OGC) in December 2008. The reference implementation is almost finished. Actually, the embedding into the modular framework of the OGC geo service standards has posed particular con straints which the design had to respect. We discuss conceptual model, query language, and the context using real-life use case scenarios.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Baumann, P.: On the Management of Multidimensional Discrete Data. VLDB Journal 4(3) (1994); Special Issue on Spatial Database Systems, VLDB, 401–444
Baumann, P.: A Database Array Algebra for Spatio-Temporal Data and Beyond. In: Tsur, S. (ed.) NGITS 1999. LNCS, vol. 1649, pp. 76–93. Springer, Heidelberg (1999)
Baumann, P.: Large-Scale Raster Services: A Case for Databases (invited keynote). In: Roddick, J.F., Benjamins, V.R., Si-said Cherfi, S., Chiang, R., Claramunt, C., Elmasri, R.A., Grandi, F., Han, H., Hepp, M., Lytras, M.D., Mišić, V.B., Poels, G., Song, I.-Y., Trujillo, J., Vangenot, C. (eds.) ER Workshops 2006. LNCS, vol. 4231, pp. 75–84. Springer, Heidelberg (2006)
Baumann, P. (ed.): Web Coverage Processing Service (WCPS) Language Interface Standard. OGC 08-068r2 (2009)
Baumann, P. (ed.): WCS Processing Extension. OGC 08-059r3 (2009)
Catell, R., Cattell, R.G.G.: The Object Data Standard, 3rd edn. Morgan Kaufmann, San Francisco (2000)
Furtado, P.: Storage Management of Multidimensional Arrays in Database Management Systems. PhD thesis, Technische Universität München (1999)
Garcia, A., Baumann, P.: Modeling Fundamental Geo-Raster Operations with Array Algebra. In: IEEE Intl. Workshop in Spatial and Spatio-Temporal Data Mining, Omaha, USA, October 28-31 (2007)
International Organization for Standardization (ISO): Data elements and interchange formats — Information interchange — Representation of dates and times. ISO IS 8601:2000 (2000)
International Organization for Standardization (ISO): Geographic Information — Coverage Geometry and Functions. ISO IS 19123:2005 (2005)
International Organization for Standardization (ISO): LOTOS, A Formal Description Technique Based on the Temporal Ordering of Observational Behaviour. ISO/IEC IS 8807 (1987)
Libkin, L., Machlin, R., Wong, L.: A Query Language for Multidimensional Arrays: Design, Implementation, and Optimization Techniques. In: Proc. 15th ACM SIGMOD, Montreal, Canada, pp. 228–239 (1996)
Lorie, R.: Issues in Databases for Design Transactions. In: Encarnaçao, J., Krause, F.L. (eds.) File Structures and Databases for CAD. North-Holland, IFIP (1982)
Maier, D., Vance, B.: A Call to Order. In: Proc. 12th ACM PODS, Washington, DC, USA, pp. 1–16 (1993)
Marathe, A., Salem, K.: A Language for Manipulating Arrays. In: Proc. 23rd VLDB, Athens, Greece, pp. 46–55 (1997)
Marathe, A., Salem, K.: Query Processing Techniques for Arrays. In: Proc. SIGMOD, New York, USA, pp. 323–334 (1999)
The rasql Query Guide, version 7. rasdaman GmbH (2008)
OGC (ed.): Abstract Specification Topic 6: Schema for Coverage Geometry and Functions. OGC 07-011 (2007)
Pisarev, A., Poustelnikova, E., Samsonova, M., Baumann, P.: Mooshka: A System for the Management of Multidimensional Gene Expression Data in Situ. Information Systems 28, 269–285 (2003)
Ritsch, R.: Optimization and Evaluation of Array Queries in Database Management Systems. PhD thesis, TU Muenchen (2002)
Ritter, G., Wilson, J., Davidson, J.: Image Algebra: An Overview. Computer Vision, Graphics, and Image Processing 49(1), 297–336 (1994)
Schut, P. (ed.): Web Processing Service (WPS). OGC 05-007r7 (2007)
van Ballegooij, A.: Ram: A Multidimensional Array Dbms. In: Lindner, W., Mesiti, M., Türker, C., Tzitzikas, Y., Vakali, A.I. (eds.) EDBT 2004. LNCS, vol. 3268, pp. 154–165. Springer, Heidelberg (2004)
Whiteside, A., Evans, J. (eds.): Web Coverage Service (WCS) Implementation Specification. OGC 07-067r5 (2008)
Widmann, N., Baumann, P.: Efficient Execution of Operations in a DBMS for Multidimensional Arrays. In: Proc. 10th Statistical and Scientific Database Management (SSDBM), Capri, Italy, pp. 155–165 (1998)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Baumann, P. (2009). Designing a Geo-scientific Request Language - A Database Approach. In: Winslett, M. (eds) Scientific and Statistical Database Management. SSDBM 2009. Lecture Notes in Computer Science, vol 5566. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-02279-1_5
Download citation
DOI: https://doi.org/10.1007/978-3-642-02279-1_5
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-02278-4
Online ISBN: 978-3-642-02279-1
eBook Packages: Computer ScienceComputer Science (R0)