Giter VIP home page Giter VIP logo

stdgont's Introduction

stdgont

Short description of the project.

Add Semantic Web ontology/Knowledge Graph power to OpenRefine!

(Proof of concept/demonstration purposes only).

Generate&use the Simplified Technical Dictionary Generic Ontology (STDGOnt) as OpenRefine operation JSON.

For example, to reconcile and enrich corporate material master data.

Introduction. This project demonstrates a practical approach for reconciliation and enrichment of source messy data, processed by OpenRefine. It just shows the concept and is not expected to be used in production environment.

The project is partially inspired by a series of ECCMA webinars, devoted to data quality in supply chain.

There are a number of sources, explaining how material master data quality impacts business, and there are a number of commercial and free solutions for improving of material master data quality. This project demonstrates another one practical approach in this area as one of use cases.

Source of poor material master data quality. Explained in ECCMA materials, and briefly in demonstration video.

Solution design. The proposed solution includes the following components:

  • OpenRefine (previously Google Refine) application
  • R Shiny application to generate or reuse Simplified Technical Dictionary Generic Ontology (STDGOnt) JSON files and OpenRefine operation JSON
  • Github Repository to keep and exchange by STDGOnt JSON files (this repository/project)
  • Semantic Web publishing service/wrapper for SPARQL endpoint
  • Semantic Web fuzzy search service/wrapper for SPARQL endpoint
  • Generic OpenRefine reconciliation API service (minimal set of features)
  • OpenRefine reconciliation API for QUDT units of mesurement service (minimal set of features)
  • SPARQL endpoint (internal service, is not available from Internet)

    Three basic use cases:

  • Use OpenRefine and R Shiny STDGOnt application to create and publish STDGOnt ontology for further use in master data reconciliation and enrichment, based on fuzzy search
  • Use R Shiny STDGOnt application to generate JSON for a set of OpenRefine operations based on STDGOnt fuzzy seach web service
  • Use OpenRefine to get master data reconciled and structured by utilizing of JSON operations, created by R Shiny STDGOnt application

    Solution demonstration video, explaining how the application can be used to solve typical problem, related to material master data cleansing.

    OpenRefine reconciliation API demonstration video, explaining how the application can be used to reconcile OpenRefine data column, containing Wikidata properties URI

    How to use STDGOnt service video - to verify and reconcile of QUDT units of measurement as OpenRefine/QUDT reconciliation API

  • stdgont's People

    Contributors

    v1st-git avatar

    Stargazers

     avatar  avatar

    Watchers

     avatar

    Recommend Projects

    • React photo React

      A declarative, efficient, and flexible JavaScript library for building user interfaces.

    • Vue.js photo Vue.js

      ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

    • Typescript photo Typescript

      TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

    • TensorFlow photo TensorFlow

      An Open Source Machine Learning Framework for Everyone

    • Django photo Django

      The Web framework for perfectionists with deadlines.

    • D3 photo D3

      Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

    Recommend Topics

    • javascript

      JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

    • web

      Some thing interesting about web. New door for the world.

    • server

      A server is a program made to process requests and deliver data to clients.

    • Machine learning

      Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

    • Game

      Some thing interesting about game, make everyone happy.

    Recommend Org

    • Facebook photo Facebook

      We are working to build community through open source technology. NB: members must have two-factor auth.

    • Microsoft photo Microsoft

      Open source projects and samples from Microsoft.

    • Google photo Google

      Google โค๏ธ Open Source for everyone.

    • D3 photo D3

      Data-Driven Documents codes.