An Efficient Nested Query Processing for Distributed Database Systems

Autor:	Hun-Gi Kim, Yu-Jin Kang, Wan-Sup Cho, Chi-Hawn Choi, Kyung-En Yang
Rok vydání:	2011
Předmět:	Distributed database View Computer science Distributed computing Online analytical processing InformationSystems_INFORMATIONSTORAGEANDRETRIEVAL InformationSystems_DATABASEMANAGEMENT Query optimization Data warehouse Database tuning Nested SQL Nested set model
Zdroj:	Convergence and Hybrid Information Technology ISBN: 9783642241055 ICHIT (2)
DOI:	10.1007/978-3-642-24106-2_85
Popis:	Performance of OLAP queries becomes a critical issue as the amount of data in the data warehouses increases rapidly. To solve this performance issue, we proposed a high performance database cluster system called HyperDB in which many PCs can be mobilized for excellent performance. In HyperDB, an OLAP query can be decomposed into sub-queries, and each of the sub-queries can be processed independently on a PC in a short time. But if an OLAP query has nested form (i.e., nested SQL), it could not be decomposed into sub-queries. In this paper, we propose a parallel distributed query processing algorithm for nested queries in HyperDB system. Traditionally, parallel distributed processing of nested queries is known as a difficult problem in the database area.
Databáze:	OpenAIRE
Externí odkaz:	https://explore.openaire.eu/search/publication?articleId=doi_________::0983d0da838a0c9f811ba90d917386f8 https://doi.org/10.1007/978-3-642-24106-2_85 Zobrazit plný text záznamu