Cocoon: Semantic Table Profiling Using Large Language Models

Fuente: arXiv
Salvato in:
Dettagli Bibliografici
Autori principali: Huang, Zezhou, Wu, Eugene
Natura: Preprint
Pubblicazione: 2024
Soggetti:
Accesso online:
Tags: Aggiungi Tag
Nessun Tag, puoi essere il primo ad aggiungerne!!
_version_ 1866917644908625920
author Huang, Zezhou
Wu, Eugene
author_facet Huang, Zezhou
Wu, Eugene
contents Data profilers play a crucial role in the preprocessing phase of data analysis by identifying quality issues such as missing, extreme, or erroneous values. Traditionally, profilers have relied solely on statistical methods, which lead to high false positives and false negatives. For example, they may incorrectly flag missing values where such absences are expected and normal based on the data's semantic context. To address these, we introduce Cocoon, a data profiling system that integrates LLMs to imbue statistical profiling with semantics. Cocoon enhances traditional profiling methods by adding a three-step process: Semantic Context, Semantic Profile, and Semantic Review. Our user studies show that Cocoon is highly effective at accurately discerning whether anomalies are genuine errors requiring correction or acceptable variations based on the semantics for real-world datasets.
format Preprint
id arxiv_https___arxiv_org_abs_2404_12552
institution arXiv
publishDate 2024
record_format arxiv
spellingShingle Cocoon: Semantic Table Profiling Using Large Language Models
Huang, Zezhou
Wu, Eugene
Databases
Data profilers play a crucial role in the preprocessing phase of data analysis by identifying quality issues such as missing, extreme, or erroneous values. Traditionally, profilers have relied solely on statistical methods, which lead to high false positives and false negatives. For example, they may incorrectly flag missing values where such absences are expected and normal based on the data's semantic context. To address these, we introduce Cocoon, a data profiling system that integrates LLMs to imbue statistical profiling with semantics. Cocoon enhances traditional profiling methods by adding a three-step process: Semantic Context, Semantic Profile, and Semantic Review. Our user studies show that Cocoon is highly effective at accurately discerning whether anomalies are genuine errors requiring correction or acceptable variations based on the semantics for real-world datasets.
title Cocoon: Semantic Table Profiling Using Large Language Models
topic Databases
url https://arxiv.org/abs/2404.12552