UnifiedViews: An ETL tool for RDF data management

Knap, Tomáš; Hanečák, Peter; Klímek, Jakub; Mader, Christian; Nečaský, Martin; Nuffelen, Bert Van; Škoda, Petr

doi:10.3233/sw-180291

Cited by 19 publications

(13 citation statements)

References 8 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The transformation of the NSRF data to knowledge graph, is done by using the UnifiedViews 14 ETL tool. The main advantage of this tool is that it can extract data straight from relational databases and then transform it to RDF triples [27][28][29]. After the transformation process, the RDF files were uploaded to an OpenLink Virtuoso Server 15 .…”

Section: Nsrf Knowledge Graph and Data Retrievalmentioning

confidence: 99%

The Use of National Strategic Reference Framework Data in Knowledge Graphs and Data Mining to Identify Red Flags

Bratsas

Chondrokostas

Koupidis

et al. 2021

Data

View full text Add to dashboard Cite

Red Flags in fiscal projects are warning signs that may indicate underlying problems with their implementation. In this paper, we present how National Strategic Reference Framework Open Data can be used to take full advantage of semantic web technologies and data mining techniques to build a knowledge-based system that identifies Red Flags. We collected the data from the Open Data API provided by the Greek Ministry of Economy and Finance. Data modeling consist of two ontologies; the Vocabulary of Fiscal Projects, describing the fiscal projects and the National Strategic Reference Framework Greece Vocabulary, illustrating the Greek National Strategic Reference Framework data. We transformed the data into RDF triples and uploaded them onto an OpenLink Virtuoso Server, so that we could retrieve them via SPARQL queries. Performance indicators were defined to assess the state of the project and Density-Based Spatial Clustering of Applications with Noise, (DBSCAN) was used to identify Red Flags. User’s demands is that rejected projects should raise Red Flags, to avoid project failure and assist the auditor to organize the monitoring process efficiently, by avoiding to examine most of the non-problematic projects. We performed a use case scenario in which an auditor has to examine NSRF projects, approximately 12 months before the end of the programming period. The system retrieved the fiscal information, calculated the performance indicators and identified the Red Flags. The last update of the projects status after the end of the programming period was retrieved and extracted the number of rejected projects, to test whether the user requirements are satisfied. Rejected projects consist of 3.8% of the total projects. The results of the use case scenario show that RedFlags platform is more likely to identify project failures and not raise Red Flags on not rejected projects. Therefore, the RedFlags platform using open data, assists the auditor to organize the monitoring process better.

show abstract

Section: Nsrf Knowledge Graph and Data Retrievalmentioning

confidence: 99%

The Use of National Strategic Reference Framework Data in Knowledge Graphs and Data Mining to Identify Red Flags

Bratsas

Chondrokostas

Koupidis

et al. 2021

Data

View full text Add to dashboard Cite

show abstract

“…UnifiedViews [80] (UV) is a predecessor of Linked-Pipes ETL, which means that it is also an open-source tool for design and execution of ETL pipelines (see Figure 7), and it is also focused on RDF and linked data and features a library of reusable components. Its requirements coverage is therefore a subset of the coverage of LinkedPipes ETL.…”

Section: Unifiedviewsmentioning

confidence: 99%

Survey of tools for Linked Data consumption

Klímek

Škoda

Nečaský

2019

Self Cite

View full text Add to dashboard Cite

There is lots of data published as Linked (Open) Data (LOD/LD). At the same time, there is also a multitude of tools for publication of LD. However, potential LD consumers still have difficulty discovering, accessing and exploiting LD. This is because compared to consumption of traditional data formats such as XML and CSV files, there is a distinct lack of tools for consumption of LD. The promoters of LD use the well-known 5-star Open Data deployment scheme to suggest that consumption of LD is a better experience once the consumer knows RDF and related technologies. This suggestion, however, falls short when the consumers search for an appropriate tooling support for LD consumption. In this paper we define a LD consumption process. Based on this process and current literature, we define a set of 34 requirements a hypothetical Linked Data Consumption Platform (LDCP) should ideally fulfill. We cover those requirements with a set of 94 evaluation criteria. We survey 110 tools identified as potential candidates for an LDCP, eliminating them in 3 rounds until 16 candidates for remain. We evaluate the 16 candidates using our 94 criteria. Based on this evaluation we show which parts of the LD consumption process are covered by the 16 candidates. Finally, we identify 8 tools which satisfy our requirements on being a LDCP. We also show that there are important LD consumption steps which are not sufficiently covered by existing tools. The authors of LDCP implementations may use this survey to decide about directions of future development of their tools. LD experts may use it to see the level of support of the state of the art technologies in existing tools. Non-LD experts may use it to choose a tool which supports their LD processing needs without requiring them to have expert knowledge of the technologies. The paper can also be used as an introductory text to LD consumption.

show abstract

“…To ask questions of this data, SPARQL queries can be easily parsed via open source graphical user interface (GUI) tools like Twinkle (Almendros-Jiménez, Becerra-Terón and Cuzzocrea, 2017) and YASGUI (Rietveld and Hoekstra, 2014). However, in order to demonstrate the benefit of adding rules to data, the integrated data in this case study was deposited in an open source triple store called Eclipse RDF4J (Knap et al, 2016). Eclipse RDF4J is an open source Java framework for storing, inferencing and querying RDF data.…”

Section: Information Retrievalmentioning

confidence: 99%

An ontology-based data integration framework for construction information management

Akinyemi

Sun

Gray

2018

Proceedings of the Institution of Civil Engineers - Management,

View full text Add to dashboard Cite

Information management during the construction phase of a built asset involves multiple stakeholders using multiple software applications to generate and store data. This is problematic as data come in different forms and are labour intensive to piece together. Existing solutions to this problem are predominantly in proprietary applications, which are sometimes cost prohibitive for small engineering firms, or conceptual studies with use cases that cannot be easily adapted. In view of these limitations, this research presents an ontology-based data integration framework that makes use of open-source tools that support Semantic Web technologies. The proposed framework enables rapid answering of queries over construction data integrated from heterogeneous sources, data quality checks and reuse of project software resources. The attributes and functionalities of the proposed solution align with the requirements common to small firms with limited information technology skill and budget. Consequently, this solution can be of great benefit for their data projects.

show abstract

UnifiedViews: An ETL tool for RDF data management

Cited by 19 publications

References 8 publications

The Use of National Strategic Reference Framework Data in Knowledge Graphs and Data Mining to Identify Red Flags

The Use of National Strategic Reference Framework Data in Knowledge Graphs and Data Mining to Identify Red Flags

Survey of tools for Linked Data consumption

An ontology-based data integration framework for construction information management

Contact Info

Product

Resources

About