CONST: Continuous online NoSQL schema tuning. (20th December 2020)
- Record Type:
- Journal Article
- Title:
- CONST: Continuous online NoSQL schema tuning. (20th December 2020)
- Main Title:
- CONST: Continuous online NoSQL schema tuning
- Authors:
- Mozaffari, Maryam
Nazemi, Eslam
Eftekhari‐Moghadam, Amir‐Masoud - 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.
- Is Part Of:
- Software, practice & experience. Volume 51:Number 5(2021)
- Journal:
- Software, practice & experience
- Issue:
- Volume 51:Number 5(2021)
- Issue Display:
- Volume 51, Issue 5 (2021)
- Year:
- 2021
- Volume:
- 51
- Issue:
- 5
- Issue Sort Value:
- 2021-0051-0005-0000
- 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 - Journal URLs:
- http://onlinelibrary.wiley.com/ ↗
- DOI:
- 10.1002/spe.2945 ↗
- Languages:
- English
- ISSNs:
- 0038-0644
- Deposit Type:
- Legaldeposit
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library DSC - 8321.453000
British Library DSC - BLDSS-3PM
British Library STI - ELD Digital store - Ingest File:
- 16183.xml