320870

An efficient uniform model to integrate SQL and NoSQL databases

Article

Last updated: 05 Jan 2025

Subjects

-

Tags

-

Abstract

In recent years, systems become more complex due to massive growth and variety of data which stored in different formats (structured and unstructured). In many cases the organizations need to use both SQL and NoSQL databases to store their data and get the advantages of both systems. A big challenge for organizations is how to integrate these data and retrieve it in a uniform format. The difficulty of integration is not only because the heterogeneity of query language and the data format but also the heterogeneity of semantic and structure. Although many researches were done to overcome these challenges, it introduced a specific solution for a special case or limited feature rather than a general model. This paper introduces a standard solution to integrate SQL with NoSQL databases and retrieve data from them in a unified form. The proposed model allows developers to write and execute queries against different data sources easily at the same time. This model solves the problems of heterogeneous data integration along three diagonal structure, semantic, and syntax heterogeneity. A web-based application is developed to ensure the usefulness of the proposed solution.

DOI

10.21608/mjcis.2019.320870

Keywords

NoSQL, SQL, Integration, Uniform Database Access

Authors

First Name

R.

Last Name

Zaki

MiddleName

-

Affiliation

Faculty of computers and information systems, I.S dep. Mansoura University, Egypt

Email

eng.rzaki@scc.mans.edu.eg

City

-

Orcid

-

First Name

A.

Last Name

Rezk

MiddleName

-

Affiliation

Faculty of computers and information systems, I.S dep. Mansoura University, Egypt

Email

-

City

-

Orcid

-

First Name

S.

Last Name

Barakat

MiddleName

-

Affiliation

Faculty of computers and information systems, I.S dep. Mansoura University, Egypt

Email

-

City

-

Orcid

-

Volume

15

Article Issue

1

Related Issue

43865

Issue Date

2019-06-01

Receive Date

2023-10-10

Publish Date

2019-06-01

Page Start

53

Page End

59

Print ISSN

2090-1666

Online ISSN

2090-1674

Link

https://mjcis.journals.ekb.eg/article_320870.html

Detail API

https://mjcis.journals.ekb.eg/service?article_code=320870

Order

320,870

Type

Original Research Articles.

Type Code

1,784

Publication Type

Journal

Publication Title

Mansoura Journal for Computer and Information Sciences

Publication Link

https://mjcis.journals.ekb.eg/

MainTitle

An efficient uniform model to integrate SQL and NoSQL databases

Details

Type

Article

Created At

28 Dec 2024