SQL-Middleware: Enabling the Blockchain with SQL

Xing Tong; Haibo Tang; Nan Jiang; Wei Fan; Yichen Gao; Sijia Deng; Zhao Zhang; Cheqing Jin; Yingjie Yang; Gang Qin

doi:10.1007/978-3-030-73200-4_48

SQL-Middleware: Enabling the Blockchain with SQL

Xing Tong, Haibo Tang, Nan Jiang, Wei Fan, Yichen Gao, Sijia Deng, Zhao Zhang, Cheqing Jin, Yingjie Yang, Gang Qin

School of Data Science and Engineering

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

3 Scopus citations

Abstract

With the development of blockchain, blockchain has a broad prospect as a new type of data management system. However, limited to the data modeling method of blockchain, the usability of blockchain is restricted; In addition, every blockchain system has its own native but naive interfaces, when developing based on the different blockchain systems, which will leads to low development efficiency and high development costs. In this study, we construct a SQL-Middleware for blockchain system to solve these problems. The SQL-Middleware first performs relational modeling of blockchain data, mapping the blockchain data into a relational table; On the basis of modeling the blockchain data, SQL-Middleware encapsulates a set of SQL interfaces for blockchain system, thus realizing the unification of interface access methods of different blockchain systems. At last, we implement the SQL-Middleware based on the open source blockchain system CITA. Demonstration shows that the SQL-Middleware greatly improves the data management capabilities of blockchain and simplifies the blockchain access steps.

Original language	English
Title of host publication	Database Systems for Advanced Applications - 26th International Conference, DASFAA 2021, Proceedings
Editors	Christian S. Jensen, Ee-Peng Lim, De-Nian Yang, Wang-Chien Lee, Vincent S. Tseng, Vana Kalogeraki, Jen-Wei Huang, Chih-Ya Shen
Publisher	Springer Science and Business Media Deutschland GmbH
Pages	622-626
Number of pages	5
ISBN (Print)	9783030731991
DOIs	https://doi.org/10.1007/978-3-030-73200-4_48
State	Published - 2021
Event	26th International Conference on Database Systems for Advanced Applications, DASFAA 2021 - Taipei, Taiwan, Province of China Duration: 11 Apr 2021 → 14 Apr 2021

Publication series

Name	Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume	12683 LNCS
ISSN (Print)	0302-9743
ISSN (Electronic)	1611-3349

Conference

Conference	26th International Conference on Database Systems for Advanced Applications, DASFAA 2021
Country/Territory	Taiwan, Province of China
City	Taipei
Period	11/04/21 → 14/04/21

Keywords

Blockchain
Data modeling
Middleware
SQL

Access to Document

10.1007/978-3-030-73200-4_48

Cite this

Tong, X., Tang, H., Jiang, N., Fan, W., Gao, Y., Deng, S., Zhang, Z., Jin, C., Yang, Y., & Qin, G. (2021). SQL-Middleware: Enabling the Blockchain with SQL. In C. S. Jensen, E.-P. Lim, D.-N. Yang, W.-C. Lee, V. S. Tseng, V. Kalogeraki, J.-W. Huang, & C.-Y. Shen (Eds.), Database Systems for Advanced Applications - 26th International Conference, DASFAA 2021, Proceedings (pp. 622-626). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 12683 LNCS). Springer Science and Business Media Deutschland GmbH. https://doi.org/10.1007/978-3-030-73200-4_48

Tong, Xing ; Tang, Haibo ; Jiang, Nan et al. / SQL-Middleware : Enabling the Blockchain with SQL. Database Systems for Advanced Applications - 26th International Conference, DASFAA 2021, Proceedings. editor / Christian S. Jensen ; Ee-Peng Lim ; De-Nian Yang ; Wang-Chien Lee ; Vincent S. Tseng ; Vana Kalogeraki ; Jen-Wei Huang ; Chih-Ya Shen. Springer Science and Business Media Deutschland GmbH, 2021. pp. 622-626 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).

@inproceedings{cd773a2d401142bbada026cccfeadf4d,

title = "SQL-Middleware: Enabling the Blockchain with SQL",

abstract = "With the development of blockchain, blockchain has a broad prospect as a new type of data management system. However, limited to the data modeling method of blockchain, the usability of blockchain is restricted; In addition, every blockchain system has its own native but naive interfaces, when developing based on the different blockchain systems, which will leads to low development efficiency and high development costs. In this study, we construct a SQL-Middleware for blockchain system to solve these problems. The SQL-Middleware first performs relational modeling of blockchain data, mapping the blockchain data into a relational table; On the basis of modeling the blockchain data, SQL-Middleware encapsulates a set of SQL interfaces for blockchain system, thus realizing the unification of interface access methods of different blockchain systems. At last, we implement the SQL-Middleware based on the open source blockchain system CITA. Demonstration shows that the SQL-Middleware greatly improves the data management capabilities of blockchain and simplifies the blockchain access steps.",

keywords = "Blockchain, Data modeling, Middleware, SQL",

author = "Xing Tong and Haibo Tang and Nan Jiang and Wei Fan and Yichen Gao and Sijia Deng and Zhao Zhang and Cheqing Jin and Yingjie Yang and Gang Qin",

note = "Publisher Copyright: {\textcopyright} 2021, Springer Nature Switzerland AG.; 26th International Conference on Database Systems for Advanced Applications, DASFAA 2021 ; Conference date: 11-04-2021 Through 14-04-2021",

year = "2021",

doi = "10.1007/978-3-030-73200-4\_48",

language = "英语",

isbn = "9783030731991",

series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",

publisher = "Springer Science and Business Media Deutschland GmbH",

pages = "622--626",

editor = "Jensen, \{Christian S.\} and Ee-Peng Lim and De-Nian Yang and Wang-Chien Lee and Tseng, \{Vincent S.\} and Vana Kalogeraki and Jen-Wei Huang and Chih-Ya Shen",

booktitle = "Database Systems for Advanced Applications - 26th International Conference, DASFAA 2021, Proceedings",

address = "德国",

}

