Sherlock: A Deep Learning Approach to Semantic Data Type Detection
Not on the map. Why?
Abstract (arXiv)
Correctly detecting the semantic type of data columns is crucial for data science tasks such as automated data cleaning, schema matching, and data discovery. Existing data preparation and analysis systems rely on dictionary lookups and regular expression matching to detect semantic types. However, these matching-based approaches often are not robust to dirty data and only detect a limited number of types. We introduce Sherlock, a multi-input deep neural network for detecting semantic types. We train Sherlock on 686,765 data columns retrieved from the VizNet corpus by matching 78 semantic types from DBpedia to column headers. We characterize each matched column with 1,588 features describing the statistical properties, character distributions, word embeddings, and paragraph vectors of column values. Sherlock achieves a support-weighted F1 score of 0.89, exceeding that of machine learning baselines, dictionary and regular expression benchmarks, and the consensus of crowdsourced annotations.
Key facts. Cited by 74 papers in the map (data through 14 Oct 2026). First posted on arXiv 25 May 2019.
Builds on
No reference list yet.
Built on by
Citing papers per year: 2021: 11; 2022: 6; 2023: 22; 2024: 8; 2025: 10; 2026: 17.
74 papers.
Sort:
By area:
- 2022Fine-tuning language models to find agreement among humans with diverse preferencescited by 189
- 2023TableLlama: Towards Open Large Generalist Models for Tablescited by 137
- 2021TABBIE: Pretrained Representations of Tabular Datacited by 111
- 2024CARTE: Pretraining and Transfer for Tabular Learningcited by 76
- 2023Table-GPT: Table-tuned GPT for Diverse Table Taskscited by 69
- 2021GitTables: A Large-Scale Corpus of Relational Tablescited by 45
- 2021Annotating Columns with Pre-trained Language Modelscited by 37
- 2023HYTREL: Hypergraph-enhanced Tabular Data Representation Learningcited by 36
- 2021LightAutoML: AutoML Solution for a Large Financial Services Ecosystemcited by 32
- 2021TCN: Table Convolutional Network for Web Table Interpretationcited by 24
- 2023CHORUS: Foundation Models for Unified Data Discovery and Explorationcited by 24
- 2023TabLib: A Dataset of 627M Tables with Contextcited by 23
38 more
- 2023Towards Cross-Table Masked Pretraining for Web Data Miningcited by 21
- 2023Column Type Annotation using ChatGPTcited by 19
- 2024SpreadsheetLLM: Encoding Spreadsheets for Large Language Modelscited by 17
- 2025TARGET: Benchmarking Table Retrieval for Generative Taskscited by 17
- 2022DeepJoin: Joinable Table Discovery with Pre-trained Language Modelscited by 15
- 2023ArcheType: A Novel Framework for Open-Source Column Type Annotation using Large Language Modelscited by 15
- 2024Tabular Data Augmentation for Machine Learning: Progress and Prospects of Embracing Generative AIcited by 15
- 2025MMTU: A Massive Multi-Task Table Understanding and Reasoning Benchmarkcited by 14
- 2023NameGuess: Column Name Expansion for Tabular Datacited by 13
- 2023Observatory: Characterizing Embeddings of Relational Tablescited by 12
- 2023LakeBench: Benchmarks for Data Discovery over Data Lakescited by 10
- 2023Knowledge Engineering using Large Language Modelscited by 9
- 2026Can LLMs Clean Up Your Mess? A Survey of Application-Ready Data Preparation with LLMscited by 9
- 2022AnaMeta: A Table Understanding Dataset of Field Metadata Knowledge Shared by Multi-dimensional Data Analysis Taskscited by 8
- 2021Auto-Validate: Unsupervised Data Validation Using Data-Domain Patterns Inferred from Data Lakescited by 7
- 2025AutoG: Towards automatic graph construction from tabular datacited by 7
- 2023DataVinci: Learning Syntactic and Semantic String Repairscited by 6
- 2023KAER: A Knowledge Augmented Pre-Trained Language Model for Entity Resolutioncited by 5
- 2023Desbordante: from benchmarking suite to high-performance science-intensive data profiler (preprint)cited by 5
- 2023Cross Modal Data Discovery over Structured and Unstructured Data Lakescited by 5
- 2025Columbo: Expanding Abbreviated Column Names for Tabular Data Using Large Language Modelscited by 5
- 2021Auto-Tag: Tagging-Data-By-Example in Data Lakescited by 4
- 2023AdaTyper: Adaptive Semantic Column Type Detectioncited by 4
- 2021On Automatic Parsing of Log Recordscited by 3
- 2023Adversarial Attacks on Tables with Entity Swapcited by 3
- 2024Graph Neural Network Approach to Semantic Type Detection in Tablescited by 3
- 2024KGLink: A column type annotation method that combines knowledge graph and pre-trained language modelcited by 3
- 2021Flexible Table Recognition and Semantic Interpretation Systemcited by 2
- 2022Fine-Tuning BERT for Automatic ADME Semantic Labeling in FDA Drug Labeling to Enhance Product-Specific Guidance Assessmentcited by 2
- 2023Tab2KG: Semantic Table Interpretation with Lightweight Semantic Profilescited by 2
- 2023KGLiDS: A Platform for Semantic Abstraction, Linking, and Automation of Data Sciencecited by 2
- 2025Auto-Test: Learning Semantic-Domain Constraints for Unsupervised Error Detection in Tablescited by 2
- 2025Toward Real-World Table Agents: Capabilities, Workflows, and Design Principles for LLM-based Table Intelligencecited by 2
- 2021Making Table Understanding Work in Practicecited by 1
- 2024TabSketchFM: Sketch-based Tabular Representation Learning for Data Discovery over Data Lakescited by 1
- 2024Gem: Gaussian Mixture Model Embeddings for Numerical Feature Distributionscited by 1
- 2025Detection of Personal Data in Structured Datasets Using a Large Language Modelcited by 1
- 2025Robust LLM-based Column Type Annotation via Prompt Augmentation with LoRA Tuningcited by 1
50 most cited of 74 All 74 (JSON)
- 2026Understanding Errors in LLM-Based Question Answering over Imperfect Tables3 Oct 2026
- 2026Learned Enterprise Data Comprehension: Compression and Routing for Data Agents21 Sep 2026
- 2026Glyph: A Multi-Strategy Agentic System for Column Description and Sensitivity-Ontology Tagging of Enterprise Data Catalogs9 Sep 2026
- 2026Polaris: Learning to Generate Table Descriptions from Retrieval Feedback17 Aug 2026
- 2026Metadata Reconstruction from Values Alone: Recovering Column Semantics in Undocumented Warehouses8 Aug 2026
- 2026Tytan: Interactive Neurosymbolic Construction of Analytic Semantic Schemas from Relational Data6 Aug 2026
- 2026Extending Desbordante with Probabilistic Functional Dependency Discovery Support26 Jul 2026
- 2026Order in Desbordante: Techniques for Efficient Implementation of Order Dependency Discovery Algorithms26 Jul 2026
- 2026Lightning Fast Matching Dependency Discovery with Desbordante12 Jul 2026
- 2026TACO: Task-Aware Column Description Generation Using LLMs19 Jun 2026
- 2026Hyperdimensional computing for structured querying on tabular data embeddings11 Jun 2026
- 2026Format-Constraint Coupling in Knowledge Graph Construction from Statistical Tables21 May 2026
38 more
- 2026An Explainable Header-Centric Framework for Large-Scale Semantic Table Interpretation and Data Quality Assessment12 May 2026
- 2026TabEmb: Joint Semantic-Structure Embedding for Table Annotation21 Apr 2026
- 2026DBAutoDoc: Automated Discovery and Documentation of Undocumented Database Schemas via Statistical Analysis and Iterative LLM Refinement24 Mar 2026
- 2026ZTab: Domain-based Zero-shot Annotation for Table Columns12 Mar 2026
- 2026Can LLMs Clean Up Your Mess? A Survey of Application-Ready Data Preparation with LLMs22 Jan 2026
- 2025Robust LLM-based Column Type Annotation via Prompt Augmentation with LoRA Tuning28 Dec 2025
- 2025Towards Contextual Sensitive Data Detection2 Dec 2025
- 2025MetaJoin: Adaptive Join Selections for Heterogeneous Tables2 Dec 2025
- 2025Columbo: Expanding Abbreviated Column Names for Tabular Data Using Large Language Models13 Aug 2025
- 2025Toward Real-World Table Agents: Capabilities, Workflows, and Design Principles for LLM-based Table Intelligence14 Jul 2025
- 2025Detection of Personal Data in Structured Datasets Using a Large Language Model27 Jun 2025
- 2025MMTU: A Massive Multi-Task Table Understanding and Reasoning Benchmark5 Jun 2025
- 2025TARGET: Benchmarking Table Retrieval for Generative Tasks14 May 2025
- 2025Auto-Test: Learning Semantic-Domain Constraints for Unsupervised Error Detection in Tables14 Apr 2025
- 2025AutoG: Towards automatic graph construction from tabular data25 Jan 2025
- 2024Gem: Gaussian Mixture Model Embeddings for Numerical Feature Distributions9 Oct 2024
- 2024T-KAER: Transparency-enhanced Knowledge-Augmented Entity Resolution Framework30 Sep 2024
- 2024Tabular Data Augmentation for Machine Learning: Progress and Prospects of Embracing Generative AI31 Jul 2024
- 2024SpreadsheetLLM: Encoding Spreadsheets for Large Language Models12 Jul 2024
- 2024TabSketchFM: Sketch-based Tabular Representation Learning for Data Discovery over Data Lakes28 Jun 2024
- 2024KGLink: A column type annotation method that combines knowledge graph and pre-trained language model1 Jun 2024
- 2024Graph Neural Network Approach to Semantic Type Detection in Tables30 Apr 2024
- 2024CARTE: Pretraining and Transfer for Tabular Learning26 Feb 2024
- 2023AdaTyper: Adaptive Semantic Column Type Detection23 Nov 2023
- 2023TableLlama: Towards Open Large Generalist Models for Tables15 Nov 2023
- 2023ArcheType: A Novel Framework for Open-Source Column Type Annotation using Large Language Models27 Oct 2023
- 2023NameGuess: Column Name Expansion for Tabular Data19 Oct 2023
- 2023Table-GPT: Table-tuned GPT for Diverse Table Tasks13 Oct 2023
- 2023TabLib: A Dataset of 627M Tables with Context11 Oct 2023
- 2023Observatory: Characterizing Embeddings of Relational Tables5 Oct 2023
- 2023Knowledge Engineering using Large Language Models1 Oct 2023
- 2023Adversarial Attacks on Tables with Entity Swap15 Sep 2023
- 2023DataVinci: Learning Syntactic and Semantic String Repairs21 Aug 2023
- 2023Comprehending Semantic Types in JSON Data with Graph Neural Networks24 Jul 2023
- 2023HYTREL: Hypergraph-enhanced Tabular Data Representation Learning14 Jul 2023
- 2023Towards Cross-Table Masked Pretraining for Web Data Mining10 Jul 2023
- 2023LakeBench: Benchmarks for Data Discovery over Data Lakes9 Jul 2023
- 2023CHORUS: Foundation Models for Unified Data Discovery and Exploration16 Jun 2023
50 newest of 74 All 74 (JSON)
- 2023TableLlama: Towards Open Large Generalist Models for Tablescited by 137
- 2021TABBIE: Pretrained Representations of Tabular Datacited by 111
- 2024CARTE: Pretraining and Transfer for Tabular Learningcited by 76
- 2023Table-GPT: Table-tuned GPT for Diverse Table Taskscited by 69
- 2021GitTables: A Large-Scale Corpus of Relational Tablescited by 45
- 2021Annotating Columns with Pre-trained Language Modelscited by 37
- 2023HYTREL: Hypergraph-enhanced Tabular Data Representation Learningcited by 36
- 2021LightAutoML: AutoML Solution for a Large Financial Services Ecosystemcited by 32
- 2021TCN: Table Convolutional Network for Web Table Interpretationcited by 24
- 2023CHORUS: Foundation Models for Unified Data Discovery and Explorationcited by 24
- 2023TabLib: A Dataset of 627M Tables with Contextcited by 23
- 2023Towards Cross-Table Masked Pretraining for Web Data Miningcited by 21
12 most cited of 69 All 69 (JSON)
- 2026Understanding Errors in LLM-Based Question Answering over Imperfect Tables3 Oct 2026
- 2026Learned Enterprise Data Comprehension: Compression and Routing for Data Agents21 Sep 2026
- 2026Metadata Reconstruction from Values Alone: Recovering Column Semantics in Undocumented Warehouses8 Aug 2026
- 2026Tytan: Interactive Neurosymbolic Construction of Analytic Semantic Schemas from Relational Data6 Aug 2026
- 2026Extending Desbordante with Probabilistic Functional Dependency Discovery Support26 Jul 2026
- 2026Order in Desbordante: Techniques for Efficient Implementation of Order Dependency Discovery Algorithms26 Jul 2026
- 2026Lightning Fast Matching Dependency Discovery with Desbordante12 Jul 2026
- 2026TACO: Task-Aware Column Description Generation Using LLMs19 Jun 2026
- 2026Hyperdimensional computing for structured querying on tabular data embeddings11 Jun 2026
- 2026Format-Constraint Coupling in Knowledge Graph Construction from Statistical Tables21 May 2026
- 2026An Explainable Header-Centric Framework for Large-Scale Semantic Table Interpretation and Data Quality Assessment12 May 2026
- 2026TabEmb: Joint Semantic-Structure Embedding for Table Annotation21 Apr 2026
12 newest of 69 All 69 (JSON)