Loading...
Please wait, while we are loading the content...
Similar Documents
ABSTRACT Vertical and Horizontal Percentage Aggregations
| Content Provider | CiteSeerX |
|---|---|
| Abstract | Existing SQL aggregate functions present important limitations to compute percentages. This article proposes two SQL aggregate functions to compute percentages addressing such limitations. The first function returns one row for each percentage in vertical form like standard SQL aggregations. The second function returns each set of percentages adding 100 % on the same row in horizontal form. These novel aggregate functions are used as a framework to introduce the concept of percentage queries and to generate efficient SQL code. Experiments study different percentage query optimization strategies and compare evaluation time of percentage queries taking advantage of our proposed aggregations against queries using available OLAP extensions. The proposed percentage aggregations are easy to use, have wide applicability and can be efficiently evaluated. 1. |
| File Format | |
| Access Restriction | Open |
| Subject Keyword | Horizontal Percentage Aggregation Abstract Vertical Percentage Query Percentage Aggregation Wide Applicability Efficient Sql Code Second Function Return Sql Aggregate Function Available Olap Extension First Function Vertical Form Novel Aggregate Function Evaluation Time Different Percentage Query Optimization Strategy Horizontal Form Standard Sql Aggregation |
| Content Type | Text |
| Resource Type | Article |
