Processing and optimization of complex queries in schema-based P2P-networks

Research output: Chapter in book/report/conference proceedingConference contributionResearchpeer review

Authors

External Research Organisations

  • Technical University of Munich (TUM)
  • University of Passau
View graph of relations

Details

Original languageEnglish
Title of host publicationDBISP2P 2004
Subtitle of host publicationDatabases, Information Systems, and Peer-to-Peer Computing
Pages31-45
Number of pages15
ISBN (electronic)978-3-540-31838-5
Publication statusPublished - 2005
EventSecond International Workshop on Databases, Information Systems, and Peer-to-Peer Computing, DBISP2P 2004 - Toronto, Ont., Canada
Duration: 29 Aug 200430 Aug 2004

Publication series

NameLecture Notes in Computer Science
PublisherSpringer Verlag
Volume3367
ISSN (Print)0302-9743

Abstract

Peer-to-Peer infrastructures are emerging as one of the important data management infrastructures in the World Wide Web. So far, however, most work has focused on simple P2P networks which tackle efficient query distribution to a large set of peers but assume that each query can be answered completely at each peer. For queries which need data from more than one peer to be executed this is clearly insufficient. Unfortunately, though quite a few database techniques can be re-used in the P2P context, P2P data management infrastructures pose additional challenges caused by the dynamic nature of these networks. In P2P networks, we can assume neither global knowledge about data distribution, nor the suitableness of static topologies and static query plans for these networks. Unlike in traditional distributed database systems, we cannot assume complete information schema and allocation schema instances but rather work with distributed schema information which can only direct query processing tasks from one node to one or more neighboring nodes. In this paper we first describe briefly our super-peer based topology and schema-aware distributed routing indices extended with suitable statistics and describe how this information is extracted and updated. Second we show how these indices facilitate the distribution and dynamic expansion of query plans. Third we propose a set of transformation rules to optimize query plans and discuss different optimization strategies in detail, enabling efficient distributed query processing in a schema-based P2P network.

ASJC Scopus subject areas

Cite this

Processing and optimization of complex queries in schema-based P2P-networks. / Dhraief, Hadhami; Kemper, Alfons; Nejdl, Wolfgang et al.
DBISP2P 2004: Databases, Information Systems, and Peer-to-Peer Computing. 2005. p. 31-45 (Lecture Notes in Computer Science; Vol. 3367).

Research output: Chapter in book/report/conference proceedingConference contributionResearchpeer review

Dhraief, H, Kemper, A, Nejdl, W & Wiesner, C 2005, Processing and optimization of complex queries in schema-based P2P-networks. in DBISP2P 2004: Databases, Information Systems, and Peer-to-Peer Computing. Lecture Notes in Computer Science, vol. 3367, pp. 31-45, Second International Workshop on Databases, Information Systems, and Peer-to-Peer Computing, DBISP2P 2004, Toronto, Ont., Canada, 29 Aug 2004. https://doi.org/10.1007/978-3-540-31838-5_3
Dhraief, H., Kemper, A., Nejdl, W., & Wiesner, C. (2005). Processing and optimization of complex queries in schema-based P2P-networks. In DBISP2P 2004: Databases, Information Systems, and Peer-to-Peer Computing (pp. 31-45). (Lecture Notes in Computer Science; Vol. 3367). https://doi.org/10.1007/978-3-540-31838-5_3
Dhraief H, Kemper A, Nejdl W, Wiesner C. Processing and optimization of complex queries in schema-based P2P-networks. In DBISP2P 2004: Databases, Information Systems, and Peer-to-Peer Computing. 2005. p. 31-45. (Lecture Notes in Computer Science). doi: 10.1007/978-3-540-31838-5_3
Dhraief, Hadhami ; Kemper, Alfons ; Nejdl, Wolfgang et al. / Processing and optimization of complex queries in schema-based P2P-networks. DBISP2P 2004: Databases, Information Systems, and Peer-to-Peer Computing. 2005. pp. 31-45 (Lecture Notes in Computer Science).
Download
@inproceedings{8f05cb12bd7440578813b55b995a5f8c,
title = "Processing and optimization of complex queries in schema-based P2P-networks",
abstract = "Peer-to-Peer infrastructures are emerging as one of the important data management infrastructures in the World Wide Web. So far, however, most work has focused on simple P2P networks which tackle efficient query distribution to a large set of peers but assume that each query can be answered completely at each peer. For queries which need data from more than one peer to be executed this is clearly insufficient. Unfortunately, though quite a few database techniques can be re-used in the P2P context, P2P data management infrastructures pose additional challenges caused by the dynamic nature of these networks. In P2P networks, we can assume neither global knowledge about data distribution, nor the suitableness of static topologies and static query plans for these networks. Unlike in traditional distributed database systems, we cannot assume complete information schema and allocation schema instances but rather work with distributed schema information which can only direct query processing tasks from one node to one or more neighboring nodes. In this paper we first describe briefly our super-peer based topology and schema-aware distributed routing indices extended with suitable statistics and describe how this information is extracted and updated. Second we show how these indices facilitate the distribution and dynamic expansion of query plans. Third we propose a set of transformation rules to optimize query plans and discuss different optimization strategies in detail, enabling efficient distributed query processing in a schema-based P2P network.",
author = "Hadhami Dhraief and Alfons Kemper and Wolfgang Nejdl and Christian Wiesner",
year = "2005",
doi = "10.1007/978-3-540-31838-5_3",
language = "English",
isbn = "978-3-540-25233-7",
series = "Lecture Notes in Computer Science",
publisher = "Springer Verlag",
pages = "31--45",
booktitle = "DBISP2P 2004",
note = "Second International Workshop on Databases, Information Systems, and Peer-to-Peer Computing, DBISP2P 2004 ; Conference date: 29-08-2004 Through 30-08-2004",

}

