Skip to Main content Skip to Navigation
Journal articles

Interactive Join Query Inference with JIM

Angela Bonifati 1 Radu Ciucanu 1, * Slawomir Staworko 1
* Corresponding author
1 LINKS - Linking Dynamic Data
LIFL - Laboratoire d'Informatique Fondamentale de Lille, Inria Lille - Nord Europe
Abstract : Specifying join predicates may become a cumbersome task in many situations e.g., when the relations to be joined come from disparate data sources, when the values of the attributes carry little or no knowledge of metadata, or simply when the user is unfamiliar with querying formalisms. Such task is recurrent in many traditional data management applications, such as data integration, constraint inference, and database denormalization, but it is also becoming pivotal in novel crowdsourcing applications. We present JIM (Join Inference Machine), a system for interactive join specification tasks, where the user infers an n-ary join predicate by selecting tuples that are part of the join result via Boolean membership queries. The user can label tuples as positive or negative, while the system allows to identify and gray out the uninformative tuples i.e., those that do not add any information to the final learning goal. The tool also guides the user to reach her join inference goal with a minimal number of interactions.
Document type :
Journal articles
Complete list of metadata

Cited literature [6 references]  Display  Hide  Download

https://hal.inria.fr/hal-01006126
Contributor : Radu Ciucanu <>
Submitted on : Thursday, September 18, 2014 - 2:07:55 PM
Last modification on : Wednesday, April 14, 2021 - 10:03:51 AM
Long-term archiving on: : Friday, December 19, 2014 - 10:40:33 AM

File

p1541-bonifati.pdf
Files produced by the author(s)

Identifiers

Citation

Angela Bonifati, Radu Ciucanu, Slawomir Staworko. Interactive Join Query Inference with JIM. Proceedings of the VLDB Endowment (PVLDB), VLDB Endowment, 2014, 7 (13), pp.1541-1544. ⟨10.14778/2733004.2733025⟩. ⟨hal-01006126⟩

Share

Metrics

Record views

635

Files downloads

436