CONST: Continuous online NoSQL schema tuning. (20th December 2020)

• Record Type: Journal Article
• Authors: Mozaffari, Maryam; Nazemi, Eslam; Eftekhari‐Moghadam, Amir‐Masoud
• Is Part Of: Software, practice & experience. Volume 51:Number 5(2021)
• Page Start: 1147
• Page End: 1169
• Publication Date: 2020-12-20
• Subjects: automatic schema design tuning -- autonomic databases -- NoSQL wide column stores -- workload change detection -- workload monitoring and analysis; Computer software -- Periodicals; Computer programming -- Periodicals; Computer programs -- Periodicals; 005.3
• DOI: 10.1002/spe.2945
• Languages: English
• ISSNs: 0038-0644

Abstract

Abstract: 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.