Evaluating Horizontal Aggregation with Partial Aggregation

Rexie J A M

ISBN 10: 6204205773 / ISBN 13: 9786204205779

Verlag: LAP LAMBERT Academic Publishing, 2021

Beschreibung

nach der Bestellung gedruckt Neuware - Printed after ordering - Preparing a data set for analysis is generally the most time-consuming task in a data mining project, requiring many complex SQL queries, joining tables, and aggregating columns. In general, a significant manual effort is required to build data sets, where a horizontal layout is required. Here introduces 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. An aggregation function with a grouping technique gives query optimizers an opportunity of providing different query evaluation plans. For queries with a non-distributive aggregation function, evaluation cannot be performed until the entire input is constructed. This delays the entire computation. Aggregation functions of this type are called holistic aggregation functions. To improve the evaluation performance of holistic aggregation function, an approach called partial aggregation can be used. Partial aggregation performs computations in an incremental way and increases the speed of computation.

Bestandsnummer des Verkäufers 9786204205779

Bibliografische Details

• Titel: Evaluating Horizontal Aggregation with Partial Aggregation
• Verlag: LAP LAMBERT Academic Publishing
• Erscheinungsjahr: 2021
• Sprache: Englisch
• ISBN-10: 6204205773
• ISBN-13: 9786204205779
• Einband: Taschenbuch
• Zustand: Neu
• Abmessungen: 220B x 150 H x 5 T Millimeter Breite: 220 mm, Höhe: 150 mm, Tiefe: 5 mm
• Gewicht: 131 Gramm

Über diesen Titel

Inhaltsangabe

Preparing a data set for analysis is generally the most time-consuming task in a data mining project, requiring many complex SQL queries, joining tables, and aggregating columns. In general, a significant manual effort is required to build data sets, where a horizontal layout is required. Here introduces 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. An aggregation function with a grouping technique gives query optimizers an opportunity of providing different query evaluation plans. For queries with a non-distributive aggregation function, evaluation cannot be performed until the entire input is constructed. This delays the entire computation. Aggregation functions of this type are called holistic aggregation functions. To improve the evaluation performance of holistic aggregation function, an approach called partial aggregation can be used. Partial aggregation performs computations in an incremental way and increases the speed of computation.