We propose simple, yet powerful, methods to generate SQL code to return aggregated columns in a horizontal tabular layout, returning a set of numbers instead of one number per row. This new class of functions is called horizontal aggregations. Horizontal aggregations build data sets with a ...
Shatdal, Order Based Analysis Functions in NCR Teradata Parallel RDBMS, Abstract Proceeding of EDBT 2000 pp. 219-223. Albrecht et al., An Architecture for Distributed OLAP, Abstract Proceedings of PDPTA '98 Jul. 13-16 pp. 1482-1488. Charczuk, Physical Structure Design for Relational Databa...
Query Level: Make use of Database aggregate functions like SUM, COUNT, MAX, MIN to reduce number of dimensions and thus reducing number of rows returned by the query. Projection Level: Once BO has data in the micro cube we can assign projection level aggregation. This is useful in D...
SQL did give you some aggregate functions that apply to discrete variables. The extrema functions (MIN () and MAX ()) extract a single value from the class. These values have be attributes of at least one element in that set. The obvious discrete statistical function that is missing is the...
We propose simple,yet powerful, methods to generate SQL code to returnaggregated columns in a horizontal tabular layout, returning aset of numbers instead of one number per row. This new class offunctions is called horizontal aggregations. Horizontalaggregations build data sets with a horizontal ...
By using the AVG() and SUM() math functions with GROUP BY, you reduce a group attribute to a value. These are the ones we picked in the early days of SQL, because they were very easy and very well understood. The problem is that they depend on the numeric values that we can comput...
butinitscommonformofequalitybasedgroupsandrestrictedaggregatefunctionsanumberofproblemsremainunsolved.Variousextensionstothisconcepthavebeenintroducedoverthelastyearsregardinguser-definedfunctionsforaggregationandgrouping.Especially,existingextensionstothegroupingoperationlikesimplederivationsofgroup-byvaluesdonotmeetthe...
Functions Group by Hash-based structure Incomplete join Independent class Insertion Anomaly Instance Invocation Is Left [Outer] Join Legal Extension Merge-scan Member Minimal Cover Minute Nested Loop Nested Query Normal Form Normalization ODBC Of Ordered Ordered Association Pointer-based model Polymorphic ...
, extension to SQL standard aggregate functions to compute horizontal aggregations We propose two fundamental methods to evaluate horizontal aggregations: CASE: Exploiting the programming CASE construct; SPJ: Based on standard relational algebra operators (SPJ queries); which is offered by some DBMSs....
In addition the Ordered Weighted Aggregation (OWA) operators are adapted for aggregating the distance functions of these features. The system supports nearest neighbor queries and various types of fuzzy queries; feature-based, image-based and color-based queries. The experimental results show that our...