Demo Data from EDBT 2026 / reviewers in the wild / expert
Christian Koenig
dblp:57/2391
· DBLP profile ↗
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
| Topic | Weight | Papers | Last | Evidence papers |
|---|---|---|---|---|
Query processing and optimization
cardinality estimation |
0.0 | 1 | 2004 | A Bi-Level Bernoulli Scheme for Database Sampling · SIGMOD Conference 2004 |
Query processing and optimization
query optimization |
0.0 | 1 | 2004 | A Bi-Level Bernoulli Scheme for Database Sampling · SIGMOD Conference 2004 |
Data mining
sampling |
0.0 | 1 | 2004 | A Bi-Level Bernoulli Scheme for Database Sampling · SIGMOD Conference 2004 |
Information retrieval
query sampling |
0.0 | 1 | 2004 | A Bi-Level Bernoulli Scheme for Database Sampling · SIGMOD Conference 2004 |
Data models and query languages › SQL
SQL extension |
0.0 | 1 | 2004 | 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
| Year | Publication | Venue | Position |
|---|---|---|---|
| 2004 | A Bi-Level Bernoulli Scheme for Database SamplingabstractCurrent 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 Conference | 2 |