Automated schema design for NoSQL databases

Mior, Michael J.

doi:10.1145/2602622.2602624

Cited by 30 publications

(13 citation statements)

References 15 publications

(12 reference statements)

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Mior in [14] follows a similar approach to ours but focus on Cassadra. He proposes a static analysis of the storage impact comparing a set of queries in different schemes.…”

Section: Related Workmentioning

confidence: 99%

Data schema does matter, even in NoSQL systems!

Gómez

Casallas

Roncancio

2016

2016 IEEE Tenth International Conference on Research Challenges in Information Science (RCIS)

View full text Add to dashboard Cite

Abstract-A Schema-less NoSQL system refers to solutions where users do not declare a database schema and, in fact, its management is moved to the application code. This paper presents a study that allows us to evaluate, to some extent, the data structuring impact. The decision of how to structure data in semi-structured databases has an enormous impact on data size, query performance and readability of the code, which influences software debugging and maintainability. This paper presents an experiment performed using MongoDB along with several alternatives of data structuring and a set of queries having increasing complexity. This paper introduces an analysis regarding the findings of such an experiment.

show abstract

“…Mior in [14] follows a similar approach to ours but focus on Cassadra. He proposes a static analysis of the storage impact comparing a set of queries in different schemes.…”

Section: Related Workmentioning

confidence: 99%

Data schema does matter, even in NoSQL systems!

Gómez

Casallas

Roncancio

2016

2016 IEEE Tenth International Conference on Research Challenges in Information Science (RCIS)

View full text Add to dashboard Cite

show abstract

“…This limits the options for programmers and companies to select only the databases that have such support. Therefore, there is need to have a solution that can be compatible with at least one category of NoSQL databases [5,7,26].…”

Section: Literature Reviewmentioning

confidence: 99%

“…This leads to the proposal of few NoSQL modeling tools. In [26], cost-driven approach for query optimization is proposed. This approach uses the cost of workload execution for mapping the physical schema to the application data model.…”

Section: Literature Reviewmentioning

confidence: 99%

Automatic schema suggestion model for NoSQL document-stores databases

et al. 2018

View full text Add to dashboard Cite

New generation databases also called NoSQL (Not only SQL) databases are highly scalable, flexible, and low-latent. These types of databases emerge as a result of the rigidity shown by traditional databases to handle today's data which is voluminous, highly diversified and generated at a very high rate. With NoSQL, problems such as database expansion difficulties, low query performance and low storage capacity are addressed. However, the inherent complexity of contemporary datasets coupled with programmers' low NoSQL modeling competence are increasingly making database modeling and design vastly challenging, especially when parameters like consistency, availability and scalability are to be balanced in accordance with system requirements. As such, a schema suggestion model for NoSQL databases is posed to address this balancing issue. The proposed model aims to abstractly suggest schemas at the initial stage of system development based on user defined system requirements and CRUD (Create, Read, Update and Delete) operations among others. This is achieved through the adaptation of exploratory and experimental approaches of research. Also, few mathematical formulas are introduced to calculate clusters availability during entity mappings. A comparison was conducted between the schema produced using the proposed model and the one without. Results obtained shows substantial improvement in the areas of security and read-write query performance.

show abstract

“…In the area of Big Data, NoSQL systems have attracted interest as mean for implementing multidimensional data warehouses (Chevalier et al, 2015a), (Chevalier et al, 2015b), (Mior, 2014), (Dede et al, 2013), (Schindler, 2012). The proposed approaches mainly rely on two specific classes of NoSQL systems, namely document-oriented systems (Chevalier et al, 2015a) and column oriented systems (Chevalier et al, 2015b), (Dede et al, 2013).…”

Section: Introductionmentioning

confidence: 99%

An Evaluation of the Challenges of Multilingualism in Data Warehouse Development

Dediź

Stanier

2016

Proceedings of the 18th International Conference on Enterprise Information Systems

View full text Add to dashboard Cite

ICEIS 2016 received 257 paper submissions from 42 countries in all continents, which makes it one of the largest conferences in the World in the area of Information Systems, thus demonstrating the success and global dimension of this conference. From these, 42 papers were selected for publication and presentation at the Conference as full papers. These numbers, leading to a full-paper acceptance ratio of 16%, show the intention of preserving a high quality forum for this conference, a quality that we intend to maintain in the future, for the next editions of this conference.The high number and high quality of the received papers imposed difficult choices in the selection process. To evaluate each submission, a double blind paper review was performed by the Program Committee, whose members are highly qualified researchers in ICEIS topic areas.All presented papers will be available at the SCITEPRESS Digital Library and will be submitted for indexation by Thomson Reuters Conference Proceedings Citation Index (ISI), INSPEC, DBLP, EI (Elsevier Index) and Scopus.Additionally, a short list of presented papers will be selected to be expanded into a forthcoming book of ICEIS 2016 Selected Papers to be published by Springer in the LNBIP Series.The technical program of the conference included a panel and 4 invited talks delivered by internationally distinguished speakers, namely: Claudia Loebbecke (University of Cologne, Germany), Sergio Gusmeroli (TXT e-solutions SPA, Italy), Wil Van Der Aalst (Technische Universiteit Eindhoven, Netherlands) and Jan Vom Brocke (University of Liechtenstein, Liechtenstein). Their participation positively contributes to reinforce the overall quality of the Conference and to provide a deeper understanding of the fields addressed by the conference.Moreover, ICEIS 2016 had a Doctoral Consortium on Enterprise Information Systems and 1 tutorial. We are thankful to the Conference Co-chairs (Olivier Camp and José Cordeiro) and Program Co-chairs (Slimane Hammoudi, Leszek Maciaszek and Michele M. Missikoff) for their dedication and hard work in organizing these events.We sincerely thank all the authors for their submissions and participation in ICEIS 2016. Furthermore, we would like to thank all the members of the program committee and reviewers, who helped us with their expertise, dedication and time. We would also like to thank the invited speakers for their excellent contribution in sharing their knowledge and vision and the workshop/special session chairs whose collaboration with ICEIS 2015 was much appreciated. Finally, we gratefully acknowledge the professional support of the ICEIS 2016 team for all organizational processes. XIIIWe hope that all colleagues find this a fruitful and inspiring conference. We hope to contribute to the development of the Enterprise Information Systems community and look forward to having additional research results presented at the next edition of ICEIS, details of which are available at http://www.iceis.org. Slimane Hammoudi University of Cologne, GermanyAbstract:...

show abstract

Automated schema design for NoSQL databases

Cited by 30 publications

References 15 publications

Data schema does matter, even in NoSQL systems!

Data schema does matter, even in NoSQL systems!

Automatic schema suggestion model for NoSQL document-stores databases

An Evaluation of the Challenges of Multilingualism in Data Warehouse Development

Contact Info

Product

Resources

About