A Language for the Specification of the Schema of Spreadsheets for the Materialization of Ontologies

Autores
Gómez, Sergio Alejandro; Fillottrani, Pablo Rubén
Año de publicación
2020
Idioma
inglés
Tipo de recurso
documento de conferencia
Estado
versión publicada
Descripción
Ontology-based Data Access (OBDA) is concerned with providing end-users and applications with a way to query legacy databases through a high-level ontology that models both the business logic and the underlying data sources, accessed by mappings that de ne how to express records of the database as ontological assertions. In this research, we are concerned with providing with tools for performing OBDA with relational and non-relational data sources. We developed an OBDA tool that is able to access H2 databases and CSV les allowing the user to explicitly formulate mappings, and populating an ontology that can be saved for later querying. In this paper, we present an extension of our previous work as a language for specifying the schema of the data in a spreadsheet data application. This speci cation is then used to access the contents of a set of Excel books and express them as a relational database with the ultimate goal of materializing its data as an OWL/RDF ontology. We characterize the syntax and semantics of the language, present a prototypical implementation and report on the performance tests showing that our implementation can handle a workload of Excel tables of the order of ten thousand records.
Workshop: WISS – Innovación en Sistemas de Software
Red de Universidades con Carreras en Informática
Materia
Ciencias Informáticas
Ontology-based data access
Ontologies
Relational databases
Spreadsheets
Nivel de accesibilidad
acceso abierto
Condiciones de uso
http://creativecommons.org/licenses/by-nc-sa/4.0/
Repositorio
SEDICI (UNLP)
Institución
Universidad Nacional de La Plata
OAI Identificador
oai:sedici.unlp.edu.ar:10915/114199
Acceder
id SEDICI_afb9aa74a55b8c09273543724346bc08
oai_identifier_str oai:sedici.unlp.edu.ar:10915/114199
network_acronym_str SEDICI
repository_id_str 1329
network_name_str SEDICI (UNLP)
spelling A Language for the Specification of the Schema of Spreadsheets for the Materialization of OntologiesGómez, Sergio AlejandroFillottrani, Pablo RubénCiencias InformáticasOntology-based data accessOntologiesRelational databasesSpreadsheetsOntology-based Data Access (OBDA) is concerned with providing end-users and applications with a way to query legacy databases through a high-level ontology that models both the business logic and the underlying data sources, accessed by mappings that de ne how to express records of the database as ontological assertions. In this research, we are concerned with providing with tools for performing OBDA with relational and non-relational data sources. We developed an OBDA tool that is able to access H2 databases and CSV les allowing the user to explicitly formulate mappings, and populating an ontology that can be saved for later querying. In this paper, we present an extension of our previous work as a language for specifying the schema of the data in a spreadsheet data application. This speci cation is then used to access the contents of a set of Excel books and express them as a relational database with the ultimate goal of materializing its data as an OWL/RDF ontology. We characterize the syntax and semantics of the language, present a prototypical implementation and report on the performance tests showing that our implementation can handle a workload of Excel tables of the order of ten thousand records.Workshop: WISS – Innovación en Sistemas de SoftwareRed de Universidades con Carreras en Informática2020-10info:eu-repo/semantics/conferenceObjectinfo:eu-repo/semantics/publishedVersionObjeto de conferenciahttp://purl.org/coar/resource_type/c_5794info:ar-repo/semantics/documentoDeConferenciaapplication/pdf546-555http://sedici.unlp.edu.ar/handle/10915/114199enginfo:eu-repo/semantics/altIdentifier/isbn/978-987-4417-90-9info:eu-repo/semantics/reference/hdl/10915/113243info:eu-repo/semantics/openAccesshttp://creativecommons.org/licenses/by-nc-sa/4.0/Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0)reponame:SEDICI (UNLP)instname:Universidad Nacional de La Platainstacron:UNLP2025-09-17T10:09:25Zoai:sedici.unlp.edu.ar:10915/114199Institucionalhttp://sedici.unlp.edu.ar/Universidad públicaNo correspondehttp://sedici.unlp.edu.ar/oai/snrdalira@sedici.unlp.edu.arArgentinaNo correspondeNo correspondeNo correspondeopendoar:13292025-09-17 10:09:25.196SEDICI (UNLP) - Universidad Nacional de La Platafalse
dc.title.none.fl_str_mv A Language for the Specification of the Schema of Spreadsheets for the Materialization of Ontologies
title A Language for the Specification of the Schema of Spreadsheets for the Materialization of Ontologies
spellingShingle A Language for the Specification of the Schema of Spreadsheets for the Materialization of Ontologies
Gómez, Sergio Alejandro
Ciencias Informáticas
Ontology-based data access
Ontologies
Relational databases
Spreadsheets
title_short A Language for the Specification of the Schema of Spreadsheets for the Materialization of Ontologies
title_full A Language for the Specification of the Schema of Spreadsheets for the Materialization of Ontologies
title_fullStr A Language for the Specification of the Schema of Spreadsheets for the Materialization of Ontologies
title_full_unstemmed A Language for the Specification of the Schema of Spreadsheets for the Materialization of Ontologies
title_sort A Language for the Specification of the Schema of Spreadsheets for the Materialization of Ontologies
dc.creator.none.fl_str_mv Gómez, Sergio Alejandro
Fillottrani, Pablo Rubén
author Gómez, Sergio Alejandro
author_facet Gómez, Sergio Alejandro
Fillottrani, Pablo Rubén
author_role author
author2 Fillottrani, Pablo Rubén
author2_role author
dc.subject.none.fl_str_mv Ciencias Informáticas
Ontology-based data access
Ontologies
Relational databases
Spreadsheets
topic Ciencias Informáticas
Ontology-based data access
Ontologies
Relational databases
Spreadsheets
dc.description.none.fl_txt_mv Ontology-based Data Access (OBDA) is concerned with providing end-users and applications with a way to query legacy databases through a high-level ontology that models both the business logic and the underlying data sources, accessed by mappings that de ne how to express records of the database as ontological assertions. In this research, we are concerned with providing with tools for performing OBDA with relational and non-relational data sources. We developed an OBDA tool that is able to access H2 databases and CSV les allowing the user to explicitly formulate mappings, and populating an ontology that can be saved for later querying. In this paper, we present an extension of our previous work as a language for specifying the schema of the data in a spreadsheet data application. This speci cation is then used to access the contents of a set of Excel books and express them as a relational database with the ultimate goal of materializing its data as an OWL/RDF ontology. We characterize the syntax and semantics of the language, present a prototypical implementation and report on the performance tests showing that our implementation can handle a workload of Excel tables of the order of ten thousand records.
Workshop: WISS – Innovación en Sistemas de Software
Red de Universidades con Carreras en Informática
description Ontology-based Data Access (OBDA) is concerned with providing end-users and applications with a way to query legacy databases through a high-level ontology that models both the business logic and the underlying data sources, accessed by mappings that de ne how to express records of the database as ontological assertions. In this research, we are concerned with providing with tools for performing OBDA with relational and non-relational data sources. We developed an OBDA tool that is able to access H2 databases and CSV les allowing the user to explicitly formulate mappings, and populating an ontology that can be saved for later querying. In this paper, we present an extension of our previous work as a language for specifying the schema of the data in a spreadsheet data application. This speci cation is then used to access the contents of a set of Excel books and express them as a relational database with the ultimate goal of materializing its data as an OWL/RDF ontology. We characterize the syntax and semantics of the language, present a prototypical implementation and report on the performance tests showing that our implementation can handle a workload of Excel tables of the order of ten thousand records.
publishDate 2020
dc.date.none.fl_str_mv 2020-10
dc.type.none.fl_str_mv info:eu-repo/semantics/conferenceObject
info:eu-repo/semantics/publishedVersion
Objeto de conferencia
http://purl.org/coar/resource_type/c_5794
info:ar-repo/semantics/documentoDeConferencia
format conferenceObject
status_str publishedVersion
dc.identifier.none.fl_str_mv http://sedici.unlp.edu.ar/handle/10915/114199
url http://sedici.unlp.edu.ar/handle/10915/114199
dc.language.none.fl_str_mv eng
language eng
dc.relation.none.fl_str_mv info:eu-repo/semantics/altIdentifier/isbn/978-987-4417-90-9
info:eu-repo/semantics/reference/hdl/10915/113243
dc.rights.none.fl_str_mv info:eu-repo/semantics/openAccess
http://creativecommons.org/licenses/by-nc-sa/4.0/
Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0)
eu_rights_str_mv openAccess
rights_invalid_str_mv http://creativecommons.org/licenses/by-nc-sa/4.0/
Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0)
dc.format.none.fl_str_mv application/pdf
546-555
dc.source.none.fl_str_mv reponame:SEDICI (UNLP)
instname:Universidad Nacional de La Plata
instacron:UNLP
reponame_str SEDICI (UNLP)
collection SEDICI (UNLP)
instname_str Universidad Nacional de La Plata
instacron_str UNLP
institution UNLP
repository.name.fl_str_mv SEDICI (UNLP) - Universidad Nacional de La Plata
repository.mail.fl_str_mv alira@sedici.unlp.edu.ar
_version_ 1843532677341249536
score 13.004268

Publicaciones similares