Distributed queries and query optimization in schema-based P2P-systems

Research output: Chapter in book/report/conference proceedingContribution to book/anthologyResearchpeer review

Authors

  • Ingo Brunkhorst
  • Hadhami Dhraief
  • Alfons Kemper
  • Wolfgang Nejdl
  • Christian Wiesner

External Research Organisations

  • University of Passau
View graph of relations

Details

Original languageEnglish
Title of host publicationDBISP2P 2003
Subtitle of host publicationDatabases, Information Systems, and Peer-to-Peer Computing
EditorsKarl Aberer, Manolis Koubarakis, Vana Kalogeraki
PublisherSpringer Verlag
Pages184-199
Number of pages16
ISBN (electronic)978-3-540-24629-9
ISBN (print)978-3-540-20968-3
Publication statusPublished - 2004

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume2944
ISSN (Print)0302-9743
ISSN (electronic)1611-3349

Abstract

Databases have employed a schema-based approach to store and retrieve structured data for decades. For peer-to-peer (P2P) networks, similar approaches are just beginning to emerge, also motivated by the fact, that sending (atomic) queries to the appropriate peers clearly fails for queries which need data from more than one peer to be executed. While quite a few database techniques can be re-used in this new context, a P2P data management infrastructure poses additional challenges which have to be solved before schema-based P2P networks become as common as schema-based databases. Because of the dynamic nature of P2P networks, we can neither assume global knowledge about data distribution, nor are static topologies and static query plans suitable for these networks. Unlike in traditional distributed database systems, we cannot assume a complete schema instance but rather work with a distributed schema which directs query processing tasks from one node to one or more neighboring nodes. In this paper, we will first discuss a suitable topology for schema-based P2P networks and how distributed knowledge about data distribution can be stored, accessed and updated based on that topology. Second we will describe how this knowledge can be used to distribute abstract query plans through the P2P network and expand them on the fly such that we can place query operators next to data sources and utilize distributed computing resources more effectively.

ASJC Scopus subject areas

Cite this

Distributed queries and query optimization in schema-based P2P-systems. / Brunkhorst, Ingo; Dhraief, Hadhami; Kemper, Alfons et al.
DBISP2P 2003: Databases, Information Systems, and Peer-to-Peer Computing . ed. / Karl Aberer; Manolis Koubarakis; Vana Kalogeraki. Springer Verlag, 2004. p. 184-199 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 2944).

Research output: Chapter in book/report/conference proceedingContribution to book/anthologyResearchpeer review

Brunkhorst, I, Dhraief, H, Kemper, A, Nejdl, W & Wiesner, C 2004, Distributed queries and query optimization in schema-based P2P-systems. in K Aberer, M Koubarakis & V Kalogeraki (eds), DBISP2P 2003: Databases, Information Systems, and Peer-to-Peer Computing . Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), vol. 2944, Springer Verlag, pp. 184-199. https://doi.org/10.1007/978-3-540-24629-9_14
Brunkhorst, I., Dhraief, H., Kemper, A., Nejdl, W., & Wiesner, C. (2004). Distributed queries and query optimization in schema-based P2P-systems. In K. Aberer, M. Koubarakis, & V. Kalogeraki (Eds.), DBISP2P 2003: Databases, Information Systems, and Peer-to-Peer Computing (pp. 184-199). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 2944). Springer Verlag. https://doi.org/10.1007/978-3-540-24629-9_14
Brunkhorst I, Dhraief H, Kemper A, Nejdl W, Wiesner C. Distributed queries and query optimization in schema-based P2P-systems. In Aberer K, Koubarakis M, Kalogeraki V, editors, DBISP2P 2003: Databases, Information Systems, and Peer-to-Peer Computing . Springer Verlag. 2004. p. 184-199. (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)). doi: 10.1007/978-3-540-24629-9_14
Brunkhorst, Ingo ; Dhraief, Hadhami ; Kemper, Alfons et al. / Distributed queries and query optimization in schema-based P2P-systems. DBISP2P 2003: Databases, Information Systems, and Peer-to-Peer Computing . editor / Karl Aberer ; Manolis Koubarakis ; Vana Kalogeraki. Springer Verlag, 2004. pp. 184-199 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).
Download
@inbook{ae361c961d254ac2b51faeee2b34e0c9,
title = "Distributed queries and query optimization in schema-based P2P-systems",
abstract = "Databases have employed a schema-based approach to store and retrieve structured data for decades. For peer-to-peer (P2P) networks, similar approaches are just beginning to emerge, also motivated by the fact, that sending (atomic) queries to the appropriate peers clearly fails for queries which need data from more than one peer to be executed. While quite a few database techniques can be re-used in this new context, a P2P data management infrastructure poses additional challenges which have to be solved before schema-based P2P networks become as common as schema-based databases. Because of the dynamic nature of P2P networks, we can neither assume global knowledge about data distribution, nor are static topologies and static query plans suitable for these networks. Unlike in traditional distributed database systems, we cannot assume a complete schema instance but rather work with a distributed schema which directs query processing tasks from one node to one or more neighboring nodes. In this paper, we will first discuss a suitable topology for schema-based P2P networks and how distributed knowledge about data distribution can be stored, accessed and updated based on that topology. Second we will describe how this knowledge can be used to distribute abstract query plans through the P2P network and expand them on the fly such that we can place query operators next to data sources and utilize distributed computing resources more effectively.",
author = "Ingo Brunkhorst and Hadhami Dhraief and Alfons Kemper and Wolfgang Nejdl and Christian Wiesner",
year = "2004",
doi = "10.1007/978-3-540-24629-9_14",
language = "English",
isbn = "978-3-540-20968-3",
series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",
publisher = "Springer Verlag",
pages = "184--199",
editor = "Karl Aberer and Manolis Koubarakis and Vana Kalogeraki",
booktitle = "DBISP2P 2003",
address = "Germany",

}

