Business modeling using SQL spreadsheets

摘要: One of the critical deficiencies SQL is lack support for array and spreadsheet like calculations which are frequent in OLAP Business Modeling applications. Applications relying on have to emulate these using joins, UNION operations, Window Functions complex CASE expressions. The designated place algebraic SELECT clause, extremely limiting forces applications generate queries with nested views, subqueries joins. This distributes computations across many query blocks, making coded hard develop. limitations RDBMS been filled by spreadsheets specialized MOLAP engines good at formulas mathematical modeling but formalism relational model, difficult manage, exhibit scalability problems. demo presents a scalable, mathematically rigorous, performant extensions Relational Modeling, called Spreadsheet. We present examples typical compare them ones standard showing performance advantages ease programming former. will show example where data processed parallel new class optimizations applicable spreadsheet.