Ergebnis 6 von 231
Sie befinden Sich nicht im Netzwerk der Universität Paderborn. Der Zugriff auf elektronische Ressourcen ist gegebenenfalls nur via VPN oder Shibboleth (DFN-AAI) möglich. mehr Informationen...
Proceedings of the VLDB Endowment, 2012-08, Vol.5 (12), p.1748-1758
2012

Details

Autor(en) / Beteiligte
Titel
A storage advisor for hybrid-store databases
Ist Teil von
  • Proceedings of the VLDB Endowment, 2012-08, Vol.5 (12), p.1748-1758
Erscheinungsjahr
2012
Link zum Volltext
Quelle
ACM Digital Library
Beschreibungen/Notizen
  • With the SAP HANA database, SAP offers a high-performance in-memory hybrid-store database. Hybrid-store databases---that is, databases supporting row- and column-oriented data management---are getting more and more prominent. While the columnar management offers high-performance capabilities for analyzing large quantities of data, the row-oriented store can handle transactional point queries as well as inserts and updates more efficiently. To effectively take advantage of both stores at the same time the novel question whether to store the given data row- or column-oriented arises. We tackle this problem with a storage advisor tool that supports database administrators at this decision. Our proposed storage advisor recommends the optimal store based on data and query characteristics; its core is a cost model to estimate and compare query execution times for the different stores. Besides a per-table decision, our tool also considers to horizontally and vertically partition the data and manage the partitions on different stores. We evaluated the storage advisor for the use in the SAP HANA database; we show the recommendation quality as well as the benefit of having the data in the optimal store with respect to increased query performance.
Sprache
Englisch
Identifikatoren
ISSN: 2150-8097
eISSN: 2150-8097
DOI: 10.14778/2367502.2367514
Titel-ID: cdi_crossref_primary_10_14778_2367502_2367514
Format

Weiterführende Literatur

Empfehlungen zum selben Thema automatisch vorgeschlagen von bX