Converting MySQL Schema to RDF: Seeking Advice and Frameworks

Mohan K. · 2023-11-08T16:31:51.167Z

Hi, I have a use case where I need to convert my MySQL .DDL and .JSON schema model to RDF serialization format. I found that I need to use the R2RML, RML frameworks. I was wondering if anyone had a similar situation and methods or framework used for conversion. Looking forward to hearing from you. Thanks for your help.

The Knowledge Graph Conference

Gautam K.
·
Hi, you can use RDFLIb or RML engine to convert it, do use any ontology for conversion?
Mohan K.
·
Hi Gautam, I have my normal MySQL workbench model and .JSON models. I want to convert it to RDF so that I upload it into a Protege tool to build more vocabulary.
François S.
·
you can also use OntoRefine, OntoPic studio, or the Stardog studio
François S.
·
If this is just a one time conversion you may not need RML. Just open the file / DB in python and write a conversion function for each using RDFLib
Mohan K.
·
Yes, it's one time, after that I want to use the Protege tool for further development of Ontologies
Mohan K.
·
Could you please share some more details in converting through a python and conversion function
François S.
·
For example for JSON, open your file using the json module, then for each object, use RDFLib to create a RDF triple corresponding to your ontology. There's really not much more than this. Obviously you need to have a good understanding of your ontology and of the data, but that will be necessary in any approach.
Gautam K.
·
Mohan K. what Francois mentioned is correct, and why do you want to import rdf file in protege, if there is a bigger dataset then it won't work
Gautam K.
·
You need protege for ontology modelling
Mohan K.
·
Thanks Gautam K. and François S., I have around 150 MySQL workbench table definition and around 1000 JSON schema files with description. I want to import MySQL workbench DDLs first and build or enhance Data model and create the Knowledge Graph objects. Similar one I want to do it for JSON schema objects.
Mohan K.
·
It is difficult to model everything from scratch. I want to first upload the converted RDFs and build Ontologies in JSON-LD objects so that I can create it in KG database
Mohan K.
·
Please let me know if you need more information
Gautam K.
·
How will you make converted RDF without an ontology?
Gautam K.
·
is it clarify anything to you?
Mohan K.
·
Thanks, assume that I have a Customer and Orders related RDBMS model. Now I need to convert them into RDFs.

Converting MySQL Schema to RDF: Seeking Advice and Frameworks

16 comments

Converting MySQL Schema to RDF: Seeking Advice and Frameworks

16 comments