<scp>CONST</scp>: Continuous online <scp>NoSQL</scp> schema tuning

Mozaffari, Maryam; Nazemi, Eslam; Moghadam, Amir Masoud Eftekhari

doi:10.1002/spe.2945

Cited by 2 publications

(2 citation statements)

References 22 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…In addition, four studies presented design processes that consist of following a series of defined steps. In [35], a control cycle is developed for tuning schemes automatically based on the workload. In [36], the authors develop a NoSQL schema recommendation system given a conceptual model and application workload.…”

Section: A Rq-1 What Are Nosql Database Modeling Procedures Based On ...mentioning

confidence: 99%

“…Six of them implemented their proposals. In [35], they highlight their fault tolerance, linear scalability, high availability, and ability to simulate a joint operation through denormalization. [36] Comment that it only supports put, get, and delete operations on column families, in addition, it provides a limited form of secondary indexing, which allows selecting records in other ways.…”

Section: Rq-3 What Characteristics Should Nosql Database Management T...mentioning

confidence: 99%

See 1 more Smart Citation

NoSQL Database Modeling and Management: A Systematic Literature Review

Aguilar Vera,

Naal Jácome,

Díaz Mendoza

et al. 2023

Rev. Fac. Ing.

View full text Add to dashboard Cite

The NoSQL databases that emerged this century were created to solve the limitations of relational database systems due to the different types of data that have appeared for information processing. In this paper, we present the results of a secondary study carried out to find and synthesize the research made up to now on modeling processes, characteristics of the used types of data, and management tools for NoSQL Databases. Currently, four types are recognized and classified according to the data model they use: key-value, document-oriented, column-based, and graph-based. With this study, it was possible to identify that the most frequently type of NoSQL database model is that of documents because it offers greater flexibility and versatility compared to the other three models. Although it offers more complex search methods, in terms of data, column and document schemas are the ones that usually describe their characteristics. It was also possible to observe a trend in the use of the column-oriented model and the document-oriented model in the management tools, and, although they all comply with the basic functionalities, the differences lie in the way in which the information is stored and the way they can be accessed.

show abstract

Section: A Rq-1 What Are Nosql Database Modeling Procedures Based On ...mentioning

confidence: 99%

Section: Rq-3 What Characteristics Should Nosql Database Management T...mentioning

confidence: 99%

NoSQL Database Modeling and Management: A Systematic Literature Review

Aguilar Vera,

Naal Jácome,

Díaz Mendoza

et al. 2023

Rev. Fac. Ing.

View full text Add to dashboard Cite

show abstract

Self-tuning Database Systems: A Systematic Literature Review of Automatic Database Schema Design and Tuning

Mozaffari,

Dignös,

Gamper

et al. 2024

ACM Comput. Surv.

View full text Add to dashboard Cite

Self-tuning is a feature of autonomic databases that includes the problem of automatic schema design. It aims at providing an optimized schema that increases the overall database performance. While in relational databases automatic schema design focuses on the automated design of the physical schema, in NoSQL databases all levels of representation are considered: conceptual, logical, and physical. This is mainly because the latter are mostly schema-less and lack a standard schema design procedure as is the case for SQL databases. In this work, we carry out a systematic literature survey on automatic schema design in both SQL and NoSQL databases. We identify the levels of representation and the methods that are used for the schema design problem, and we present a novel taxonomy to classify and compare different schema design solutions. Our comprehensive analysis demonstrates that, despite substantial progress that has been made, schema design is still a developing field and considerable challenges need to be addressed, notably for NoSQL databases. We highlight the most important findings from the results of our analysis and identify areas for future research work.

show abstract

CONST: Continuous online NoSQL schema tuning

Cited by 2 publications

References 22 publications

NoSQL Database Modeling and Management: A Systematic Literature Review

NoSQL Database Modeling and Management: A Systematic Literature Review

Self-tuning Database Systems: A Systematic Literature Review of Automatic Database Schema Design and Tuning

Contact Info

Product

Resources

About