ICIC   25583
INSTITUTO DE CIENCIAS E INGENIERIA DE LA COMPUTACION
Unidad Ejecutora - UE
congresos y reuniones científicas
Título:
A Language for the Specification of the Schema of Spreadsheets for the Materialization of Ontologies
Autor/es:
PABLO R. FILLOTTRANI; SERGIO GÓMEZ
Lugar:
La Matanza
Reunión:
Congreso; Congreso Argentino de Ciencias de la Computación - CACIC 2020; 2020
Institución organizadora:
Universidad Nacional de La Matanza
Resumen:
Abstract. Ontology-based Data Access (OBDA) is concerned with pro-viding end-users and applications with a way to query legacy databasesthrough a high-level ontology that models both the business logic andthe underlying data sources, accessed by mappings that define how toexpress records of the database as ontological assertions. In this research,we are concerned with providing with tools for performing OBDA withrelational and non-relational data sources. We developed an OBDA toolthat is able to access H2 databases and CSV files allowing the user toexplicitly formulate mappings, and populating an ontology that can besaved for later querying. In this paper, we present an extension of ourprevious work as a language for specifying the schema of the data in aspreadsheet data application. This specification is then used to access thecontents of a set of Excel books and express them as a relational databasewith the ultimate goal of materializing its data as an OWL/RDF ontol-ogy. We characterize the syntax and semantics of the language, present aprototypical implementation and report on the performance tests show-ing that our implementation can handle a workload of Excel tables ofthe order of ten thousand records.