A query language for multidimensional arrays: design, implementation, and optimization techniques
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
The multidimensional database system RasDaMan
SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
The Design and Implementation of a Sequence Database System
VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
A Foundation for Multi-dimensional Databases
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
A Database Array Algebra for Spatio-Temporal Data and Beyond
NGIT '99 Proceedings of the 4th International Workshop on Next Generation Information Technologies and Systems
SRQL: Sorted Relational Query Language
SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management
Tale of Two Cultures: Are There Database Research Issues in Bioinformatics?
SSDBM '02 Proceedings of the 14th International Conference on Scientific and Statistical Database Management
Query processing techniques for arrays
The VLDB Journal — The International Journal on Very Large Data Bases
Scientific data management in the coming decade
ACM SIGMOD Record
AQuery: query language for ordered data, optimization techniques, and experiments
VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29
Flexible and efficient IR using array databases
The VLDB Journal — The International Journal on Very Large Data Bases
Communications of the ACM
Overview of sciDB: large scale array storage, processing and analysis
Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
SciQL: bridging the gap between science and relational DBMS
Proceedings of the 15th Symposium on International Database Engineering & Applications
Towards scalable ad-hoc climate anomalies search
Proceedings of the 1st ACM SIGSPATIAL International Workshop on Analytics for Big Geospatial Data
Graywulf: a platform for federated scientific databases and services
Proceedings of the 25th International Conference on Scientific and Statistical Database Management
The array database that is not a database: file based array query answering in rasdaman
SSTD'13 Proceedings of the 13th international conference on Advances in Spatial and Temporal Databases
Breaking the big data barrier by enhancing on-board sensor flexibility
Proceedings of the 2nd ACM SIGSPATIAL International Workshop on Analytics for Big Geospatial Data
| Hi-index | 0.00 |
Scientific applications are still poorly served by contemporary relational database systems. At best, the system provides a bridge towards an external library using user-defined functions, explicit import/export facilities or linked-in Java/C# interpreters. Time has come to rectify this with SciQL1, a SQL query language for scientific applications with arrays as first class citizens. It provides a seamless symbiosis of array-, set-, and sequence- interpretation using a clear separation of the mathematical object from its underlying implementation. A key innovation is to extend value-based grouping in SQL:2003 with structural grouping, i.e., fixed-sized and unbounded groups based on explicit relationships between their dimension attributes. It leads to a generalization of window-based query processing with wide applicability in science domains. This paper is focused on the language features, extensively illustrated with examples of its intended use.