The Knowledge Graph Conference Icon
The Knowledge Graph Conference
  • 🏠Home
  • 📅Events
  • 👤Members
  • 🔵Announcements
  • 🔵Ask
  • 🔵Ask The Ontologists
  • 🔵Events
  • 🔵Jobs
  • 🔵Promotions
  • 🔵Share
Powered by Tightknit

Benjamin C.

Commented on Exploring Virtualization in Knowledge Graphs: Key...·Posted inAsk
Avatar of Benjamin C.
Benjamin C.
·

Hi François S., Ontop translates each SPARQL query into one SQL query. When you have only one source, and this source speaks SQL, then Ontop can directly speak to it (as long as it knows its dialect). Otherwise, if you have multiple sources or if your source don't speak SQL (e.g. MongoDB, data lake files or a WebAPI), you need to use a database federator/data virtualization platform that makes all the data looking relational and virtually appearing as coming from "one single source". Denodo is particularly good at that (especially when you have WebAPIs) and there is also open-source alternatives like Dremio and Teiid. Unfortunately, to the best of my knowledge, these database federators do no support graph databases. So if you need to federate with a SPARQL endpoint, you currently need to do it at the SPARQL level.

1
Commented on Seeking Guidance on MDM Solutions with Graph Techn...·Posted inAsk
Avatar of Benjamin C.
Benjamin C.
·

Douglas Moore Yes such a triple table would be supported by Ontop, but it won't be very efficient. The resulting SQL query would contain a lot of joins and unions that cannot be optimized. Ontop needs a more structured non-generic database storage so as to apply optimizations and produce efficient SQL queries. As for the OLAP/data lake setting, the upcoming version of Ontop (4.1) will include support for Dremio. A Docker snapshot is already available for testing.

1

About

  • Job title
  • Location
  • Organization