Gradual Data Aggregation in Multi-Granular Fact Tables on Resource-Constrained Systems

Nadeem Iftikhar, Torben Bach Pedersen

Publikation: Bidrag til tidsskriftKonferenceartikel i tidsskriftForskningpeer review

7 Citationer (Scopus)

Resumé

Multi-granular fact tables are used to store and query data at different levels of granularity. In order to collect data in multi-granular fact tables on a resource-constrained system and to keep it for a long time, we gradually aggregate data to save space, however, still allowing analysis queries, for example, for maintenance purposes etc. to work and generate valid results even after aggregation. However, ineffective means of data aggregation is one of the main factors that can not only reduce performance of the queries but also leads to erroneous reporting. This paper presents effective methods for data reduction that are developed to perform gradual data aggregation in multi-granular fact tables on resource-constrained systems. With the gradual data aggregation mechanism, older data can be made coarse-grained while keeping the newest data fine-grained. This paper also evaluates the proposed methods based on a real world farming case study.
OriginalsprogEngelsk
BogserieLecture Notes in Computer Science
Vol/bind6278
Sider (fra-til)349-358
ISSN0302-9743
DOI
StatusUdgivet - 2010
Begivenhed14th International Conference on Knowledge-based Intelligent Information & Engineering Systems (KES), Part III - Cardiff, Storbritannien
Varighed: 8 sep. 201010 sep. 2010

Konference

Konference14th International Conference on Knowledge-based Intelligent Information & Engineering Systems (KES), Part III
LandStorbritannien
ByCardiff
Periode08/09/201010/09/2010

Fingerprint

Data Aggregation
Constrained Systems
Tables
Agglomeration
Resources
Query
Data Reduction
Data reduction
Granularity
Aggregation
Maintenance
Valid
Evaluate

Citer dette

@inproceedings{95ea7fa8653b402e8c32a21462829a83,
title = "Gradual Data Aggregation in Multi-Granular Fact Tables on Resource-Constrained Systems",
abstract = "Multi-granular fact tables are used to store and query data at different levels of granularity. In order to collect data in multi-granular fact tables on a resource-constrained system and to keep it for a long time, we gradually aggregate data to save space, however, still allowing analysis queries, for example, for maintenance purposes etc. to work and generate valid results even after aggregation. However, ineffective means of data aggregation is one of the main factors that can not only reduce performance of the queries but also leads to erroneous reporting. This paper presents effective methods for data reduction that are developed to perform gradual data aggregation in multi-granular fact tables on resource-constrained systems. With the gradual data aggregation mechanism, older data can be made coarse-grained while keeping the newest data fine-grained. This paper also evaluates the proposed methods based on a real world farming case study.",
author = "Nadeem Iftikhar and Pedersen, {Torben Bach}",
year = "2010",
doi = "10.1007/978-3-642-15393-8_40",
language = "English",
volume = "6278",
pages = "349--358",
journal = "Lecture Notes in Computer Science",
issn = "0302-9743",
publisher = "Physica-Verlag",

}

Gradual Data Aggregation in Multi-Granular Fact Tables on Resource-Constrained Systems. / Iftikhar, Nadeem; Pedersen, Torben Bach.

I: Lecture Notes in Computer Science, Bind 6278, 2010, s. 349-358.

Publikation: Bidrag til tidsskriftKonferenceartikel i tidsskriftForskningpeer review

TY - GEN

T1 - Gradual Data Aggregation in Multi-Granular Fact Tables on Resource-Constrained Systems

AU - Iftikhar, Nadeem

AU - Pedersen, Torben Bach

PY - 2010

Y1 - 2010

N2 - Multi-granular fact tables are used to store and query data at different levels of granularity. In order to collect data in multi-granular fact tables on a resource-constrained system and to keep it for a long time, we gradually aggregate data to save space, however, still allowing analysis queries, for example, for maintenance purposes etc. to work and generate valid results even after aggregation. However, ineffective means of data aggregation is one of the main factors that can not only reduce performance of the queries but also leads to erroneous reporting. This paper presents effective methods for data reduction that are developed to perform gradual data aggregation in multi-granular fact tables on resource-constrained systems. With the gradual data aggregation mechanism, older data can be made coarse-grained while keeping the newest data fine-grained. This paper also evaluates the proposed methods based on a real world farming case study.

AB - Multi-granular fact tables are used to store and query data at different levels of granularity. In order to collect data in multi-granular fact tables on a resource-constrained system and to keep it for a long time, we gradually aggregate data to save space, however, still allowing analysis queries, for example, for maintenance purposes etc. to work and generate valid results even after aggregation. However, ineffective means of data aggregation is one of the main factors that can not only reduce performance of the queries but also leads to erroneous reporting. This paper presents effective methods for data reduction that are developed to perform gradual data aggregation in multi-granular fact tables on resource-constrained systems. With the gradual data aggregation mechanism, older data can be made coarse-grained while keeping the newest data fine-grained. This paper also evaluates the proposed methods based on a real world farming case study.

U2 - 10.1007/978-3-642-15393-8_40

DO - 10.1007/978-3-642-15393-8_40

M3 - Conference article in Journal

VL - 6278

SP - 349

EP - 358

JO - Lecture Notes in Computer Science

JF - Lecture Notes in Computer Science

SN - 0302-9743

ER -