Brighthouse: an analytic data warehouse for ad-hoc queries

Brighthouse: an analytic data warehouse for ad-hoc queries

Brighthouse is a column-oriented data warehouse with an automatically tuned, ultra small overhead metadata layer called Knowledge Grid, that is used as an alternative to classical indexes. The advantages of column-oriented data storage, as well as data compression have already been well-documented,...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:Proceedings of the VLDB Endowment 2008-08, Vol.1 (2), p.1337-1345
Hauptverfasser: Ślȩzak, Dominik, Wróblewski, Jakub, Eastwood, Victoria, Synak, Piotr
Format: Artikel
Sprache:eng
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
container_end_page 1345
container_issue 2
container_start_page 1337
container_title Proceedings of the VLDB Endowment
container_volume 1
creator Ślȩzak, Dominik
Wróblewski, Jakub
Eastwood, Victoria
Synak, Piotr
description Brighthouse is a column-oriented data warehouse with an automatically tuned, ultra small overhead metadata layer called Knowledge Grid, that is used as an alternative to classical indexes. The advantages of column-oriented data storage, as well as data compression have already been well-documented, especially in the context of analytic, decision support querying. This paper demonstrates additional benefits resulting from Knowledge Grid for compressed, column-oriented databases. In particular, we explain how it assists in query optimization and execution, by minimizing the need of data reads and data decompression.
doi_str_mv 10.14778/1454159.1454174
format Article
fullrecord <record><control><sourceid>crossref</sourceid><recordid>TN_cdi_crossref_primary_10_14778_1454159_1454174</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>10_14778_1454159_1454174</sourcerecordid><originalsourceid>FETCH-LOGICAL-c196t-1069cde722ad9eed49e192a51e71dc396f0b19e4e5de507e11c5e5341ae0ab103</originalsourceid><addsrcrecordid>eNpNzz1PAkEUheGJgURY6P0Ti_fszsfeUokoCYmN1JNh5i4f0WBmsPDfm8AWVu-pTvIo9QBaQDvXPUIbDcOLa52-U5MGhuqO2I3-7Xs1LeVEZDuLbqKq53zcHy6H80-RmRr34bPIfGiltquXj-VbvXl_XS-fNnUE20sNshyTuKYJiUWSZgE3wUAcUmzZ9rQDixaTxJATIBoxrUYQCjtQWym6_cZ8LiVL77_z8SvkXw_yV4wfMH7AtH-SuTqQ</addsrcrecordid><sourcetype>Aggregation Database</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype></control><display><type>article</type><title>Brighthouse: an analytic data warehouse for ad-hoc queries</title><source>ACM Digital Library Complete</source><creator>Ślȩzak, Dominik ; Wróblewski, Jakub ; Eastwood, Victoria ; Synak, Piotr</creator><creatorcontrib>Ślȩzak, Dominik ; Wróblewski, Jakub ; Eastwood, Victoria ; Synak, Piotr</creatorcontrib><description>Brighthouse is a column-oriented data warehouse with an automatically tuned, ultra small overhead metadata layer called Knowledge Grid, that is used as an alternative to classical indexes. The advantages of column-oriented data storage, as well as data compression have already been well-documented, especially in the context of analytic, decision support querying. This paper demonstrates additional benefits resulting from Knowledge Grid for compressed, column-oriented databases. In particular, we explain how it assists in query optimization and execution, by minimizing the need of data reads and data decompression.</description><identifier>ISSN: 2150-8097</identifier><identifier>EISSN: 2150-8097</identifier><identifier>DOI: 10.14778/1454159.1454174</identifier><language>eng</language><ispartof>Proceedings of the VLDB Endowment, 2008-08, Vol.1 (2), p.1337-1345</ispartof><lds50>peer_reviewed</lds50><woscitedreferencessubscribed>false</woscitedreferencessubscribed><cites>FETCH-LOGICAL-c196t-1069cde722ad9eed49e192a51e71dc396f0b19e4e5de507e11c5e5341ae0ab103</cites></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><link.rule.ids>314,778,782,27907,27908</link.rule.ids></links><search><creatorcontrib>Ślȩzak, Dominik</creatorcontrib><creatorcontrib>Wróblewski, Jakub</creatorcontrib><creatorcontrib>Eastwood, Victoria</creatorcontrib><creatorcontrib>Synak, Piotr</creatorcontrib><title>Brighthouse: an analytic data warehouse for ad-hoc queries</title><title>Proceedings of the VLDB Endowment</title><description>Brighthouse is a column-oriented data warehouse with an automatically tuned, ultra small overhead metadata layer called Knowledge Grid, that is used as an alternative to classical indexes. The advantages of column-oriented data storage, as well as data compression have already been well-documented, especially in the context of analytic, decision support querying. This paper demonstrates additional benefits resulting from Knowledge Grid for compressed, column-oriented databases. In particular, we explain how it assists in query optimization and execution, by minimizing the need of data reads and data decompression.</description><issn>2150-8097</issn><issn>2150-8097</issn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>2008</creationdate><recordtype>article</recordtype><recordid>eNpNzz1PAkEUheGJgURY6P0Ti_fszsfeUokoCYmN1JNh5i4f0WBmsPDfm8AWVu-pTvIo9QBaQDvXPUIbDcOLa52-U5MGhuqO2I3-7Xs1LeVEZDuLbqKq53zcHy6H80-RmRr34bPIfGiltquXj-VbvXl_XS-fNnUE20sNshyTuKYJiUWSZgE3wUAcUmzZ9rQDixaTxJATIBoxrUYQCjtQWym6_cZ8LiVL77_z8SvkXw_yV4wfMH7AtH-SuTqQ</recordid><startdate>200808</startdate><enddate>200808</enddate><creator>Ślȩzak, Dominik</creator><creator>Wróblewski, Jakub</creator><creator>Eastwood, Victoria</creator><creator>Synak, Piotr</creator><scope>AAYXX</scope><scope>CITATION</scope></search><sort><creationdate>200808</creationdate><title>Brighthouse</title><author>Ślȩzak, Dominik ; Wróblewski, Jakub ; Eastwood, Victoria ; Synak, Piotr</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-c196t-1069cde722ad9eed49e192a51e71dc396f0b19e4e5de507e11c5e5341ae0ab103</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>eng</language><creationdate>2008</creationdate><toplevel>peer_reviewed</toplevel><toplevel>online_resources</toplevel><creatorcontrib>Ślȩzak, Dominik</creatorcontrib><creatorcontrib>Wróblewski, Jakub</creatorcontrib><creatorcontrib>Eastwood, Victoria</creatorcontrib><creatorcontrib>Synak, Piotr</creatorcontrib><collection>CrossRef</collection><jtitle>Proceedings of the VLDB Endowment</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext</fulltext></delivery><addata><au>Ślȩzak, Dominik</au><au>Wróblewski, Jakub</au><au>Eastwood, Victoria</au><au>Synak, Piotr</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><atitle>Brighthouse: an analytic data warehouse for ad-hoc queries</atitle><jtitle>Proceedings of the VLDB Endowment</jtitle><date>2008-08</date><risdate>2008</risdate><volume>1</volume><issue>2</issue><spage>1337</spage><epage>1345</epage><pages>1337-1345</pages><issn>2150-8097</issn><eissn>2150-8097</eissn><abstract>Brighthouse is a column-oriented data warehouse with an automatically tuned, ultra small overhead metadata layer called Knowledge Grid, that is used as an alternative to classical indexes. The advantages of column-oriented data storage, as well as data compression have already been well-documented, especially in the context of analytic, decision support querying. This paper demonstrates additional benefits resulting from Knowledge Grid for compressed, column-oriented databases. In particular, we explain how it assists in query optimization and execution, by minimizing the need of data reads and data decompression.</abstract><doi>10.14778/1454159.1454174</doi><tpages>9</tpages></addata></record>
fulltext fulltext
identifier ISSN: 2150-8097
ispartof Proceedings of the VLDB Endowment, 2008-08, Vol.1 (2), p.1337-1345
issn 2150-8097
2150-8097
language eng
recordid cdi_crossref_primary_10_14778_1454159_1454174
source ACM Digital Library Complete
title Brighthouse: an analytic data warehouse for ad-hoc queries
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-17T08%3A20%3A39IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-crossref&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.genre=article&rft.atitle=Brighthouse:%20an%20analytic%20data%20warehouse%20for%20ad-hoc%20queries&rft.jtitle=Proceedings%20of%20the%20VLDB%20Endowment&rft.au=%C5%9Al%C8%A9zak,%20Dominik&rft.date=2008-08&rft.volume=1&rft.issue=2&rft.spage=1337&rft.epage=1345&rft.pages=1337-1345&rft.issn=2150-8097&rft.eissn=2150-8097&rft_id=info:doi/10.14778/1454159.1454174&rft_dat=%3Ccrossref%3E10_14778_1454159_1454174%3C/crossref%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true