Tehničko veleučilište u Zagrebu · Zagreb

An overview of data integration principles for heterogeneous databases

izvorni znanstveni rad

izvorni znanstveni rad

An overview of data integration principles for heterogeneous databases

Vrsta prilog sa skupa (u zborniku)
Tip izvorni znanstveni rad
Godina 2022
Nadređena publikacija 2022 45th Jubilee International Convention on Information, Communication and Electronic Technology (MIPRO)
Stranice str. 1111-1116
DOI 10.23919/MIPRO55190.2022.9803579
ISSN 2623-8764
Status objavljeno

Sažetak

Modern large-scale information systems often use multiple database management systems, not all of which are necessarily relational. In recent years, NoSQL databases have gained acceptance in certain domains while relational databases remain de facto standard in many others. Many “legacy” information systems also use relational databases. Unlike relational database systems, NoSQL databases do not have a common data model or query language, making it difficult for users to access data in a uniform manner when using a combination of relational and NoSQL databases or simply several different NoSQL database systems. Therefore, the need for uniform data access from such a variety of data sources becomes one of the central problems for data integration. In this paper we provide an overview of the main problems, methods, and solutions for data integration between relational and NoSQL databases, as well as between different NoSQL databases. We focus mainly on the problems of structural, syntactic, and semantic heterogeneity and on proposed solutions for uniform data access, emphasizing some of the more recent proposals.

Ključne riječi

data integration; database; SQL; NoSQL; heterogeneous