Extension of SQL Aggregation Functions
Zeng Fen-shi · Jisuanji gongcheng · 2009
Current SQL aggregate functions have evident limitations for computing percentages.This paper proposes two SQL aggregation functions for computing percentages.The two novel aggregation functions are easy to use,have wide applicability and can be efficiently evaluated.They may be used as a framework to study percentage queries and to generate efficient SQL code.Experiments compare the proposed percentage aggregations against queries using SQL/OLAP aggregations.Experimental results show that both proposed aggregations are significantly faster than existing SQL/OLAP aggregation functions.