Towards a hybrid relational and XML benchmark for loosely-coupled distributed data sources

Mahesh B. Chaudhari, Suzanne Dietrich, Jennifer Ortiz, Spencer Pearson

Research output: Contribution to journalArticle

1 Citation (Scopus)

Abstract

There are known benchmarks for the performance evaluation of relational and XML databases. However, there is an increasing demand for database applications that require access to heterogeneous loosely-coupled distributed data sources. This paper presents a hybrid benchmark based on TPC-H where the data sources are heterogeneous. Specifically, the paper describes the design of the relational and XML data sources as well as the query redesign in the LINQ query language, which supports queries over heterogeneous data sources. The results of a performance evaluation of the hybrid benchmark over various database products is included for untyped and typed XML with and without clearing the database cache.

Original languageEnglish (US)
Pages (from-to)78-87
Number of pages10
JournalJournal of Systems and Software
Volume109
DOIs
StatePublished - Nov 1 2015

Fingerprint

XML
Query languages

Keywords

  • Benchmark
  • Heterogeneous
  • LINQ

ASJC Scopus subject areas

  • Hardware and Architecture
  • Software
  • Information Systems

Cite this

Towards a hybrid relational and XML benchmark for loosely-coupled distributed data sources. / Chaudhari, Mahesh B.; Dietrich, Suzanne; Ortiz, Jennifer; Pearson, Spencer.

In: Journal of Systems and Software, Vol. 109, 01.11.2015, p. 78-87.

Research output: Contribution to journalArticle

Chaudhari, Mahesh B. ; Dietrich, Suzanne ; Ortiz, Jennifer ; Pearson, Spencer. / Towards a hybrid relational and XML benchmark for loosely-coupled distributed data sources. In: Journal of Systems and Software. 2015 ; Vol. 109. pp. 78-87.
@article{004b005878b84428937c649ef4fae35c,
title = "Towards a hybrid relational and XML benchmark for loosely-coupled distributed data sources",
abstract = "There are known benchmarks for the performance evaluation of relational and XML databases. However, there is an increasing demand for database applications that require access to heterogeneous loosely-coupled distributed data sources. This paper presents a hybrid benchmark based on TPC-H where the data sources are heterogeneous. Specifically, the paper describes the design of the relational and XML data sources as well as the query redesign in the LINQ query language, which supports queries over heterogeneous data sources. The results of a performance evaluation of the hybrid benchmark over various database products is included for untyped and typed XML with and without clearing the database cache.",
keywords = "Benchmark, Heterogeneous, LINQ",
author = "Chaudhari, {Mahesh B.} and Suzanne Dietrich and Jennifer Ortiz and Spencer Pearson",
year = "2015",
month = "11",
day = "1",
doi = "10.1016/j.jss.2015.07.029",
language = "English (US)",
volume = "109",
pages = "78--87",
journal = "Journal of Systems and Software",
issn = "0164-1212",
publisher = "Elsevier Inc.",

}

TY - JOUR

T1 - Towards a hybrid relational and XML benchmark for loosely-coupled distributed data sources

AU - Chaudhari, Mahesh B.

AU - Dietrich, Suzanne

AU - Ortiz, Jennifer

AU - Pearson, Spencer

PY - 2015/11/1

Y1 - 2015/11/1

N2 - There are known benchmarks for the performance evaluation of relational and XML databases. However, there is an increasing demand for database applications that require access to heterogeneous loosely-coupled distributed data sources. This paper presents a hybrid benchmark based on TPC-H where the data sources are heterogeneous. Specifically, the paper describes the design of the relational and XML data sources as well as the query redesign in the LINQ query language, which supports queries over heterogeneous data sources. The results of a performance evaluation of the hybrid benchmark over various database products is included for untyped and typed XML with and without clearing the database cache.

AB - There are known benchmarks for the performance evaluation of relational and XML databases. However, there is an increasing demand for database applications that require access to heterogeneous loosely-coupled distributed data sources. This paper presents a hybrid benchmark based on TPC-H where the data sources are heterogeneous. Specifically, the paper describes the design of the relational and XML data sources as well as the query redesign in the LINQ query language, which supports queries over heterogeneous data sources. The results of a performance evaluation of the hybrid benchmark over various database products is included for untyped and typed XML with and without clearing the database cache.

KW - Benchmark

KW - Heterogeneous

KW - LINQ

UR - http://www.scopus.com/inward/record.url?scp=84941269110&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84941269110&partnerID=8YFLogxK

U2 - 10.1016/j.jss.2015.07.029

DO - 10.1016/j.jss.2015.07.029

M3 - Article

AN - SCOPUS:84941269110

VL - 109

SP - 78

EP - 87

JO - Journal of Systems and Software

JF - Journal of Systems and Software

SN - 0164-1212

ER -