Demonstration venue · read-only. Every page can be browsed; the buttons that would change it are switched off. Create an account to run TaxoReview on your own data.

Holger Kache

dblp:86/2924 · DBLP profile ↗
← Back
3ranked-venue papers
1as first author
0since 2021 · last 2007
—ORCID · none

Domains — the database's venue-derived domains; a paper can count in several

Databases, data management, data science and information retrieval · 3 · 1 first-author

Expertise — from the expertise taxonomy: the topics of the expert's papers under the CCF categories. A weight counts papers with recency: 1 for a paper about the topic, 0.3 when the topic is its context, halved every five years.

Databases, data mining, and information retrieval
2 papers
Query processing and optimization · 82% Distributed and cloud data management · 18%
Computer architecture, parallel and distributed computing, and storage systems
1 paper
Parallel and multicore computing · 100%

Topics — the 6 heaviest of 6, each with the papers that count most for it

TopicWeightPapersLastEvidence papers
Query processing and optimization
cardinality estimation
0.112007
Progressive optimization in a shared-nothing parallel database · SIGMOD Conference 2007
Query processing and optimization › adaptive query processing
progressive optimization
0.112007
Progressive optimization in a shared-nothing parallel database · SIGMOD Conference 2007
Query processing and optimization
query optimization
0.112007
Progressive optimization in a shared-nothing parallel database · SIGMOD Conference 2007
Distributed and cloud data management
federated database
0.112006
POP/FED: Progressive Query Optimization for Federated Queries in DB2 · VLDB 2006
Query processing and optimization › query optimization › distributed query optimization
federated query optimization
0.112006
POP/FED: Progressive Query Optimization for Federated Queries in DB2 · VLDB 2006
Parallel and multicore computing › parallel computing › parallel database systems
shared-nothing parallel database machine
0.012007
Progressive optimization in a shared-nothing parallel database · SIGMOD Conference 2007

Methods — techniques the papers use, named apart from their topics

parallel checkpoint operators · 0.1voting schemes · 0.1voting scheme · 0.1
YearPublicationVenuePosition
2007 Progressive optimization in a shared-nothing parallel database
abstract
Commercial enterprise data warehouses are typically implemented on parallel databases due to the inherent scalability and performance limitation of a serial architecture. Queries used in such large data warehouses can contain complex predicates as well as multiple joins, and the resulting query execution plans generated by the optimizer may be sub-optimal due to mis-estimates of row cardinalities. Progressive optimization (POP) is an approach to detect cardinality estimation errors by monitoring actual cardinalities at run-time and to recover by triggering re-optimization with the actual cardinalities measured. However, the original serial POP solution is based on a serial processing architecture, and the core ideas cannot be readily applied to a parallel shared-nothing environment. Extending the serial POP to a parallel environment is a challenging problem since we need to determine when and how we can trigger re-optimization based on cardinalities collected from multiple independent nodes. In this paper, we present a comprehensive and practical solution to this problem, including several novel voting schemes whether to trigger re-optimization, a mechanism to reuse local intermediate results across nodes as a partitioned materialized view, several flavors of parallel checkpoint operators, and parallel checkpoint processing methods using efficient communication protocols. This solution has been prototyped in a leading commercial parallel DBMS. We have performed extensive experiments using the TPC-H benchmark and a real-world database. Experimental results show that our solution has negligible runtime overhead and accelerates the performance of complex OLAP queries by up to a factor of 22.
Wook-Shin Han, Jack Ng, Volker Markl, Holger Kache, Mokhtar Kandil
SIGMOD Conference4
2006 Progressive Query Optimization for Federated Queries
Stephan Ewen, Holger Kache, Volker Markl, Vijayshankar Raman
EDBT2
2006 POP/FED: Progressive Query Optimization for Federated Queries in DB2
Holger Kache, Wook-Shin Han, Volker Markl, Vijayshankar Raman, Stephan Ewen
VLDB1