Data exploration on large amount of relational data through keyword queries

Domenico Beneventano, Francesco Guerra, Yannis Velegrakis

Research output: Chapter in Book/Report/Conference proceedingConference contributionAcademicpeer-review

Abstract

The paper describes a new approach for querying relational databases through keyword search by exploting Information Retrieval (IR) techniques. When users do not know the structures and the content, keyword search becomes the only efficient and effective solution for allowing people exploring a relational database. The approach is based on a unified view of the database relations (performed through the full disjunction operator), where its composing tuples will be considered as documents to be indexed and searched by means of an IR search engine. Moreover, as it happens in relational databases, the system can merge the data stored in different documents for providing a complete answer to the user. In particular, two documents can be joined because either their tuples in the original database share some Primary Key or, always in the original database, some tuple is connected by a Primary / Foreign Key Relation. Our preliminary proposal, the description of the tabular data structure for storing and retrieving the possible connections among the documents and a metrics for scoring the results are introduced in the paper.

Original languageEnglish
Title of host publicationProceedings - 2017 International Conference on High Performance Computing and Simulation, HPCS 2017
EditorsWaleed W. Smari
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages70-73
Number of pages4
ISBN (Electronic)9781538632505
DOIs
Publication statusPublished - 12 Sept 2017
Event15th International Conference on High Performance Computing and Simulation, HPCS 2017 - Genoa, Italy
Duration: 17 Jul 201721 Jul 2017

Conference

Conference15th International Conference on High Performance Computing and Simulation, HPCS 2017
Country/TerritoryItaly
CityGenoa
Period17/07/1721/07/17

Fingerprint

Dive into the research topics of 'Data exploration on large amount of relational data through keyword queries'. Together they form a unique fingerprint.

Cite this