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 the data of 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 database, 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.

Data exploration on large amount of relational data through keyword queries / Beneventano, Domenico; Guerra, Francesco; Velegrakis, Yannis. - (2017), pp. 70-73. (Intervento presentato al convegno 15th International Conference on High Performance Computing and Simulation, HPCS 2017 tenutosi a Genoa, Italy nel 17-21 July 2017) [10.1109/HPCS.2017.21].

Data exploration on large amount of relational data through keyword queries

Velegrakis, Yannis
2017-01-01

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 the data of 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 database, 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.
2017
2017 International Conference on High Performance Computing and Simulation, HPCS 2017
USA
Institute of Electrical and Electronics Engineers Inc.
9781538632505
Beneventano, Domenico; Guerra, Francesco; Velegrakis, Yannis
Data exploration on large amount of relational data through keyword queries / Beneventano, Domenico; Guerra, Francesco; Velegrakis, Yannis. - (2017), pp. 70-73. (Intervento presentato al convegno 15th International Conference on High Performance Computing and Simulation, HPCS 2017 tenutosi a Genoa, Italy nel 17-21 July 2017) [10.1109/HPCS.2017.21].
File in questo prodotto:
File Dimensione Formato  
BeneventanoGV18.pdf

accesso aperto

Tipologia: Post-print referato (Refereed author’s manuscript)
Licenza: Tutti i diritti riservati (All rights reserved)
Dimensione 227.28 kB
Formato Adobe PDF
227.28 kB Adobe PDF Visualizza/Apri
08035060.pdf

Solo gestori archivio

Tipologia: Versione editoriale (Publisher’s layout)
Licenza: Tutti i diritti riservati (All rights reserved)
Dimensione 282.16 kB
Formato Adobe PDF
282.16 kB Adobe PDF   Visualizza/Apri

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/11572/195021
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 1
  • ???jsp.display-item.citation.isi??? 1
  • OpenAlex ND
social impact