New Publication: A Storage Advisor for Hybrid-Store Databases
A new publication about SAP HANA (by SAP Research) is out, you can find it here:
Proceedings of the VLDB Endowment, Vol. 5 in Issue No. 12, August 2012 (Direct link to the PDF: http://vldb.org/pvldb/vol5/p1748_philipprosch_vldb2012.pdf)
With the SAP HANA database, SAP oﬀers 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 oﬀers 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 eﬃciently. To eﬀectively take advantage of both stores at the same time the novel question whether to store the given data row- or columnoriented 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 diﬀerent stores. Besides a per-table decision, our tool also considers to horizontally and vertically partition the data and manage the partitions on diﬀerent stores. We evaluated the storage advisor for the use in the SAP HANA database; we show the recommendation quality as well as the beneﬁt of having the data in the optimal store with respect to increased query performance.
If you’re interested in other publications of our team, have a look at our list