A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2015; you can also visit the original URL.
The file type is
Spreadsheets in RDBMS for OLAP
Proceedings of the 2003 ACM SIGMOD international conference on on Management of data - SIGMOD '03
One of the critical deficiencies of SQL is lack of support for ndimensional array-based computations which are frequent in OLAP environments. Relational OLAP (ROLAP) applications have to emulate them using joins, recently introduced SQL Window Functions  and complex and inefficient CASE expressions. The designated place in SQL for specifying calculations is the SELECT clause, which is extremely limiting and forces the user to generate queries using nested views, subqueries and complexdoi:10.1145/872757.872767 dblp:conf/sigmod/WitkowskiBBDFGSS03 fatcat:g6f52zdz6jfnja3cneqzhqd2mu