2003 Digital Symposium Collection

Spreadsheets in RDBMS for OLAP

Andrew Witkowski, Srikanth Bellamkonda, Tolga Bozkaya, Gregory Dorman, Nathan Folkert, Abhinav Gupta, Lei Sheng, and Sankar Subramanian
View Paper (PDF)

Return to OLAP

Abstract

rather than on random access structures for inter-row calculations. This has created a gap that has been filled by spreadsheets and specialized MOLAP engines, which are good at formulas for mathematical modeling but lack the formalism of the relational model, are difficult to manage, and exhibit scalability problems. This paper presents SQL extensions involving array based calculations for complex modeling. In addition, we present optimizations, access structures and execution models for processing them efficiently.

BIBTEX

@inproceedings       {DBLP:conf/sigmod/WitkowskiBBDFGSS03,
  author    = {Andrew Witkowski and
                Srikanth Bellamkonda and
                Tolga Bozkaya and
                Gregory Dorman and
                Nathan Folkert and
                Abhinav Gupta and
                Lei Sheng and
                Sankar Subramanian},
   booktitle = {SIGMOD Conference},
   title     = {Spreadsheets in RDBMS for OLAP.},
   pages     = {52-63},
   year      = {2003},
   url       = {db/conf/sigmod/sigmod2003.html#WitkowskiBBDFGSS03},
   ee        = {http://www.acm.org/sigmod/sigmod03/eproceedings/papers/r03p01.pdf},
   crossref  = {conf/sigmod/2003},
   bibsource = {DBLP, http://dblp.uni-trier.de}
}