Data adapter for querying and transformation between SQL and NoSQL database

被引：36

作者：

Liao, Ying-Ti ^{[1
]}

Zhou, Jiazheng ^{[1
]}

Lu, Chia-Hung ^{[1
]}

Chen, Shih-Chang ^{[1
]}

Hsu, Ching-Hsien ^{[2
,3
]}

Chen, Wenguang ^{[4
]}

Jiang, Mon-Fong ^{[5
]}

Chung, Yeh-Ching ^{[1
]}

机构：

[1] Natl Tsing Hua Univ, Dept Comp Sci, Hsinchu 30013, Taiwan

[2] Foshan Univ, Sch Math & Big Data, Foshan, Chancheng, Peoples R China

[3] Chung Hua Univ, Dept Comp Sci & Informat Engn, Hsinchu, Taiwan

[4] Tsinghua Univ, Dept Comp Sci & Technol, Beijing, Peoples R China

[5] Island Syst Inc, 300, Hsinchu, Taiwan

来源：

FUTURE GENERATION COMPUTER SYSTEMS-THE INTERNATIONAL JOURNAL OF ESCIENCE | 2016年 / 65卷

关键词：

Big data; NoSQL; Data adapter; Hybrid database; Cloud computing; Database services; BIG-DATA; SECURITY;

D O I：

10.1016/j.future.2016.02.002

中图分类号：

TP301 [理论、方法];

学科分类号：

081202 ;

摘要：

As the growing of applications with big data in cloud computing become popular, many existing systems expect to expand their service to support the explosive increase of data. We propose a data adapter system to support hybrid database architecture including a relational database (RDB) and NoSQL database. It can support query from application and deal with database transformation at the same time. We provide three modes of query approach in data adapter system: blocking transformation mode (BT mode), blocking dump mode (BD mode), and direct access mode (DA mode). We provide a data synchronization mechanism and describe the design and implementation in detail. This paper focuses on velocity with proposed three modes and partly variety with data stored in RDB, NoSQL database and temporary files. With the proposed data adapter system, we can provide a seamless mechanism to use RDB and NoSQL database at the same time. (C) 2016 Elsevier B.V. All rights reserved.

引用

页码：111 / 121

页数：11

共 50 条

[1] Uniform data access platform for SQL and NoSQL database systems
Vathy-Fogarassy, Agnes
Hugyak, Tamas
[J]. INFORMATION SYSTEMS, 2017, 69 : 93 - 105
[2] QUERYING DATA IN NOSQL DATABASES
Babic, Andrea
Jaksic, Danijela
Poscic, Patrizia
[J]. ZBORNIK VELEUCILISTA U RIJECI-JOURNAL OF THE POLYTECHNICS OF RIJEKA, 2019, 7 (01): : 257 - 270
[3] Schema Conversion Model of SQL Database to NoSQL
Zhao, Gansen
Lin, Qiaoying
Li, Libo
Li, Zijing
[J]. 2014 NINTH INTERNATIONAL CONFERENCE ON P2P, PARALLEL, GRID, CLOUD AND INTERNET COMPUTING (3PGCIC), 2014, : 355 - 362
[4] Improved Information Retrieval Performance on SQL Database Using Data Adapter
Husni, M.
Djanali, S.
Ciptaningtyas, H. T.
Wicaksana, I. G. N. A.
[J]. 2ND INTERNATIONAL CONFERENCE ON INNOVATION IN ENGINEERING AND VOCATIONAL EDUCATION, 2018, 306
[5] Graph-Based Denormalization for Migrating Big Data from SQL Database to NoSQL Database
Rathika, V
[J]. INTELLIGENT COMMUNICATION TECHNOLOGIES AND VIRTUAL MOBILE NETWORKS, ICICV 2019, 2020, 33 : 546 - 556
[6] Modeling and Querying Data in NoSQL Databases
Kaur, Karamjit
Rani, Rinkle
[J]. 2013 IEEE INTERNATIONAL CONFERENCE ON BIG DATA, 2013,
[7] A fresh approach for hybrid SQL/NoSQL database design based on data structuredness
Bjeladinovic, Srdja
[J]. ENTERPRISE INFORMATION SYSTEMS, 2018, 12 (8-9) : 1202 - 1220
[8] Correlation Aware Technique for SQL to NoSQL Transformation
Hsu, Jen-Chun
Hsu, Ching-Hsien
Chen, Shih-Chang
Chung, Yeh-Ching
[J]. 2014 7TH INTERNATIONAL CONFERENCE ON UBI-MEDIA COMPUTING AND WORKSHOPS (UMEDIA), 2014, : 43 - 46
[9] A Method of SQL Processing Data in NoSQL
Pan, Wumin
[J]. PROCEEDINGS OF THE 2ND INTERNATIONAL CONFERENCE ON SOFT COMPUTING IN INFORMATION COMMUNICATION TECHNOLOGY, 2014, : 213 - 215
[10] SQL Database with physical database tuning technique and NoSQL graph database comparisons
Khan, Wisal
Ahmad, Waqas
Luo, Bin
Ahmed, Ejaz
[J]. PROCEEDINGS OF 2019 IEEE 3RD INFORMATION TECHNOLOGY, NETWORKING, ELECTRONIC AND AUTOMATION CONTROL CONFERENCE (ITNEC 2019), 2019, : 110 - 116

← 1 2 3 4 5 →