2022 IEEE 38th International Conference on Data Engineering (ICDE) · 2022 · 28 citations · 35 references
ComputingComputer ScienceInformation TechnologyDatabasesInformation RetrievalMachine LearningHash TablesNearest Neighbor SearchQuery OptimizationQuery ProcessingRelational AlgebraSearching AlgorithmsAccuracyData AugmentationHashingIndex StructuresIndexingIndexing StructuresJoin AlgorithmsSketch-based Querying
Dataset search is emerging as a critical capability in both research and industry: it has spurred many novel applications, ranging from the enrichment of analyses of real-world phenomena to the improvement of machine learning models. Recent research in this field has explored a new class of data-driven queries: queries consist of datasets and retrieve, from a large collection, related datasets. In this paper, we study a specific type of data-driven query that supports relational data augmentation through numerical data relationships: given an input query table, find the top-k tables that are both joinable with it and contain columns that are correlated with a column in the query. We propose a novel hashing scheme that allows the construction of a sketch-based index to support efficient correlated table search. We show that our proposed approach is effective and efficient, and achieves better trade-offs that significantly improve both the ranking accuracy and recall compared to the state-of-the-art solutions.
35
Optimal aggregation algorithms for middleware
Ronald Fagin, Amnon Lotem, Moni Naor · Journal of Computer and System Sciences · 2003 · 941 citations