$ CubiST^{++} $: Evaluating Ad-Hoc CUBE Queries Using Statistics Trees
Abstract We report on a new, efficient encoding for the data cube, which results in a drastic speed-up of OLAP queries that aggregate along any combination of dimensions over numerical and categorical attributes. We are focusing on a class of queries called cube queries, which return aggregated valu...
Ausführliche Beschreibung
Autor*in: |
Hammer, Joachim [verfasserIn] |
---|
Format: |
Artikel |
---|---|
Sprache: |
Englisch |
Erschienen: |
2003 |
---|
Anmerkung: |
© Kluwer Academic Publishers 2003 |
---|
Übergeordnetes Werk: |
Enthalten in: Distributed and parallel databases - Kluwer Academic Publishers, 1993, 14(2003), 3 vom: Nov., Seite 221-254 |
---|---|
Übergeordnetes Werk: |
volume:14 ; year:2003 ; number:3 ; month:11 ; pages:221-254 |
Links: |
---|
DOI / URN: |
10.1023/A:1025537315785 |
---|
Katalog-ID: |
OLC2027065652 |
---|
LEADER | 01000caa a22002652 4500 | ||
---|---|---|---|
001 | OLC2027065652 | ||
003 | DE-627 | ||
005 | 20230503034738.0 | ||
007 | tu | ||
008 | 200819s2003 xx ||||| 00| ||eng c | ||
024 | 7 | |a 10.1023/A:1025537315785 |2 doi | |
035 | |a (DE-627)OLC2027065652 | ||
035 | |a (DE-He213)A:1025537315785-p | ||
040 | |a DE-627 |b ger |c DE-627 |e rakwb | ||
041 | |a eng | ||
082 | 0 | 4 | |a 070 |a 020 |a 004 |q VZ |
084 | |a 24,1 |2 ssgn | ||
100 | 1 | |a Hammer, Joachim |e verfasserin |4 aut | |
245 | 1 | 0 | |a $ CubiST^{++} $: Evaluating Ad-Hoc CUBE Queries Using Statistics Trees |
264 | 1 | |c 2003 | |
336 | |a Text |b txt |2 rdacontent | ||
337 | |a ohne Hilfsmittel zu benutzen |b n |2 rdamedia | ||
338 | |a Band |b nc |2 rdacarrier | ||
500 | |a © Kluwer Academic Publishers 2003 | ||
520 | |a Abstract We report on a new, efficient encoding for the data cube, which results in a drastic speed-up of OLAP queries that aggregate along any combination of dimensions over numerical and categorical attributes. We are focusing on a class of queries called cube queries, which return aggregated values rather than sets of tuples. Our approach, termed $ CubiST^{++} $ (Cubing with Statistics Trees Plus Families), represents a drastic departure from existing relational (ROLAP) and multi-dimensional (MOLAP) approaches in that it does not use the view lattice to compute and materialize new views from existing views in some heuristic fashion. Instead, $ CubiST^{++} $ encodes all possible aggregate views in the leaves of a new data structure called statistics tree (ST) during a one-time scan of the detailed data. In order to optimize the queries involving constraints on hierarchy levels of the underlying dimensions, we select andmaterialize a family of candidate trees, which represent superviews over the different hierarchical levels of the dimensions. Given a query, our query evaluation algorithm selects the smallest tree in the family, which can provide the answer. Extensive evaluations of our prototype implementation have demonstrated its superior run-time performance and scalability when compared with existing MOLAP and ROLAP systems. | ||
700 | 1 | |a Fu, Lixin |4 aut | |
773 | 0 | 8 | |i Enthalten in |t Distributed and parallel databases |d Kluwer Academic Publishers, 1993 |g 14(2003), 3 vom: Nov., Seite 221-254 |w (DE-627)165664401 |w (DE-600)913166-8 |w (DE-576)038480352 |x 0926-8782 |7 nnns |
773 | 1 | 8 | |g volume:14 |g year:2003 |g number:3 |g month:11 |g pages:221-254 |
856 | 4 | 1 | |u https://doi.org/10.1023/A:1025537315785 |z lizenzpflichtig |3 Volltext |
912 | |a GBV_USEFLAG_A | ||
912 | |a SYSFLAG_A | ||
912 | |a GBV_OLC | ||
912 | |a SSG-OLC-MAT | ||
912 | |a SSG-OPC-BBI | ||
912 | |a GBV_ILN_31 | ||
912 | |a GBV_ILN_40 | ||
912 | |a GBV_ILN_62 | ||
912 | |a GBV_ILN_65 | ||
912 | |a GBV_ILN_70 | ||
912 | |a GBV_ILN_100 | ||
912 | |a GBV_ILN_2005 | ||
912 | |a GBV_ILN_2006 | ||
912 | |a GBV_ILN_2010 | ||
912 | |a GBV_ILN_2021 | ||
912 | |a GBV_ILN_2244 | ||
912 | |a GBV_ILN_4036 | ||
912 | |a GBV_ILN_4126 | ||
912 | |a GBV_ILN_4266 | ||
912 | |a GBV_ILN_4305 | ||
912 | |a GBV_ILN_4307 | ||
912 | |a GBV_ILN_4318 | ||
912 | |a GBV_ILN_4326 | ||
951 | |a AR | ||
952 | |d 14 |j 2003 |e 3 |c 11 |h 221-254 |
author_variant |
j h jh l f lf |
---|---|
matchkey_str |
article:09268782:2003----::uitvlaigdocbqeissns |
hierarchy_sort_str |
2003 |
publishDate |
2003 |
allfields |
10.1023/A:1025537315785 doi (DE-627)OLC2027065652 (DE-He213)A:1025537315785-p DE-627 ger DE-627 rakwb eng 070 020 004 VZ 24,1 ssgn Hammer, Joachim verfasserin aut $ CubiST^{++} $: Evaluating Ad-Hoc CUBE Queries Using Statistics Trees 2003 Text txt rdacontent ohne Hilfsmittel zu benutzen n rdamedia Band nc rdacarrier © Kluwer Academic Publishers 2003 Abstract We report on a new, efficient encoding for the data cube, which results in a drastic speed-up of OLAP queries that aggregate along any combination of dimensions over numerical and categorical attributes. We are focusing on a class of queries called cube queries, which return aggregated values rather than sets of tuples. Our approach, termed $ CubiST^{++} $ (Cubing with Statistics Trees Plus Families), represents a drastic departure from existing relational (ROLAP) and multi-dimensional (MOLAP) approaches in that it does not use the view lattice to compute and materialize new views from existing views in some heuristic fashion. Instead, $ CubiST^{++} $ encodes all possible aggregate views in the leaves of a new data structure called statistics tree (ST) during a one-time scan of the detailed data. In order to optimize the queries involving constraints on hierarchy levels of the underlying dimensions, we select andmaterialize a family of candidate trees, which represent superviews over the different hierarchical levels of the dimensions. Given a query, our query evaluation algorithm selects the smallest tree in the family, which can provide the answer. Extensive evaluations of our prototype implementation have demonstrated its superior run-time performance and scalability when compared with existing MOLAP and ROLAP systems. Fu, Lixin aut Enthalten in Distributed and parallel databases Kluwer Academic Publishers, 1993 14(2003), 3 vom: Nov., Seite 221-254 (DE-627)165664401 (DE-600)913166-8 (DE-576)038480352 0926-8782 nnns volume:14 year:2003 number:3 month:11 pages:221-254 https://doi.org/10.1023/A:1025537315785 lizenzpflichtig Volltext GBV_USEFLAG_A SYSFLAG_A GBV_OLC SSG-OLC-MAT SSG-OPC-BBI GBV_ILN_31 GBV_ILN_40 GBV_ILN_62 GBV_ILN_65 GBV_ILN_70 GBV_ILN_100 GBV_ILN_2005 GBV_ILN_2006 GBV_ILN_2010 GBV_ILN_2021 GBV_ILN_2244 GBV_ILN_4036 GBV_ILN_4126 GBV_ILN_4266 GBV_ILN_4305 GBV_ILN_4307 GBV_ILN_4318 GBV_ILN_4326 AR 14 2003 3 11 221-254 |
spelling |
10.1023/A:1025537315785 doi (DE-627)OLC2027065652 (DE-He213)A:1025537315785-p DE-627 ger DE-627 rakwb eng 070 020 004 VZ 24,1 ssgn Hammer, Joachim verfasserin aut $ CubiST^{++} $: Evaluating Ad-Hoc CUBE Queries Using Statistics Trees 2003 Text txt rdacontent ohne Hilfsmittel zu benutzen n rdamedia Band nc rdacarrier © Kluwer Academic Publishers 2003 Abstract We report on a new, efficient encoding for the data cube, which results in a drastic speed-up of OLAP queries that aggregate along any combination of dimensions over numerical and categorical attributes. We are focusing on a class of queries called cube queries, which return aggregated values rather than sets of tuples. Our approach, termed $ CubiST^{++} $ (Cubing with Statistics Trees Plus Families), represents a drastic departure from existing relational (ROLAP) and multi-dimensional (MOLAP) approaches in that it does not use the view lattice to compute and materialize new views from existing views in some heuristic fashion. Instead, $ CubiST^{++} $ encodes all possible aggregate views in the leaves of a new data structure called statistics tree (ST) during a one-time scan of the detailed data. In order to optimize the queries involving constraints on hierarchy levels of the underlying dimensions, we select andmaterialize a family of candidate trees, which represent superviews over the different hierarchical levels of the dimensions. Given a query, our query evaluation algorithm selects the smallest tree in the family, which can provide the answer. Extensive evaluations of our prototype implementation have demonstrated its superior run-time performance and scalability when compared with existing MOLAP and ROLAP systems. Fu, Lixin aut Enthalten in Distributed and parallel databases Kluwer Academic Publishers, 1993 14(2003), 3 vom: Nov., Seite 221-254 (DE-627)165664401 (DE-600)913166-8 (DE-576)038480352 0926-8782 nnns volume:14 year:2003 number:3 month:11 pages:221-254 https://doi.org/10.1023/A:1025537315785 lizenzpflichtig Volltext GBV_USEFLAG_A SYSFLAG_A GBV_OLC SSG-OLC-MAT SSG-OPC-BBI GBV_ILN_31 GBV_ILN_40 GBV_ILN_62 GBV_ILN_65 GBV_ILN_70 GBV_ILN_100 GBV_ILN_2005 GBV_ILN_2006 GBV_ILN_2010 GBV_ILN_2021 GBV_ILN_2244 GBV_ILN_4036 GBV_ILN_4126 GBV_ILN_4266 GBV_ILN_4305 GBV_ILN_4307 GBV_ILN_4318 GBV_ILN_4326 AR 14 2003 3 11 221-254 |
allfields_unstemmed |
10.1023/A:1025537315785 doi (DE-627)OLC2027065652 (DE-He213)A:1025537315785-p DE-627 ger DE-627 rakwb eng 070 020 004 VZ 24,1 ssgn Hammer, Joachim verfasserin aut $ CubiST^{++} $: Evaluating Ad-Hoc CUBE Queries Using Statistics Trees 2003 Text txt rdacontent ohne Hilfsmittel zu benutzen n rdamedia Band nc rdacarrier © Kluwer Academic Publishers 2003 Abstract We report on a new, efficient encoding for the data cube, which results in a drastic speed-up of OLAP queries that aggregate along any combination of dimensions over numerical and categorical attributes. We are focusing on a class of queries called cube queries, which return aggregated values rather than sets of tuples. Our approach, termed $ CubiST^{++} $ (Cubing with Statistics Trees Plus Families), represents a drastic departure from existing relational (ROLAP) and multi-dimensional (MOLAP) approaches in that it does not use the view lattice to compute and materialize new views from existing views in some heuristic fashion. Instead, $ CubiST^{++} $ encodes all possible aggregate views in the leaves of a new data structure called statistics tree (ST) during a one-time scan of the detailed data. In order to optimize the queries involving constraints on hierarchy levels of the underlying dimensions, we select andmaterialize a family of candidate trees, which represent superviews over the different hierarchical levels of the dimensions. Given a query, our query evaluation algorithm selects the smallest tree in the family, which can provide the answer. Extensive evaluations of our prototype implementation have demonstrated its superior run-time performance and scalability when compared with existing MOLAP and ROLAP systems. Fu, Lixin aut Enthalten in Distributed and parallel databases Kluwer Academic Publishers, 1993 14(2003), 3 vom: Nov., Seite 221-254 (DE-627)165664401 (DE-600)913166-8 (DE-576)038480352 0926-8782 nnns volume:14 year:2003 number:3 month:11 pages:221-254 https://doi.org/10.1023/A:1025537315785 lizenzpflichtig Volltext GBV_USEFLAG_A SYSFLAG_A GBV_OLC SSG-OLC-MAT SSG-OPC-BBI GBV_ILN_31 GBV_ILN_40 GBV_ILN_62 GBV_ILN_65 GBV_ILN_70 GBV_ILN_100 GBV_ILN_2005 GBV_ILN_2006 GBV_ILN_2010 GBV_ILN_2021 GBV_ILN_2244 GBV_ILN_4036 GBV_ILN_4126 GBV_ILN_4266 GBV_ILN_4305 GBV_ILN_4307 GBV_ILN_4318 GBV_ILN_4326 AR 14 2003 3 11 221-254 |
allfieldsGer |
10.1023/A:1025537315785 doi (DE-627)OLC2027065652 (DE-He213)A:1025537315785-p DE-627 ger DE-627 rakwb eng 070 020 004 VZ 24,1 ssgn Hammer, Joachim verfasserin aut $ CubiST^{++} $: Evaluating Ad-Hoc CUBE Queries Using Statistics Trees 2003 Text txt rdacontent ohne Hilfsmittel zu benutzen n rdamedia Band nc rdacarrier © Kluwer Academic Publishers 2003 Abstract We report on a new, efficient encoding for the data cube, which results in a drastic speed-up of OLAP queries that aggregate along any combination of dimensions over numerical and categorical attributes. We are focusing on a class of queries called cube queries, which return aggregated values rather than sets of tuples. Our approach, termed $ CubiST^{++} $ (Cubing with Statistics Trees Plus Families), represents a drastic departure from existing relational (ROLAP) and multi-dimensional (MOLAP) approaches in that it does not use the view lattice to compute and materialize new views from existing views in some heuristic fashion. Instead, $ CubiST^{++} $ encodes all possible aggregate views in the leaves of a new data structure called statistics tree (ST) during a one-time scan of the detailed data. In order to optimize the queries involving constraints on hierarchy levels of the underlying dimensions, we select andmaterialize a family of candidate trees, which represent superviews over the different hierarchical levels of the dimensions. Given a query, our query evaluation algorithm selects the smallest tree in the family, which can provide the answer. Extensive evaluations of our prototype implementation have demonstrated its superior run-time performance and scalability when compared with existing MOLAP and ROLAP systems. Fu, Lixin aut Enthalten in Distributed and parallel databases Kluwer Academic Publishers, 1993 14(2003), 3 vom: Nov., Seite 221-254 (DE-627)165664401 (DE-600)913166-8 (DE-576)038480352 0926-8782 nnns volume:14 year:2003 number:3 month:11 pages:221-254 https://doi.org/10.1023/A:1025537315785 lizenzpflichtig Volltext GBV_USEFLAG_A SYSFLAG_A GBV_OLC SSG-OLC-MAT SSG-OPC-BBI GBV_ILN_31 GBV_ILN_40 GBV_ILN_62 GBV_ILN_65 GBV_ILN_70 GBV_ILN_100 GBV_ILN_2005 GBV_ILN_2006 GBV_ILN_2010 GBV_ILN_2021 GBV_ILN_2244 GBV_ILN_4036 GBV_ILN_4126 GBV_ILN_4266 GBV_ILN_4305 GBV_ILN_4307 GBV_ILN_4318 GBV_ILN_4326 AR 14 2003 3 11 221-254 |
allfieldsSound |
10.1023/A:1025537315785 doi (DE-627)OLC2027065652 (DE-He213)A:1025537315785-p DE-627 ger DE-627 rakwb eng 070 020 004 VZ 24,1 ssgn Hammer, Joachim verfasserin aut $ CubiST^{++} $: Evaluating Ad-Hoc CUBE Queries Using Statistics Trees 2003 Text txt rdacontent ohne Hilfsmittel zu benutzen n rdamedia Band nc rdacarrier © Kluwer Academic Publishers 2003 Abstract We report on a new, efficient encoding for the data cube, which results in a drastic speed-up of OLAP queries that aggregate along any combination of dimensions over numerical and categorical attributes. We are focusing on a class of queries called cube queries, which return aggregated values rather than sets of tuples. Our approach, termed $ CubiST^{++} $ (Cubing with Statistics Trees Plus Families), represents a drastic departure from existing relational (ROLAP) and multi-dimensional (MOLAP) approaches in that it does not use the view lattice to compute and materialize new views from existing views in some heuristic fashion. Instead, $ CubiST^{++} $ encodes all possible aggregate views in the leaves of a new data structure called statistics tree (ST) during a one-time scan of the detailed data. In order to optimize the queries involving constraints on hierarchy levels of the underlying dimensions, we select andmaterialize a family of candidate trees, which represent superviews over the different hierarchical levels of the dimensions. Given a query, our query evaluation algorithm selects the smallest tree in the family, which can provide the answer. Extensive evaluations of our prototype implementation have demonstrated its superior run-time performance and scalability when compared with existing MOLAP and ROLAP systems. Fu, Lixin aut Enthalten in Distributed and parallel databases Kluwer Academic Publishers, 1993 14(2003), 3 vom: Nov., Seite 221-254 (DE-627)165664401 (DE-600)913166-8 (DE-576)038480352 0926-8782 nnns volume:14 year:2003 number:3 month:11 pages:221-254 https://doi.org/10.1023/A:1025537315785 lizenzpflichtig Volltext GBV_USEFLAG_A SYSFLAG_A GBV_OLC SSG-OLC-MAT SSG-OPC-BBI GBV_ILN_31 GBV_ILN_40 GBV_ILN_62 GBV_ILN_65 GBV_ILN_70 GBV_ILN_100 GBV_ILN_2005 GBV_ILN_2006 GBV_ILN_2010 GBV_ILN_2021 GBV_ILN_2244 GBV_ILN_4036 GBV_ILN_4126 GBV_ILN_4266 GBV_ILN_4305 GBV_ILN_4307 GBV_ILN_4318 GBV_ILN_4326 AR 14 2003 3 11 221-254 |
language |
English |
source |
Enthalten in Distributed and parallel databases 14(2003), 3 vom: Nov., Seite 221-254 volume:14 year:2003 number:3 month:11 pages:221-254 |
sourceStr |
Enthalten in Distributed and parallel databases 14(2003), 3 vom: Nov., Seite 221-254 volume:14 year:2003 number:3 month:11 pages:221-254 |
format_phy_str_mv |
Article |
institution |
findex.gbv.de |
dewey-raw |
070 |
isfreeaccess_bool |
false |
container_title |
Distributed and parallel databases |
authorswithroles_txt_mv |
Hammer, Joachim @@aut@@ Fu, Lixin @@aut@@ |
publishDateDaySort_date |
2003-11-01T00:00:00Z |
hierarchy_top_id |
165664401 |
dewey-sort |
270 |
id |
OLC2027065652 |
language_de |
englisch |
fullrecord |
<?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01000caa a22002652 4500</leader><controlfield tag="001">OLC2027065652</controlfield><controlfield tag="003">DE-627</controlfield><controlfield tag="005">20230503034738.0</controlfield><controlfield tag="007">tu</controlfield><controlfield tag="008">200819s2003 xx ||||| 00| ||eng c</controlfield><datafield tag="024" ind1="7" ind2=" "><subfield code="a">10.1023/A:1025537315785</subfield><subfield code="2">doi</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627)OLC2027065652</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-He213)A:1025537315785-p</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-627</subfield><subfield code="b">ger</subfield><subfield code="c">DE-627</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="082" ind1="0" ind2="4"><subfield code="a">070</subfield><subfield code="a">020</subfield><subfield code="a">004</subfield><subfield code="q">VZ</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">24,1</subfield><subfield code="2">ssgn</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Hammer, Joachim</subfield><subfield code="e">verfasserin</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">$ CubiST^{++} $: Evaluating Ad-Hoc CUBE Queries Using Statistics Trees</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="c">2003</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">Text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">ohne Hilfsmittel zu benutzen</subfield><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">Band</subfield><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">© Kluwer Academic Publishers 2003</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Abstract We report on a new, efficient encoding for the data cube, which results in a drastic speed-up of OLAP queries that aggregate along any combination of dimensions over numerical and categorical attributes. We are focusing on a class of queries called cube queries, which return aggregated values rather than sets of tuples. Our approach, termed $ CubiST^{++} $ (Cubing with Statistics Trees Plus Families), represents a drastic departure from existing relational (ROLAP) and multi-dimensional (MOLAP) approaches in that it does not use the view lattice to compute and materialize new views from existing views in some heuristic fashion. Instead, $ CubiST^{++} $ encodes all possible aggregate views in the leaves of a new data structure called statistics tree (ST) during a one-time scan of the detailed data. In order to optimize the queries involving constraints on hierarchy levels of the underlying dimensions, we select andmaterialize a family of candidate trees, which represent superviews over the different hierarchical levels of the dimensions. Given a query, our query evaluation algorithm selects the smallest tree in the family, which can provide the answer. Extensive evaluations of our prototype implementation have demonstrated its superior run-time performance and scalability when compared with existing MOLAP and ROLAP systems.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Fu, Lixin</subfield><subfield code="4">aut</subfield></datafield><datafield tag="773" ind1="0" ind2="8"><subfield code="i">Enthalten in</subfield><subfield code="t">Distributed and parallel databases</subfield><subfield code="d">Kluwer Academic Publishers, 1993</subfield><subfield code="g">14(2003), 3 vom: Nov., Seite 221-254</subfield><subfield code="w">(DE-627)165664401</subfield><subfield code="w">(DE-600)913166-8</subfield><subfield code="w">(DE-576)038480352</subfield><subfield code="x">0926-8782</subfield><subfield code="7">nnns</subfield></datafield><datafield tag="773" ind1="1" ind2="8"><subfield code="g">volume:14</subfield><subfield code="g">year:2003</subfield><subfield code="g">number:3</subfield><subfield code="g">month:11</subfield><subfield code="g">pages:221-254</subfield></datafield><datafield tag="856" ind1="4" ind2="1"><subfield code="u">https://doi.org/10.1023/A:1025537315785</subfield><subfield code="z">lizenzpflichtig</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_USEFLAG_A</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">SYSFLAG_A</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_OLC</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">SSG-OLC-MAT</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">SSG-OPC-BBI</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_31</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_40</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_62</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_65</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_70</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_100</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_2005</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_2006</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_2010</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_2021</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_2244</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_4036</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_4126</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_4266</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_4305</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_4307</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_4318</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_4326</subfield></datafield><datafield tag="951" ind1=" " ind2=" "><subfield code="a">AR</subfield></datafield><datafield tag="952" ind1=" " ind2=" "><subfield code="d">14</subfield><subfield code="j">2003</subfield><subfield code="e">3</subfield><subfield code="c">11</subfield><subfield code="h">221-254</subfield></datafield></record></collection>
|
author |
Hammer, Joachim |
spellingShingle |
Hammer, Joachim ddc 070 ssgn 24,1 $ CubiST^{++} $: Evaluating Ad-Hoc CUBE Queries Using Statistics Trees |
authorStr |
Hammer, Joachim |
ppnlink_with_tag_str_mv |
@@773@@(DE-627)165664401 |
format |
Article |
dewey-ones |
070 - News media, journalism & publishing 020 - Library & information sciences 004 - Data processing & computer science |
delete_txt_mv |
keep |
author_role |
aut aut |
collection |
OLC |
remote_str |
false |
illustrated |
Not Illustrated |
issn |
0926-8782 |
topic_title |
070 020 004 VZ 24,1 ssgn $ CubiST^{++} $: Evaluating Ad-Hoc CUBE Queries Using Statistics Trees |
topic |
ddc 070 ssgn 24,1 |
topic_unstemmed |
ddc 070 ssgn 24,1 |
topic_browse |
ddc 070 ssgn 24,1 |
format_facet |
Aufsätze Gedruckte Aufsätze |
format_main_str_mv |
Text Zeitschrift/Artikel |
carriertype_str_mv |
nc |
hierarchy_parent_title |
Distributed and parallel databases |
hierarchy_parent_id |
165664401 |
dewey-tens |
070 - News media, journalism & publishing 020 - Library & information sciences 000 - Computer science, knowledge & systems |
hierarchy_top_title |
Distributed and parallel databases |
isfreeaccess_txt |
false |
familylinks_str_mv |
(DE-627)165664401 (DE-600)913166-8 (DE-576)038480352 |
title |
$ CubiST^{++} $: Evaluating Ad-Hoc CUBE Queries Using Statistics Trees |
ctrlnum |
(DE-627)OLC2027065652 (DE-He213)A:1025537315785-p |
title_full |
$ CubiST^{++} $: Evaluating Ad-Hoc CUBE Queries Using Statistics Trees |
author_sort |
Hammer, Joachim |
journal |
Distributed and parallel databases |
journalStr |
Distributed and parallel databases |
lang_code |
eng |
isOA_bool |
false |
dewey-hundreds |
000 - Computer science, information & general works |
recordtype |
marc |
publishDateSort |
2003 |
contenttype_str_mv |
txt |
container_start_page |
221 |
author_browse |
Hammer, Joachim Fu, Lixin |
container_volume |
14 |
class |
070 020 004 VZ 24,1 ssgn |
format_se |
Aufsätze |
author-letter |
Hammer, Joachim |
doi_str_mv |
10.1023/A:1025537315785 |
dewey-full |
070 020 004 |
title_sort |
$ cubist^{++} $: evaluating ad-hoc cube queries using statistics trees |
title_auth |
$ CubiST^{++} $: Evaluating Ad-Hoc CUBE Queries Using Statistics Trees |
abstract |
Abstract We report on a new, efficient encoding for the data cube, which results in a drastic speed-up of OLAP queries that aggregate along any combination of dimensions over numerical and categorical attributes. We are focusing on a class of queries called cube queries, which return aggregated values rather than sets of tuples. Our approach, termed $ CubiST^{++} $ (Cubing with Statistics Trees Plus Families), represents a drastic departure from existing relational (ROLAP) and multi-dimensional (MOLAP) approaches in that it does not use the view lattice to compute and materialize new views from existing views in some heuristic fashion. Instead, $ CubiST^{++} $ encodes all possible aggregate views in the leaves of a new data structure called statistics tree (ST) during a one-time scan of the detailed data. In order to optimize the queries involving constraints on hierarchy levels of the underlying dimensions, we select andmaterialize a family of candidate trees, which represent superviews over the different hierarchical levels of the dimensions. Given a query, our query evaluation algorithm selects the smallest tree in the family, which can provide the answer. Extensive evaluations of our prototype implementation have demonstrated its superior run-time performance and scalability when compared with existing MOLAP and ROLAP systems. © Kluwer Academic Publishers 2003 |
abstractGer |
Abstract We report on a new, efficient encoding for the data cube, which results in a drastic speed-up of OLAP queries that aggregate along any combination of dimensions over numerical and categorical attributes. We are focusing on a class of queries called cube queries, which return aggregated values rather than sets of tuples. Our approach, termed $ CubiST^{++} $ (Cubing with Statistics Trees Plus Families), represents a drastic departure from existing relational (ROLAP) and multi-dimensional (MOLAP) approaches in that it does not use the view lattice to compute and materialize new views from existing views in some heuristic fashion. Instead, $ CubiST^{++} $ encodes all possible aggregate views in the leaves of a new data structure called statistics tree (ST) during a one-time scan of the detailed data. In order to optimize the queries involving constraints on hierarchy levels of the underlying dimensions, we select andmaterialize a family of candidate trees, which represent superviews over the different hierarchical levels of the dimensions. Given a query, our query evaluation algorithm selects the smallest tree in the family, which can provide the answer. Extensive evaluations of our prototype implementation have demonstrated its superior run-time performance and scalability when compared with existing MOLAP and ROLAP systems. © Kluwer Academic Publishers 2003 |
abstract_unstemmed |
Abstract We report on a new, efficient encoding for the data cube, which results in a drastic speed-up of OLAP queries that aggregate along any combination of dimensions over numerical and categorical attributes. We are focusing on a class of queries called cube queries, which return aggregated values rather than sets of tuples. Our approach, termed $ CubiST^{++} $ (Cubing with Statistics Trees Plus Families), represents a drastic departure from existing relational (ROLAP) and multi-dimensional (MOLAP) approaches in that it does not use the view lattice to compute and materialize new views from existing views in some heuristic fashion. Instead, $ CubiST^{++} $ encodes all possible aggregate views in the leaves of a new data structure called statistics tree (ST) during a one-time scan of the detailed data. In order to optimize the queries involving constraints on hierarchy levels of the underlying dimensions, we select andmaterialize a family of candidate trees, which represent superviews over the different hierarchical levels of the dimensions. Given a query, our query evaluation algorithm selects the smallest tree in the family, which can provide the answer. Extensive evaluations of our prototype implementation have demonstrated its superior run-time performance and scalability when compared with existing MOLAP and ROLAP systems. © Kluwer Academic Publishers 2003 |
collection_details |
GBV_USEFLAG_A SYSFLAG_A GBV_OLC SSG-OLC-MAT SSG-OPC-BBI GBV_ILN_31 GBV_ILN_40 GBV_ILN_62 GBV_ILN_65 GBV_ILN_70 GBV_ILN_100 GBV_ILN_2005 GBV_ILN_2006 GBV_ILN_2010 GBV_ILN_2021 GBV_ILN_2244 GBV_ILN_4036 GBV_ILN_4126 GBV_ILN_4266 GBV_ILN_4305 GBV_ILN_4307 GBV_ILN_4318 GBV_ILN_4326 |
container_issue |
3 |
title_short |
$ CubiST^{++} $: Evaluating Ad-Hoc CUBE Queries Using Statistics Trees |
url |
https://doi.org/10.1023/A:1025537315785 |
remote_bool |
false |
author2 |
Fu, Lixin |
author2Str |
Fu, Lixin |
ppnlink |
165664401 |
mediatype_str_mv |
n |
isOA_txt |
false |
hochschulschrift_bool |
false |
doi_str |
10.1023/A:1025537315785 |
up_date |
2024-07-03T13:38:53.080Z |
_version_ |
1803565329925799936 |
fullrecord_marcxml |
<?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01000caa a22002652 4500</leader><controlfield tag="001">OLC2027065652</controlfield><controlfield tag="003">DE-627</controlfield><controlfield tag="005">20230503034738.0</controlfield><controlfield tag="007">tu</controlfield><controlfield tag="008">200819s2003 xx ||||| 00| ||eng c</controlfield><datafield tag="024" ind1="7" ind2=" "><subfield code="a">10.1023/A:1025537315785</subfield><subfield code="2">doi</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627)OLC2027065652</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-He213)A:1025537315785-p</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-627</subfield><subfield code="b">ger</subfield><subfield code="c">DE-627</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="082" ind1="0" ind2="4"><subfield code="a">070</subfield><subfield code="a">020</subfield><subfield code="a">004</subfield><subfield code="q">VZ</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">24,1</subfield><subfield code="2">ssgn</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Hammer, Joachim</subfield><subfield code="e">verfasserin</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">$ CubiST^{++} $: Evaluating Ad-Hoc CUBE Queries Using Statistics Trees</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="c">2003</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">Text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">ohne Hilfsmittel zu benutzen</subfield><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">Band</subfield><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">© Kluwer Academic Publishers 2003</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Abstract We report on a new, efficient encoding for the data cube, which results in a drastic speed-up of OLAP queries that aggregate along any combination of dimensions over numerical and categorical attributes. We are focusing on a class of queries called cube queries, which return aggregated values rather than sets of tuples. Our approach, termed $ CubiST^{++} $ (Cubing with Statistics Trees Plus Families), represents a drastic departure from existing relational (ROLAP) and multi-dimensional (MOLAP) approaches in that it does not use the view lattice to compute and materialize new views from existing views in some heuristic fashion. Instead, $ CubiST^{++} $ encodes all possible aggregate views in the leaves of a new data structure called statistics tree (ST) during a one-time scan of the detailed data. In order to optimize the queries involving constraints on hierarchy levels of the underlying dimensions, we select andmaterialize a family of candidate trees, which represent superviews over the different hierarchical levels of the dimensions. Given a query, our query evaluation algorithm selects the smallest tree in the family, which can provide the answer. Extensive evaluations of our prototype implementation have demonstrated its superior run-time performance and scalability when compared with existing MOLAP and ROLAP systems.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Fu, Lixin</subfield><subfield code="4">aut</subfield></datafield><datafield tag="773" ind1="0" ind2="8"><subfield code="i">Enthalten in</subfield><subfield code="t">Distributed and parallel databases</subfield><subfield code="d">Kluwer Academic Publishers, 1993</subfield><subfield code="g">14(2003), 3 vom: Nov., Seite 221-254</subfield><subfield code="w">(DE-627)165664401</subfield><subfield code="w">(DE-600)913166-8</subfield><subfield code="w">(DE-576)038480352</subfield><subfield code="x">0926-8782</subfield><subfield code="7">nnns</subfield></datafield><datafield tag="773" ind1="1" ind2="8"><subfield code="g">volume:14</subfield><subfield code="g">year:2003</subfield><subfield code="g">number:3</subfield><subfield code="g">month:11</subfield><subfield code="g">pages:221-254</subfield></datafield><datafield tag="856" ind1="4" ind2="1"><subfield code="u">https://doi.org/10.1023/A:1025537315785</subfield><subfield code="z">lizenzpflichtig</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_USEFLAG_A</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">SYSFLAG_A</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_OLC</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">SSG-OLC-MAT</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">SSG-OPC-BBI</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_31</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_40</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_62</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_65</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_70</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_100</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_2005</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_2006</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_2010</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_2021</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_2244</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_4036</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_4126</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_4266</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_4305</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_4307</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_4318</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">GBV_ILN_4326</subfield></datafield><datafield tag="951" ind1=" " ind2=" "><subfield code="a">AR</subfield></datafield><datafield tag="952" ind1=" " ind2=" "><subfield code="d">14</subfield><subfield code="j">2003</subfield><subfield code="e">3</subfield><subfield code="c">11</subfield><subfield code="h">221-254</subfield></datafield></record></collection>
|
score |
7.400219 |