Tong, X, Tang, H, Jiang, N, Fan, W, Gao, Y, Deng, S, Zhang, Z , Jin, C, Yang, Y & Qin, G 2021, SQL-Middleware: Enabling the Blockchain with SQL. in CS Jensen, E-P Lim, D-N Yang, W-C Lee, VS Tseng, V Kalogeraki, J-W Huang & C-Y Shen (eds), Database Systems for Advanced Applications - 26th International Conference, DASFAA 2021, Proceedings. Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), vol. 12683 LNCS, Springer Science and Business Media Deutschland GmbH, pp. 622-626, 26th International Conference on Database Systems for Advanced Applications, DASFAA 2021, Taipei, Taiwan, Province of China, 11/04/21. https://doi.org/10.1007/978-3-030-73200-4_48

SQL-Middleware: Enabling the Blockchain with SQL. / Tong, Xing; Tang, Haibo; Jiang, Nan et al.
Database Systems for Advanced Applications - 26th International Conference, DASFAA 2021, Proceedings. ed. / Christian S. Jensen; Ee-Peng Lim; De-Nian Yang; Wang-Chien Lee; Vincent S. Tseng; Vana Kalogeraki; Jen-Wei Huang; Chih-Ya Shen. Springer Science and Business Media Deutschland GmbH, 2021. p. 622-626 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 12683 LNCS).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

TY - GEN

T1 - SQL-Middleware

T2 - 26th International Conference on Database Systems for Advanced Applications, DASFAA 2021

AU - Tong, Xing

AU - Tang, Haibo

AU - Jiang, Nan

AU - Fan, Wei

AU - Gao, Yichen

AU - Deng, Sijia

AU - Zhang, Zhao

AU - Jin, Cheqing

AU - Yang, Yingjie

AU - Qin, Gang

PY - 2021

Y1 - 2021

N2 - With the development of blockchain, blockchain has a broad prospect as a new type of data management system. However, limited to the data modeling method of blockchain, the usability of blockchain is restricted; In addition, every blockchain system has its own native but naive interfaces, when developing based on the different blockchain systems, which will leads to low development efficiency and high development costs. In this study, we construct a SQL-Middleware for blockchain system to solve these problems. The SQL-Middleware first performs relational modeling of blockchain data, mapping the blockchain data into a relational table; On the basis of modeling the blockchain data, SQL-Middleware encapsulates a set of SQL interfaces for blockchain system, thus realizing the unification of interface access methods of different blockchain systems. At last, we implement the SQL-Middleware based on the open source blockchain system CITA. Demonstration shows that the SQL-Middleware greatly improves the data management capabilities of blockchain and simplifies the blockchain access steps.

AB - With the development of blockchain, blockchain has a broad prospect as a new type of data management system. However, limited to the data modeling method of blockchain, the usability of blockchain is restricted; In addition, every blockchain system has its own native but naive interfaces, when developing based on the different blockchain systems, which will leads to low development efficiency and high development costs. In this study, we construct a SQL-Middleware for blockchain system to solve these problems. The SQL-Middleware first performs relational modeling of blockchain data, mapping the blockchain data into a relational table; On the basis of modeling the blockchain data, SQL-Middleware encapsulates a set of SQL interfaces for blockchain system, thus realizing the unification of interface access methods of different blockchain systems. At last, we implement the SQL-Middleware based on the open source blockchain system CITA. Demonstration shows that the SQL-Middleware greatly improves the data management capabilities of blockchain and simplifies the blockchain access steps.

KW - Blockchain

KW - Data modeling

KW - Middleware

KW - SQL

UR - https://www.scopus.com/pages/publications/85104769693

U2 - 10.1007/978-3-030-73200-4_48

DO - 10.1007/978-3-030-73200-4_48

M3 - 会议稿件

AN - SCOPUS:85104769693

SN - 9783030731991

T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

SP - 622

EP - 626

BT - Database Systems for Advanced Applications - 26th International Conference, DASFAA 2021, Proceedings

A2 - Jensen, Christian S.

A2 - Lim, Ee-Peng

A2 - Yang, De-Nian

A2 - Lee, Wang-Chien

A2 - Tseng, Vincent S.

A2 - Kalogeraki, Vana

A2 - Huang, Jen-Wei

A2 - Shen, Chih-Ya

PB - Springer Science and Business Media Deutschland GmbH

Y2 - 11 April 2021 through 14 April 2021

ER -

Tong X, Tang H, Jiang N, Fan W, Gao Y, Deng S et al. SQL-Middleware: Enabling the Blockchain with SQL. In Jensen CS, Lim EP, Yang DN, Lee WC, Tseng VS, Kalogeraki V, Huang JW, Shen CY, editors, Database Systems for Advanced Applications - 26th International Conference, DASFAA 2021, Proceedings. Springer Science and Business Media Deutschland GmbH. 2021. p. 622-626. (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)). doi: 10.1007/978-3-030-73200-4_48

SQL-Middleware: Enabling the Blockchain with SQL

Abstract

Publication series

Conference

Keywords

Access to Document

Other files and links

Fingerprint

Cite this