OCL Constraints Checking on NoSQL Systems Through an MDA-Based Approach

Databases are commonly used to store complex and distinct information. With the advancement of the database system, non-relational databases have been used to store a vast amount of data as traditional databases are not sufficient for making queries on a wide range of massive data. However, storing data in a database is always challenging for non-expert users. We propose a conversion technique that enables non-expert users to access and filter data as close to human language as possible from the NoSQL database. Researchers have already explored a variety of technologies in order to develop more precise conversion procedures. This paper proposed a generic NoSQL query conversion learning method to generate a Non-Structured Query Language from natural language. The proposed system includes natural language processing-based text preprocessing and the Levenshtein distance algorithm to extract the collection and attributes if there were any spelling errors. The analysis of the result shows that our suggested approach is more efficient and accurate than other state-of-the-art methods in terms of bilingual understudy scoring with the WikiSQL dataset. Additionally, the proposed method outperforms the existing approaches because our method utilizes a bidirectional encoder representation from a transformer multi-text classifier. The classifier process extracts database operations that might increase the accuracy. The model achieves state-of-the-art performance on WikiSQL, obtaining 88.76% average accuracy.

show abstract

“…Fatma et al [23] proposed an automatic UML/OCL model for the NoSQL database converter. Their system mainly focuses on the big data platform.…”

Section: Related Workmentioning

confidence: 99%

BERT Model-based Natural Language to NoSQL Query Conversion using Deep Learning Approach

Hossen¹,

Uddin²,

Arefin³

et al. 2023

IJACSA

View full text Add to dashboard Cite

show abstract

“…This section presents a series of mapping rules, based on the work of De La Vega et al [11] and Ait Brahim et al [21], for transforming a conceptual metamodel into a NoSQL metamodel via model-to-model transformations. The main idea behind these rules is the creation of a collection to support each access query.…”

Section: Transformations From Pidm To Key-value Metamodelmentioning

confidence: 99%

“…Abdelhedi et al enrich the previous work by also considering the constraints dimension with an MDA approach despite access queries weren't supported [21]. The result is a physical data model and an OCL code that describes the integrity constraints of the database.…”

Section: Related Workmentioning

confidence: 99%

KVMod - A novel approach to designKey-Value NoSQL databases

Dourhri

Hanine

Ouahmane

2023

Preprint

View full text Add to dashboard Cite

The growth of structured, semi-structured, and unstructured data produced by the new applications is a result of the development and expansion of social networks, the Internet of Things, web technology, mobile devices, and other technologies. However, as traditional databases became less suitable to manage rapidly growing data quantity and the variety of data structures, a new class of database management systems named NoSQL is required to satisfy the new requirements. Although NoSQL databases are generally schemaless, significant research has been conducted on NoSQL design. A literature review presented in this paper let us claim the need to create modeling techniques to describe how to structure data in NoSQL databases. Key-value is one of the NoSQL families, which has received too little attention, especially about its design methodology. Most studies have focused on the other families like column-oriented and document-oriented. This paper aims to present a design approach named KVMod (key-value modeling) specific to key-value databases. The purpose is to provide to the scientific community and engineers a methodology for the design of key-value stores using the maximum automation and therefore the minimum human intervention, which equals the minimum of errors. A software tool called KVDesign has been implemented to automate the proposed methodology and thus the most time-consuming database modeling tasks. The complexity is also discussed to assess the efficiency of our proposed algorithms.

show abstract

Definitions and Computational Properties of OCL: A Systematic Review

Rajić,

Sruk

2024

IEEE Access

View full text Add to dashboard Cite

OCL Constraints Checking on NoSQL Systems Through an MDA-Based Approach

Cited by 3 publications

References 1 publication

BERT Model-based Natural Language to NoSQL Query Conversion using Deep Learning Approach

BERT Model-based Natural Language to NoSQL Query Conversion using Deep Learning Approach

KVMod - A novel approach to designKey-Value NoSQL databases

Definitions and Computational Properties of OCL: A Systematic Review

Contact Info

Product

Resources

About