Self‐tuning is a feature of autonomic databases that includes the problem of automatic schema design. Automating the schema design process is critical to provide an optimized schema that increases the performance of an application's workload in NoSQL databases. There has been important work on automated design tuning for NoSQL databases. Existing solutions take an offline approach to the schema design problem and leave several important decisions to database administrators. Although offline approaches recommend good and efficient schemas, their analysis is far too heavy‐weight to be run continuously. This paper develops a novel self‐tuning control loop, called CONST, for online monitoring, analysis, and schema tuning a managed NoSQL database system that automatically modify the current schema design reacting to changes in the application's workload. CONST provides components that fulfill IBM's MAPE‐K loop phases to support self‐tuning. We describe an implementation of the proposed CONST loop on top of the Cassandra wide column store and evaluate its performance experimentally. Our results show the low overhead of CONST and demonstrate its ability to tune a schema design in response to changes in the application's workload.

中文翻译：

---

CONST：连续在线NoSQL模式调整

自我调整是自主数据库的一项功能，其中包括自动模式设计的问题。自动化模式设计过程对于提供优化的模式至关重要，该模式可以提高NoSQL数据库中应用程序工作负载的性能。在NoSQL数据库的自动设计调整方面，已经进行了重要的工作。现有的解决方案采用离线方法来解决方案设计问题，并将一些重要的决定留给数据库管理员。尽管离线方法建议使用好的高效模式，但是它们的分析过于繁重，无法连续运行。本文开发了一种称为CON​​ST的新颖的自调整控制循环，用于在线监视，分析和调整托管NoSQL数据库系统的模式，该系统可自动修改当前模式设计以响应应用程序中的更改。的工作量。CONST提供的组件可以满足IBM的MAPE-K循环阶段以支持自整定。我们在Cassandra宽列存储的顶部描述了建议的CONST循环的实现，并通过实验评估了其性能。我们的结果表明CONST的开销很低，并展示了CONST可以根据应用程序工作负载的变化来调整架构设计的能力。