Download

TY - CHAP

T1 - Distributed queries and query optimization in schema-based P2P-systems

AU - Brunkhorst, Ingo

AU - Dhraief, Hadhami

AU - Kemper, Alfons

AU - Nejdl, Wolfgang

AU - Wiesner, Christian

PY - 2004

Y1 - 2004

N2 - Databases have employed a schema-based approach to store and retrieve structured data for decades. For peer-to-peer (P2P) networks, similar approaches are just beginning to emerge, also motivated by the fact, that sending (atomic) queries to the appropriate peers clearly fails for queries which need data from more than one peer to be executed. While quite a few database techniques can be re-used in this new context, a P2P data management infrastructure poses additional challenges which have to be solved before schema-based P2P networks become as common as schema-based databases. Because of the dynamic nature of P2P networks, we can neither assume global knowledge about data distribution, nor are static topologies and static query plans suitable for these networks. Unlike in traditional distributed database systems, we cannot assume a complete schema instance but rather work with a distributed schema which directs query processing tasks from one node to one or more neighboring nodes. In this paper, we will first discuss a suitable topology for schema-based P2P networks and how distributed knowledge about data distribution can be stored, accessed and updated based on that topology. Second we will describe how this knowledge can be used to distribute abstract query plans through the P2P network and expand them on the fly such that we can place query operators next to data sources and utilize distributed computing resources more effectively.

AB - Databases have employed a schema-based approach to store and retrieve structured data for decades. For peer-to-peer (P2P) networks, similar approaches are just beginning to emerge, also motivated by the fact, that sending (atomic) queries to the appropriate peers clearly fails for queries which need data from more than one peer to be executed. While quite a few database techniques can be re-used in this new context, a P2P data management infrastructure poses additional challenges which have to be solved before schema-based P2P networks become as common as schema-based databases. Because of the dynamic nature of P2P networks, we can neither assume global knowledge about data distribution, nor are static topologies and static query plans suitable for these networks. Unlike in traditional distributed database systems, we cannot assume a complete schema instance but rather work with a distributed schema which directs query processing tasks from one node to one or more neighboring nodes. In this paper, we will first discuss a suitable topology for schema-based P2P networks and how distributed knowledge about data distribution can be stored, accessed and updated based on that topology. Second we will describe how this knowledge can be used to distribute abstract query plans through the P2P network and expand them on the fly such that we can place query operators next to data sources and utilize distributed computing resources more effectively.

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

U2 - 10.1007/978-3-540-24629-9_14

DO - 10.1007/978-3-540-24629-9_14

M3 - Contribution to book/anthology

AN - SCOPUS:33749470038

SN - 978-3-540-20968-3

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

SP - 184

EP - 199

BT - DBISP2P 2003

A2 - Aberer, Karl

A2 - Koubarakis, Manolis

A2 - Kalogeraki, Vana

PB - Springer Verlag

ER -

By the same author(s)