Implementing a Classic ER Algebra to Automatically Generate Complex Queries for Document-Oriented Databases

Noguera, Viviana Elizabeth Romero; Lucrédio, Daniel

doi:10.1145/3357141.3357601

Proceedings of the XIII Brazilian Symposium on Software Components, Architectures, and Reuse 2019

DOI: 10.1145/3357141.3357601

|View full text |Cite

Implementing a Classic ER Algebra to Automatically Generate Complex Queries for Document-Oriented Databases

Viviana Elizabeth Romero Noguera

Daniel Lucrédio

Help me understand this report

Search citation statements

Order By: Relevance

Paper Sections

Select...

Citation Types

Supporting

Mentioning

Contrasting

Year Published

2020

2024

Publication Types

Select...

Article2

Relationship

Self Cite0

Independent2

Authors

Journals

Cited by 2 publications

References 22 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

CONST: Continuous online NoSQL schema tuning

2020

View full text Add to dashboard Cite

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.

show abstract

CONST: Continuous online NoSQL schema tuning

2020

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

scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.

Contact Info

customersupport@researchsolutions.com

10624 S. Eastern Ave., Ste. A-614

Henderson, NV 89052, USA

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Blog Terms and Conditions API Terms Privacy Policy Contact Cookie Preferences Do Not Sell or Share My Personal Information

Made with 💙 for researchers

Part of the Research Solutions Family.

Implementing a Classic ER Algebra to Automatically Generate Complex Queries for Document-Oriented Databases

Cited by 2 publications

References 22 publications

CONST: Continuous online NoSQL schema tuning

CONST: Continuous online NoSQL schema tuning

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

Contact Info

Product

Resources

About