S2CX: From relational data via SQL/XML to (Un-)Compressed XML

被引：2

作者：

Boettcher, Stefan ^{[1
]}

Hartel, Rita ^{[1
]}

Wolters, Dennis ^{[1
]}

机构：

[1] Univ Paderborn, Dept Comp Sci, D-33102 Paderborn, Germany

来源：

INFORMATION SYSTEMS | 2016年 / 56卷

关键词：

SQL/XML; XML compression; XML generation from relational databases; COMPRESSION;

D O I：

10.1016/j.is.2015.09.011

中图分类号：

TP [自动化技术、计算机技术];

学科分类号：

0812 ;

摘要：

The gap between storing data in relational databases and transferring data in form of XML has been closed e.g. by SQL/XML queries that generate XML data out of relational data sources. However, only few relational database systems support the evaluation of SQL/XML queries. And even in those systems supporting SQL/XML, the evaluation of such queries is quite slow compared to the evaluation of SQL queries. In this paper, we present S2CX, an approach that allows to efficiently evaluate SQL/XML queries on any relational database system, no matter whether it supports SQL/XML or not. As a result to an SQL/XML query, S2CX supports different output formats ranging from plain XML to different compressed XML representations including a succinct encoding of XML data, schema-aware compressed XML to grammar compressed XML. In many cases, S2CX produces compressed XML as a result to an SQL/XML query even faster than the evaluation of SQL/XML queries into non-compressed XML as provided by Oracle 11 g and by DB2. Furthermore, our approach to query evaluation scales better, i.e., the larger the dataset, the faster is our approach compared to SQL/XML query evaluation in Oracle 11 g and in DB2. (c) 2015 Elsevier Ltd. All rights reserved.

引用

页码：198 / 213

页数：16

共 32 条

[1]

Adiego J, 2004, IEEE DATA COMPR CONF, P112

[2]

Agichtein E, 2003, LECT NOTES COMPUT SC, V2814, P390

[3]

[Anonymous], 2003, 29 INT C VER LARG DA, DOI DOI 10.1016/B978-012722442-8/50021-5

[4]

[Anonymous], 2008, SER SIGMOD 08, DOI DOI 10.1145/1376616.1376650

[5] XQueC: A query-conscious compressed XML database [J].

Arion, Andrei ;

Bonifati, Angela ;

Manolescu, Ioana ;

Pugliese, Andrea .

ACM TRANSACTIONS ON INTERNET TECHNOLOGY, 2007, 7 (02)

[6]

Bayardo R.J., 2004, WWW2004, P345, DOI DOI 10.1145/988672.988719

[7]

Böttcher S, 2008, WEBIST 2008: PROCEEDINGS OF THE FOURTH INTERNATIONAL CONFERENCE ON WEB INFORMATION SYSTEMS AND TECHNOLOGIES, VOL 1, P13

[8] Generalizing and Improving SQL/XML Query Evaluation [J].

Boettcher, Stefan ;

Bokermann, Dennis ;

Hartel, Rita .

8TH INTERNATIONAL CONFERENCE ON SIGNAL IMAGE TECHNOLOGY & INTERNET BASED SYSTEMS (SITIS 2012), 2012, :441-449

[9]

Böttcher S, 2010, ICEIS 2010: PROCEEDINGS OF THE 12TH INTERNATIONAL CONFERENCE ON ENTERPRISE INFORMATION SYSTEMS, VOL 1: DATABASES AND INFORMATION SYSTEMS INTEGRATION, P142

[10]

Böttcher S, 2011, LECT NOTES COMPUT SC, V7051, P209, DOI 10.1007/978-3-642-24577-0_21

← 1 2 3 4 →