Show simple item record

dc.contributor.authorDeb Nath, Rudra Pratap
dc.contributor.authorHose, Katja
dc.contributor.authorBach Pedersen, Torben
dc.contributor.authorRomero Moral, Óscar
dc.contributor.otherUniversitat Politècnica de Catalunya. Departament d'Enginyeria de Serveis i Sistemes d'Informació
dc.date.accessioned2018-02-02T08:23:33Z
dc.date.available2019-03-05T01:30:40Z
dc.date.issued2017-08-01
dc.identifier.citationDeb Nath, R., Hose, K., Bach, T., Romero, O. SETL: A programmable semantic extract-transform-load framework for semantic data warehouses. "Information systems", 1 Agost 2017, vol. 68, p. 17-43.
dc.identifier.issn0306-4379
dc.identifier.urihttp://hdl.handle.net/2117/113594
dc.description.abstractIn order to create better decisions for business analytics, organizations increasingly use external structured, semi-structured, and unstructured data in addition to the (mostly structured) internal data. Current Extract-Transform-Load (ETL) tools are not suitable for this “open world scenario” because they do not consider semantic issues in the integration processing. Current ETL tools neither support processing semantic data nor create a semantic Data Warehouse (DW), a repository of semantically integrated data. This paper describes our programmable Semantic ETL (SETL) framework. SETL builds on Semantic Web (SW) standards and tools and supports developers by offering a number of powerful modules, classes, and methods for (dimensional and semantic) DW constructs and tasks. Thus it supports semantic data sources in addition to traditional data sources, semantic integration, and creating or publishing a semantic (multidimensional) DW in terms of a knowledge base. A comprehensive experimental evaluation comparing SETL to a solution made with traditional tools (requiring much more hand-coding) on a concrete use case, shows that SETL provides better programmer productivity, knowledge base quality, and performance.
dc.format.extent27 p.
dc.language.isoeng
dc.rightsAttribution-NonCommercial-NoDerivs 3.0 Spain
dc.rights.urihttp://creativecommons.org/licenses/by-nc-nd/3.0/es/
dc.subjectÀrees temàtiques de la UPC::Informàtica::Sistemes d'informació
dc.subject.lcshSemantic computing
dc.subject.lcshData warehousing
dc.subject.lcshExpert systems (Computer science)
dc.subject.otherETL
dc.subject.otherRDF
dc.subject.otherSemantic integration
dc.subject.otherData warehouse
dc.subject.otherSemantic-aware
dc.subject.otherKnowledge base
dc.titleSETL: A programmable semantic extract-transform-load framework for semantic data warehouses
dc.typeArticle
dc.subject.lemacGestor de dades
dc.subject.lemacSistemes experts (Informàtica)
dc.contributor.groupUniversitat Politècnica de Catalunya. MPI - Modelització i Processament de la Informació
dc.identifier.doi10.1016/j.is.2017.01.005
dc.description.peerreviewedPeer Reviewed
dc.relation.publisherversionhttp://www.sciencedirect.com/science/article/pii/S0306437916302101
dc.rights.accessOpen Access
local.identifier.drac21165996
dc.description.versionPostprint (author's final draft)
local.citation.authorDeb Nath, R.; Hose, K.; Bach, T.; Romero, O.
local.citation.publicationNameInformation systems
local.citation.volume68
local.citation.startingPage17
local.citation.endingPage43


Files in this item

Thumbnail

This item appears in the following Collection(s)

Show simple item record

Attribution-NonCommercial-NoDerivs 3.0 Spain
Except where otherwise noted, content on this work is licensed under a Creative Commons license : Attribution-NonCommercial-NoDerivs 3.0 Spain