eprintid: 12565
rev_number: 2
eprint_status: archive
userid: 1
dir: disk0/00/01/25/65
datestamp: 2023-11-10 03:27:07
lastmod: 2023-11-10 03:27:07
status_changed: 2023-11-10 01:49:00
type: article
metadata_visibility: show
creators_name: Imam, A.A.
creators_name: Basri, S.
creators_name: Ahmad, R.
creators_name: Wahab, A.A.
creators_name: González-Aparicio, M.T.
creators_name: Capretz, L.F.
creators_name: Alazzawi, A.K.
creators_name: Balogun, A.O.
title: Dsp: Schema design for non-relational applications
ispublished: pub
note: cited By 5
abstract: The way a database schema is designed has a high impact on its performance in relational databases, which are symmetric in nature. While the problem of schema optimization is even more significant for NoSQL (�Not only SQL�) databases, existing modeling tools for relational databases are inadequate for this asymmetric setting. As a result, NoSQL modelers rely on rules of thumb to model schemas that require a high level of competence. Several studies have been conducted to address this problem; however, they are either proprietary, symmetrical, relationally dependent or post-design assessment tools. In this study, a Dynamic Schema Proposition (DSP) model for NoSQL databases is proposed to handle the asymmetric nature of today�s data. This model aims to facilitate database design and improve its performance in relation to data availability. To achieve this, data modeling styles were aggregated and classified. Existing cardinality notations were empirically extended using synthetically generated queries. A binary integer formulation was used to guide the mapping of asymmetric entities from the application�s conceptual data model to a database schema. An experiment was conducted to evaluate the impact of the DSP model on NoSQL schema production and its performance. A profound improvement was observed in read/write query performance and schema production complexities. In this regard, DSP has significant potential to produce schemas that are capable of handling big data efficiently. © 2020 by the authors. Licensee MDPI, Basel, Switzerland.
date: 2020
publisher: MDPI AG
official_url: https://www.scopus.com/inward/record.uri?eid=2-s2.0-85094816569&doi=10.3390%2fsym12111799&partnerID=40&md5=3a865c89756bcde7cbe234479d0b3c03
id_number: 10.3390/sym12111799
full_text_status: none
publication: Symmetry
volume: 12
number: 11
pagerange: 1-33
refereed: TRUE
issn: 20738994
citation:   Imam, A.A. and Basri, S. and Ahmad, R. and Wahab, A.A. and González-Aparicio, M.T. and Capretz, L.F. and Alazzawi, A.K. and Balogun, A.O.  (2020) Dsp: Schema design for non-relational applications.  Symmetry, 12 (11).  pp. 1-33.  ISSN 20738994