2012-01-01
SciQL, Bridging the Gap Between Science and Relational DBMS
Publication
Publication
Presented at the
Extremely Large Databases Conference at Asia, Beijing, China
| Additional Metadata | |
|---|---|
| THEME | Information (theme 2) |
| Conference | Extremely Large Databases Conference at Asia |
| Note | Lightening talk ABSTRACT: Scientific discoveries increasingly rely on the ability to efficiently grind massive amounts of experimental data using database technologies. To bridge the gap between the needs of the Data-Intensive Research fields and the current DBMS technologies, we propose SciQL (pronounced as `cycle'), the first SQL-based query language for scientific applications with both tables and arrays as first class citizens. It provides a seamless symbiosis of array-, set- and sequence- interpretations. A key innovation is the extension of value-based grouping of SQL:2003 with structural grouping, i.e., fixed-sized and unbounded groups based on explicit relationships between elements positions. This leads to a generalisation of window-based query processing with wide applicability in science domains. This talk describes the main language features of SciQL and illustrates it using time-series concepts. |
| Citation |
Zhang, Y. (2012). SciQL, Bridging the Gap Between Science and Relational DBMS.
|