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. A simulation from public publication records: the people listed were not invited and did not agree to review.
? Tutorial for this page

Christian Koenig

dblp:57/2391 · DBLP profile ↗
← Back
1ranked-venue papers
0as first author
0since 2021 · last 2004
—ORCID · none

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

Databases, data management, data science and information retrieval · 1

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
1 paper
Query processing and optimization · 56% Data mining · 28% Data models and query languages · 8%

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

TopicWeightPapersLastEvidence papers
Query processing and optimization
cardinality estimation
0.012004
A Bi-Level Bernoulli Scheme for Database Sampling · SIGMOD Conference 2004
Query processing and optimization
query optimization
0.012004
A Bi-Level Bernoulli Scheme for Database Sampling · SIGMOD Conference 2004
Data mining
sampling
0.012004
A Bi-Level Bernoulli Scheme for Database Sampling · SIGMOD Conference 2004
Information retrieval
query sampling
0.012004
A Bi-Level Bernoulli Scheme for Database Sampling · SIGMOD Conference 2004
Data models and query languages › SQL
SQL extension
0.012004
A Bi-Level Bernoulli Scheme for Database Sampling · SIGMOD Conference 2004

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

pilot sampling · 0.0heuristic parameter setting · 0.0bernoulli sampling · 0.0
YearPublicationVenuePosition
2004 A Bi-Level Bernoulli Scheme for Database Sampling
abstract
Current database sampling methods give the user insufficient control when processing ISO-style sampling queries. To address this problem, we provide a bi-level Bernoulli sampling scheme that combines the row-level and page-level sampling methods currently used in most commercial systems. By adjusting the parameters of the method, the user can systematically trade off processing speed and statistical precision---the appropriate choice of parameter settings becomes a query optimization problem. We indicate the SQL extensions needed to support bi-level sampling and determine the optimal parameter settings for an important class of sampling queries with explicit time or accuracy constraints. As might be expected, row-level sampling is preferable when data values on each page are homogeneous, whereas page-level sampling should be used when data values on a page vary widely. Perhaps surprisingly, we show that in many cases the optimal sampling policy is of the "bang-bang" type: we identify a "page-heterogeneity index" (PHI) such that optimal sampling is as "row-like" as possible if the PHI is less than 1 and as "page-like" as possible otherwise. The PHI depends upon both the query and the data, and can be estimated by means of a pilot sample. Because pilot sampling can be nontrivial to implement in commercial database systems, we also give a heuristic method for setting the sampling parameters; the method avoids pilot sampling by using a small number of summary statistics that are maintained in the system catalog. Results from over 1100 experiments on 372 real and synthetic data sets show that the heuristic method performs optimally about half of the time, and yields sampling errors within a factor of 2.2 of optimal about 93% of the time. The heuristic method is stable over a wide range of sampling rates and performs best in the most critical cases, where the data is highly clustered or skewed.
Peter J. Haas, Christian Koenig
SIGMOD Conference2