Demo Data from EDBT 2026 / reviewers in the wild / expert
Stefan Berchtold
dblp:b/SBerchtold
· DBLP profile ↗
20ranked-venue papers
17as first author
0since 2021 · last 2003
—ORCID · none
Domains — the database's venue-derived domains; a paper can count in several
Databases, data management, data science and information retrieval · 19 · 16 first-authorArtificial intelligence and machine learning · 4 · 4 first-authorSystems, architecture and hardware · 1 · 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
13 papers |
Data mining · 44% Information retrieval · 27% Indexing and storage engines · 20% | |
| Computer graphics and multimedia
3 papers |
Multimedia analysis and retrieval · 73% Geometric modeling and processing · 27% |
Topics — the 25 heaviest of 28, each with the papers that count most for it
| Topic | Weight | Papers | Last | Evidence papers |
|---|---|---|---|---|
Indexing and storage engines › multidimensional indexing
high-dimensional indexing |
0.1 | 5 | 2000 | Independent Quantization: An Index Compression Technique for High-Dimensional Data Spaces · ICDE 2000 High-Dimensional Index Structures, Database Support for Next Decade's Applications (Tutorial) · SIGMOD Conference 1998 The Pyramid-Technique: Towards Breaking the Curse of Dimensionality · SIGMOD Conference 1998 |
Information retrieval › similarity search
nearest neighbor search |
0.1 | 4 | 2000 | Indexing the Solution Space: A New Technique for Nearest Neighbor Search in High-Dimensional Space · IEEE Trans. Knowl. Data Eng. 2000 Independent Quantization: An Index Compression Technique for High-Dimensional Data Spaces · ICDE 2000 Fast Nearest Neighbor Search in High-Dimensional Space · ICDE 1998 |
Data mining
anomaly detection |
0.1 | 2 | 2003 | Efficient Biased Sampling for Approximate Clustering and Outlier Detection in Large Data Sets · IEEE Trans. Knowl. Data Eng. 2003 An Efficient Approximation Scheme for Data Mining Tasks · ICDE 2001 |
Data mining › clustering
approximate clustering |
0.1 | 2 | 2003 | Efficient Biased Sampling for Approximate Clustering and Outlier Detection in Large Data Sets · IEEE Trans. Knowl. Data Eng. 2003 An Efficient Approximation Scheme for Data Mining Tasks · ICDE 2001 |
Data mining
clustering |
0.1 | 2 | 2003 | Efficient Biased Sampling for Approximate Clustering and Outlier Detection in Large Data Sets · IEEE Trans. Knowl. Data Eng. 2003 An Efficient Approximation Scheme for Data Mining Tasks · ICDE 2001 |
Information retrieval
similarity search |
0.1 | 3 | 1997 | Using Extended Feature Objects for Partial Similarity Retrieval · VLDB J. 1997 S3: Similarity Search in CAD Database Systems · SIGMOD Conference 1997 Fast Parallel Similarity Search in Multimedia Databases · SIGMOD Conference 1997 |
Data mining › sampling
density-biased sampling |
0.0 | 2 | 2003 | An Efficient Approximation Scheme for Data Mining Tasks · ICDE 2001 Efficient Biased Sampling for Approximate Clustering and Outlier Detection in Large Data Sets · IEEE Trans. Knowl. Data Eng. 2003 |
Data mining
sampling |
0.0 | 2 | 2003 | An Efficient Approximation Scheme for Data Mining Tasks · ICDE 2001 Efficient Biased Sampling for Approximate Clustering and Outlier Detection in Large Data Sets · IEEE Trans. Knowl. Data Eng. 2003 |
Indexing and storage engines
multidimensional indexing |
0.0 | 2 | 2000 | Indexing the Solution Space: A New Technique for Nearest Neighbor Search in High-Dimensional Space · IEEE Trans. Knowl. Data Eng. 2000 The X-tree : An Index Structure for High-Dimensional Data · VLDB 1996 |
Data mining › anomaly detection
outlier detection |
0.0 | 1 | 2003 | Efficient Biased Sampling for Approximate Clustering and Outlier Detection in Large Data Sets · IEEE Trans. Knowl. Data Eng. 2003 |
Information retrieval › similarity search › nearest neighbor search
high-dimensional nearest neighbor search |
0.0 | 1 | 2000 | Indexing the Solution Space: A New Technique for Nearest Neighbor Search in High-Dimensional Space · IEEE Trans. Knowl. Data Eng. 2000 |
Information retrieval › indexing
index compression |
0.0 | 1 | 2000 | Independent Quantization: An Index Compression Technique for High-Dimensional Data Spaces · ICDE 2000 |
Information retrieval › similarity search › nearest neighbor search › approximate nearest neighbor search
quantization |
0.0 | 1 | 2000 | Independent Quantization: An Index Compression Technique for High-Dimensional Data Spaces · ICDE 2000 |
Query processing and optimization
range query |
0.0 | 1 | 1998 | The Pyramid-Technique: Towards Breaking the Curse of Dimensionality · SIGMOD Conference 1998 |
Data mining › visualization
visual data mining |
0.0 | 1 | 1998 | Independence Diagrams: A Technique for Visual Data Mining · KDD 1998 |
Query processing and optimization
cost model |
0.0 | 1 | 1997 | A Cost Model For Nearest Neighbor Search in High-Dimensional Data Space · PODS 1997 |
Indexing and storage engines › partitioning
data declustering |
0.0 | 1 | 1997 | Fast Parallel Similarity Search in Multimedia Databases · SIGMOD Conference 1997 |
Multimedia analysis and retrieval › multimedia retrieval › content-based retrieval
multimedia similarity search |
0.0 | 1 | 2000 | Indexing the Solution Space: A New Technique for Nearest Neighbor Search in High-Dimensional Space · IEEE Trans. Knowl. Data Eng. 2000 |
Performance modeling and evaluation
cost modeling |
0.0 | 1 | 2000 | Independent Quantization: An Index Compression Technique for High-Dimensional Data Spaces · ICDE 2000 |
Multimedia analysis and retrieval
similarity search |
0.0 | 1 | 1998 | Fast Nearest Neighbor Search in High-Dimensional Space · ICDE 1998 |
Data models and query languages
object-oriented database |
0.0 | 1 | 1997 | S3: Similarity Search in CAD Database Systems · SIGMOD Conference 1997 |
Indexing and storage engines
spatial index |
0.0 | 1 | 1997 | A Cost Model For Nearest Neighbor Search in High-Dimensional Data Space · PODS 1997 |
Geometric modeling and processing
computer-aided design |
0.0 | 1 | 1997 | S3: Similarity Search in CAD Database Systems · SIGMOD Conference 1997 |
Parallel and multicore computing
parallel programming models |
0.0 | 1 | 1997 | Fast Parallel Similarity Search in Multimedia Databases · SIGMOD Conference 1997 |
Parallel and multicore computing › parallel algorithms
parallel search |
0.0 | 1 | 1997 | Fast Parallel Similarity Search in Multimedia Databases · SIGMOD Conference 1997 |
Methods — techniques the papers use, named apart from their topics
voronoi cell precomputation · 0.1optimization algorithm · 0.1cost model · 0.1conservative approximation · 0.1biased sampling · 0.0hilbert curve · 0.0density-biased sampling · 0.0partitioning · 0.0b+-tree · 0.0query-by-sketch · 0.0query-by-example · 0.0nearest-neighbor search · 0.0nearest neighbor search · 0.0
| Year | Publication | Venue | Position |
|---|---|---|---|
| 2003 | Efficient Biased Sampling for Approximate Clustering and Outlier Detection in Large Data SetsabstractWe investigate the use of biased sampling according to the density of the data set to speed up the operation of general data mining tasks, such as clustering and outlier detection in large multidimensional data sets. In density-biased sampling, the probability that a given point will be included in the sample depends on the local density of the data set. We propose a general technique for density-biased sampling that can factor in user requirements to sample for properties of interest and can be tuned for specific data mining tasks. This allows great flexibility and improved accuracy of the results over simple random sampling. We describe our approach in detail, we analytically evaluate it, and show how it can be optimized for approximate clustering and outlier detection. Finally, we present a thorough experimental evaluation of the proposed method, applying density-biased sampling on real and synthetic data sets, and employing clustering and outlier detection algorithms, thus highlighting the utility of our approach. George Kollios, Dimitrios Gunopulos, Nick Koudas, Stefan Berchtold |
IEEE Trans. Knowl. Data Eng. | 4 |
| 2001 | An Efficient Approximation Scheme for Data Mining TasksabstractWe investigate the use of biased sampling according to the density of the dataset, to speed up the operation of general data mining tasks, such as clustering and outlier detection in large multidimensional datasets. In density biased sampling, the probability that a given point will be included in the sample depends on the local density of the dataset. We propose a general technique for density-biased sampling that can factor in user requirements to sample for properties of interest, and can be tuned for specific data mining tasks. This allows great flexibility and improved accuracy of the results over simple random sampling. We describe our approach in detail, we analytically evaluate it, and show how it can be optimized for approximate clustering and outlier detection. Finally we present a thorough experimental evaluation of the proposed method, applying density-biased sampling on real and synthetic data sets, and employing clustering and outlier detection algorithms, thus highlighting the utility of our approach. George Kollios, Dimitrios Gunopulos, Nick Koudas, Stefan Berchtold |
ICDE | 4 |
| 2001 | On Optimizing Nearest Neighbor Queries in High-Dimensional Data Spaces
Stefan Berchtold, Christian Böhm 0001, Daniel A. Keim, Florian Krebs, Hans-Peter Kriegel |
ICDT | 1 |
| 2000 | Optimal Multidimensional Query Processing Using Tree Striping
Stefan Berchtold, Christian Böhm 0001, Daniel A. Keim, Hans-Peter Kriegel, Xiaowei Xu 0001 |
DaWaK | 1 |
| 2000 | Independent Quantization: An Index Compression Technique for High-Dimensional Data SpacesabstractTwo major approaches have been proposed to efficiently process queries in databases: speeding up the search by using index structures, and speeding up the search by operating on a compressed database, such as a signature file. Both approaches have their limitations: indexing techniques are inefficient in extreme configurations, such as high-dimensional spaces, where even a simple scan may be cheaper than an index-based search. Compression techniques are not very efficient in all other situations. We propose to combine both techniques to search for nearest neighbors in a high-dimensional space. For this purpose, we develop a compressed index, called the IQ-tree, with a three-level structure: the first level is a regular (flat) directory consisting of minimum bounding boxes, the second level contains data points in a compressed representation, and the third level contains the actual data. We overcome several engineering challenges in constructing an effective index structure of this type. The most significant of these is to decide how much to compress at the second level. Too much compression will lead to many needless expensive accesses to the third level. Too little compression will increase both the storage and the access cost for the first two levels. We develop a cost model and an optimization algorithm based on this cost model that permits an independent determination of the degree of compression for each second level page to minimize expected query cost. In an experimental evaluation, we demonstrate that the IQ-tree shows a performance that is the "best of both worlds" for a wide range of data distributions and dimensionalities. Stefan Berchtold, Christian Böhm 0001, H. V. Jagadish, Hans-Peter Kriegel, Jörg Sander 0001 |
ICDE | 1 |
| 2000 | Indexing High-Dimensional Spaces: Database Support for Next Decade's ApplicationsabstractSummary form only given. The tutorial is structured as follows: In the first section, we describe two examples of new database applications, which demonstrate the need for efficient query processing techniques in highdimensional spaces. In the second section, we discuss the effects occurring in high-dimensional spaces - first from a pure mathematical point of view and then from a database perspective. Next, we describe the different approaches for modeling the costs of processing queries on high-dimensional data. The description of the different approaches demonstrates nicely what happens if we ignore the special properties of high-dimensional spaces. In the fourth section, we then provide a structured overview of the proposed querying and indexing techniques, discussing their advantages and drawbacks. In this section, we also cover a number of additional techniques dealing with optimization and parallelization. In concluding the tutorial, we try to stir further research activities by presenting a number of interesting research problems. Stefan Berchtold, Daniel A. Keim |
ICDE | 1 |
| 2000 | Multidimensional Index Structures in Relational Databases
Christian Böhm 0001, Stefan Berchtold, Hans-Peter Kriegel, Urs Michel |
J. Intell. Inf. Syst. | 2 |
| 2000 | Indexing the Solution Space: A New Technique for Nearest Neighbor Search in High-Dimensional SpaceabstractSimilarity search in multimedia databases requires an efficient support of nearest-neighbor search on a large set of high-dimensional points as a basic operation for query processing. As recent theoretical results show, state of the art approaches to nearest-neighbor search are not efficient in higher dimensions. In our new approach, we therefore precompute the result of any nearest-neighbor search which corresponds to a computation of the Voronoi cell of each data point. In a second step, we store conservative approximations of the Voronoi cells in an index structure efficient for high-dimensional data spaces. As a result, nearest neighbor search corresponds to a simple point query on the index structure. Although our technique is based on a precomputation of the solution space, it is dynamic, i.e., it supports insertions of new data points. An extensive experimental evaluation of our technique demonstrates the high efficiency for uniformly distributed as well as real data. We obtained a significant reduction of the search time compared to nearest neighbor search in other index structures such as the X-tree. Stefan Berchtold, Daniel A. Keim, Hans-Peter Kriegel, Thomas Seidl 0001 |
IEEE Trans. Knowl. Data Eng. | 1 |
| 1999 | Implementation of Multidimensional Index Structures for Knowledge Discovery in Relational Databases
Stefan Berchtold, Christian Böhm 0001, Hans-Peter Kriegel, Urs Michel |
DaWaK | 1 |
| 1998 | Improving the Query Performance of High-Dimensional Index Structures by Bulk-Load Operations
Stefan Berchtold, Christian Böhm 0001, Hans-Peter Kriegel |
EDBT | 1 |
| 1998 | Fast Nearest Neighbor Search in High-Dimensional SpaceabstractSimilarity search in multimedia databases requires an efficient support of nearest neighbor search on a large set of high dimensional points as a basic operation for query processing. As recent theoretical results show, state of the art approaches to nearest neighbor search are not efficient in higher dimensions. In our new approach, we therefore precompute the result of any nearest neighbor search which corresponds to a computation of the voronoi cell of each data point. In a second step, we store the voronoi cells in an index structure efficient for high dimensional data spaces. As a result, nearest neighbor search corresponds to a simple point query on the index structure. Although our technique is based on a precomputation of the solution space, it is dynamic, i.e. it supports insertions of new data points. An extensive experimental evaluation of our technique demonstrates the high efficiency for uniformly distributed as well as real data. We obtained a significant reduction of the search time compared to nearest neighbor search in the X tree (up to a factor of 4). Stefan Berchtold, Bernhard Ertl, Daniel A. Keim, Hans-Peter Kriegel, Thomas Seidl 0001 |
ICDE | 1 |
| 1998 | Independence Diagrams: A Technique for Visual Data Mining
Stefan Berchtold, H. V. Jagadish, Kenneth A. Ross |
KDD | 1 |
| 1998 | The Pyramid-Technique: Towards Breaking the Curse of DimensionalityabstractIn this paper, we propose the Pyramid-Technique, a new indexing method for high-dimensional data spaces. The Pyramid-Technique is highly adapted to range query processing using the maximum metric Lmax. In contrast to all other index structures, the performance of the Pyramid-Technique does not deteriorate when processing range queries on data of higher dimensionality. The Pyramid-Technique is based on a special partitioning strategy which is optimized for high-dimensional data. The basic idea is to divide the data space first into 2d pyramids sharing the center point of the space as a top. In a second step, the single pyramids are cut into slices parallel to the basis of the pyramid. These slices from the data pages. Furthermore, we show that this partition provides a mapping from the given d-dimensional space to a 1-dimensional space. Therefore, we are able to use a B+-tree to manage the transformed data. As an analytical evaluation of our technique for hypercube range queries and uniform data distribution shows, the Pyramid-Technique clearly outperforms index structures using other partitioning strategies. To demonstrate the practical relevance of our technique, we experimentally compared the Pyramid-Technique with the X-tree, the Hilbert R-tree, and the Linear Scan. The results of our experiments using both, synthetic and real data, demonstrate that the Pyramid-Technique outperforms the X-tree and the Hilbert R-tree by a factor of up to 14 (number of page accesses) and up to 2500 (total elapsed time) for range queries. Stefan Berchtold, Christian Böhm 0001, Hans-Peter Kriegel |
SIGMOD Conference | 1 |
| 1998 | High-Dimensional Index Structures, Database Support for Next Decade's Applications (Tutorial)abstractNo abstract available. Stefan Berchtold, Daniel A. Keim |
SIGMOD Conference | 1 |
| 1997 | A Cost Model For Nearest Neighbor Search in High-Dimensional Data SpaceabstractIn this paper, we present a new cost model for nearest neighbor search in high-dimensional data space. We first analyze different nearest neighbor algorithms, present a generalization of an algorithm which has been originally proposed for Quadtrees [13], and show that this algorithm is optimal. Then, we develop a cost model which- in contrast to previous models- takes boundary effects into account and therefore also works in high dimensions. The advantages of our model are in particular: Our model works for data sets with an arbitrary number of dimensions and an arbitrary number of data points, is applicable to different data distributions and index structures, and provides accurate estimates of the expected query execution time. To show the practical relevance and accuracy of our model, we perform a detailed analysis using synthetic and real data. The results of applying our model to Stefan Berchtold, Christian Böhm 0001, Daniel A. Keim, Hans-Peter Kriegel |
PODS | 1 |
| 1997 | Fast Parallel Similarity Search in Multimedia DatabasesabstractMost similarity search techniques map the data objects into some high-dimensional feature space. The similarity search then corresponds to a nearest-neighbor search in the feature space which is computationally very intensive. In this paper, we present a new parallel method for fast nearest-neighbor search in high-dimensional feature spaces. The core problem of designing a parallel nearest-neighbor algorithm is to find an adequate distribution of the data onto the disks. Unfortunately, the known declustering methods to not perform well for high-dimensional nearest-neighbor search. In contrast, our method has been optimized based on the special properties of high-dimensional spaces and therefore provides a near-optimal distribution of the data items among the disks. The basic idea of our data declustering technique is to assign the buckets corresponding to different quadrants of the data space to different disks. We show that our technique - in contrast to other declustering methods - guarantees that all buckets corresponding to neighboring quadrants are assigned to different disks. We evaluate our method using large amounts of real data (up to 40 MBytes) and compare it with the best known data declustering method, the Hilbert curve. Our experiments show that our method provides an almost linear speed-up and a constant scale-up. Additionally, it outperforms the Hilbert approach by a factor of up to 5. Stefan Berchtold, Christian Böhm 0001, Bernhard Braunmüller, Daniel A. Keim, Hans-Peter Kriegel |
SIGMOD Conference | 1 |
| 1997 | S3: Similarity Search in CAD Database SystemsabstractS3 is the prototype of a database system supporting the management and similarity retrieval of industrial CAD parts. The major goal of the system is to reduce the cost for developing and producing new parts by maximizing the reuse of existing parts. S3 supports the following three types of similarity queries: query by example (of an existing part in the database), query by sketch and thematic similarity query. S3 is an object-oriented system offering an adequate graphical user interface. On top of providing various state-of-the-art algorithms and index structures for geometry-based similarity retrieval, it is an excellent testbed for developing and testing new similarity algorithms and index structures. Stefan Berchtold, Hans-Peter Kriegel |
SIGMOD Conference | 1 |
| 1997 | Using Extended Feature Objects for Partial Similarity Retrieval
Stefan Berchtold, Daniel A. Keim, Hans-Peter Kriegel |
VLDB J. | 1 |
| 1996 | The X-tree : An Index Structure for High-Dimensional Data
Stefan Berchtold, Daniel A. Keim, Hans-Peter Kriegel |
VLDB | 1 |
| 1994 | A scalable optimizer for automatically generated manipulator motionsabstractStarting from a collision-free robot path-given by an automatic motion planner or by a human programmer-the proposed method shortens and smoothes this path by using iteratively a few local, elementary geometric operations. The fast path-optimization process is interruptable at any time, thus always getting the best result obtainable within a certain amount of time. This property is especially useful in interactive or autonomous applications where the computation time is much more important than the traverse time and the quality of the robot motion. Some example environments including obstacle-constraint tightness and a bulky payload show the performance and usefulness of the new algorithm.> Stefan Berchtold, Bernhard Glavina |
IROS | 1 |