DataGraphic is a visual programming module for semantic web data reading in Ryven.
-
DataGraphic supports queries on local and cloud semantic web.
-
DataGraphic supports data visualization based on JoyVis, which used networkx, rdflib, and pyvis.
-
DataGraphic supports queries on relational database based on semantic queries.
An example of how the module works.
-
Read ontology is the first node in the workflow. Either load the local graph or use the remote server as an endpoint. The Query input can take custom Spark Queries, it is by default passive until activated. The Show Graph input takes boolean values to determine whether the queried graph is rendered. The Limit input takes integers to limit the amount of returned query results.
-
OntoData converts graph results to lists. The graph results are split into prefixes and entities, categorized by subjects, predicates, and objects.
-
A Select module is used to get particular results from the lists, the results are assembled as potential entity names that you might want to query.
-
The Entity ID later goes to the GraphQueryBuilder to get your desired results. This is not needed if you are familiar with Spark queries. Then, the query goes through ReadOntology and OntoData again.
-
Transfer the IDs of the queried entities to DataQueryBuilder, this node will get DataFrame based o the IDs from relational databases. The Query input can take custom SQL Queries, it is by default passive until activated. The Start and End inputs take String values to determine the time range. The Limit input takes integers to limit the amount of returned query results.
-
The DataFrame is saved to .csv through Save Data.
To use this module, Python environments are needed, better below 3.10, currently. Ryven is also a prerequisite, the installation guide is here.
Import the nodes through the Ryven interface, and you can get started.
Connection with a remote relational database requires additional parameters in the db_param.json file.
This plug-in is supported by Midea-Building-Technologies-Division
AGPL 3.0