Download

TY - GEN

T1 - Processing and optimization of complex queries in schema-based P2P-networks

AU - Dhraief, Hadhami

AU - Kemper, Alfons

AU - Nejdl, Wolfgang

AU - Wiesner, Christian

PY - 2005

Y1 - 2005

N2 - Peer-to-Peer infrastructures are emerging as one of the important data management infrastructures in the World Wide Web. So far, however, most work has focused on simple P2P networks which tackle efficient query distribution to a large set of peers but assume that each query can be answered completely at each peer. For queries which need data from more than one peer to be executed this is clearly insufficient. Unfortunately, though quite a few database techniques can be re-used in the P2P context, P2P data management infrastructures pose additional challenges caused by the dynamic nature of these networks. In P2P networks, we can assume neither global knowledge about data distribution, nor the suitableness of static topologies and static query plans for these networks. Unlike in traditional distributed database systems, we cannot assume complete information schema and allocation schema instances but rather work with distributed schema information which can only direct query processing tasks from one node to one or more neighboring nodes. In this paper we first describe briefly our super-peer based topology and schema-aware distributed routing indices extended with suitable statistics and describe how this information is extracted and updated. Second we show how these indices facilitate the distribution and dynamic expansion of query plans. Third we propose a set of transformation rules to optimize query plans and discuss different optimization strategies in detail, enabling efficient distributed query processing in a schema-based P2P network.

AB - Peer-to-Peer infrastructures are emerging as one of the important data management infrastructures in the World Wide Web. So far, however, most work has focused on simple P2P networks which tackle efficient query distribution to a large set of peers but assume that each query can be answered completely at each peer. For queries which need data from more than one peer to be executed this is clearly insufficient. Unfortunately, though quite a few database techniques can be re-used in the P2P context, P2P data management infrastructures pose additional challenges caused by the dynamic nature of these networks. In P2P networks, we can assume neither global knowledge about data distribution, nor the suitableness of static topologies and static query plans for these networks. Unlike in traditional distributed database systems, we cannot assume complete information schema and allocation schema instances but rather work with distributed schema information which can only direct query processing tasks from one node to one or more neighboring nodes. In this paper we first describe briefly our super-peer based topology and schema-aware distributed routing indices extended with suitable statistics and describe how this information is extracted and updated. Second we show how these indices facilitate the distribution and dynamic expansion of query plans. Third we propose a set of transformation rules to optimize query plans and discuss different optimization strategies in detail, enabling efficient distributed query processing in a schema-based P2P network.

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

U2 - 10.1007/978-3-540-31838-5_3

DO - 10.1007/978-3-540-31838-5_3

M3 - Conference contribution

AN - SCOPUS:24144454784

SN - 978-3-540-25233-7

T3 - Lecture Notes in Computer Science

SP - 31

EP - 45

BT - DBISP2P 2004

T2 - Second International Workshop on Databases, Information Systems, and Peer-to-Peer Computing, DBISP2P 2004

Y2 - 29 August 2004 through 30 August 2004

ER -

By the same author(s)