Storage advisor for hybrid-store databases

摘要

Methods, systems, and computer-readable storage media for recommending a storage layout for the hybrid-store database with actions including receiving one or more data characteristics associated with data that is to be stored in the hybrid-store database, receiving one or more query characteristics associated with one or more queries that are expected to be applied to the hybrid-store database, processing the one or more data characteristics and the one or more query characteristics using a cost model to generate a plurality of costs, each cost being associated with a respective storage layout, identifying, based on the plurality of costs, a recommended storage layout, and providing the recommended storage layout for application to the hybrid-store database.

主权项

1. A computer-implemented method for recommending a storage layout for a hybrid-store database, the method being executed using one or more processors and comprising:
receiving, by the one or more processors, one or more data characteristics associated with data that is to be stored in the hybrid-store database before the data is stored in the hybrid-store database; receiving, by the one or more processors, one or more query characteristics associated with one or more queries that are expected to be applied to the hybrid-store database; processing, by the one or more processors, the one or more data characteristics and the one or more query characteristics using a cost model to generate a plurality of storage costs based on a level of details of the one or more query characteristics, each storage cost being associated with a respective storage layout and being determined as a sum of a base cost and one or more adaptation factors, the base cost being associated with default data and default query characteristics and each of the one or more adaptation factors corresponding to a storage sub-cost determined for each of the one or more queries; identifying, based on the plurality of storage costs, a recommended storage layout; and providing the recommended storage layout for application to the hybrid-store database.