A Storage Advisor for Hybrid-Store Databases
Source: VLD Digital
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 columnoriented arises. The authors tackle this problem with a storage advisor tool that supports database administrators at this decision.